Who it's for: Excel users interested in one of the most useful tools Microsoft's spreadsheet app offers.
What it is: A Pivot Table is a powerful feature in Excel that analyzes complex datasets and streamlines that information into neat and tidy tables, displaying only the information you really need to see.
What you'll learn: In this comprehensive course, you’ll learn how to create, modify, and update Pivot Tables in Excel. We'll also show you how to create Pivot Charts and use XLOOKUP. For advanced users, we'll tackle Power Pivot, DAX expressions, data mining, and much more.
Exercise Files - Download Before Starting the Course
Available in
days
days
after you enroll
Course
Available in
days
days
after you enroll
- 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)