The Ultimate Microsoft Excel Pivot Table MasterClass

The Ultimate Microsoft Excel Pivot Table MasterClass

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.

Language: english

Note: 4.7/5 (18 notes) 2,880 students

Instructor(s): The Dronaachaarya

Last update: 2022-03-14

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.



  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
  • Basic Understanding of Microsoft Excel Usage.



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

  • Understanding the Basics
    • Introduction
    • What are Pivot Table?
    • FAQs
    • Creating your First Pivot Table
    • Understanding Field Well Options
  • Preparing the Source Data
    • Cleaning the Source Data
    • Using Data Tables
    • Merge data Tables
  • Pivot Table Layouts
    • Pivot Tables Layouts Option
    • Totals. SubTotals and GrandTotals
    • Grouping and Ungrouping
  • Mathematical Functions in Pivot Table
    • Sum Count Average etc
    • Cumulative Sum
    • Percentages
    • Top X and Bottom X
    • Creating Calculated Fields
  • Formatting the Pivot Table
    • Formatting the Values
    • Understanding Auto Update
    • Using Pivot Styles and Design
    • Using Conditional Format
  • Data Filtering in Pivot Table
    • Using Build in Filters
    • Using Slicers
    • Date Filters and Timelines
    • Connecting Slicers to Multiple Pivot Tables
  • Data Sorting
    • Basic Sort
    • Custom Sort
    • Values Sort
  • Details Extraction
    • Details using double click
    • Understanding GETPIVOTDATA
  • Data Visualization and Autorefresh
    • Using Charts in Pivot Table
    • Autorefresh
  • Releasing the Pivot Table
    • Points to Remember
    • Congratulations.


Time remaining or 668 enrolls left


Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate