Get startedGet started for free

Calculating sales and profit

In the previous exercise, we calculated some basic statistics about our data - good job!

Now, we're looking to summarize our total sales and cost to calculate our overall profit and profit margin ratio.

We'll be using a mix of aggregate function and arithmetic to achieve our desired result! The output will enable Adventure Works to better understand their total profit and profit margin.

If you lost progress, close any open reports and load 2_5_calculating_sales_and_profit.xlsx from the Workbooks folder on your local computer.

This exercise is part of the course

Introduction to Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise