Spreadsheets: Good practice with pivot tables (Course pack)

IT Learning Portfolio icon

Using the features provided by pivot tables in Excel to enable you to create Filtered Reports, Slicers, use Calculated Fields as well as Grouping and Sorting data.

[click on a red button and edit the text if necessary - capital letters on buttons. Use the Link To Content button to point it to a PDF or ZIP or other file that you have previously uploaded into the Media Files collection. Duplicate a red button if needed. ]

[click on the white button to edit it. Use Link to point it to the correct course URL in CoSy.]

[when ready, delete this guidance text in square brackets]

This course pack is suitable for Mac or Windows users.

Some free resources related to this course

You can download a copy of the course workbook or a folder with the course exercise files:



These resources relate to one of our workshops.

You can search CoSy for booking details:


Contact us:

IT Learning Centre

Use our online contact form
email us at courses@it.ox.ac.uk