Microsoft Excel’s pivot table function is an essential tool that allows you see the ‘bigger picture’ – quickly and easily summarising, analysing, and presenting large amounts of data.
We show you all the basics of the pivot table function, showing you how it works and how it can help you. Learners are encouraged to participate in the session by asking questions, and we’ll be here to give you support via telephone, email or Twitter for 90 days after the programme finishes.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- How pivot tables work
- How to create and modify your pivot table structures
- How to change the summary calculation used to analyse your data
- How to use report filters
- How to group data
- How to sort data
- How to create a pivot chart