Signup as a Tutor

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

"Microsoft Excel - Intermediate level" is no longer available

No Reviews Yet

Ramapuram, Chennai

Course ID: 42757

Ramapuram, Chennai

Kothai picture
No Reviews Yet

About the Course

Learner level: Novice/ Practitioner in Excel.

Course outcome: Learn to access basic and salient features of Excel.

� Excel application basics - File properties, user settings and object reference.

� Access information from textual data like length of the text, find whether the given text contains any specific term, extract required part of the string, etc.

� Access date values to find day/ week/ month of specific date, calculate duration between two dates in required format considering official calendar, calculate age/ experience/ upcoming dues which are helpful in planning tasks.

� Enables to manipulate data using aggregate functions like counting/ sum up given values, find maximum/ minimum from set of values and verify data using logical functions like AND, OR, IF, etc.

� Search specific value and Look up related information of the searched value in collection of data or huge table.

� Format excel data that includes font sizing, font format and font color, cell highlighting with colors, vertical alignment and horizontal alignment within a cell, border coverage and border thickness.

â?¢ Dynamic formatting using one or more rules

â?¢ Structure data into meaningful information by presenting it as tables. Using pivot functions to handle table updates and output with drag and drop options and aggregate functions.

â?¢ Create visual outputs of the tabulated data using excel graphs with variety of templates and designs.

� Covers shortcuts required for frequently used excel actions.

� Includes practice exercises for each topic.



1. Excel application - Basics

2. Text functions

3. Date functions

4. Aggregate and Logical functions

5. Search/ Look up functions

6. Formatting - basics

7. Formatting - Dynamic/ Conditional

8. Tables

9. Graphs

10. Frequently used Short cuts

11. Practice exercises

12. Excel best practices

Date and Time

Not decided yet.

About the Trainer

Kothai picture

Avg Rating






12 Years of Experience

Corporate trainer for Microsoft applications.
Specialized in Excel formulae, Shortcuts & macro.


No reviews currently


Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more