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.
|Part 1: What is a Pivot Table in Excel?|
Part 2: Create a Basic Excel Pivot Table
Part 3: How to Group a Pivot Table
Part 4: Create an Advanced Excel Pivot Table
Part 5: How to Sort a Pivot Table
Further advanced pivot table training is provided on the Microsoft Office website.