Microsoft Excel Pivot Tables Deep Dive

In this course, participants will delve into the powerful features of Microsoft Excel pivot tables.

Dates

There are no dates currently scheduled for this course.

Interested in this course? Suggest a date/location

Description

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.

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.

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

Prerequisites

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.

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.

Certification

College certificate of attendance