- 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 Strategic Advanced Excel
course is designed to equip professionals, managers, and decision-makers with
advanced Excel skills for strategic planning, business analysis, financial
modelling, performance management, forecasting, and evidence-based
decision-making. The course focuses on transforming complex organizational data
into strategic insights through advanced formulas, dashboards, data
visualization, Power Query, scenario modelling, and automated reporting.
Target
Participants
- Senior managers and executives
- Strategic planning professionals
- Finance and accounting professionals
- Business and data analysts
- Operations and project managers
- Monitoring and evaluation professionals
- Management consultants
- Business development professionals
- Departmental heads and team leaders
- Entrepreneurs and business owners
- Professionals involved in strategic reporting and
decision-making
Course
Objectives
By the end of the course,
participants will be able to:
- Apply advanced Excel techniques to strategic business
problems.
- Analyse complex financial, operational, and
organizational datasets.
- Develop strategic dashboards and KPI scorecards.
- Build sophisticated financial and business models.
- Conduct trend, variance, and performance analysis.
- Develop forecasts and strategic scenarios.
- Perform sensitivity and what-if analysis.
- Use advanced Excel functions for decision-support
applications.
- Consolidate and transform data using Power Query.
- Automate recurring strategic reports and analytical
processes.
- Create compelling data visualizations for strategic
communication.
- Develop Excel-based tools to support planning and
resource allocation.
- Translate data analysis into meaningful strategic
insights.
Course
Outline
Module 1: Strategic Excel and
Decision-Making
- Excel as a strategic decision-support tool
- Advanced workbook design
- Structuring strategic models
- Data organization and model controls
- Advanced Excel productivity techniques
Module 2: Advanced Formulas for
Strategic Analysis
- XLOOKUP
- INDEX and MATCH
- Advanced logical functions
- SUMIFS, COUNTIFS and AVERAGEIFS
- Statistical and financial functions
- Dynamic array functions
- Nested formulas
- Formula auditing and error management
Module 3: Strategic Data Management
- Data cleaning and preparation
- Managing large datasets
- Data validation and quality control
- Advanced sorting and filtering
- Combining and structuring organizational data
- Preparing data for strategic analysis
Module 4: Strategic Dashboards and
KPIs
- Strategic KPI development
- Executive dashboards
- Performance scorecards
- Target versus actual analysis
- Dynamic charts
- Interactive dashboards
- Data visualization for strategic communication
Module 5: Strategic Financial
Modelling
- Financial modelling principles
- Budget and resource allocation models
- Revenue and expenditure analysis
- Profitability analysis
- Cash-flow projections
- Financial performance analysis
- Investment and project modelling
Module 6: Forecasting and Scenario
Planning
- Trend analysis
- Business forecasting
- Goal Seek
- Scenario Manager
- Data Tables
- Sensitivity analysis
- Strategic scenario modelling
- Risk and opportunity analysis
Module 7: Power Query for Strategic
Analysis
- Importing data from multiple sources
- Data transformation
- Merging and appending datasets
- Automated data cleaning
- Consolidating organizational information
- Creating refreshable analytical reports
Module 8: Advanced Reporting and
Data Visualization
- Strategic management reports
- Advanced charts
- Interactive visualizations
- KPI reporting
- Data storytelling
- Presenting complex information to decision-makers
- Designing decision-oriented reports
Module 9: Excel Automation
- Introduction to macros
- Recording and using macros
- Automating recurring reports
- Basic VBA concepts
- Automated dashboards
- Improving strategic reporting efficiency
Course Schedules:
| Dates | Fees | Location | Apply |
|---|---|---|---|
| 23/11/2026 - 27/11/2026 | $6000 | Mauritius | Physical Class Online Class |
| 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 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $5000 | Dubai, UAE | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $6000 | Mauritius | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 07/12/2026 - 11/12/2026 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $5000 | Dubai, UAE | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 28/12/2026 - 01/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 04/01/2027 - 08/01/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 04/01/2027 - 08/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $6000 | Mauritius | Physical Class Online Class |
| 11/01/2027 - 15/01/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $4000 | Johannesburg, South Africa | 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 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $2500 | Kigali, Rwanda | 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 |
| 25/01/2027 - 29/01/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $6000 | Mauritius | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 01/02/2027 - 05/02/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $6000 | Mauritius | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $4500 | Pretoria, 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 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $6000 | Mauritius | Physical Class Online Class |
| 01/03/2027 - 05/03/2027 | $4500 | Pretoria, 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 | Singapore, Singapore | Physical Class Online Class |
| 08/03/2027 - 12/03/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 08/03/2027 - 12/03/2027 | $4000 | Johannesburg, 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 | $2500 | Kigali, Rwanda | 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 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 22/03/2027 - 26/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 22/03/2027 - 26/03/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 05/04/2027 - 09/04/2027 | $6000 | Mauritius | Physical Class Online Class |
| 05/04/2027 - 09/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 05/04/2027 - 09/04/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 12/04/2027 - 16/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $6000 | Mauritius | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $1500 | Nairobi, Kenya | 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 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 10/05/2027 - 14/05/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 17/05/2027 - 21/05/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 24/05/2027 - 28/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 | $6000 | Mauritius | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $6000 | Mauritius | Physical Class Online Class |
| 14/06/2027 - 18/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $6000 | Mauritius | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $6000 | Mauritius | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 09/08/2027 - 13/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 | $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 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 23/08/2027 - 27/08/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $5000 | Singapore, Singapore | 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 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $6000 | Mauritius | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 20/09/2027 - 24/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 11/10/2027 - 15/10/2027 | $6000 | Mauritius | Physical Class Online Class |
No upcoming dates for this location.


