If you're not sure how to create a pivot table, you can have Excel create one for you using its recommendation, which is a great way to learn about pivot tables. This video shows how to select the data for a pivot table and select a table from Excel's list of recommendations, which you can then customize.
