Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.
What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.
What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.
Exercise Files - Download Before Starting the Course
Available in
days
days
after you enroll
Course
Available in
days
days
after you enroll
- 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)