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
Nov 21, 2014
The word ‘learning’ does not just have to refer to putting people in classrooms or taking them out of the office on a week-long training programme. It can mean something more organic than that, more ingrained into the fabric of your organisation and the way people work every day. By creating and
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