← Back to Courses

Excel Advanced

You are a newly hired data analyst at the United Nations Population Division. Your first assignment is to turn a real, world-bank sourced population dataset into a clean, analysed and professionally formatted workbook. This advanced Excel course takes you through the whole workflow: importing real-world data, cleaning and structuring it, building lookups and logic, summarising millions of rows with PivotTables, creating charts and a dashboard, and finally validating, protecting and exporting your work. Each lesson is a step in the assignment, and the course ends with a final quiz.

Explore this course

Preview the journey below — 6 hands-on labs. Enroll to unlock the labs, study notes, the practice quiz and the certification exam.

Login to Enroll for K300.00 Create an account
📖

Study Notes

Enroll to unlock this study note.
Enroll to unlock this study note.
Enroll to unlock this study note.
Enroll to unlock this study note.
Enroll to unlock this study note.
Enroll to unlock this study note.
💡

Hints

1

Getting Started with the Population Dataset

Stuck? Peek at a pointer, not the answer

2

Cleaning and Organising the Data

Stuck? Peek at a pointer, not the answer

3

Lookups and Logic with Formulas

Stuck? Peek at a pointer, not the answer

4

Summarising with PivotTables and Slicers

Stuck? Peek at a pointer, not the answer

5

Charts, Data Bars and a Dashboard

Stuck? Peek at a pointer, not the answer

6

Validation, Protection and Export

Stuck? Peek at a pointer, not the answer

💻

Hands-On Labs

Getting Started with the Population Dataset

Import the real World Bank population CSV, inspect it, and convert it into a proper Excel workbook.

55 min · Enrolled users only

Cleaning and Organising the Data

Format the raw data as a proper Excel table, check for duplicates, and make the sheet easier to work with.

55 min · Enrolled users only

Lookups and Logic with Formulas

Add the income group to every row with VLOOKUP and classify countries with the IF function.

55 min · Enrolled users only

Summarising with PivotTables and Slicers

Build a PivotTable that sums population by region and year, then control it with a slicer.

55 min · Enrolled users only

Charts, Data Bars and a Dashboard

Add data bars, build a line chart of population trends, and lay out a one-page dashboard.

60 min · Enrolled users only

Validation, Protection and Export

Restrict inputs with data validation, protect the workbook, and export a print-ready PDF.

55 min · Enrolled users only