Share Description
In this course, you will learn:-
- Excel Pivot Tables: Understand Their Importance
- Recognize the Spheres in Which Excel Pivot Tables Are Most Effective
- Learn how to create and update a basic Excel pivot table, as well as how to use the Slicer feature in Excel.
- Make a Pivot Table in Excel your own.
Syllabus:-
-
Welcome to the Course on Excel 2016 Pivot Tables
-
Life Before Excel Pivot Tables
-
Life After Excel Pivot Tables
-
Download Course Resources from Here
-
Why Should You Use Excel Pivot Tables?
-
When Should You Use a Pivot Table?
-
Anatomy of an Excel Pivot Table
-
Preparing Your Data For Excel Pivot Tables
-
Summary of Preparing the Data Source for a Pivot Table
-
Case Study: Cleaning Up Data for Pivot Table Analysis
-
Creating a Basic Pivot Table - Part 1
-
Creating a Basic Pivot Table - Part 2
-
Filtering Pivot Tables with Slicers
-
Updating Pivot Table Data Sources
-
Deferring Layout Update, Starting Over with One Click and Relocating Pivot Table
