Need Help? Call: +44 (0)151 650 6907


Excel: PivotTables & Large Spreadsheets

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Course Objectives

Learn how to organise, summarise and present your data using Excel PivotTables and PivotCharts. These powerful tools will help you to simplify and analyse the complex data stored in your spreadsheets. This course is suitable for people of an intermediate level of Excel. The course will be delivered in the PC version of Excel 2016.

Training Format

This course can either be delivered as a short course in half a day or as a seminar.

Classroom Training – Small groups of people using their own PCs or Laptops – or these can be provided by SquareOne at an additional cost. Sessions to be 3 hours in length.

Seminar Format – Maximum of 100 delegates. This seminar will be delivered by a trainer as a demonstration. Session can last between 60 minutes to 90 minutes. If this is to be delivered to small groups then this can be repeated up to 3 sessions per day.

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at you office in any location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead and Aberdeen as well as in European countries such as France, Switzerland, Germany, Sweden, Norway and Ireland.

Course Duration

Half Day Classroom Training or Online

Pivot Tables

Introduction to PivotTablesOrganising your Data before creating a PivotTableListsTrim DataConcatenateCreating a PivotTableUnderstanding Rows, Columns and Report AreasAdding, Moving & Removing FieldsCustomising FormatsCustomising CalculationsSorting & Filtering Pivot DataFiltering Data with Interactive SlicersGrouping & Ungrouping DataDrill Down & Extract DataSummary Functions & Custom CalculationsDefining Pivot Field & Field SettingsPivotTable Formats and LayoutsCreating & Modifying PivotChart Reports


Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

Related Courses

For more information about any of our courses

please call +44 (0)151 650 6907, email or complete an enquiry form.