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)
https://www.youtube.com/watch?v=Ep5q1cUhQas
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)
https://www.youtube.com/watch?v=_OdsZR_rL1U
Summary
- highlight the data you want to sort
- select option
- sort ascending/descending
- filter by column header