Excel Pivot Table Tutorial

This Excel Pivot Table Tutorial provides a step-by-step guide on how to create pivot tables in Excel.

The tutorial begins by answering the common question, "What is a Pivot Table in Excel?", and continues with a guide on how to create a basic Pivot Table in Excel.

This is followed by a guide on how to create a more advanced, two-dimensional Excel Pivot Table. Finally, we describe how to sort a Pivot Table by the data fields, so that you can easily analyse your data. Each stage of the tutorial is accompanied by a Pivot Table example.

As the interface used to create a Pivot Table in Excel is slightly different in Excel 2003, compared to later versions of Excel, we have produced two separate versions of parts 2 & 3 of the tutorial, so that you can work through the guide that relates to your current version of Excel.


Further advanced pivot table training is provided on the Microsoft Office website.


Start the Excel Pivot Table Tutorial  >>