The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

This Advanced Excel Course will empower the participants to be able to do the following:

Performing complex calculations more efficiently, using various Excel functions.

Organizing and analyzing large volumes of data.

Creating MIS reports.

Designing and using templates.

Consolidating and managing data from multiple workbooks.

Course Content: –

Advanced Formulas and Functions

Advanced Text Functions

Advanced Date & Time Functions

Advanced Lookup & Reference Functions

Advanced Mathematics and Statistics Functions

What If Analysis

Scenario Analysis

Goal Seek

Data Table

Data Consolidation

Working with Duplicates

Data Validation

Advanced Custom Formatting

Advanced Conditional Formatting

Advanced Pivot Tables

Charts & Graphs

Macros

Power Query – Power in Your Hands to Work with Data

PowerPivot – Revolutionary Power for Data Analysis

Troubleshooting Excel Problems