Learn Microsoft Excel from scratch to advance level

The Only Advanced Excel Course You Need

Impress your boss with your data-driven advanced Excel skills and outperform others

Topics Covered

 

1) Advanced Functions 

SUMIF, SUMIFS, SUMPRODUCT, DSUM , VLOOKUP, HLOOKUP
COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS,
IFERROR, ISERROR, ISBLANK,
MATCH, CHOOSE etc..
Various other functions related to Date & Time etc.

 

2) If Condition 

When should use the “IF” Conditions?
Creation of Multiple IF Conditions in One Cell
Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR Functions

 

3) Advanced Excel Options 

Various Methods of Filter and Advance Filter options
Text to Column options, Flash Fill option
Uses of Data Grouping
Various Method of Sorting Data,
Conditional formatting
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources

 

4) Pivots and Charts Explained

Various Methods and Options of Pivot Table
Using the Pivot Table Wizard
Changing the Pivot Table Layout
Subtotal and Grand total Options
Formatting
Calculation in Pivot Table

 

5) Excel Tips and Tricks

Some tips that will not only make your simple but also help you to be more productive. 

 

Contact:

IPCA – Institute

206 Sakina Complex, Above Maharaja Sweets,
Mehdipatnam X Roads,
Hyderabad. Telangana

Phone No: 9246884200