This Excel Pivot Table Tutorial provides a four-part 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 step-by-step guide on how to create a basic Pivot Table in Excel.
This is followed by a step-by-step guide on how to create a more advanced Pivot Table in Excel, and then we describe how to sorting a Pivot Table by the data fields to 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 Excel 2007 & Excel 2010 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.