This course is suitable for the Excel Users

• Consolidating data,
• generating Reports out of it,
• Users keen to upgrade their technics.

Well, you are equipped with Excel, generating reports and wondering how to simplify this?

You will improve your efficiency availing this course.

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

We take business scenarios during the training. Each Session will have slot for review and queries.