Microsoft Excel Pivot Tables Deep Dive

Course Overview

Course Overview:

In this course, participants will delve into the powerful features of Microsoft Excel pivot tables. From the basics of pivot tables to advanced features such as custom groupings and calculated fields, participants will learn how to effectively analyse and visualize their data. The course will also introduce Microsoft Power Pivot, offering even more options for data analysis.

Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

Target Audience:

  • Anyone who works with data and wants to improve their data analysis skills or wants to take their pivot table skills to the next level.

Course Content:

  • Understand the basics of 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 for pivot tables
  • Group dates as unique
  • Add slicers to easily filter data
  • Add dynamic charts
  • Add a timeline to pivot tables
  • Gain an understanding of Microsoft Power Pivot

Prerequisites for attending:

  • Intermediate understanding of Microsoft Excel
  • Stable internet connection
  • No previous understanding of pivot tables is required
  • Having a second display is beneficial but not required

Programme Information

Study Mode:  Virtual (via Teams)

Duration:  6 hours

Times:  9.30  - 4.00pm

Price : £90

For further information on this course contact corporate@wcs.ac.uk or call 0141 581 2121 .