Excel 2007 - pivot tables

Hi Sue,

Thank you for your post, welcome to the forum, in answer to your question;

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 follow 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, and can now be manipulated or Pivoted by moving field headings to different locations.

Please note we cover Pivot Tables on the Excel Advanced Course.

I hope that has helped, regards Pete