202R2 Sorting & Filtering Data (Excel)

Spreadsheets are all about recording and managing data, but sometimes there is too much to understand or it is disorganised

• Columns of cells can be sorted alphabetically and numerically.
• Filters let you hide data you don’t want to see. You can still see all your data when you turn the filter off

We will look at only the Excel/ribbon method

See here for Google Sheets methods

Sorting

Look at this guide

The video covers both simple and advanced sorting techniques (you need to know only the simple methods covered in the first 2 minutes)

Filtering Data

This video covers both simple and advanced filtering techniques (you need to know only the simple methods covered in the first 2 minutes)

Summary

1. highlight the data you want to sort
2. select option
   1. sort ascending/descending
   2. filter by column header