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, which will enable you to quickly extract important information. Each stage of the tutorial is illustrated with 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, parts 2 & 3 of the tutorial have each been produced as two separate versions, so that you can work through the guide that relates to your current 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.