13.1 Portfolio — one workbook, one report, one deck
You have three finished artefacts that show what you can do.
Before:05. Excel — Charts & Dashboards08. Word — Long Documents & Expert10. PowerPoint — Design & Delivery
Three finished artefacts — a workbook that cleans raw data through Power Query into a dashboard, a styled report with a contents page and cross-references, and a ten-slide deck built on your own master and presented in five minutes — are the proof this course produces. The project sits at the end because it draws on every module, and the short write-up of what each artefact does is part of the work. The common confusion is treating a portfolio as a pile of exercises; three finished things that survive a stranger's inspection beat thirty fragments.
Work through these
A workbook: raw data in, cleaned by Power Query, one dashboard out
A workbook that takes raw data, cleans it through a repeatable query, and produces a single dashboard. It demonstrates the whole spreadsheet part of this subject in one artefact.
A report: styled, with a contents page, captions and cross-references
A report using styles, with a generated contents page, numbered captions and cross-references that update. It shows you can produce a long document that maintains itself.
A deck: built on your own master, ten slides, presented in five minutes
A ten-slide deck on your own master, delivered in five minutes. The constraint is the exercise, because cutting to fit is the hard part.
A short write-up of what each one does and how
A short write-up explaining what each artefact does and how it was built. It is what lets someone assess your work without opening every file.
Practice files
- xl-07-dashboard-starter.xlsx
Clean data plus an empty dashboard sheet with the five questions written on it.
- wd-02-long-report.docx
A structureless multi-page report: no heading styles, a hand-typed contents page with wrong page numbers, two uncaptioned tables. Add sections, styles, a real TOC, captions and cross-references.
- pp-02-master-rebuild.pptx
The same content stripped to an outline, for rebuilding on a proper slide master.
Opens in Excel. Every name, number and address in these files is made up. No account needed to download.
Sign in to keep your progress.
Free resources
We haven't checked most of these for screen reader use yet.
Links last checked 29 Aug 2026.
Stuck here?
Ask a mentor. A real person answers, and they can see exactly which topic you're on. Usually within a couple of working days.
Checking your session…
Topics shown in module order.