Tables

Hi Amy,

Thank you for your question.

A Pivot Table is a user friendly tool you can use to analyse large amounts of data.

To create a Pivot table you open the file containing the data and then use the Insert tab followed by Pivot Table on the Tables group. Select the excel list option and then select the entire list including the headings. The final step of the wizard is to tell Excel where to place the Pivot table.

Now select your Page, Row, Column and Data fields to analyse.

I hope this answers your question.

Regards

Simon