Advanced Excel – Course Contents

1. Advanced Excel Foundations
- Advanced formulas & nested functions
- Logical functions: IF, IFS, SWITCH
- Lookup functions: VLOOKUP, XLOOKUP, INDEX + MATCH
- Text functions: LEFT, RIGHT, MID, TRIM
- Date & time functions
- Named ranges
- Data validation

2. Data Analysis & Management
- Sorting & multi-level filtering
- Conditional formatting (advanced)
- Data cleaning & remove duplicates
- Flash Fill & Text to Columns
- What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables

3. Pivot Tables & Pivot Charts
- Creating Pivot Tables
- Advanced calculations
- Grouping data
- Slicers & filters
- Pivot Charts
- Dynamic dashboards

4. Dashboard & MIS Reporting
- KPI creation
- Interactive dashboards
- Dynamic charts
- Professional MIS reports

5. Automation Basics
- Introduction to Macros
- Basic automation concepts