WhatIf Analysis

• Goal Seek
• Data Tables
• Scenario Manager

Auto and Advanced Filters:

• Extracting Records with Advanced Filter
• Using Formulas In Criteria
• Handling complex Criteria(s)
• Using Multiple Criteria in Advanced Filter
• Generating MIS Reports and Balance sheets

Advanced Charting and Dashboard:

• Creating Multiple Chart Types
• Primary, Secondary and Combo Charts
• Trend line Charting, Spark Line
• Gantt Chart, Doughnut Charts
• Dynamic Charting Techniques
• Dashboard Designing
• Excel templates designing

Data Analysis:

• Sub Total Reports, Auto Filter
• Password Protecting Worksheets, Single Cell Protection
• Linking Multiple Sheets
• Sheet Referencing
• MIS Reporting

Functions: LOOKUP,VLOOKUP,HLOOKUP,COUNTIF:

• What-if-analysis
• GOAL SEEK
• NESTED IF
• Reporting
• Character Functions
• Date Functions
• Age Calculations

Pivot Tables and Pivot Charts:

• Enter the Pivot Table Data
• Create the Pivot Table
• Adding Data to the Pivot Table
• Filtering the Pivot Table Data
• Change the Pivot Table Data
• Analyze Data Columns in Pivot Tables
• Adjust Data to Analyze