Skip to content

Business Excel & Job Interview Challenges · Exercise 1 of 10 · Excel for work · Intermediate · 20 min · Premium

Monthly Sales Performance

Build the monthly sales report: attainment against target, a running year-to-date total, the best month and how many months met target.

What you will practise: Calculate attainment against a target, build a running total with a mixed reference, and name the best month with INDEX, MATCH and MAX.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Open exerciseNot a member? See Premium plans