Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

# Learn from Home - Excel 2007 / 2010 / 2013

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype and e-mail Support

Course ID: 10979

Course type: Online Instructor led Course

Platform: Skype and e-mail Support

Students Interested 0 (Seats Left 0)

No Reviews Yet

Learn MS EXCEL (Beginner / Intermediate / Advance Levels) from your home / office through our online sessions from Microsoft Office Certified Master Trainer.

## Topics Covered

1) Excel Quick Overview: Difference between Excel 2003 and 2007 or 2010, Use of Excel, its boundaries & features
2) Data Formatting & Custom settings: Number, Text, Date, Currency, Custom settings. Data formatting & cleaning
3) Conditional Formatting
4) Filters, Queries & Data Sorting
5) Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, Count Blank, Count If, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.
6) If-Then-Else & Nested If commands:
7) V lookup / H lookup
8) Hyper / Data Linking: Hyper & data linking, within or outside Worksheet
9) Grouping / Ungrouping
10) Pivot Tables.
11) Security & Protection for worksheet and file.
12) Data validation
13) Goal Seek & Data Table
14) Solver
15) Charts
16) Paste Special Options
17) Index & Match functions
18) Various Printing Options
19) Macros in Excel (Basic Level)

## Who should attend

Any one who is using Excel in their day to day activities be it office or at home

## Pre-requisites

Should have a minimum working knowledge in Excel and should have suitable computer loaded with all required software to attend online sessions.

## What you need to bring

For participants in Chennai - 3 hours personal introductory session will be provided. For such sessions, they should bring their LAPTOP"

## Key Takeaways

1. Excellent working knowledge in Excel
2. Ability to identify methods for future working needs.
3. Sample files provided for Hands-on Exercise will be a reference material for future use also.

Not decided yet.

## Students also enrolled in these Courses

Avg Rating

0 Reviews

0 Students

1 Courses

Raja Chandramouli

Senior Corporate Trainer

12 Years of Experience

14+ years of experience in L & D. The trainer is a MS OFFICE MASTER TRAINER and is conducting MS Office training programs to various corporate organizations. You can learn MS Office topics through online either in English or in Tamil.

## Reviews

No reviews currently Be the First to Review

## Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now

Enquire

Submit your enquiry for Learn from Home - Excel 2007 / 2010 / 2013

Please enter valid question or comment

Connect With Raja

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Enter valid Email or Phone Number