Pivot Tables

Hello Kate

Thank you for your question and welcome to the forum.

As pivot tables can be used to present data in numerous ways, it is difficult to be able to answer this question in a way that would help you with the specific data you are using.

If you would like to be able to learn more about pivot tables and how they work, there are a number of pivot table tutorials on the Microsoft web site - within each tutorial there is a Practice option which you can download a practice spreadsheet from and instructions will open in Excel Help that will step you through an exercise.

A complete list of Excel tutorials can be found on the following page (Pivot Tables specifically are listed under number 6):
http://office.microsoft.com/en-gb/excel/HA011161281033.aspx

An example of a page where you can download a practice activity from is below:
http://office.microsoft.com/training/Training.aspx?AssetID=RP010139641033& ;CTT=6&Origin=RC010136191033

I hope this helps.
Amanda