Week 1: Excel Foundations & Productivity Tools
- Navigating Excel (ribbons, sheets, cell references)
- Data entry, formatting, and validation
- Working with formulas (basic arithmetic, text, logical functions)
- Shortcuts & productivity hacks
Hands-on: Building a personal budget sheet
Week 2: Data Management & Cleaning
- Sorting & filtering data
- Removing duplicates, handling missing data
- Text-to-columns, flash fill, find & replace
- Named ranges & structured references
Hands-on: Clean and organize a raw dataset
Week 3: Analytical Functions & PivotTables
- Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH)
- Statistical functions (AVERAGE, MEDIAN, STDEV, COUNTIFS)
- PivotTables & PivotCharts for summary reporting
Conditional formatting for insights
Hands-on: Build a sales analysis dashboard
Week 4: Advanced Excel & Reporting
- What-if analysis (Goal Seek, Scenario Manager, Data Tables)
- Advanced charts (Combo, Waterfall, Sparklines)
- Introduction to Power Query for automation
- Dashboard creation best practices
Mini Project: Develop an interactive business dashboard
