Course Overview

The Advanced Excel Data Analysis course is designed to equip participants with advanced skills for analysing complex datasets, identifying trends and patterns, developing interactive dashboards, conducting statistical and financial analysis, and producing decision-ready reports. The course combines advanced Excel formulas, PivotTables, Power Query, data visualization, forecasting, scenario analysis, and practical analytical techniques using real-world datasets.

Target Participants

  • Data and business analysts
  • Finance and accounting professionals
  • Managers and supervisors
  • Monitoring and evaluation professionals
  • Researchers and statisticians
  • Project and programme officers
  • Operations and performance analysts
  • Marketing and sales professionals
  • Human resource professionals
  • Procurement and supply chain professionals
  • Consultants and business advisors
  • Professionals with intermediate Excel and data analysis skills

Course Objectives

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

  • Apply advanced Excel functions to complex data analysis problems.
  • Clean, transform, and structure large datasets for analysis.
  • Use advanced lookup, logical, statistical, and financial functions.
  • Perform descriptive, comparative, and trend analysis.
  • Use PivotTables, PivotCharts, slicers, and timelines for advanced analysis.
  • Develop interactive dashboards and KPI reporting systems.
  • Apply advanced data visualization techniques.
  • Conduct correlation, variance, and sensitivity analysis.
  • Apply forecasting and scenario modelling techniques.
  • Use Power Query to import, combine, and transform datasets.
  • Automate recurring data preparation and reporting processes.
  • Interpret analytical results and communicate insights effectively.
  • Develop professional Excel-based decision-support tools.

Course Outline

Module 1: Advanced Excel Data Analysis Framework

  • Data analysis workflow
  • Structuring datasets for analysis
  • Excel tables and structured references
  • Named ranges
  • Managing large datasets
  • Analytical workbook design

Module 2: Advanced Formulas and Functions

  • XLOOKUP
  • INDEX and MATCH
  • Advanced logical functions
  • SUMIFS, COUNTIFS and AVERAGEIFS
  • Statistical functions
  • Financial functions
  • Dynamic array functions
  • Nested formulas
  • Error handling and formula auditing

Module 3: Advanced Data Cleaning and Transformation

  • Identifying data inconsistencies
  • Handling missing data
  • Removing duplicates
  • Text and date transformations
  • Data validation
  • Advanced sorting and filtering
  • Preparing datasets for analysis

Module 4: Advanced PivotTable Analysis

  • Advanced PivotTables
  • Grouping and calculated fields
  • Multiple-level analysis
  • PivotCharts
  • Slicers and timelines
  • Interactive analytical reports
  • Drill-down analysis

Module 5: Advanced Statistical Analysis

  • Descriptive statistics
  • Mean, median, and mode
  • Variance and standard deviation
  • Percentiles and quartiles
  • Frequency distributions
  • Correlation analysis
  • Comparative analysis
  • Trend analysis

Module 6: Advanced Data Visualization

  • Choosing appropriate visualizations
  • Advanced charts
  • Combination charts
  • Dynamic charts
  • Conditional formatting
  • KPI visualizations
  • Interactive dashboards
  • Data storytelling

Module 7: Forecasting and Predictive Analysis

  • Trendlines
  • Moving averages
  • Forecasting functions
  • Time-series analysis
  • Scenario modelling
  • Sensitivity analysis
  • What-if analysis
  • Interpreting forecasts

Module 8: Power Query for Advanced Analysis

  • Importing data from multiple sources
  • Data transformation
  • Merging datasets
  • Appending datasets
  • Automated data cleaning
  • Refreshable analytical models
  • Building repeatable data workflows

Module 9: Advanced Business and Financial Analysis

  • Financial performance analysis
  • Budget and variance analysis
  • Revenue and cost analysis
  • Profitability analysis
  • KPI analysis
  • Operational performance analysis
  • Decision-support modelling

Module 10: Advanced Excel Dashboards and Reporting

  • Dashboard architecture
  • Interactive KPI dashboards
  • Management reporting
  • Automated reporting
  • Presenting analytical findings
  • Designing decision-oriented reports

 

Course Schedules:

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