The Ultimate Microsoft Excel Pivot Table MasterClass
3.9 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,547 students enrolled

The Ultimate Microsoft Excel Pivot Table MasterClass

Learn the core of Pivot tables with Best Practices, Case Studies, Techniques and become an Excel Pivot Table Ninja.
3.9 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,547 students enrolled
Created by The Excel Gurus
Last updated 9/2019
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn Excels most powerful data analysis tool
  • Learn How to analyze, Sort, Filter and Analyze data in a understandable way.
  • Learn some of the Best Practices for Sourcing, Sorting, Formatting and creating Custom Styles.
  • Get a solid understanding of everything about Pivot Tables from Bestselling Udemy Instructor.
Requirements
  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
  • Basic Understanding of Microsoft Excel Usage.
Description

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. A Pivot Table is a summary of a large dataset that usually includes the total figures, average, minimum, maximum, etc. let's say you have a sales data for different regions, with a pivot table, you can summarize the data by region and find the average sales per region, the maximum and minimum sale per region, etc. Pivot tables allow us to analyse, summarize and show only relevant data in our reports.

This online course is designed to give you a solid understanding of Pivot Tables, taking you from novice to ninja!.

In this course you will explore the Ultimate power of Pivot Tables in Sorting, Filtering, Analyzing and Presenting complex data in a easy to Understand Format and derive meaning outputs for decision making.

The course will Equip you with the Best Practices for preparing source data, using database ,  preserve formats and create custom styles, sorting and filtering techniques, and much more.

Every lecture comes with ample to resource files and case studies for your practice and hands on experience.

Whether you are new to the world of Excel or a regular User, this course will be a milestone on your journey to become a Excel Ninja and a Go To Person at Work.

I am totally Excited to see you inside the course.


Who this course is for:
  • Anyone who is a regular user of Microsoft Excel
  • Anyone who would like to take his Excel skills to a new level.
  • Anyone who would like to get a solid understanding of the concept of Pivot Table.
Course content
Expand all 32 lectures 04:30:03
+ Preparing the Source Data
3 lectures 23:42
Cleaning the Source Data
08:11
Using Data Tables
08:34
Merge data Tables
06:57
+ Pivot Table Layouts
3 lectures 25:30
Pivot Tables Layouts Option
09:18
Totals and Subtotals
08:06
Grouping and Ungrouping
08:06
+ Mathematical Functions in Pivot Table
5 lectures 43:47
Sum Count Average etc
08:03
Cumulative Sum
08:29
Percentages
11:21
Top X and Bottom X
08:22
Creating Calculated Fields
07:32
+ Formatting the Pivot Table
4 lectures 30:40
Formatting the Values
06:08
Understanding Auto Update
05:28
Using Pivot Styles and Design
07:45
Using Conditional Format
11:19
+ Data Filtering in Pivot Table
4 lectures 42:01
Using Build in Filters
12:48
Using Slicers
11:16
Date Filters and Timelines
08:49
Connecting Slicers to Multiple Pivot Tables
09:08
+ Data Sorting
3 lectures 21:58
Basic Sort
05:47
Custom Sort
08:18
Values Sort
07:53
+ Details Extraction
2 lectures 19:11
Details using double click
08:28
Understanding GETPIVOTDATA
10:43
+ Data Visualization and Autorefresh
2 lectures 28:28
Using Charts in Pivot Table
11:56
Autorefresh
16:32
+ Releasing the Pivot Table
2 lectures 11:57
Points to Remember
11:22
Congratulations.
00:35