Course Overview:
Excel Dashboards for Professionals is a practical and advanced training course designed to equip professionals with the skills to develop interactive, visually compelling, and data-driven dashboards using Microsoft Excel. The course covers data preparation, analysis, visualization, KPI development, interactive controls, PivotTables, PivotCharts, Power Query, and dashboard automation. Participants will learn how to transform complex datasets into clear management reports that support monitoring, analysis, and decision-making.

Target Participants:

  • Finance and accounting professionals
  • Business analysts and data analysts
  • Project and programme professionals
  • Monitoring and evaluation professionals
  • Human resource professionals
  • Sales and marketing professionals
  • Operations and procurement professionals
  • Managers and departmental reporting officers
  • Professionals responsible for business reporting and performance monitoring

Course Objectives:
By the end of the course, participants will be able to:

  • Design professional and interactive Excel dashboards.
  • Prepare, clean, and organize data for dashboard development.
  • Use Excel formulas and functions to generate dashboard metrics.
  • Develop KPIs and performance indicators.
  • Create and customize PivotTables and PivotCharts.
  • Apply charts, slicers, timelines, and interactive controls.
  • Use Power Query for data transformation and preparation.
  • Build automated and dynamic management dashboards.
  • Apply dashboard design principles for effective data visualization.
  • Analyze trends, variances, and performance indicators.
  • Present complex information in a concise and professional format.
  • Develop dashboards for real-world business and organizational applications.

Course Outline:

  1. Introduction to Excel Dashboards
    • Concepts and principles of dashboard development
    • Types of Excel dashboards
    • Dashboard components and architecture
    • Professional dashboard design principles
  2. Data Preparation for Dashboards
    • Data collection and organization
    • Data cleaning and validation
    • Removing duplicates and errors
    • Structuring data tables
    • Data preparation best practices
  3. Excel Functions for Dashboard Development
    • IF and nested IF functions
    • SUMIFS, COUNTIFS and AVERAGEIFS
    • XLOOKUP and INDEX/MATCH
    • IFERROR and logical functions
    • Dynamic formulas
  4. PivotTables and PivotCharts
    • Creating and managing PivotTables
    • Grouping and filtering data
    • Calculated fields and metrics
    • Creating interactive PivotCharts
    • Connecting multiple dashboard components
  5. KPI and Performance Metrics
    • Designing effective KPIs
    • Actual versus target analysis
    • Variance analysis
    • Trend indicators
    • Performance scorecards
  6. Data Visualization
    • Selecting appropriate charts
    • Column, bar, line and combination charts
    • Sparklines
    • Conditional formatting
    • Visual presentation of trends and comparisons
  7. Interactive Dashboard Development
    • Using slicers
    • Using timelines
    • Interactive filters
    • Dynamic charts
    • Navigation buttons and dashboard controls
  8. Power Query for Dashboard Data
    • Importing data
    • Cleaning and transforming datasets
    • Combining multiple data sources
    • Refreshing dashboard data
    • Creating repeatable data workflows
  9. Building Professional Excel Dashboards
    • Dashboard layout and structure
    • Executive summary dashboards
    • Financial dashboards
    • Sales and marketing dashboards
    • HR and operations dashboards
  10. Dashboard Automation and Reporting
    • Dynamic ranges
    • Automated calculations
    • Refreshable reports
    • Dashboard maintenance
    • Protecting and sharing dashboards

 

Course Schedules:

