The only Advanced Excel Course you Need

Course Overview

Target Audience – The target audience for this course are those who are functional users of Excel and who would want to take their game to next level. 

Agenda of the Course – To make you a Advanced user of Excel

Practical examples along with some case study are shared with the learner, this helps a person to better visualize how thing will really work in their workplace environment. 

Topics Covered

1) Advanced Functions 

• SUMIF, SUMIFS, SUMPRODUCT, DSUM , VLOOKUP, HLOOKUP
• COUNTIF, COUNTIFS
• IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
• SEARCH, INDEX, MATCH ETC
• Various other functions related to Date, Time, Text 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
• Creating and Updating Subtotals
• Various Methods of Text to Column options
• Uses of Data Grouping and Consolidation options
• Various Method of Sorting Data, Conditional formatting
• Creating, Formatting and Modifying Chart
• Data Validation, Creating drop down lists using different data sources
• Linking Workbooks and Uses of Edit Link options
• Excel Options,Customizing the Quick Access Tool Bar
• Introduction to new tools like Sparklines.
• Formula Auditing features and Trace formula error

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
• Grouping Items
• Inserting Calculated Fields
• Pivot Table Options
• Calculation in Pivot Table
• Display and Hide Data in Field
• Select, Move & Clear Pivot Data
• Creating and Modifying Pivot Chart

5) Excel Tips and Tricks

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