Get startedGet started for free

Filtering data

Look how far you've come in Excel! You can now create formulas, calculated columns and utilise structured cell references. These concepts will become very useful throughout the course.

In this exercise, we'll filter and sort our data in various ways to help Adventure Works better understand its sales in a given period.

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