Microsoft Office - Advanced Excel Training @ IPCA Institute
19 Sep, 2026
Hyderabad, AP 500028
Safety Tips
- Meet in a safe, public place
- Check the item before buying
- Pay only after collecting the item
Description
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
202/206 Sakina Complex, Above Maharaja Sweets,
Mehdipatnam X Roads,
Hyderabad. Telangana
Phone No: 9246884200
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
202/206 Sakina Complex, Above Maharaja Sweets,
Mehdipatnam X Roads,
Hyderabad. Telangana
Phone No: 9246884200