Excel

Hi Becky,

Welcome to the forum and thank you for your post, in reply:


A pivot table is a summarisation of data which can be manipulated and viewed from different angles, if you have a large database and wish to summarise it; extracting either Totals, Averages, Highest or Lowest values etc, you could use a Pivot Table.

To create a Pivot table go to the menu command Data, Pivot Table and Pivot Chart Report, follow the Wizard's commands/suggestions to arrive at a grid which then allows you to place your field headings in the appropriate places. Your Pivot table will then be created.

I hope that has helped, regards Pete