Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)
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.
Frequently asked questions
Related courses
More Microsoft & data training delivered in Nairobi and live online across Kenya.
- Beginner
Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)KES 10,000 - Intermediate
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)KES 15,500 Power BI
Turn raw data into interactive reports and dashboards stakeholders actually use.
2 days (14 hours)KES 32,500