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 the essential features, as well as some of the more advanced techniques, you need to know in order to fully utilise this powerful function – from creating and customising pivot tables, to performing calculations.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- Build and customise Pivot Tables
- Group and sort information within Pivot Tables
- Add different summary calculations to Pivot Tables
- Create Pivot Charts
- Add calculated fields and items