Course Overview:
Practical Excel Dashboards is a hands-on training course designed to equip participants with the practical skills required to create interactive, visually appealing, and functional dashboards using Microsoft Excel. The course emphasizes learning by doing, with participants working with realistic datasets to clean data, calculate KPIs, create PivotTables and charts, build interactive controls, and develop complete dashboards for business and organizational reporting.

Target Participants:

  • Excel users and office professionals
  • Finance and accounting staff
  • Business and data analysts
  • Sales and marketing professionals
  • HR and administration staff
  • Project and programme officers
  • Monitoring and evaluation professionals
  • Operations and procurement staff
  • Supervisors and managers
  • Anyone responsible for Excel-based reporting and analysis

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

  • Build functional Excel dashboards from raw datasets.
  • Clean, organize, and prepare data for dashboard development.
  • Create tables and structured datasets.
  • Calculate and display key performance indicators.
  • Use Excel formulas for automated calculations.
  • Create PivotTables and PivotCharts.
  • Develop interactive dashboards using slicers and timelines.
  • Create dynamic charts and visual reports.
  • Apply conditional formatting and dashboard indicators.
  • Use Power Query for practical data preparation.
  • Refresh and update dashboards efficiently.
  • Design professional dashboards for real-world reporting requirements.

Course Outline:

  1. Introduction to Practical Excel Dashboards
    • Understanding dashboards
    • Dashboard components
    • Examples of business dashboards
    • Dashboard design principles
  2. Preparing Data for Dashboards
    • Importing and organizing data
    • Data cleaning
    • Removing duplicates
    • Data validation
    • Creating Excel Tables
  3. Practical Excel Formulas
    • IF functions
    • SUMIFS and COUNTIFS
    • AVERAGEIFS
    • XLOOKUP
    • INDEX/MATCH
    • Error handling
  4. Creating KPIs
    • Identifying KPIs
    • Target versus actual performance
    • Variance calculations
    • Percentage changes
    • KPI indicators and scorecards
  5. PivotTables and PivotCharts
    • Creating PivotTables
    • Filtering and grouping
    • Summarizing datasets
    • Creating PivotCharts
    • Refreshing PivotTables
  6. Charts and Data Visualization
    • Column and bar charts
    • Line charts
    • Pie and doughnut charts
    • Combination charts
    • Sparklines
    • Conditional formatting
  7. Building Interactive Dashboards
    • Slicers
    • Timelines
    • Interactive filters
    • Dynamic charts
    • Dashboard navigation
  8. Power Query Practical Applications
    • Importing data
    • Cleaning and transforming data
    • Combining datasets
    • Automating repetitive data preparation
    • Refreshing dashboard data
  9. Real-World Dashboard Projects
    • Sales dashboard
    • Financial dashboard
    • HR dashboard
    • Operations dashboard
    • Project performance dashboard

Course Schedules:

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