Excel

Hi Leigh,

Thank you for your post and welcome to the forum, I hope you enjoyed your course today.

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.

I hope that has helped, regards Pete