A pivot table can be used to summarize a larger amount of data. You can easy add, subtract or change the way the data is presented in a pivot table.
This is how you do
1. Click on the tab Insert.
2. Click on PivotTable in the group Tables.
3. In the box Create a PivotTable, select Select table or range.
4. Click on the
icon to select an area.
5. Select the area you want to be included in the pivot table an click on the
icon.
You can choose to create the pivot table on a new worksheet, to do this select New Worksheet.
6. Click on OK.
7. Select the fields you want to show in your pivo table.
You can also drag the fields to the boxes down below to alter the appearance of the pivot table.