All courses
Advanced
Advanced Excel for Professionals
Corporate-grade Excel training for Kenyan finance, operations and analytics teams who need to ship reliable reports fast.
Duration
3 days (21 hours)
Fee
KES 28,500
per participant
About this course
A career-defining Advanced Excel training programme designed for working professionals in Nairobi and across Kenya. Over three intensive days you'll build the muscle memory leading finance and analytics teams rely on — advanced formulas, robust data models, decision-ready dashboards and automation that turns hours of weekly work into minutes. Delivered by Microsoft-experienced instructors at our Westlands centre or live online for distributed teams.
Class goals
- Compose advanced formulas with XLOOKUP, LET, LAMBDA and dynamic arrays
- Build resilient PivotTable and PivotChart reports for executive audiences
- Run scenario, sensitivity and what-if analysis using Solver and Data Tables
- Automate repetitive reporting tasks with macros and lightweight VBA
- Design clean, accessible dashboards aligned to Microsoft design guidance
Course outline
- 1Advanced formulas: XLOOKUP, LET, LAMBDA, dynamic arrays
- 2PivotTables, slicers, timelines & PowerPivot intro
- 3Scenario, sensitivity & what-if analysis with Solver
- 4Macros & VBA automation essentials
- 5Executive dashboard design & publishing
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.