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.