Festival Season OfferUp to 25% off on all our programmes — claim it before you enrol
MODULE 2 OF 9  ·  20 Hrs  ·  2 Weeks

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.

Who This Module Is For
Students who have completed the fundamentals module and are ready to build real analysis skills in Excel.
Real-World Relevance
Excel fluency — especially pivot tables and lookups — is tested directly in almost every data analyst interview, and remains the tool most businesses actually run their reporting on.
Program OverviewView Hands-On Labs
Curriculum

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
Technology Stack

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.

Practical Work

Hands-On Labs

Production-style data analytics lab scenarios, built using real business datasets.

01

Clean and prepare a messy dataset using Excel formulas and data validation.

02

Build a pivot table and pivot chart to summarise a real business dataset.

03

Look up and merge data across sheets using VLOOKUP, XLOOKUP and INDEX-MATCH.

04

Run a what-if analysis using Excel's scenario tools.

05

Build a simple interactive dashboard in Excel using pivot tables and slicers.

Evaluation

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.

Portfolio

Projects

Industry-style deliverables added directly to your project portfolio.

Portfolio Project 01

Excel Dashboard Build

Clean a raw dataset and build an interactive Excel dashboard with pivot tables and lookups.

Module Outcome

What This Module Builds

Students gain hands-on mastery of Excel as an analytics tool, from cleaning raw data to building interactive dashboards.

Maps to job roles
Data AnalystReporting AnalystBusiness Analyst (Junior)Excel Analyst
FAQs

Questions about Excel for Data Analysis

Do I need to know Excel well before this module?

No. The module follows Module 1 and starts with the formulas and functions you use for analysis, then builds up to pivot tables, lookups and dashboards over 2 weeks (20 hours). If you already use Excel at work, the labs on lookups, what-if analysis and macros will still stretch you.

Why learn Excel when the course also covers SQL and Power BI?

Most businesses still run their day-to-day reporting in spreadsheets, and pivot tables and lookups are tested directly in data analyst interviews. Excel is also where you first learn to clean data, summarise it and build a dashboard. Later modules repeat those steps with SQL and Power BI, so the ideas carry straight over.

Which lookup functions does the module cover?

VLOOKUP, XLOOKUP and INDEX-MATCH. You use all three in a lab that merges data across sheets, so you see where each one works and where it breaks, for example when columns move or a lookup has to search to the left.

What will I have built by the end of the module?

An interactive Excel dashboard built from a raw dataset, using pivot tables, pivot charts and slicers. For the practical evaluation you clean the raw data yourself and use the dashboard to answer a set of business questions, and the dashboard goes into your project portfolio.

Does the module cover Power Query and macros?

Yes, at an introductory level. Power Query is used to import, clean and reshape data inside Excel, and the final topic covers automating repetitive tasks with basic macros. Google Sheets is used alongside Excel for shared, collaborative analysis.

Continue building your data analytics portfolio

Next up: Module 3 — SQL for Data Analysis

Go to Module 3Full Roadmap