Pivot Tables

Pivot tables are incredibly useful, and easy to execute within Excel. They allow for filtering and summarisation of raw, ‘flat’ data, helping make sense of a broader data set. Pivot tables are created by selecting all the relevant data fields, then choosing Insert>Pivot Table. Pivot Tables are created in a new sheet, giving you the flexibility to analyse entire sheets worth of data in creating a more accessible table, so you can more accurately draw conclusions from large volumes of Excel tracked data.