- Call: +254 184 263 663
- Email: training(@)plezafriqueinstitute.org
- Home
- Categories
- Research, Data Management & Data Analytics Courses
- Accounting, Finance & Taxation Courses
- Audit, Compliance and Governance Training
- Leadership, Supervision & Management
- Professional Communication & Interpersonal Skills
- Project Management & Agile Methodologies
- Financial Acumen for Non-Financial Managers
- Customer Service & Client Experience (CX)
- Sales, Negotiation & Revenue Growth
- Cybersecurity, Data Privacy & Information Security
- Data Analytics, Business Intelligence & AI Literacy
- Operations, Quality Control & Lean Six Sigma
- Workplace Wellness, Productivity & Compliance
- Data, Statistics & Analytics
- Engineering, Construction & Technical
- Real Estate, Insurance & Risk
- Administration, Governance & Records
- About Us
- Courses
- News
- Contact Us
Course Overview:
Excel Dashboards for Managers is a practical management-focused course designed
to equip managers with the skills required to create interactive dashboards for
monitoring organizational performance, analyzing trends, tracking KPIs, and
supporting evidence-based decision-making. Participants will learn how to
transform operational and financial data into concise management dashboards
using Excel formulas, PivotTables, PivotCharts, slicers, conditional
formatting, and Power Query.
Target Participants:
- Departmental and functional managers
- Finance and accounting managers
- Operations managers
- Sales and marketing managers
- Human resource managers
- Project and programme managers
- Procurement and supply chain managers
- Monitoring and evaluation managers
- Business and performance managers
- Managers responsible for reporting and decision-making
Course Objectives:
By the end of the course, participants will be able to:
- Develop professional Excel dashboards for management
reporting.
- Identify and design relevant management KPIs.
- Prepare and organize data for dashboard analysis.
- Use PivotTables and PivotCharts to summarize management
information.
- Create interactive dashboards using slicers and
timelines.
- Apply Excel formulas to automate performance
calculations.
- Analyze actual versus target performance.
- Identify trends, variances, and performance gaps.
- Use charts and conditional formatting to communicate
information effectively.
- Use Power Query to clean and transform management data.
- Develop dynamic and refreshable dashboards.
- Use dashboards to support managerial planning and
decision-making.
Course Outline:
- Introduction to Management Dashboards
- Purpose of management dashboards
- Dashboard components
- Types of management dashboards
- Principles of effective dashboard design
- Preparing Management Data
- Data organization and validation
- Data cleaning
- Structuring Excel tables
- Identifying relevant management indicators
- Excel Formulas for Management Reporting
- IF and logical functions
- SUMIFS and COUNTIFS
- XLOOKUP and INDEX/MATCH
- Error handling
- Dynamic calculations
- KPIs and Performance Measurement
- KPI identification
- Targets and actual performance
- Variance analysis
- Trend analysis
- Performance indicators and scorecards
- PivotTables and PivotCharts
- Summarizing management data
- Filtering and grouping
- Creating management reports
- Developing PivotCharts
- Interactive Dashboard Design
- Slicers and timelines
- Interactive filters
- Dynamic charts
- Dashboard navigation
- User-friendly dashboard layouts
- Management Data Visualization
- Selecting appropriate charts
- Trend and comparison charts
- Conditional formatting
- Traffic-light indicators
- Executive-level visual reporting
- Power Query for Management Dashboards
- Importing data
- Cleaning and transforming data
- Combining datasets
- Refreshing dashboard information
- Management Dashboard Applications
- Financial performance dashboard
- Sales performance 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 | $6000 | Mauritius | 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 |
| 23/11/2026 - 27/11/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 30/11/2026 - 04/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/12/2026 - 11/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 | $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 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $5000 | Dubai, UAE | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 14/12/2026 - 18/12/2026 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 21/12/2026 - 25/12/2026 | $2500 | Dar es Salaam, Tanzania | 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 | $6000 | Mauritius | Physical Class Online Class |
| 04/01/2027 - 08/01/2027 | $4500 | Pretoria, South Africa | 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 | $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 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 18/01/2027 - 22/01/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 25/01/2027 - 29/01/2027 | $5000 | Singapore, Singapore | 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 |
| 01/02/2027 - 05/02/2027 | $6000 | Mauritius | 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 |
| 08/02/2027 - 12/02/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 08/02/2027 - 12/02/2027 | $6000 | Mauritius | 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 |
| 15/02/2027 - 19/02/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 15/02/2027 - 19/02/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 22/02/2027 - 26/02/2027 | $5000 | Dubai, UAE | 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 | $2000 | Mombasa, 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 |
| 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 |
| 01/03/2027 - 05/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 | Singapore, Singapore | 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 |
| 22/03/2027 - 26/03/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 22/03/2027 - 26/03/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 29/03/2027 - 02/04/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 05/04/2027 - 09/04/2027 | $5000 | Singapore, Singapore | 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 | $5000 | Dubai, UAE | 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 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 12/04/2027 - 16/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 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 19/04/2027 - 23/04/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 26/04/2027 - 30/04/2027 | $6000 | Mauritius | 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 | $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 |
| 10/05/2027 - 14/05/2027 | $6000 | Mauritius | 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 | $2000 | Mombasa, 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 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 24/05/2027 - 28/05/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 24/05/2027 - 28/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 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 31/05/2027 - 04/06/2027 | $2000 | Mombasa, Kenya | 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 |
| 07/06/2027 - 11/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 07/06/2027 - 11/06/2027 | $4500 | Pretoria, South Africa | 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 |
| 14/06/2027 - 18/06/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 14/06/2027 - 18/06/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 21/06/2027 - 25/06/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 28/06/2027 - 02/07/2027 | $2500 | Kigali, Rwanda | 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 |
| 05/07/2027 - 09/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 05/07/2027 - 09/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 05/07/2027 - 09/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 | $2500 | Dar es Salaam, Tanzania | Physical Class Online Class |
| 12/07/2027 - 16/07/2027 | $6000 | Mauritius | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 19/07/2027 - 23/07/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $5000 | Dubai, UAE | 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 |
| 26/07/2027 - 30/07/2027 | $6000 | Mauritius | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 26/07/2027 - 30/07/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 02/08/2027 - 06/08/2027 | $5000 | Dubai, UAE | 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 | $1500 | Nairobi, Kenya | 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 | Singapore, Singapore | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $6000 | Mauritius | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 16/08/2027 - 20/08/2027 | $1500 | Nairobi, 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 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $6000 | Mauritius | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 30/08/2027 - 03/09/2027 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 06/09/2027 - 10/09/2027 | $5000 | Dubai, UAE | 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 |
| 13/09/2027 - 17/09/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $5000 | Dubai, UAE | Physical Class Online Class |
| 13/09/2027 - 17/09/2027 | $1500 | Nairobi, 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 | $2000 | Mombasa, Kenya | Physical Class Online Class |
| 27/09/2027 - 01/10/2027 | $2500 | Kigali, Rwanda | Physical Class Online Class |
| 27/09/2027 - 01/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 | $1500 | Nairobi, Kenya | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $4500 | Pretoria, South Africa | Physical Class Online Class |
| 04/10/2027 - 08/10/2027 | $5000 | Singapore, Singapore | Physical Class Online Class |
| 11/10/2027 - 15/10/2027 | $4000 | Johannesburg, South Africa | Physical Class Online Class |
No upcoming dates for this location.


