Skip to main content

Microsoft Excel – Pivot Tables- Tutor led training

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.

Date
6th March 2023
Time
13.30 - 16.30
Price
£115 for Scomis Customers and £150 for non-customers
Duration
3 hours
Course type
Remote tutor led course
Available Dates
6th March 2023

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