Learn Pivot Tables from scratch, applying calculations, applying formatting & combining multiple Pivots.
Want to learn how to use Excel Pivot Tables? You can!
What you’ll learn
- Understand how Excel represents data in different forms.
- Learn how to create Pivot Table from scratch.
- Understand how to effectively use Excel Pivot Tables.
- Ad-hoc analysis of using multiple Pivot Tables.
- Creating Dashboard by using multiple Pivot Tables.
Course Content
- Introduction –> 3 lectures • 8min.
- Creating your first Pivot Table –> 2 lectures • 7min.
- Implementing Calculations in Pivot Tables –> 5 lectures • 22min.
- Page Filters, Slicers & Timelines –> 4 lectures • 9min.
- Formatting a Pivot Table –> 2 lectures • 5min.
- Using Pivot Charts –> 1 lecture • 1min.
- Creating Dashboard using Pivot Tables –> 1 lecture • 11min.
Requirements
Want to learn how to use Excel Pivot Tables? You can!
This Introductory course will teach you the basics for working with Pivot Tables and It will equip you with the skills needed for creating Pivot Tables from scratch to the extent that you can create a Dashboard using Pivot Tables.
We’ll start with some basic concepts and terminology. Then we’ll provide an easy to follow example using some fairly straightforward data and develop a pivot table and a pivot chart. We’ll then move into performing calculations using Pivot Tables, you will learn how to pull data using GETPIVOTDATA function, you will learn to apply formatting to the Pivot Table, you will learn to use Slicers & Timelines and finally you will create a Dashboard on the fly.
By the end of the course, you’ll be confident using Pivot Tables on the data that you use every day.