Loading Events

« All Events

  • This event has passed.
Event Series Event Series: Pivot Tables Deep Dive Workshop

Pivot Tables Deep Dive Workshop

September 12, 2023

Pivot Table in Excel is one of the most powerful features of the software. It allows you to analyse hundreds of rows with just a few clicks.
In this ‘Deep Dive’ into the topic, we will devote the full day to exploring Pivot Tables and how they can be used for Data Analysis.

We recommend that you have a basic to intermediate understanding of Microsoft Excel. No prior knowledge of Pivot Tables is required.
In this course, participants will be introduced to Excel pivot tables and then develop a deeper understanding of advanced pivot table features including a high-level introduction to Microsoft Power Pivot

What you will learn:

  • Introduction to pivot tables
  • Convert data to tables
  • Adjust field list settings
  • Create multiple reports with one click
  • Add data bars to pivot tables
  • Master pivot table settings
  • Add and remove calculated fields to pivot tables
  • Calculate the difference between columns
  • Add smart custom number formatting
  • Create custom groupings to pivot tables
  • Group dates as unique
  • Add slicers to easily filter data
  • Add dynamic charts
  • Add a timeline to pivot tables
  • Introduction to Microsoft Power PivotDuration: 1 Day

    This course is delivered on our open schedules in Edinburgh and Glasgow We can also deliver this workshop via a virtual classroom over two half sessions, using Zoom or Teams.


September 12, 2023
Event Categories:


4 Queen Street
Edinburgh, EH2 1JE United Kingdom
0131 556 5650


Pitman Training Centre – Aberdeen
01224 595277