Filtering and pivot tables

Once your data is organised and clean, you can now begin to filter and analyse the data.

In this module we will learn how to:

• Sort and filter data in a spreadsheet
• Apply formula to generate simple statistics
• Create a number of pivot tables
• Create a number of summary graphs

To prepare you for this exercise you will need this spreadsheet. Note that it has two sheets; the first tab holds the data, and the second tab called ‘Statistics’ will be used when we look at formula.