Back to Courses
Advanced
Advanced Excel
Transform from Excel user to Excel expert. Master formulas, pivot tables, macros, and data analysis.
$1608 weeksAdvanced
What You'll Learn
Advanced formulas and functions
Pivot tables and charts
Data validation and cleaning
Power Query basics
VBA and macros
Dashboard creation
Data analysis tools
Business reporting
Course Outline
1
Week 1
Advanced Formulas
- XLOOKUP
- INDEX/MATCH
- Array formulas
- Dynamic arrays
2
Week 2u20133
Data Analysis
- Pivot Tables
- Power Query
- Data cleaning
- What-if analysis
3
Week 4
Visualization
- Advanced charts
- Sparklines
- Conditional formatting
- Dashboard design
4
Week 5u20136
Automation & Projects
- VBA basics
- Macros
- Automation workflows
- Business project
$160
8 weeks · Advanced
This course includes:
8 weeks of content
8 topics covered
Certificate of completion
Advanced level