How to create pivot tables

If you are working with any sort of lists in Excel and you want to be able to extract meaningful data out of it, a key skill you should have in your toolbox is how to create a pivot table.

Essentially a pivot table allows you to move around the headings of your list so that you can spot relationships, see patterns and generally get meaningful information from your list.

As always before you begin working with your list – make sure it is set up with the following parameters (see post on Sorting). This will make the whole experience much easier.

See the video below on how to create your first pivot table and as always there is a file underneath you can use to download and practise on.

[flowplayer src=’’]



Click on this link to download an Excel file you can practise on..introduction_to_pivot_tables