Excel 2007

Hello Darren

Thank you for your question and welcome to the forum.

A pivot table is used to display data stored in columns, in a tabular format. The big advantage of a pivot table is that data can easily be added to and removed from the table, so that data can be analysed in many different ways.

We cover pivot tables as part of our Excel Advanced course.

Kind regards
Amanda