This course is included (as well as over 200 others) in every subscription!
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.
Excel 2019 Pivot TablesSign up to view this video |
- Introduction
- Data Mining
- Adding Related Data Using VLOOKUP
- Inserting Pivot Tables
- Setting Up Pivot Tables
- Building Pivot Tables
- Filtering and Slicing Pivot Table Data
- Changing Source Data and Refreshing Pivot Tables
- Inserting Pivot Charts
- Using Tables to Build Pivot Tables
- Finding Correct Layouts for Reports
- Setting Default Layouts for Reports
|
|
- Using Pivot Table Styles
- Subtotals and Grand Totals
- Creating Report Pages
- Adding the Power Pivot Tab to Excel
- Creating Tables for the Data Model
- Adding Relationships with Power Pivot
- Using DAX Expressions with Power Pivot
- Creating Pivot Tables with Power Pivot
- When to Use Power Pivot
- Conclusion
|
|
|