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, Malabar Gold Shop
Hyderabad. TS.

Phone No: 9246884200