Sales Analysis in Excel

In this project, you will step into the role of a business analyst working for a supermarket chain. Using transaction-level sales data, you will analyze revenue performance across multiple financial periods and store types.

Your goal is to transform raw data into clear, management-ready insights by applying Excel’s conditional aggregation functions. You will calculate total revenues, break them down by product groups and store formats, and evaluate year-on-year performance trends.

This project mirrors real-world financial analysis tasks commonly performed in finance, analytics, and business intelligence roles, and strengthens your ability to work with multi-criteria calculations in Excel.

To successfully complete this project, you should be able to:

• Navigate and understand transaction-level datasets
• Use Excel formulas, especially SUMIFS, to aggregate data using multiple criteria
• Work with financial periods and time-based analysis
• Validate results and ensure consistency across multiple tables
• Present calculations in a clear and structured format suitable for business reporting