Data: Sort

This lesson will investigate the Data Ribbon: Sort, Filter and Subtotal. Each Data command adds to your understanding of the numbers. Each option also has it's limits: it can only do "so much."

 

When you Sort the data, you can find patterns. For example, the customer information might make sense when it is sorted by City.

 

1. Try This: Sort the Data

Select the entire spreadsheet.

Go to Data ->Sort and Filter.

Click on Sort. When you are prompted choose:

Sort by: City

Sort On: Values.

Order: A to Z.

 

What Do You See? This Sort organized the customers by one criteria: City.  Keep going...

 

Data->Sort and Filter->Sort

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data using single or multiple criteria