Our courses

Build a confident foundation: navigate workbooks, format data and write your first formulas.

• Workbook & worksheet navigation
• Data entry, formatting & cell styles
• Basic formulas: SUM, AVERAGE, MIN, MAX
• Sorting, filtering & freeze panes
• Printing and page setup

Move beyond the basics with conditional logic, lookups, charts and pivot tables.

• IF, AND, OR & nested functions
• VLOOKUP, XLOOKUP & INDEX/MATCH
• Conditional formatting
• PivotTables & PivotCharts
• Named ranges & data validation

Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.

• Dynamic arrays & LAMBDA
• Advanced PivotTables & slicers
• What-if analysis & Solver
• Macros & introduction to VBA
• Dashboard design best practices

Turn raw data into interactive reports and dashboards stakeholders actually use.

• Connecting & shaping data
• Data modelling & relationships
• DAX measures & calculated columns
• Building interactive visuals
• Publishing & sharing reports

Automate messy data preparation with repeatable, refreshable ETL workflows.

• Importing from files, folders & web
• Cleaning & transforming data
• Merging and appending queries
• Parameters & functions
• Refresh strategies

Plan, schedule and track projects with confidence using industry-standard tools.

• Project setup & calendars
• Tasks, dependencies & milestones
• Resource allocation & levelling
• Tracking progress & baselines
• Reporting to stakeholders

Produce polished professional documents — from reports to long-form publications.

• Styles & document structure
• Tables, images & captions
• Tables of contents & references
• Mail merge
• Templates & collaboration

Corporate-grade Excel training for Kenyan finance, operations and analytics teams who need to ship reliable reports fast — now including Power Query, Power Pivot and AI-powered productivity with Copilot.

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

Build investor-ready three-statement models, DCF valuations and sensitivity analyses in Excel.

• Model design principles & best-practice formatting
• Three-statement model build (P&L, BS, CF)
• Revenue, cost & working capital forecasting
• DCF valuation, WACC & terminal value
• Scenario, sensitivity & data tables for stress testing

Run a credible annual budget cycle and rolling forecast process using modern Excel.

• Budget structure, drivers & assumptions
• Rolling forecast methodology & cadence
• Variance analysis & commentary frameworks
• Scenario planning for revenue & cost shocks
• Board and donor reporting pack design

End-to-end data analytics: from messy source data to dashboards and data-driven decisions.

• Analytics lifecycle & question framing
• Data sourcing, cleaning & joining with Power Query
• Data modelling, relationships & core DAX
• Dashboard design with Power BI
• Data storytelling & insight communication

Supercharge your analytics workflow with AI: master Claude, Claude Cowork and Microsoft Copilot for data analysis, reporting and insight generation.

• Introduction to AI in analytics: Claude, Copilot and the modern analyst toolkit
• Claude for data analysis: uploading datasets, running calculations and generating insights
• Claude Cowork: collaborative AI workspaces for team-based analytics projects
• Microsoft Copilot in Excel: formula generation, conditional formatting and PivotTable automation
• Building AI-accelerated dashboards and executive summaries
• Responsible AI: verifying outputs, handling sensitive data and maintaining accuracy

Model millions of rows inside Excel with relationships, hierarchies and DAX measures.

• Power Pivot data model fundamentals
• Relationships, hierarchies & calculated columns
• DAX measures & CALCULATE deep dive
• Time intelligence: YTD, QTD, prior-period analysis
• Bridging to Power BI

Strategic BI consulting for Kenyan organisations: assessment, roadmap, dashboard build and team enablement.

• Discovery: reporting audit & maturity assessment
• BI roadmap & technology recommendations
• Data model & dashboard build (Power BI / Excel)
• Governance, security & refresh strategy
• Team enablement & knowledge transfer