- Call: +254 184 263 663
- Email: training(@)plezafriqueinstitute.org
- Home
- Categories
- Research, Data Management & Data Analytics Courses
- Accounting, Finance & Taxation Courses
- Audit, Compliance and Governance Training
- Leadership, Supervision & Management
- Professional Communication & Interpersonal Skills
- Project Management & Agile Methodologies
- Financial Acumen for Non-Financial Managers
- Customer Service & Client Experience (CX)
- Sales, Negotiation & Revenue Growth
- Cybersecurity, Data Privacy & Information Security
- Data Analytics, Business Intelligence & AI Literacy
- Operations, Quality Control & Lean Six Sigma
- Workplace Wellness, Productivity & Compliance
- Data, Statistics & Analytics
- Engineering, Construction & Technical
- Real Estate, Insurance & Risk
- Administration, Governance & Records
- About Us
- Courses
- News
- Contact Us
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 |
No upcoming dates for this location.


