Pivot Tables Deep Dive Workshop

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 Pivot

  Duration: 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.