Get startedGet started for free

Summarizing sales

By now you'll be familiar with the general structure of a formula and will have the capabilities to perform basic arithmetic operations.

In this exercise, we'll start working with aggregate functions and summarize key metrics on our data including the minimum, maximum and average price of our items.

If you lost progress, close any open reports and load 2_4_summarizing_sales.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