This Excel Pivot Table Tutorial provides a step-by-step guide on how to create pivot tables in Excel.
The tutorial begins with the question, "What is a Pivot Table in Excel?", and continues with instructions 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, so that you can easily analyse your data. Each stage of the tutorial is accompanied by Pivot Table examples.
|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.