Free Excel Tutorial - Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

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