Course Overview

The Advanced Excel Dashboards course equips participants with advanced skills for designing interactive, dynamic, and professional dashboards using Microsoft Excel. The course focuses on transforming complex datasets into meaningful KPIs, visual reports, interactive charts, and management information systems that support analysis, performance monitoring, and strategic decision-making. Participants will work with advanced formulas, PivotTables, PivotCharts, slicers, Power Query, dynamic visualizations, and dashboard automation techniques.

Target Participants

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

Course Objectives

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

  • Design advanced and professional Excel dashboards.
  • Structure and prepare complex datasets for dashboard development.
  • Develop meaningful KPIs and performance indicators.
  • Use advanced Excel formulas to create dynamic dashboard metrics.
  • Build interactive PivotTable and PivotChart dashboards.
  • Apply slicers, timelines, filters, and interactive controls.
  • Create dynamic and visually effective charts.
  • Use conditional formatting for advanced performance analysis.
  • Apply Power Query to import, clean, transform, and refresh data.
  • Integrate multiple datasets into a single dashboard.
  • Develop financial, sales, HR, operational, and management dashboards.
  • Automate dashboard updates and reporting processes.
  • Optimize dashboard performance and usability.
  • Apply professional dashboard design and presentation principles.
  • Build a complete advanced Excel dashboard from a real-world dataset.

Course Outline

Module 1: Advanced Dashboard Concepts

  • Principles of advanced dashboard design
  • Types of organizational dashboards
  • Operational, analytical, management, and executive dashboards
  • Dashboard architecture
  • Dashboard development workflow
  • Data-to-insight transformation
  • Dashboard usability and accessibility

Module 2: Advanced Data Preparation

  • Structuring complex datasets
  • Excel Tables and named ranges
  • Data validation
  • Data cleaning and standardization
  • Handling missing and inconsistent data
  • Removing duplicates
  • Data quality checks
  • Preparing data for automated reporting

Module 3: Advanced Excel Formulas for Dashboards

  • Advanced IF and IFS functions
  • SUMIFS, COUNTIFS, and AVERAGEIFS
  • XLOOKUP
  • INDEX and MATCH
  • Dynamic arrays
  • FILTER, SORT, UNIQUE, and SEQUENCE
  • IFERROR and error management
  • Nested formulas
  • Dynamic dashboard calculations

Module 4: Advanced KPI Development

  • Understanding strategic and operational KPIs
  • KPI selection and design
  • Actual versus target analysis
  • Variance analysis
  • Growth and trend indicators
  • KPI scorecards
  • Traffic-light indicators
  • Dynamic KPI cards
  • Performance monitoring

Module 5: Advanced Data Visualization

  • Advanced chart selection
  • Combination charts
  • Dynamic charts
  • Waterfall charts
  • Histogram and statistical charts
  • Trend and variance charts
  • Interactive chart techniques
  • Chart formatting and optimization
  • Visual storytelling with Excel

Module 6: Advanced PivotTables and PivotCharts

  • Advanced PivotTable techniques
  • Multiple-field analysis
  • Grouping and calculated fields
  • PivotChart development
  • Slicers
  • Timelines
  • Interactive filtering
  • Connecting multiple PivotTables
  • Building interactive dashboard components

Module 7: Interactive Dashboard Development

  • Dashboard layout and architecture
  • Navigation systems
  • Interactive buttons and controls
  • Dynamic titles and labels
  • KPI cards
  • Linked dashboard elements
  • Drill-down analysis
  • Dashboard user experience
  • Professional dashboard presentation

Module 8: Power Query for Advanced Dashboards

  • Importing data from multiple sources
  • Data transformation
  • Combining datasets
  • Merging and appending queries
  • Automated data cleaning
  • Data type management
  • Refreshable datasets
  • Building automated data preparation workflows

Module 9: Advanced Management Dashboards

  • Financial performance dashboards
  • Sales and marketing dashboards
  • Human resource dashboards
  • Project management dashboards
  • Operations dashboards
  • Budget and expenditure dashboards
  • Customer and business performance dashboards
  • Executive performance dashboards

Module 10: Dashboard Automation and Optimization

  • Automating dashboard updates
  • Refreshing data automatically
  • Introduction to Excel macros
  • Workbook protection
  • Managing dashboard dependencies
  • Improving workbook performance
  • Reducing calculation delays
  • Dashboard maintenance and version control

 

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