Excel: final assessment
This covers the whole course. Take it after the last module.
Final quiz
Practical assessment: Analyse a sales list
In your own Excel, without the lessons open, turn a list of a few hundred sales into a short analysis.
- Convert the list to a Table and clean its text and dates
- Add totals by region and month with SUMIFS and with a PivotTable, and check they agree
- Look up each product's category from a second table with XLOOKUP or INDEX and MATCH
- Chart the monthly trend and highlight months below target
Final project
A monthly sales dashboard: Turn a raw sales export into a one-page dashboard that refreshes each month: totals by region and product, the trend, the top sellers and targets.
How it is evaluated
- Correctness: totals agree between formulas, PivotTables and the source
- Structure: inputs, data and reports are separated, with Tables and clear names
- Clarity: charts and formatting make the main message obvious
- Robustness: new data can be added without editing formulas
To complete this course
- Score at least 70% on the final quiz
- Pass every module quiz
- Finish one project in your own Excel and check it against the criteria