Course Overview

The Excel Data Analysis course is designed to equip participants with practical skills for collecting, cleaning, organizing, analysing, and presenting data using Microsoft Excel. Participants will learn how to transform raw data into meaningful information through formulas, PivotTables, charts, statistical analysis, dashboards, and data visualization. The course emphasizes practical exercises using real-world datasets to support evidence-based decision-making.

Target Participants

  • Data and business analysts
  • Finance and accounting professionals
  • Managers and supervisors
  • Monitoring and evaluation professionals
  • Researchers and statisticians
  • Project and programme officers
  • Human resource professionals
  • Marketing and sales professionals
  • Procurement and supply chain professionals
  • Operations professionals
  • Students and professionals working with data
  • Entrepreneurs and business owners

Course Objectives

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

  • Import, organize, and prepare datasets for analysis.
  • Clean and validate data using Excel tools.
  • Apply formulas and functions for data analysis.
  • Use statistical functions to summarize datasets.
  • Analyse trends, patterns, and relationships in data.
  • Create and interpret PivotTables and PivotCharts.
  • Develop professional charts and data visualizations.
  • Build interactive data analysis dashboards.
  • Conduct descriptive and comparative analysis.
  • Apply what-if and basic forecasting techniques.
  • Use Power Query to transform and consolidate datasets.
  • Present analytical findings through professional reports and dashboards.
  • Use Excel to support evidence-based business decisions.

Course Outline

Module 1: Introduction to Excel Data Analysis

  • Data analysis concepts
  • Excel data analysis workflow
  • Types and sources of data
  • Organizing analytical datasets
  • Excel tables and structured references

Module 2: Data Cleaning and Preparation

  • Identifying data errors
  • Removing duplicates
  • Handling missing and inconsistent data
  • Text-to-columns
  • Data validation
  • Sorting and filtering
  • Conditional formatting

Module 3: Excel Formulas for Data Analysis

  • Logical functions
  • Lookup and reference functions
  • XLOOKUP
  • INDEX and MATCH
  • SUMIFS and COUNTIFS
  • AVERAGEIFS
  • Text and date functions
  • Error-handling functions

Module 4: Descriptive Data Analysis

  • Measures of central tendency
  • Mean, median, and mode
  • Minimum and maximum values
  • Range and variance
  • Standard deviation
  • Percentages and ratios
  • Frequency analysis

Module 5: PivotTables and PivotCharts

  • Creating PivotTables
  • Summarizing large datasets
  • Grouping and filtering data
  • Calculated fields
  • PivotCharts
  • Slicers and timelines
  • Interactive analysis

Module 6: Data Visualization

  • Selecting appropriate charts
  • Column, bar, line, and pie charts
  • Combination charts
  • Trend visualization
  • Conditional formatting
  • Dynamic charts
  • Effective presentation of analytical findings

Module 7: Advanced Data Analysis

  • Correlation analysis
  • Trend analysis
  • Variance analysis
  • Comparative analysis
  • Ranking and classification
  • What-if analysis
  • Sensitivity analysis

Module 8: Forecasting and Predictive Analysis

  • Forecasting concepts
  • Trendlines
  • Moving averages
  • Forecast functions
  • Scenario analysis
  • Basic predictive techniques
  • Interpreting forecast results

Module 9: Power Query for Data Analysis

  • Importing data from different sources
  • Data transformation
  • Merging and appending datasets
  • Automating data preparation
  • Refreshing analytical datasets
  • Creating repeatable data workflows

Module 10: Excel Dashboards and Reporting

  • Dashboard design principles
  • KPI development
  • Interactive dashboards
  • Data storytelling
  • Analytical reports
  • Presenting insights to decision-makers

 

Course Schedules:

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