How to use pivot table to group same item data and calculate sum, count, average, max, min in Ms Excel 2013

The pivot table will automate how to calculate sum, count, average, max, min, standard deviation etc based on data group which are associated to the same data. This make the analysis work / calculation easier and faster to achieve without manually group them. The pivot table also have a filter that allow users to filter the data group which they want to display only.

In order to use the pivot table Ms Excel 2013

1. Select the data you want to analyze including its header
2. Select INSERT>Pivot Table
3. It will prove which data to analyze just click OK since it is already selected
4. Select the field you want to display in pivot table
5. Put numbers in the values section which you want to analyze sum, count, average, max or min

You can also analyze percentage data