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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
