- Call: +254 184 263 663
- Email: training(@)plezafriqueinstitute.org
- Home
- Categories
- Research, Data Management & Data Analytics Courses
- Accounting, Finance & Taxation Courses
- Audit, Compliance and Governance Training
- Leadership, Supervision & Management
- Professional Communication & Interpersonal Skills
- Project Management & Agile Methodologies
- Financial Acumen for Non-Financial Managers
- Customer Service & Client Experience (CX)
- Sales, Negotiation & Revenue Growth
- Cybersecurity, Data Privacy & Information Security
- Data Analytics, Business Intelligence & AI Literacy
- Operations, Quality Control & Lean Six Sigma
- Workplace Wellness, Productivity & Compliance
- Data, Statistics & Analytics
- Engineering, Construction & Technical
- Real Estate, Insurance & Risk
- Administration, Governance & Records
- About Us
- Courses
- News
- Contact Us
Course
Overview
The Advanced Excel for Executives
course is designed to equip senior leaders with advanced Excel capabilities for
strategic analysis, executive reporting, performance monitoring, financial
modelling, forecasting, and data-driven decision-making. The course focuses on
transforming complex organizational data into concise dashboards, KPIs,
financial insights, forecasts, and executive reports.
Target
Participants
- Chief executive officers and managing directors
- Executive directors and senior executives
- Finance and accounting executives
- Operations executives
- Human resource executives
- Strategy and planning executives
- Business development executives
- Senior project and programme executives
- Senior consultants and business advisors
- Departmental heads and senior managers
Course
Objectives
By the end of the course,
participants will be able to:
- Apply advanced Excel techniques to strategic business
analysis.
- Analyse complex organizational and financial data.
- Develop executive dashboards and KPI scorecards.
- Prepare concise and effective executive reports.
- Apply advanced formulas and functions to
decision-support models.
- Conduct financial, operational, and performance
analysis.
- Develop budgets, forecasts, and financial models.
- Perform scenario, sensitivity, and what-if analysis.
- Identify trends and patterns using advanced data
visualization.
- Use PivotTables and PivotCharts for executive-level
analysis.
- Use Power Query to transform and consolidate data.
- Automate recurring executive reports and dashboards.
- Present complex information in a clear and
decision-oriented format.
- Use Excel to support strategic planning and
organizational decision-making.
Course
Outline
Module 1: Advanced Excel for
Executive Decision-Making
- Excel productivity techniques
- Executive spreadsheet design
- Workbook organization and controls
- Structured references and named ranges
- Managing complex Excel models
- Data security and protection
Module 2: Advanced Excel Functions
- XLOOKUP
- INDEX and MATCH
- Advanced logical functions
- SUMIFS, COUNTIFS and AVERAGEIFS
- Nested formulas
- Statistical functions
- Financial functions
- Dynamic array functions
- Formula auditing and error handling
Module 3: Executive Data Analysis
- Data cleaning and preparation
- Analysing large datasets
- Trend and variance analysis
- Performance analysis
- Data validation
- Identifying business patterns and insights
Module 4: Executive Dashboards and
KPIs
- Executive dashboard design
- KPI development and monitoring
- Performance scorecards
- Dynamic charts
- Interactive dashboards
- Target versus actual analysis
- Executive data visualization
Module 5: Strategic Financial
Analysis
- Financial modelling
- Budget analysis
- Revenue and expenditure analysis
- Profitability analysis
- Cash-flow analysis
- Financial ratios
- Budget versus actual analysis
- Variance analysis
Module 6: Forecasting and Strategic
Scenario Modelling
- Business forecasting
- Trend analysis
- Goal Seek
- Scenario Manager
- Data Tables
- Sensitivity analysis
- Strategic scenario modelling
- Risk and opportunity analysis
Module 7: Power Query for Executive
Reporting
- Importing data from multiple sources
- Data transformation
- Merging and consolidating datasets
- Automated data cleaning
- Refreshable executive reports
- Building repeatable reporting workflows
Module 8: Executive Reporting and
Visualization
- Designing executive reports
- Selecting appropriate charts
- Advanced chart techniques
- Management scorecards
- Presenting complex data clearly
- Data storytelling
- Converting analysis into actionable insights
Module 9: Excel Automation
- Introduction to macros
- Recording and using macros
- Automating recurring reports
- Basic VBA concepts
- Automated dashboards
- Improving reporting efficiency
Course Schedules:
| Dates | Fees | Location | Apply |
|---|---|---|---|
| 23/11/2026 - 27/11/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 23/11/2026 - 27/11/2026 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 23/11/2026 - 27/11/2026 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 23/11/2026 - 27/11/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $5000 | Dubai, UAE | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $6000 | Mauritius | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $5000 | Dubai, UAE | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 28/12/2026 - 01/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 28/12/2026 - 01/01/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 04/01/2027 - 08/01/2027 | $6000 | Mauritius | Physical Class Online Class |
| 04/01/2027 - 08/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $6000 | Mauritius | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $6000 | Mauritius | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 08/03/2027 - 12/03/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 08/03/2027 - 12/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 08/03/2027 - 12/03/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 15/03/2027 - 19/03/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 15/03/2027 - 19/03/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 15/03/2027 - 19/03/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 15/03/2027 - 19/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 15/03/2027 - 19/03/2027 | $6000 | Mauritius | Physical Class Online Class |
| 22/03/2027 - 26/03/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 22/03/2027 - 26/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $6000 | Mauritius | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 05/04/2027 - 09/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 03/05/2027 - 07/05/2027 | $6000 | Mauritius | Physical Class Online Class |
| 03/05/2027 - 07/05/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 03/05/2027 - 07/05/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 03/05/2027 - 07/05/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 03/05/2027 - 07/05/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 10/05/2027 - 14/05/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 10/05/2027 - 14/05/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 10/05/2027 - 14/05/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $6000 | Mauritius | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $6000 | Mauritius | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 14/06/2027 - 18/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 14/06/2027 - 18/06/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $6000 | Mauritius | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $6000 | Mauritius | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 09/08/2027 - 13/08/2027 | $6000 | Mauritius | Physical Class Online Class |
| 09/08/2027 - 13/08/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 09/08/2027 - 13/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $6000 | Mauritius | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $6000 | Mauritius | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 11/10/2027 - 15/10/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 18/10/2027 - 22/10/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 15/11/2027 - 19/11/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 13/12/2027 - 17/12/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 10/01/2028 - 14/01/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 24/01/2028 - 28/01/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 07/02/2028 - 11/02/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 13/03/2028 - 17/03/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 27/03/2028 - 31/03/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 17/04/2028 - 21/04/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 15/05/2028 - 19/05/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 05/06/2028 - 09/06/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 03/07/2028 - 07/07/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 24/07/2028 - 28/07/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 14/08/2028 - 18/08/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 11/09/2028 - 15/09/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 25/09/2028 - 29/09/2028 | $4500 | Pretoria, South Africa | Physical Class Online Class |
No upcoming dates for this location.


