The tip for Excel tutorial teaches you everything you need to learn about pivot tables.
Anyone using Excel to analyse data will at some point come across the Excel pivot table. A Pivot Table sits on top of raw data (a customer database for example) and lets you design a new table where you can view results. Then when the raw data is updated the changes are reflected in the pivot table you have designed.
A Pivot Table is made up of many parts. Above is an image of a simple pivot table.
- Pivot table field list – this shows you all the fields (metrics and dimensions) that are available. These will be all the columns in your raw data plus any calculated fields you have created
- Report Filter – here you drag fields that you want to use to be able to filter your data. In this example we have chosen to filter by date
- Column labels – here you list the fields that go along the top of your pivot table – the columns. These can be metrics or dimensions (city, country etc). In our example we have “Week”
- Row labels - here you list the fields that go along the left of your pivot table – the rows. These can be metrics or dimensions (city, country etc). In our example we have the values. The values are those in step 5
- The Values – these are all the metrics. You may be counting, averaging or summing up any of the metrics you had in your raw data. In our example we have summed up Total Visits plus other metrics
- Filters – Number 6 in the diagram shows you how you can use filters to slice and dice your data. Maybe you want to just see results from January for example…
Continue to start creating a pivot table >>