Excel for Data Analysis
Excel remains the tool every analyst reaches for first. This module builds real mastery — formulas, pivot tables, lookups and dashboards — turning Excel from a spreadsheet into a genuine analysis tool.
What You Will Learn
A detailed, industry-aligned breakdown of every topic covered in this module.
- Excel formulas & functions for analysis
- Pivot tables & pivot charts
- Data cleaning with Excel
- VLOOKUP, XLOOKUP & INDEX-MATCH
- Conditional formatting & data validation
- What-if analysis & scenario tools
- Building dashboards in Excel
- Automating tasks with basic macros
Tools You Will Use
Hands-on time with the same tools used by working business and data analysts today.
Excel
Spreadsheet tool used for quick data analysis, calculations and lightweight reporting.
Google Sheets
Cloud-based spreadsheet tool used for collaborative data analysis and quick calculations.
Power Query
Data-transformation tool used inside Excel to import, clean and reshape data sources.
Hands-On Labs
Production-style data analytics lab scenarios, built using real business datasets.
Clean and prepare a messy dataset using Excel formulas and data validation.
Build a pivot table and pivot chart to summarise a real business dataset.
Look up and merge data across sheets using VLOOKUP, XLOOKUP and INDEX-MATCH.
Run a what-if analysis using Excel's scenario tools.
Build a simple interactive dashboard in Excel using pivot tables and slicers.
Assessment
Knowledge Assessment
Quiz covering pivot tables, lookup functions and data validation techniques.
Practical Evaluation
Students must clean a raw dataset and build an interactive Excel dashboard that answers a set of business questions.
Projects
Industry-style deliverables added directly to your project portfolio.
Excel Dashboard Build
Clean a raw dataset and build an interactive Excel dashboard with pivot tables and lookups.
What This Module Builds
Students gain hands-on mastery of Excel as an analytics tool, from cleaning raw data to building interactive dashboards.