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 – 500028. Phone No: 9246884200
Login