Dates Fees Location Apply
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
23/11/2026 - 27/11/2026 $6000 Mauritius Physical Class Online Class
30/11/2026 - 04/12/2026 $4500 Pretoria, South Africa Physical Class Online Class
30/11/2026 - 04/12/2026 $5000 Singapore, Singapore Physical Class Online Class
30/11/2026 - 04/12/2026 $1500 Nairobi, Kenya 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
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
07/12/2026 - 11/12/2026 $5000 Dubai, UAE 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 $2000 Mombasa, Kenya 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 $4000 Johannesburg, South Africa Physical Class Online Class
28/12/2026 - 01/01/2027 $5000 Dubai, UAE 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 $2500 Dar es Salaam, Tanzania Physical Class Online Class
04/01/2027 - 08/01/2027 $6000 Mauritius Physical Class Online Class
04/01/2027 - 08/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
04/01/2027 - 08/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
11/01/2027 - 15/01/2027 $5000 Singapore, Singapore Physical Class Online Class
11/01/2027 - 15/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
18/01/2027 - 22/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
18/01/2027 - 22/01/2027 $5000 Dubai, UAE Physical Class Online Class
18/01/2027 - 22/01/2027 $6000 Mauritius Physical Class Online Class
18/01/2027 - 22/01/2027 $5000 Singapore, Singapore 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 $1500 Nairobi, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $4000 Johannesburg, South Africa Physical Class Online Class
25/01/2027 - 29/01/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 $4500 Pretoria, South Africa Physical Class Online Class
08/02/2027 - 12/02/2027 $2500 Kigali, Rwanda Physical Class Online Class
08/02/2027 - 12/02/2027 $5000 Dubai, UAE Physical Class Online Class
08/02/2027 - 12/02/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
08/02/2027 - 12/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $5000 Singapore, Singapore Physical Class Online Class
15/02/2027 - 19/02/2027 $6000 Mauritius Physical Class Online Class
15/02/2027 - 19/02/2027 $4500 Pretoria, South Africa Physical Class Online Class
15/02/2027 - 19/02/2027 $2000 Mombasa, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $4000 Johannesburg, South Africa Physical Class Online Class
15/02/2027 - 19/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
22/02/2027 - 26/02/2027 $1500 Nairobi, Kenya 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 $1500 Nairobi, Kenya Physical Class Online Class
01/03/2027 - 05/03/2027 $4500 Pretoria, South Africa Physical Class Online Class
08/03/2027 - 12/03/2027 $4000 Johannesburg, South Africa Physical Class Online Class
08/03/2027 - 12/03/2027 $2500 Kigali, Rwanda Physical Class Online Class
08/03/2027 - 12/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/03/2027 - 12/03/2027 $5000 Dubai, UAE Physical Class Online Class
08/03/2027 - 12/03/2027 $2000 Mombasa, Kenya Physical Class Online Class
15/03/2027 - 19/03/2027 $5000 Singapore, Singapore 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
15/03/2027 - 19/03/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
22/03/2027 - 26/03/2027 $4500 Pretoria, South Africa 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
22/03/2027 - 26/03/2027 $5000 Dubai, UAE Physical Class Online Class
29/03/2027 - 02/04/2027 $5000 Singapore, Singapore 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
05/04/2027 - 09/04/2027 $2500 Kigali, Rwanda Physical Class Online Class
05/04/2027 - 09/04/2027 $6000 Mauritius 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 $2500 Dar es Salaam, Tanzania Physical Class Online Class
19/04/2027 - 23/04/2027 $4500 Pretoria, South Africa Physical Class Online Class
19/04/2027 - 23/04/2027 $4000 Johannesburg, South Africa Physical Class Online Class
19/04/2027 - 23/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/04/2027 - 30/04/2027 $6000 Mauritius Physical Class Online Class
26/04/2027 - 30/04/2027 $2500 Kigali, Rwanda Physical Class Online Class
26/04/2027 - 30/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/04/2027 - 30/04/2027 $5000 Dubai, UAE 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 $2000 Mombasa, Kenya Physical Class Online Class
03/05/2027 - 07/05/2027 $5000 Singapore, Singapore Physical Class Online Class
03/05/2027 - 07/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
10/05/2027 - 14/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
10/05/2027 - 14/05/2027 $6000 Mauritius Physical Class Online Class
10/05/2027 - 14/05/2027 $4500 Pretoria, South Africa Physical Class Online Class
17/05/2027 - 21/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 $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 $2500 Dar es Salaam, Tanzania Physical Class Online Class
24/05/2027 - 28/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
24/05/2027 - 28/05/2027 $2500 Kigali, Rwanda Physical Class Online Class
24/05/2027 - 28/05/2027 $5000 Singapore, Singapore Physical Class Online Class
31/05/2027 - 04/06/2027 $5000 Dubai, UAE Physical Class Online Class
31/05/2027 - 04/06/2027 $6000 Mauritius Physical Class Online Class
31/05/2027 - 04/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $2000 Mombasa, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $2500 Kigali, Rwanda Physical Class Online Class
07/06/2027 - 11/06/2027 $5000 Singapore, Singapore Physical Class Online Class
07/06/2027 - 11/06/2027 $4000 Johannesburg, South Africa Physical Class Online Class
07/06/2027 - 11/06/2027 $1500 Nairobi, 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 Dar es Salaam, Tanzania Physical Class Online Class
14/06/2027 - 18/06/2027 $4500 Pretoria, South Africa 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 $1500 Nairobi, Kenya Physical Class Online Class
28/06/2027 - 02/07/2027 $4000 Johannesburg, South Africa Physical Class Online Class
05/07/2027 - 09/07/2027 $2500 Kigali, Rwanda Physical Class Online Class
05/07/2027 - 09/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
05/07/2027 - 09/07/2027 $6000 Mauritius Physical Class Online Class
05/07/2027 - 09/07/2027 $2000 Mombasa, Kenya Physical Class Online Class
12/07/2027 - 16/07/2027 $5000 Singapore, Singapore 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 $1500 Nairobi, Kenya Physical Class Online Class
12/07/2027 - 16/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
19/07/2027 - 23/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
19/07/2027 - 23/07/2027 $2000 Mombasa, Kenya 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
26/07/2027 - 30/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/07/2027 - 30/07/2027 $2500 Kigali, Rwanda Physical Class Online Class
02/08/2027 - 06/08/2027 $4000 Johannesburg, South Africa 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
02/08/2027 - 06/08/2027 $6000 Mauritius Physical Class Online Class
02/08/2027 - 06/08/2027 $2500 Dar es Salaam, Tanzania 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
09/08/2027 - 13/08/2027 $5000 Singapore, Singapore Physical Class Online Class
16/08/2027 - 20/08/2027 $4000 Johannesburg, 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 Dubai, UAE Physical Class Online Class
23/08/2027 - 27/08/2027 $4500 Pretoria, South Africa Physical Class Online Class
23/08/2027 - 27/08/2027 $2000 Mombasa, Kenya 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 $5000 Dubai, UAE Physical Class Online Class
30/08/2027 - 03/09/2027 $4500 Pretoria, South Africa Physical Class Online Class
30/08/2027 - 03/09/2027 $2500 Kigali, Rwanda 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 $1500 Nairobi, Kenya Physical Class Online Class
06/09/2027 - 10/09/2027 $2000 Mombasa, 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 $5000 Singapore, Singapore Physical Class Online Class
13/09/2027 - 17/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 $1500 Nairobi, Kenya Physical Class Online Class
27/09/2027 - 01/10/2027 $5000 Dubai, UAE Physical Class Online Class
27/09/2027 - 01/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
27/09/2027 - 01/10/2027 $5000 Singapore, Singapore Physical Class Online Class
04/10/2027 - 08/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
04/10/2027 - 08/10/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
04/10/2027 - 08/10/2027 $6000 Mauritius Physical Class Online Class
04/10/2027 - 08/10/2027 $4500 Pretoria, South Africa Physical Class Online Class
04/10/2027 - 08/10/2027 $2500 Kigali, Rwanda Physical Class Online Class
11/10/2027 - 15/10/2027 $4000 Johannesburg, South Africa Physical Class Online Class