The training is fully hands-on format. 

Learn excel by creating real world application. 

We train users to create a real world application . We believe that excel can be used effectively only if one can visualize how to use different features together. 

This course is suitable for the Excel Users Consolidating data, generating Reports out of it.

This course covers

Applying Simple Formula – (Yes! You are using them.)

Using different References methods in Formula

Advance Formulas for Total, Count

Getting acquainted to IF, AND, OR

Functions – Simple, Nested, String functions

Handling Dates – birthdate 1-4-1981 is in January or April?

Working on multiple worksheets when you are,

Collecting data from different Sources, 

Maintaining Monthly Data in Different Sheets

Inspecting and Validating data using Sort / Filter

Corrections to the data – cleaning of data

Formatting Data uniformly

Using Lookup functions and include data from Master Lists

Using Cell Range,

Generating Simple Dashboards from multiple sheets.

Conditional Formatting will turn your simple report into an informative, eye catchy report.

Pivot Table – Generate cross tab reports

Various formats available with Pivot Table

Different summary options available with Pivot Table

Charts – Learn to choose proper Type of chart for the presentation

Printing and Exporting Data with proper headers, footers

Shortcuts and Tricks to swiftly complete tasks