Course Overview

The Excel Dashboards course is designed to equip participants with practical skills for creating professional, interactive, and visually effective dashboards using Microsoft Excel. Participants will learn how to transform raw data into meaningful KPIs, charts, summaries, and interactive reports that support monitoring, performance management, reporting, and decision-making. The course emphasizes hands-on dashboard development using real-world datasets.

Target Participants

  • Managers and supervisors
  • Finance and accounting professionals
  • Business and data analysts
  • Monitoring and evaluation professionals
  • Project and programme officers
  • Human resource professionals
  • Sales and marketing professionals
  • Operations and performance professionals
  • Entrepreneurs and business owners
  • Consultants and management professionals
  • Professionals responsible for reporting and data visualization

Course Objectives

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

  • Understand the principles of effective Excel dashboard design.
  • Prepare and structure data for dashboard development.
  • Define relevant KPIs and performance indicators.
  • Create interactive charts and visualizations.
  • Use PivotTables and PivotCharts to build dashboards.
  • Apply slicers and timelines for interactive filtering.
  • Create dynamic dashboard elements using formulas.
  • Design management and executive dashboards.
  • Apply conditional formatting to highlight important information.
  • Integrate multiple datasets into a dashboard.
  • Use Power Query to prepare and refresh dashboard data.
  • Improve dashboard usability, accuracy, and presentation.
  • Develop professional dashboards for business and organizational reporting.

Course Outline

Module 1: Introduction to Excel Dashboards

  • What is an Excel dashboard?
  • Purpose and applications of dashboards
  • Types of dashboards
  • Dashboard components
  • Principles of effective dashboard design
  • Understanding the dashboard development process

Module 2: Preparing Data for Dashboards

  • Data collection and organization
  • Excel tables
  • Data cleaning and validation
  • Removing duplicates
  • Handling missing data
  • Structuring data for analysis
  • Preparing dashboard-ready datasets

Module 3: KPI Development and Analysis

  • Understanding KPIs
  • Defining measurable indicators
  • Target versus actual analysis
  • Performance indicators
  • KPI calculations
  • KPI scorecards
  • Presenting performance measures

Module 4: Excel Formulas for Dashboards

  • IF and IFS functions
  • SUMIFS and COUNTIFS
  • AVERAGEIFS
  • XLOOKUP
  • INDEX and MATCH
  • Dynamic formulas
  • Error handling
  • Creating dynamic dashboard metrics

Module 5: Charts and Data Visualization

  • Selecting appropriate charts
  • Column and bar charts
  • Line charts
  • Pie and doughnut charts
  • Combination charts
  • Dynamic charts
  • Conditional formatting
  • Effective data visualization

Module 6: PivotTables and PivotCharts

  • Creating PivotTables
  • Summarizing dashboard data
  • PivotCharts
  • Grouping and filtering
  • Calculated fields
  • Slicers
  • Timelines
  • Interactive dashboard components

Module 7: Interactive Dashboard Design

  • Dashboard layout
  • Navigation and user experience
  • Interactive filters
  • Dynamic titles and labels
  • KPI cards
  • Linking multiple dashboard elements
  • Dashboard usability and presentation

Module 8: Power Query for Dashboard Development

  • Importing data from different sources
  • Data transformation
  • Merging and appending datasets
  • Automated data cleaning
  • Refreshing dashboard data
  • Building repeatable dashboard workflows

Module 9: Management and Executive Dashboards

  • Management performance dashboards
  • Financial dashboards
  • Sales dashboards
  • HR dashboards
  • Project dashboards
  • Operations dashboards
  • Executive KPI dashboards

Module 10: Dashboard Automation and Optimization

  • Automating dashboard updates
  • Introduction to macros
  • Dashboard protection
  • Improving workbook performance
  • Managing dashboard data sources
  • Maintaining dashboard accuracy

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