Excel Pivot Tables for Data Analysis
Master Excel Pivot Tables to transform raw data into actionable insights and drive data-driven decisions.
...
Share
Introduction to Pivot Tables
Unit 1: Pivot Table Fundamentals
Why Pivot Tables?
Anatomy of a Pivot Table
Source Data Structure
Creating Your First Pivot
Drag & Drop Magic
Unit 2: Advanced Pivot Table Creation
Pivot from External Data
Data Model Intro
Refresh Button Power
Change Data Source
Slicers Quick Intro
Unit 3: Customizing and Refining Pivot Tables
Report Filters
Calculated Fields
Show Values As
PivotTable Options
Drill Down Details
Summarizing and Calculating Data in Pivot Tables
Unit 1: Basic Calculations in Pivot Tables
Summarizing with Sum
Averaging Your Data
Counting Data Entries
Finding Min & Max Values
Changing Summary Calc
Unit 2: Showing Values As Percentages
% of Row Total
% of Column Total
% of Grand Total
Mix and Match %
Unit 3: Calculated Fields and Advanced Calculations
Creating Calc Fields
Calc Field Examples
Running Totals
Calculating Differences
Index Values
Grouping and Filtering Pivot Table Data
Unit 1: Grouping Data in Pivot Tables
Intro to Grouping
Grouping by Date Ranges
Grouping by Numbers
Grouping Text Fields
Ungrouping Data
Unit 2: Filtering Data in Pivot Tables
Intro to Filtering
Report Filters: Basics
Report Filters: Advanced
Slicers: The Basics
Slicers: Advanced
Unit 3: Combining Grouping and Filtering
Grouping then Filtering
Filtering then Grouping
Multiple Filters
Clear All
Best Practices
Formatting and Visualizing Pivot Tables
Unit 1: Styling and Formatting Pivot Tables
Pivot Table Styles
Style Options
Number Formatting
Layout Options: Compact
Layout Options: Outline
Unit 2: Advanced Layouts and Pivot Charts
Layout Options: Tabular
Report Layout Options
Intro to Pivot Charts
Chart Types for Pivots
Chart Elements
Unit 3: Customizing and Analyzing Pivot Charts
Chart Styles & Colors
Filtering in Charts
Analyzing Trends
Spotting Outliers
Interactive Dashboards