Course Overview

The Advanced Excel course is designed to develop practical and advanced skills for analysing data, automating tasks, creating professional reports, and supporting business decision-making. Participants will learn advanced Excel functions, data analysis techniques, PivotTables, dashboards, data visualization, what-if analysis, and automation. The course emphasizes hands-on application using real-world business and organizational datasets.

Target Participants

  • Finance and accounting professionals
  • Business analysts and data analysts
  • Managers and supervisors
  • Project and programme officers
  • Human resource professionals
  • Procurement and supply chain professionals
  • Monitoring and evaluation officers
  • Administrative professionals
  • Entrepreneurs and business owners
  • Professionals who already have basic or intermediate Excel knowledge

Course Objectives

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

  • Apply advanced Excel functions and formulas to solve complex business problems.
  • Analyse and interpret large datasets efficiently.
  • Use PivotTables and PivotCharts for advanced data analysis.
  • Create interactive dashboards and management reports.
  • Apply advanced data-cleaning and data-management techniques.
  • Use conditional formatting and data validation effectively.
  • Perform what-if analysis, forecasting, and scenario modelling.
  • Apply advanced lookup and reference functions.
  • Use Excel tables, named ranges, and structured references.
  • Import, transform, and combine data using Power Query.
  • Automate repetitive tasks using Excel tools and basic VBA concepts.
  • Develop professional financial, operational, and analytical reports.
  • Present data using effective charts and visualizations.

Course Outline

Module 1: Advanced Excel Fundamentals

  • Advanced Excel interface and productivity techniques
  • Workbook and worksheet management
  • Excel tables and structured references
  • Named ranges
  • Advanced formatting and professional worksheet design

Module 2: Advanced Excel Formulas and Functions

  • Logical functions
  • Lookup and reference functions
  • INDEX and MATCH
  • XLOOKUP
  • SUMIFS, COUNTIFS and AVERAGEIFS
  • Text and date functions
  • Dynamic array functions
  • Error-handling functions
  • Nested formulas

Module 3: Advanced Data Management

  • Data cleaning and preparation
  • Removing duplicates
  • Text-to-columns
  • Data validation
  • Sorting and filtering
  • Advanced filtering techniques
  • Working with large datasets

Module 4: PivotTables and PivotCharts

  • Creating and customizing PivotTables
  • Grouping and filtering data
  • Calculated fields
  • PivotCharts
  • Slicers and timelines
  • Interactive management reports

Module 5: Data Analysis and Visualization

  • Selecting appropriate charts
  • Advanced chart techniques
  • Combination charts
  • Dynamic charts
  • Conditional formatting
  • KPI reporting
  • Interactive dashboards
  • Dashboard design principles

Module 6: What-If Analysis and Forecasting

  • Goal Seek
  • Scenario Manager
  • Data Tables
  • Forecasting techniques
  • Trend analysis
  • Sensitivity analysis
  • Business scenario modelling

Module 7: Power Query and Data Transformation

  • Introduction to Power Query
  • Importing data from different sources
  • Cleaning and transforming data
  • Merging and appending datasets
  • Refreshing queries
  • Creating reusable data workflows

Module 8: Advanced Financial and Business Analysis

  • Financial modelling in Excel
  • Budgeting and forecasting
  • Variance analysis
  • Cost and profitability analysis
  • Investment analysis
  • Financial reporting
  • Management decision-support models

Module 9: Excel Automation

  • Automating repetitive tasks
  • Introduction to macros
  • Recording and using macros
  • Basic VBA concepts
  • Automating reports and workflows

 

Course Schedules:

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