This module covers the basics of pivot tables such creating, building, updating, refreshing your pivot tables, proper data structure, and changing the summarization types.

✅ Exploring the Dataset

✅ What is a Pivot Table?

✅ Required Data Structure for Pivot Tables [Tabular Data]

✅ Creating a Pivot Table

✅ The Pivot Table Fields Window

✅ How Pivot Tables Work

✅ Exploring the Analyze and Design Tabs

✅ Updating Data and Refreshing a Pivot Table

✅ Understanding the Pivot Table Cache

✅ Using Tables with Pivot Tables

✅ Actions: Selecting, Copying, Moving, and Clearing

✅ Field Settings Menu: Changing the Aggregation Type

This module teaches you to format pivot tables by applying number formats, replacing blank cells, customizing field names and styles, changing layouts, and using advanced conditional formatting.

✅ Apply Number Format [Correct Method]

✅ Replace Blank Cells with Any Value

✅ Customize Field Names and Labels

✅ Customize the Pivot Table Style

✅ Change the Pivot Table Layout

✅ Add Data Bars, Color Scales, and Icons

✅ Highlight Cells with Rules

✅ Advanced Custom Conditional Formats

This module will show you how to enhance your pivot tables by adding calculated fields, calculated items, and using “Show Values As” calculations.

✅ Add Calculated Fields

✅ Count with a Calculated Field

✅ Add Calculated Items

✅ Show Values As Calculations

This module covers grouping items manually, grouping dates by weeks and weekdays, managing automatic date grouping, grouping numbers into ranges, and expanding or collapsing groups.

✅ Manually Group Items

✅ Group Dates

✅ Group by Weeks and Weekdays

✅ Enable or Disable Automatic Date Grouping

✅ Group Numbers Into Ranges

✅ Expand and Collapse Groups

This module teaches you to sort pivot tables and create custom sort orders.

✅ Sorting a Pivot Table

✅ Create a Custom Sort Order

This module teaches you to manually filter data, use label or value filters, apply date filters, apply multiple filters, and utilize wildcards in label filters.

✅ Manually Filter a Pivot Table

✅ Label Filters

✅ Value Filters

✅ Date Filters

✅ Apply Mulitple Filters Simultaneously

✅ Pivot Table Report Filter Pages

✅ Wildcards with Label Filters

Master the use of slicers and timelines in this module to enhance your pivot table interactivity. Learn to add, format, and customize slicers and timelines for dynamic data analysis.

✅ Add Slicers to a Pivot Table

✅ Add Timelines to a Pivot Table

✅ Report Connections: Connect Mulitple Pivot Tables

✅ Stop Pivot Tables and Slicers from Moving

This module delves into pivot charts, teaching you to create, customize, and integrate them with pivot tables for dynamic data visualization and insightful analysis.

✅ Create a Pivot Charts

✅ Customize Pivot Chart Layout & Style

✅ Moving Pivot Charts

✅ Connect Slicers & Timelines to Multiple Pivot Charts

Learn step-by-step how to build an interactive dashboard using pivot tables. Master techniques for creating beautiful dynamic reports and dashboards your boss will love!

✅ Dashboard Overview

✅ Build the Pivot Tables

✅ Build and Customize the Pivot Charts

✅ Build and Customize the Slicers

✅ Build and Connect KPI Data Cards

✅ Align and Arrange Objects

✅ Lock Objects in the Dashboard