← All courses
📈Advanced
Excel Advanced
Master modern Excel — dynamic arrays, advanced lookups, LET/LAMBDA, Power Query for automated data cleaning, what-if analysis, macros and self-updating dashboards.
4 modules · 16 lessons · 16 lessons
Share
₦2,25070% OFF
₦7,500 save ₦5,250
Offer ends in …
What you'll learn
- Dynamic arrays
- Power Query
- What-if analysis
- Macros & dashboards
Curriculum
5 modules · 16 lessonsModule 2Advanced formulas3 lessons
Multi-criteria lookups
LET: name your calculations
LAMBDA: your own functions
Module 3Power Query3 lessons
What Power Query is
Cleaning data with Power Query
Combining tables (append & merge)
Module 4What-if analysis3 lessons
Goal Seek
Scenarios and Data Tables
Building a model
Module 5Automation & dashboards4 lessons
Macros: record repetitive work
A taste of VBA
Building a dashboard
Where to go next
Reviews
No reviews yet.
