Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2019 Pivot Tables
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (2:37)
Data Mining (10:55)
Adding Related Data Using VLOOKUP (12:47)
Inserting PivotTables (4:28)
Setting Up Pivot Tables (6:04)
Building PivotTables (5:24)
Filtering and Slicing Pivot Table Data (6:02)
Changing Source Data and Refreshing Pivot Tables (6:53)
Inserting Pivot Charts (4:10)
Using Tables to Build Pivot Tables (6:09)
Finding Correct Layouts for Reports (5:25)
Setting Default Layouts for Reports (3:22)
Using Pivot Table Styles (3:38)
Subtotals and Grand Totals (2:28)
Creating Report Pages (6:42)
Adding the Power Pivot Tab to Excel (3:23)
Creating Tables for the Data Model (3:56)
Adding Relationships with Power Pivot (5:46)
Using DAX Expressions with Power Pivot (2:02)
Creating Pivot Tables with Power Pivot (3:41)
When to Use Power Pivot (1:30)
Conclusion (0:59)
Adding Related Data Using VLOOKUP
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock