Course Overview

The Practical Advanced Excel course is designed to provide hands-on experience in using advanced Excel tools to solve real-world workplace problems. Participants will work with practical datasets and business scenarios to develop skills in advanced formulas, data analysis, PivotTables, dashboards, financial modelling, reporting, forecasting, Power Query, and Excel automation. The course emphasizes practical application, problem-solving, and workplace productivity.

Target Participants

  • Finance and accounting professionals
  • Business and data analysts
  • Managers and supervisors
  • Project and programme officers
  • Monitoring and evaluation professionals
  • Human resource professionals
  • Procurement and supply chain professionals
  • Administrative and operations professionals
  • Entrepreneurs and business owners
  • Professionals with intermediate Excel knowledge seeking practical advanced skills

Course Objectives

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

  • Apply advanced Excel formulas to real-world workplace problems.
  • Clean, organize, and analyse complex datasets.
  • Use XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and other advanced functions.
  • Build and analyse PivotTables and PivotCharts.
  • Create interactive dashboards and KPI reports.
  • Perform financial, operational, and performance analysis.
  • Apply forecasting, scenario, and sensitivity analysis.
  • Use Power Query to import, clean, transform, and combine data.
  • Automate repetitive Excel tasks using macros.
  • Create professional management and analytical reports.
  • Use charts and visualizations to communicate data insights.
  • Develop practical Excel-based decision-support tools.

Course Outline

Module 1: Advanced Excel in Practice

  • Advanced Excel interface and productivity techniques
  • Workbook and worksheet management
  • Excel tables and structured references
  • Named ranges
  • Professional spreadsheet design
  • Practical Excel shortcuts

Module 2: Advanced Formulas and Functions

  • XLOOKUP
  • INDEX and MATCH
  • IF and IFS
  • SUMIFS and COUNTIFS
  • AVERAGEIFS
  • Text and date functions
  • Dynamic array functions
  • Error handling
  • Nested formulas

Module 3: Practical Data Cleaning and Management

  • Importing and preparing data
  • Removing duplicates
  • Data validation
  • Sorting and filtering
  • Text-to-columns
  • Cleaning inconsistent data
  • Managing large datasets

Module 4: PivotTables and PivotCharts

  • Creating PivotTables
  • Grouping and summarizing data
  • Advanced filtering
  • Calculated fields
  • PivotCharts
  • Slicers and timelines
  • Practical management reporting

Module 5: Practical Excel Dashboards

  • Dashboard design principles
  • KPI tracking
  • Interactive charts
  • Dynamic dashboards
  • Performance monitoring
  • Management scorecards
  • Practical dashboard development

Module 6: Financial and Business Analysis

  • Budget preparation and analysis
  • Revenue and expenditure analysis
  • Profitability analysis
  • Cost analysis
  • Budget versus actual analysis
  • Variance analysis
  • Financial modelling

Module 7: Forecasting and What-If Analysis

  • Trend analysis
  • Forecasting
  • Goal Seek
  • Scenario Manager
  • Data Tables
  • Sensitivity analysis
  • Practical business scenarios

Module 8: Power Query

  • Importing data from different sources
  • Data transformation
  • Merging and appending datasets
  • Automated data cleaning
  • Refreshable reports
  • Practical Power Query exercises

Module 9: Excel Automation

  • Introduction to macros
  • Recording macros
  • Automating repetitive tasks
  • Basic VBA concepts
  • Automated reporting
  • Practical automation exercises

 

Course Schedules:

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