Skip to main content

Microsoft Excel – Pivot Tables

Using Excel spreadsheets is an integral part of many roles. We have developed a series of half day remote tutor led training opportunities covering key aspects of Excel to enable you to’ pick and mix’ according to your requirements. As part of our suite of Excel courses, this will help you with pivot tables. If you have no experience of creating formulas it is recommended that you attend the Formulas and Functions course first.

Monday 17th October 2022
13.30 - 16.30
£115 for Scomis Customers and £150 for non-customers
3 hours
Course type
Remote tutor led course

The course will cover:

  • Prepare the Data Source
  • Summarise Data in a PivotTable
  • Functions in a PivotTable
  • Filter, Group Fields
  • Adding Calculated Fields
  • Filter Data with Slicers
  • Analyse Data with PivotCharts