Locked lesson.
About this lesson
Organize your data using sorts and filters.
Quick reference
Sorting & Filtering
Quickly organize data by grouping them with sorting and filtering techniques
When to use
Learn how to group data or place them in a particular order. Learn how to temporarily remove data from a display using Excel filters
Instructions
Sorting
- Highlight the dataset that we want sorted, go to the ‘Data’ tab on the Ribbon
- Click ‘Sort’ in the Sort & Filter command group
- In the dialog box, select whether or not your selected data has headers
- Select the column you want your data to be sorted by, and choose the sort order
- Select additional columns if needed by clicking ‘Add Level’ in the within the dialog box
Filtering
- Select the data you want to create a filter for
- Go to the Data tab and click the Filter icon in the Sort & Filter command group
- Use the dropdown arrow to uncheck any data that you would like to temporarily remove from your display
Lesson notes are only available for subscribers.