DataCareerHubLearn · Practice · Progress
Explore learning
DataCareerHub
Explore learning
Learning paths/Data Analyst Foundations
Module 02 · Excel practice

Excel for data analysis.

Prepare an order extract, build reliable formulas, map categories, create a PivotTable and explain your findings in Excel.

6 published lessons305 min suggested studyStarter & solution workbooks
Start the first lesson →Get the practice files ↓
The same case, new skills

Northstar Shop

From an order extract
to a working Excel analysis.

2 reporting months12 verified orders
Fictional learning case · EUR · No personal data
What you will produce

An Excel analysis
you can explain.

Prepare the data, build monthly metrics, classify channels and reconcile your results. Create your own PivotTable and an editable chart, then write a concise evidence note. Every lesson includes an explanation, practical task and worked solution.

Before you start: Complete Module 1 or understand grain, completed-order metrics and source-backed corrections. Use Excel with basic formula support. A desktop edition is recommended for the full PivotTable task. No macros or add-ins are needed.

Allow about five hours including exercises. The suggested times are flexible. Keep your work locally; no upload or payment is required.

The starter supplies verified Prepared inputs for the formula lessons. Recreate cleaning on a separate Source copy. Neither workbook has a prebuilt PivotTable: you create one in Excel. The solution includes live formula totals and an editable chart.

A connected learning journey

6 lessons. One complete piece of work.

Explanation + practice + solution
01

Import data and build a reliable Excel Table

Keep raw source data separate from prepared analytical data.

40 min02

Clean carefully and keep a quality log

Find duplicates, missing fields and invalid values without destroying the source.

50 min03

Build monthly metrics with reliable formulas

Use relative, absolute and mixed references intentionally.

60 min04

Join a mapping with exact lookups

Use a unique mapping key instead of repeated nested category rules.

45 min05

Build a PivotTable and reconcile the result

Choose a PivotTable source at the correct row grain.

55 min06

Create a clear chart and deliver your analysis

Build an editable chart linked to the correct summary.

55 min
Everything for the exercise

Your workbook.
Your practical next step.

Start with your own copy of the learner workbook. Amber areas are for your formulas and notes. Open the separate solution after trying the exercises.

The .xlsx files contain no macros or external connections. English formulas use comma separators; adapt to your Excel locale. INDEX/MATCH is provided for compatibility. All records are fictional.

Starter workbookPractice in the amber cells. Verified inputs are supplied.
Download ↓
Worked solution workbookLive formulas, mapping checks and an editable chart.
Download ↓
Raw orders CSV13 rows with the four deliberate issues from Module 1.
Download ↓
Verified orders CSV12 unique fictional orders for checking your preparation.
Download ↓
Channel mapping CSVUnique channel keys and their training classifications.
Download ↓
Data dictionary & workbook guideField meaning, worksheet ranges and compatibility notes.
Download ↓
Learner worksheetRecord your tests, native PivotTable task and evidence note.
Download ↓
Before moving on

Can someone reproduce your answer?

Use the final lesson's 10-point rubric to review your work. A suggested target is 8 points, with no zero in formulas and no unsupported causal claim. This is a self-review guide, not an accredited or automatically verified assessment.

Begin Module 02 →

Continue to Module 03: SQL for data analysis →

Self-learning is free. Verify your email for protected practice materials; optional support never affects access.