DSEAfrica

Excel

Microsoft Excel projects

Download a real dataset, clean and analyse it in Excel, then submit your workbook for marking. Every project comes with the business questions your workbook needs to answer.

Browse all projects

You work in Excel itself, not in the browser

We do not try to reproduce Excel in a web page — you would lose the features the exercises are about. The Data Lab gives you the dataset, the instructions, a preview of the data and the submission workflow; the workbook itself you build in Excel, LibreOffice Calc or Google Sheets.
1

Download the dataset

Every project ships a .csv or .xlsx file plus a data dictionary describing each column.

2

Read the brief

The scenario tells you who the client is, what they need to decide, and which formulas the exercise expects.

3

Build the workbook

Clean the data, build your PivotTables and charts, and lay out a dashboard sheet.

4

Submit and get marked

Upload the workbook and screenshots, write your summary, and an instructor scores it against the rubric.

What you will practise

Structure and cleaning

  • Tables
  • Sorting and filtering
  • Removing duplicates
  • Text to columns
  • Data validation
  • Conditional formatting

Functions

  • IF and nested IF
  • SUMIFS
  • COUNTIFS
  • XLOOKUP
  • INDEX and MATCH
  • Text functions
  • Date functions
  • IFERROR

Analysis and presentation

  • PivotTables
  • PivotCharts
  • Slicers
  • Calculated fields
  • Dashboard layout
  • Chart design

What you submit

  • The completed .xlsx workbook
  • Screenshots of your dashboard sheet
  • A written summary of your findings
  • Your cleaning log, documenting each decision

Resources

Excel projects(1)

Current section: /excel