Introduction to Excel Pivot Tables
4.2 (40 ratings)
3,786 students enrolled

# Introduction to Excel Pivot Tables

Learn Pivot Tables from scratch, applying calculations, applying formatting & combining multiple Pivots.
4.2 (40 ratings)
3,786 students enrolled
Created by Nooruddin Surani
Last updated 7/2019
English
Current price: \$13.99 Original price: \$19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 1 hour on-demand video
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• Understand how Excel represents data in different forms
• Learn how to create Pivot Table from scratch
• Ad-hoc analysis of using multiple Pivot Tables
• Creating Dashboard by using multiple Pivot Tables
Requirements
• Understanding of basic Excel
Description

This course 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.

It starts with creating a basic Pivot Table, then it moves to 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.

Who this course is for:
• Beginner of Microsoft Excel
• Want to understand Data Analysis using Excel
Course content
Expand all 18 lectures 01:03:50
+ Introduction
3 lectures 08:21
Data Summarize & Dashboards
01:23
Preview 05:30
+ Implementing Calculations in Pivot Tables
5 lectures 22:19
Using GETPIVOTDATA Function
05:17
Field Settings or Value Field Settings
03:18
Creating Calculated Fields & Calculated Items in Pivot Tables
04:06
Groups & Subtotals with Pivot Tables
04:39
Calculating percent for subtotals in a Pivot Table
04:59
+ Page Filters, Slicers & Timelines
4 lectures 09:04
Page Filter
01:11
Using Slicers with Pivot Tables
02:43
Value & Label Filters
01:47
Using Timelines with Pivot Tables
03:23
+ Formatting a Pivot Table
2 lectures 05:08
Changing Pivot Table Style
03:40
Changing Field Formatting
01:28
+ Using Pivot Charts
1 lecture 01:21
One Shortcut to Create Pivot Chart out of Pivot Table
01:21
+ Creating Dashboard using Pivot Tables
1 lecture 10:49
Creating Dashboard using Pivot Tables
10:49