Skip to content

Advanced Excel Formulas & Analysis · Exercise 10 of 10 · Data analysis · Advanced · 40 min · Premium

Advanced Sales Analysis Capstone

Finish the path with a full sales analysis: revenue by region, best region and product, an above-average count and quarter-on-quarter growth for one rep.

What you will practise: Combine SUMPRODUCT, SUMIF, INDEX with MATCH, ratios and IFERROR in one analysis where later answers build on earlier ones.

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