Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel Pivot Tables
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (1:06)
What are Pivot Tables? (5:33)
Preparing Data for Analysis (4:32)
Pivot Table Components (6:18)
Building Pivot Tables to Show Different Values (5:15)
Adding Fields to Pivot Tables (6:48)
Using Built-In Filters (5:50)
Filtering Data with Slicers (6:49)
Displaying New Values from Data Sources (6:31)
Inserting Pivot Charts (6:51)
XLOOKUP (8:11)
Joining Data Sets with XLOOKUP (7:53)
Introduction to Advanced Pivot Tables (1:25)
Inserting Pivot Tables from Tables (7:46)
Calculated Fields (5:49)
Using the Timeline Tool (5:16)
Report Filter Pages (6:43)
Pivot Table Layouts (6:24)
Creating Pivot Table Designs (7:25)
Adding Power Pivot Tabs to the Ribbon (2:43)
Adding Tables to Power Pivot Data Model (5:01)
Creating Table Relationships (4:11)
Creating Columns with DAX Expressions (7:25)
Displaying New Source Data in Power Pivot Tables (2:51)
Data Mining with Flash Fill (6:02)
Conclusion (0:50)
Joining Data Sets with XLOOKUP
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock