All courses
Advanced
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
Duration
2 days (16 hours)
Fee
KES 22,500
per participant
About this course
An advanced, hands-on workshop for experienced Excel users who want to build sophisticated models, automate repetitive tasks and deliver insight-driven dashboards. We cover modern dynamic arrays, LAMBDA, what-if analysis and an introduction to VBA macros for automation.
Class goals
- Use dynamic arrays and LAMBDA to write reusable formulas
- Build advanced PivotTables with slicers and timelines
- Run what-if analysis and optimisation with Solver
- Automate repetitive tasks with macros and basic VBA
- Design clear, decision-ready dashboards
Course outline
- 1Dynamic arrays & LAMBDA
- 2Advanced PivotTables & slicers
- 3What-if analysis & Solver
- 4Macros & introduction to VBA
- 5Dashboard design best practices
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.