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
Dec 11, 2014
Emotional intelligence (EI) – described by business psychologist Dr Susan David of Harvard University as ‘the ability to solve problems with and about emotions effectively’ – is essentially the measure of how well a person monitors their own emotions and the emotions of others, and how they
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