Pivot tables

Hello Nick,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding how to create a pivot table.

First, click anywhere in the data that you require to summarise using a pivot table. Click the 'Insert' ribbon then click the 'Pivot Table' button (first button from the left).

Follow the wizard preferably selecting to place the table into a new worksheet. On the right-hand side you will see the 'Pivot Table Field List' which will contain all the column headings from the data sheet.

You must choose which headings you would like to view as summarised information then drag these fields to the 'Row Labels', 'Column Labels', 'Report Filter' and 'Values' sections. The 'Values' section requires number/currency fields.

You will now be able to view the information from your data sheet as summarised using the default Sum function.

You can also change the fields by swopping them around.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer