Training on Introduction to Data Analysis with Excel
Learn essential data analysis techniques, including data cleaning, data transformation, and data visualization. Gain the skills to extract valuable insights and make data-driven decisions.
Next intake
20 Jul 2026 · Nakuru
Duration
10 days
Live instruction
Delivery
Physical + Virtual
Cohort based
Level
Foundation
Working professionals
Certification
NITA reimbursable
For Kenyan cohorts
Language
English
All materials
About this programme
This course is designed to equip participants with the fundamental skills needed to analyze data using Microsoft Excel. Excel is a powerful tool used by professionals across various industries for data manipulation, analysis, and visualization. This course provides a hands-on approach to learning essential data analysis techniques, enabling participants to turn raw data into meaningful insights that can inform business decisions. By the end of the course, participants will be proficient in using Excel to manage, analyze, and present data effectively.
Course Duration
10 Days
Who Should Attend
- Professionals who are new to data analysis and want to learn how to use Excel for this purpose.
- Business analysts and managers who need to use Excel to interpret data.
- Students and recent graduates looking to build their data analysis skills.
- Anyone interested in enhancing their data handling and analytical abilities using Excel.
What you'll walk away with
By the end of this course, participants will be able to:
- Understand the basics of data analysis and its importance in decision-making.
- Navigate and utilize Excel’s interface and tools for data analysis.
- Perform basic to intermediate data manipulation tasks using Excel functions and formulas.
- Create and interpret various types of charts and graphs for data visualization.
- Use pivot tables and pivot charts to summarize and analyze large datasets.
- Apply Excel’s built-in functions to perform statistical analysis.
- Implement best practices for data cleaning and preparation in Excel.
- Automate repetitive tasks using Excel macros.
- Interpret and present data insights effectively through reports and dashboards.
- Gain confidence in using Excel as a tool for data-driven decision-making.
What we cover, module by module
Module 1: Excel Basics and Data Entry
- Excel interface and basic functionalities
- Data types and formatting
- Efficient data entry techniques
- Case Study: Organizing raw business data into a structured Excel sheet
- Practical: Create and format a dataset using best practices for data entry
Module 2: Data Cleaning and Preparation
- Identifying and handling missing data
- Removing duplicates and inconsistencies
- Data validation and error checking
- Case Study: Cleaning messy sales data for accurate reporting
- Practical: Clean and validate a dataset using Excel tools
Module 3: Excel Formulas and Functions
- Basic arithmetic and logical functions
- Date and time functions
- Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Case Study: Automating calculations in financial reporting
- Practical: Apply formulas and functions to solve real data problems
Module 4: Data Visualization
- Creating various chart types (bar, line, pie, scatter, etc.)
- Customizing chart appearance
- Effective data storytelling through visualization
- Case Study: Presenting business performance using charts
- Practical: Create and customize charts for a dataset
Module 5: Descriptive Statistics
- Measures of central tendency (mean, median, mode)
- Measures of dispersion (range, variance, standard deviation)
- Data distribution analysis (frequency distributions, histograms)
- Case Study: Analyzing customer data trends using descriptive statistics
- Practical: Perform statistical analysis using Excel functions
Module 6: PivotTables and PivotCharts
- Creating and manipulating PivotTables
- Analyzing data with PivotTables
- Generating interactive PivotCharts
- Case Study: Summarizing large datasets for management reporting
- Practical: Build and analyze PivotTables and PivotCharts
Module 7: Data Analysis Tools
- What-if analysis (Goal Seek, Data Tables)
- Solver for optimization problems
- Descriptive statistics ToolPak
- Case Study: Optimizing business decisions using Excel tools
- Practical: Use Solver and What-if analysis for scenario planning
Module 8: Data Analysis with Excel Functions
- Advanced statistical functions (AVERAGEIF, COUNTIF, SUMIF, etc.)
- Correlation and covariance analysis
- Regression analysis (simple linear regression)
- Case Study: Identifying relationships between variables in business data
- Practical: Conduct correlation and regression analysis
Module 9: Data Import and Export
- Importing data from various sources (CSV, text, databases)
- Exporting data to different formats
- Case Study: Integrating external data sources into Excel workflows
- Practical: Import, transform, and export datasets
Module 10: Data Analysis Case Studies
- Real-world examples of data analysis
- Applying learned skills to solve business problems
- Developing critical thinking and problem-solving abilities
- Case Study: End-to-end analysis of a business dataset
- Practical: Complete a full data analysis project from data cleaning to reporting
Where the change lands
Organizational Impact
-
Improve daily operations by equipping employees with fundamental data skills.
-
Increase efficiency by reducing time spent on manual data tasks.
-
Foster a data-literate culture for more informed, reliable decision-making.
Personal Impact
-
Gain essential, widely applicable data skills for modern office roles.
-
Build a foundation for advanced data analysis and career progression.
-
Contribute to team efficiency and success through data-driven insights.
-
Develop confidence to work effectively and professionally with data.
Dates and locations
Upcoming intakes
Every intake is limited to a small cohort. Booking closes when a date fills or three weeks before the start, whichever comes first.
| City | Starts | Ends | Delivery | Book |
|---|---|---|---|---|
NakuruNext | 20 Jul 2026 | 31 Jul 2026 | In-Person | Book |
Kigali | 20 Jul 2026 | 31 Jul 2026 | In-Person | Book |
Accra | 20 Jul 2026 | 31 Jul 2026 | In-Person | Book |
Kisumu | 27 Jul 2026 | 07 Aug 2026 | In-Person | Book |
Johannesburg | 27 Jul 2026 | 07 Aug 2026 | In-Person | Book |
Dakar | 27 Jul 2026 | 07 Aug 2026 | In-Person | Book |
- NakuruNext
20 Jul → 31 Jul·In-Person
Book this intake - Kigali
20 Jul → 31 Jul·In-Person
Book this intake - Accra
20 Jul → 31 Jul·In-Person
Book this intake - Kisumu
27 Jul → 07 Aug·In-Person
Book this intake - Johannesburg
27 Jul → 07 Aug·In-Person
Book this intake - Dakar
27 Jul → 07 Aug·In-Person
Book this intake
Common questions.
Still not sure? Send us a note and a facilitator will get back to you within a business day.
You may also like.
Programmes in the same discipline that participants often pair with this course.
Hybrid5 daysMaster research methods, data analysis, and report writing for the public sector. Gain the skills to conduct rigorous research, analyze data effectively, and communicate findings clearly.
Hybrid5 daysGain practical skills in AI ethics, governance, and regulatory compliance for sustainable innovation.
Hybrid5 daysBuild skills in ethical AI and governance. This course equips professionals to implement AI responsibly while addressing bias, privacy, and accountability.
Course finder
Find the right course for you
Prefer to talk it through? Send us an enquiry and a facilitator will scope a fit within a business day.
For corporate teams
Training 10+ professionals?
We deliver Training on Introduction to Data Analysis with Excel in-house at your offices, at a venue we arrange, or fully virtual. Customise the curriculum against your KPIs, and get a bespoke price for the cohort size you need.