Introduction to Pivot Tables & Dashboards
Learn how to make sense of large data in Excel. Learn how to create Pivot Tables, Pivot Charts and dashboards.
Course curriculum
-
2
Let's Create our First Pivot Table
-
Create a Pivot Table
-
Answer for Pivot Table Exercise
-
-
3
Customize Your Pivot Table
-
Change the Name and Format of Fields
-
Display the Percent of Total on Your Pivot Chart
-
Insert a Timeline for your Pivot Table
-
Answers for your formatting exercise.
-
-
4
Advanced Customization of Pivot Tables
-
Insert a Calculated Field in Your Pivot Chart
-
The Grouping Feature and Replacing Blank Cells
-
Answers to Exercise Grouping
-
-
5
Pivot Charts and Slicers
-
Creating a Pivot Chart
-
-
6
Creating a Dashboard
-
Plan Your Dashboard
-
Create Your Dashboard
-
Free online support
Book a meeting