Advanced Excel for Professionals

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. New modules now cover Power Query for automated data transformation, Power Pivot for modelling millions of rows with DAX, and hands-on use of Microsoft Copilot and Claude AI add-ins to speed up formula writing, analysis and reporting. 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
• Automate data extraction and transformation with Power Query
• Model large datasets in Power Pivot with relationships, hierarchies and DAX measures
• Run scenario, sensitivity and what-if analysis using Solver and Data Tables
• Automate repetitive reporting tasks with macros and lightweight VBA
• Leverage Microsoft Copilot and Claude AI add-ins to accelerate formula writing, analysis and dashboard creation
• Design clean, accessible dashboards aligned to Microsoft design guidance

Course outline

• 1Advanced formulas: XLOOKUP, LET, LAMBDA, dynamic arrays
• 2PivotTables, slicers, timelines & calculated fields
• 3Power Query: import, clean, merge and transform data from any source
• 4Power Pivot: load millions of rows, build star-schema models and write DAX measures
• 5Scenario, sensitivity & what-if analysis with Solver
• 6Macros & VBA automation essentials
• 7AI-powered Excel: using Microsoft Copilot and Claude for formulas, analysis and reporting
• 8Executive dashboard design & publishing

Delivery

Frequently asked questions