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.
If you’re an experienced Excel user, already confident in creating and editing worksheets and writing basic formulas, this advanced Excel training course will enhance your current skillset.
By the end of the programme you’ll be able to:
The anatomy of a pivot table
Setting pivot table options
Customising pivot tables
Filtering and sorting
Test Analyst, B&CE Benefits Schemes
May 06, 2015
In the relatively short space of time that people have populated the world, we have gone from living in caves and breaking into our dinner with a sharpened stone to creating things so vast and powerful they would make our stone-wielding ancestors’ jaws drop.Engineering – and with it: effective p
Apprentices are in high demand – research by Barclays shows that £4.4bn would be injected into the UK economy if more businesses employed them. Thales UK is a proud member of The 5% Club which is focused on creating momentum behind the recruitment of apprentices and graduates into the workforce.
As part of Thales UK’s commitment to nurturing raw