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
Feb 25, 2015
If you work within project management, are looking to move into the field, or just have a general interest in the profession, going to industry events can be an effective way to develop your knowledge and network with other project professionals. We have compiled a list, in chronological order, of t
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