Pivot table is a very useful tool available in MS-Excel. This can be used to summarize data in tabular format. It can be used to quickly create cross tab view. User can use the data stored in spreadsheet to create pivot table and perform mathematical functions like sum, count, average to summarize data and make it more presentable. Pivot Table also provides drag and drop functionality.

This picture has some data from different zones and in next image there is a pivot table based on this data.

Download above example in Excel

Download video for this example

How to create a Pivot Table

Sorting in Pivot Table

Grouping in Pivot Table

Selecting records from the top

Calculated fields in Pivot Table

Microsoft Excel Pivot Table Tutorial

Copyright www.exceltutorial.in a Microsoft Excel Tutorial and Training