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 extract specific information. 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 version of Excel.

It is recommended that you start with Part 1 and work through the Excel Pivot Table Tutorial in sequential order.


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