Professional Training
4.8 (361 Reviews)

Excel Pivot Tables

STL, In London (+21 locations)
Length
1 day
Price
300 GBP excl. VAT
Next course start
17 July, 2024 (+50 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
300 GBP excl. VAT
Next course start
17 July, 2024 (+50 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Pivot Tables

STL courses

  • At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.
  • You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 50 start dates

17 July, 2024

  • Virtual Classroom
  • Online
  • English

5 August, 2024

  • Classroom
  • London
  • English

16 August, 2024

  • Virtual Classroom
  • Online
  • English

4 September, 2024

  • Classroom
  • London
  • English

16 September, 2024

  • Virtual Classroom
  • Online
  • English

4 October, 2024

  • Classroom
  • London
  • English

16 October, 2024

  • Virtual Classroom
  • Online
  • English

4 November, 2024

  • Classroom
  • London
  • English

15 November, 2024

  • Virtual Classroom
  • Online
  • English

4 December, 2024

  • Classroom
  • London
  • English

16 December, 2024

  • Virtual Classroom
  • Online
  • English

3 January, 2025

  • Classroom
  • London
  • English

15 January, 2025

  • Virtual Classroom
  • Online
  • English

3 February, 2025

  • Classroom
  • London
  • English

14 February, 2025

  • Virtual Classroom
  • Online
  • English

5 March, 2025

  • Classroom
  • London
  • English

17 March, 2025

  • Virtual Classroom
  • Online
  • English

4 April, 2025

  • Classroom
  • London
  • English

16 April, 2025

  • Virtual Classroom
  • Online
  • English

1 May, 2025

  • Classroom
  • London
  • English

16 May, 2025

  • Virtual Classroom
  • Online
  • English

2 June, 2025

  • Classroom
  • London
  • English

16 June, 2025

  • Virtual Classroom
  • Online
  • English

2 July, 2025

  • Classroom
  • London
  • English

16 July, 2025

  • Virtual Classroom
  • Online
  • English

1 August, 2025

  • Classroom
  • London
  • English

15 August, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



Our Microsoft Excel Pivot Tables course is suitable for those with a basic working knowledge of Pivot Tables who want a greater understanding of the more sophisticated functions and features available.

You may also wish to consider our soft skills training workshops.

Training Course Content



Pivot Table Fundamentals

What is a Pivot Table?
When and why use a Pivot Table?
Anatomy of a Pivot Table
Limitations of Pivot Tables

Creating Basic Pivot Tables

Preparing your data
· Tabular Layout
· Removing Section Headings
· Removing Repeated Column Groups
· Eliminating Gaps
· Type Formatting
Creating Pivot Tables
· Adding Fields
· Adding Layers
· Altering Structure
· Report Filters
Managing Changes in Your Source Data
· Dynamic Named Ranges
· Dealing with Zeroes
Subtotals
Summary Calculations
· Running totals
· Differences (year on year, month on month)
· Percentages of Rows, Columns, Totals and other fields
Running Totals and Top 10 reports
Pivot Table Tools
· Layout Updates
· Refreshing and Restarting
· Moving Pivot Tables

Pivot Table Views

Conditional formatting
Sorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views

Pivot Table Calculations

Calculated Fields and Items
Managing and maintaining Pivot Table calculations

Pivot Charts

What is a Pivot Chart?
Creating a Pivot Chart
Pivot Chart Rules
· Managing the underlying data
· Adding Layers
· Altering Structure
Pivot Chart Alternatives
· Dynamic Charts
· Transition tables

Working with Data Sources

Consolidating multiple sheets or ranges of data
Using external data sources (Access)

Automating Pivot Tables with Macros

Introducing Macros
Recording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)

Summary

Frequent Pivot Table Questions and Answers
Solutions to common problems

Expenses



List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Excel Pivot Tables.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.8

Based on 361 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Jenny Executive Assistant
06 Nov 2023

Most useful topic: the slicer function

5/5
Anne Payroll Manager
26 Oct 2023

Jens is a fantastic trainer and I love his passions and enthusiasm for Excel; it makes the training so much more enjoyable.

5/5
David Strategy Planning & Performance Analyst
26 Oct 2023

Maybe record the session so we can refer back

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads