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
Apr 24, 2015
Primavera P6 and PRA Features and Benefits GuideThis informative guide will provide you with the valuable information the features and benefits of Primavera P6 and PRA.Primavera Enterprise Project Management (P6)This offers a comprehensive project management toolset for the effective management of 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