Filtering and pivot tables

Categories: Open Data
Includes lifetime access

Course Overview

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.