Course Overview

The Practical Excel Data Analysis course provides hands-on training in using Microsoft Excel to collect, clean, organize, analyse, and present real-world data. Participants will work with practical datasets to develop skills in formulas, data cleaning, PivotTables, charts, dashboards, statistical analysis, forecasting, and reporting. The course emphasizes practical problem-solving and the application of Excel data analysis techniques to workplace situations.

Target Participants

  • Finance and accounting professionals
  • Business and data analysts
  • Managers and supervisors
  • Monitoring and evaluation professionals
  • Researchers and project officers
  • Human resource professionals
  • Marketing and sales professionals
  • Procurement and supply chain professionals
  • Operations and administrative professionals
  • Entrepreneurs and business owners
  • Students and professionals working with data

Course Objectives

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

  • Import and organize real-world datasets in Excel.
  • Clean and prepare data for analysis.
  • Apply Excel formulas and functions to practical data problems.
  • Use XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and related functions.
  • Analyse data using PivotTables and PivotCharts.
  • Perform descriptive, comparative, and trend analysis.
  • Create professional charts and data visualizations.
  • Develop interactive dashboards and KPI reports.
  • Conduct basic forecasting and what-if analysis.
  • Use Power Query to clean and combine datasets.
  • Prepare professional analytical reports.
  • Interpret data and communicate meaningful insights.
  • Apply Excel analysis techniques to practical workplace problems.

Course Outline

Module 1: Practical Excel Data Analysis Fundamentals

  • Understanding data analysis
  • Excel data analysis workflow
  • Setting up analytical workbooks
  • Excel tables and structured references
  • Organizing datasets
  • Practical data analysis exercises

Module 2: Data Cleaning and Preparation

  • Identifying data errors
  • Removing duplicate records
  • Handling missing and inconsistent data
  • Data validation
  • Sorting and filtering
  • Text-to-columns
  • Conditional formatting
  • Practical data-cleaning exercises

Module 3: Excel Formulas for Data Analysis

  • IF and IFS functions
  • SUMIFS and COUNTIFS
  • AVERAGEIFS
  • XLOOKUP
  • INDEX and MATCH
  • Text functions
  • Date functions
  • Error-handling functions
  • Practical formula exercises

Module 4: PivotTables and PivotCharts

  • Creating PivotTables
  • Summarizing datasets
  • Grouping and filtering
  • Calculated fields
  • PivotCharts
  • Slicers and timelines
  • Practical reporting exercises

Module 5: Practical Statistical Analysis

  • Mean, median, and mode
  • Minimum and maximum
  • Range
  • Variance and standard deviation
  • Percentages and ratios
  • Frequency analysis
  • Comparative analysis
  • Practical statistical exercises

Module 6: Data Visualization

  • Selecting appropriate charts
  • Column and bar charts
  • Line charts
  • Pie charts
  • Combination charts
  • Conditional formatting
  • Dynamic charts
  • Presenting analytical findings

Module 7: Practical Dashboards

  • Dashboard design principles
  • KPI development
  • Interactive dashboards
  • Performance scorecards
  • Dynamic visualizations
  • Management reporting
  • Practical dashboard development

Module 8: Forecasting and What-If Analysis

  • Trend analysis
  • Moving averages
  • Basic forecasting
  • Goal Seek
  • Scenario Manager
  • Sensitivity analysis
  • Practical business scenarios

Module 9: Power Query for Practical Analysis

  • Importing data from different sources
  • Cleaning and transforming data
  • Merging datasets
  • Appending datasets
  • Automating data preparation
  • Refreshing analytical reports 

Course Schedules:

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