Module 1: Excel Refresher (Basics)

• Excel interface overview
• Workbook, worksheet, rows, columns, cells
• Data types (text, number, date)
• Basic formatting & shortcuts
• Basic formulas: SUM, AVERAGE, MIN, MAX

Module 2: Advanced Formulas & Functions

A. Logical Functions

• IF, IFERROR, AND, OR, NOT
• Nested IF statements
• SWITCH function (Excel 2016+)

B. Lookup & Reference Functions

• VLOOKUP, HLOOKUP
• INDEX & MATCH
• XLOOKUP (Excel 365 / 2021)
• ROW, COLUMN, ADDRESS

C. Text Functions

• CONCAT / CONCATENATE
• LEFT, RIGHT, MID
• LEN, TRIM, UPPER, LOWER, PROPER
• REPLACE, SUBSTITUTE
• TEXT & VALUE

D. Date & Time Functions

• TODAY(), NOW()
• DATE, DAY, MONTH, YEAR
• NETWORKDAYS, WORKDAY
• EOMONTH, DATEDIF

E. Mathematical & Statistical Functions

• ROUND, ROUNDUP, ROUNDDOWN
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• AVERAGEIF, AVERAGEIFS

Module 3: Data Tools & Analysis

• Data validation (drop-downs, rules)
• Conditional formatting (basic & formula-based)
• Remove duplicates & text to columns
• Goal Seek
• Scenario Manager
• Solver basics

Module 4: Pivot Tables & Pivot Charts

• Creating Pivot Tables
• Grouping & summarizing data
• Pivot Charts
• Calculated fields & items
• Filtering & slicers
• Drill-down & reporting

Module 5: Charts & Visualization

• Column, Bar, Line, Pie, Area charts
• Combo charts
• Sparklines
• Dynamic charts with named ranges
• Conditional formatting visualization

Module 6: Advanced Data Analysis

• Power Query basics
• Importing & transforming data
• Cleaning & merging datasets
• Power Pivot basics
• Relationships between tables
• DAX formulas introduction (SUMX, CALCULATE, RELATED)

Module 7: Macros & VBA Basics

• Introduction to macros
• Recording & running macros
• VBA editor overview
• Writing simple VBA scripts
• Creating user-defined functions
• Automating repetitive tasks

Module 8: Advanced Excel Techniques

• Named ranges & dynamic ranges
• Array formulas
• INDEX-MATCH for dynamic lookups
• OFFSET & INDIRECT for dynamic ranges
• Advanced filtering
• Using Tables (Excel Table feature)

Module 9: Dashboards & Reporting

• Interactive dashboards with slicers & pivot tables
• Charts & KPIs in dashboards
• Using form controls
• Dynamic reports
• Dashboard best practices

Module 10: Projects & Case Studies

• Sales analysis dashboard
• Inventory management tracker
• Employee performance tracker
• Financial statement analysis
• Dashboard for business metrics
• Real-time data reporting (Power Query)