Course Overview:
Excel Dashboards for Supervisors is a practical course designed to equip supervisors with the skills needed to create and use Excel dashboards for monitoring daily operations, team performance, productivity, targets, workloads, and key operational indicators. Participants will learn how to organize data, calculate KPIs, create charts and PivotTables, use interactive filters, and develop clear dashboards for routine supervision and reporting.

Target Participants:

  • Supervisors and team leaders
  • Operations supervisors
  • Finance and accounting supervisors
  • Sales supervisors
  • HR and administration supervisors
  • Production supervisors
  • Procurement and supply chain supervisors
  • Project supervisors
  • Monitoring and evaluation officers
  • Staff responsible for operational reporting

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

  • Create practical Excel dashboards for supervisory reporting.
  • Organize and prepare operational data for analysis.
  • Develop relevant team and operational KPIs.
  • Use Excel formulas to calculate performance indicators.
  • Create and analyze PivotTables and PivotCharts.
  • Develop charts for monitoring trends and performance.
  • Use slicers and filters to interact with dashboard information.
  • Monitor actual performance against targets.
  • Identify performance gaps and operational trends.
  • Apply conditional formatting and visual indicators.
  • Use Power Query for basic data cleaning and transformation.
  • Prepare clear dashboards for supervisory meetings and reporting.

Course Outline:

  1. Introduction to Excel Dashboards
    • Purpose and uses of dashboards
    • Dashboard components
    • Supervisory reporting requirements
    • Basic dashboard design principles
  2. Preparing Operational Data
    • Data entry and organization
    • Excel tables
    • Data cleaning and validation
    • Removing duplicates and errors
  3. Excel Formulas for Supervisory Reporting
    • IF and logical functions
    • SUMIFS and COUNTIFS
    • AVERAGEIFS
    • XLOOKUP
    • Error handling and dynamic calculations
  4. Supervisory KPIs
    • Identifying relevant KPIs
    • Setting targets
    • Actual versus target analysis
    • Productivity indicators
    • Attendance and workload indicators
    • Variance analysis
  5. PivotTables and PivotCharts
    • Creating PivotTables
    • Filtering and grouping data
    • Summarizing team performance
    • Creating PivotCharts
    • Refreshing dashboard data
  6. Charts and Data Visualization
    • Column and bar charts
    • Line charts
    • Combination charts
    • Sparklines
    • Conditional formatting
    • Traffic-light indicators
  7. Interactive Dashboards
    • Using slicers
    • Using timelines
    • Interactive filters
    • Dynamic charts
    • Dashboard navigation
  8. Power Query for Supervisors
    • Importing operational data
    • Cleaning datasets
    • Combining data
    • Transforming data
    • Refreshing reports
  9. Practical Supervisory Dashboards
    • Team performance dashboard
    • Sales monitoring dashboard
    • Attendance dashboard
    • Productivity dashboard
    • Project/task monitoring dashboard

 

Course Schedules:

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