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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9_g5I7h_N13eIXkr8WYi66xuZEN7KP6q2x8i0m73V_SHdnJ4XAKA45kQjP6jEh8kQr1YkFuyK7w4z7T0kq4IzBclTlyjAbf8Jo5MpJxYVs34p7TxqZVwefHP8CzBVCPPeqtwmoEmkjpSr/s400/Ms+Excel+Pivot+Table.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisEPzuY5uIQVuuIFDD_WzAi6Fn0PlbWzHFCyhSq3M196y4whtJtYzvWXhQEGeK799PYl94qOpW0U5VL_bsyxJTl-XuxjcvEhI37VQ7y1ZDORgoO9oNYixCTLplMrzyLKtQCba_PDTC6VKP/s400/Ms+Excel+Pivot+Table+Values.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiR2lqU7PH-w9bIM4BT6sBE_nQ7JvXPzN2QsRQesJyJP41bx9gO6Wk9CO1d96G0aXi-chTEiSExRZ7UIRBDa__jI1xg0rr5CYLnjcFoMXWd1ILO4zLLm9kLqwzg8w91StMn5QhAOaO7XHx/s400/Ms+Excel+Pivot+Table+calculation+mode.jpg)