IT & Business Systems Training Courses

Excel – Pivot Table Specialist

IT Capability Banner 2

Book this course

1 Day
£230.00 +VAT

Course description

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.

Is it right for me?

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.

What will I get out of it?

By the end of the course you will be able to:

  • Build and customise Pivot Tables
  • Group and sort information within Pivot Tables
  • Add different summary calculations to Pivot Tables
  • Create Pivot Charts
  • Add calculated fields and items

Richard was excellent. I had a lot of questions which he answered each time. The group was very small (3 people) which worked well as he was there whenever I had to ask him something.

Test Analyst, B&CE Benefits Schemes

What does it cover?

  • Using a pivot cache
  • Building a pivot table
  • The pivot table interface
  • Refreshing the pivot table
  • Adding column, row, page and data fields
  • Changing data orientation
  • Showing data fields in columns or rows
  • Using the slicer tool (2010)
  • Format options
  • Totals and filters options (2007 and 2010)
  • Display and printing options (2007 and 2010)
  • Data options
  • Modifying field names
  • Data formatting
  • Changing field layout options
  • Changing summary calculations
  • Working with subtotals
  • Filtering items
  • Sorting data
  • Value and label filters (2007 and 2010)
  • Creating top 10 reports
  • Using search within a pivot table (2010)
  • Grouping date fields
  • Grouping numeric fields
  • Adding your own groups
  • Running totals
  • Differences year on year, month on month
  • % differences year on year, month on month
  • % of row, column, total and other fields
  • Pivot chart rules
  • Creating a pivot chart
  • Working with your pivot chart
  • Adding calculated fields
  • Adding calculated items

Book this course

1 Day
£230.00 +VAT

Course leader

Richard Harker

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.


Enhance your potential




Nov 24, 2015

That’s a Wrap – The Final Round-up from the Lake District

That’s a Wrap – The Final Round-up from the Lake DistrictThe apprentices’ week with the Outward Bound Trust has come to an end and everyone is settling back into their normal working environments once again, but the experiences of last week will likely not be forgotten any time soon.  It was

Thales Blog >


Visit us on Twitter >


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 

Join the discussion >


31st March - Intelligent Outsourcing, Programme Management & Organisational Health

2nd July - Digital Learning & Workforce Planning

1st October - Discovery Center launch


Book Now >