Home › Excel case studies › Retail Store Sales vs Target & Seasonality

Retail Store Sales vs Target & Seasonality

A home-furnishing chain with 18 stores closes its year. Find which stores really hit target, how regions compare, and when the money is made. **What you’ll learn:** Store ranking and achievement % with RANK, INDEX/MATCH and SUMIFS Net sales, return rates and category mix Building a monthly seasonality index

Open this Excel case study

Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.

View case study → Free Excel formula practice

All Excel case studies · Excel interview prep · Excel formulas