Sharing Is Caring:

Pivot Tables Playground for Business Users

Learn to use Pivot Tables to produce Business Insights and semi automate the reports.

Free tutorial

Created by Kunaal Naik


What you’ll learn

  • Generate insights using Pivot Tables
  • Semi Automate Reports
  • Improve Accuracy while reporting
  • Build quick Dashboards using Pivot Tables


  • Basics of Excel
  • Enthusiastic about bringing insights to business users


As a Business user, you might often feel overwhelmed by the number of requests you can handle at a time. Sometimes you wished there were more hours in a day to work them out correctly and at the same time provide insights.

In this Pivot Table series for Power Business users, you will learn smart tips and tricks to get to a solution quickly using Excel Pivot tables and semi-automate your reporting to answer same questions faster in the future repeatedly. Also, we will learn how to build Dashboards which are easy to make and simple to use.

Who this course is for:

  • Beginner users who want to learn to generate insights using data
  • Build quick dashboards using Pivot Tables

Show less

Course content

6 sections • 14 lectures • 1h 39m total lengthCollapse all sections

Welcome1 lecture • 1min

  • Introduction01:09

Starting with Basic5 lectures • 33min

  • Analyse Data by Manual Grouping10:24
  • Analyse Time Series Data10:29
  • Dynamically Update Pivot Tables04:15
  • Create Histograms03:18
  • Uneven Histogram04:58
Read Also -->   Learn VBA in 67 Minutes

Adding Calculated Fields and Items3 lectures • 30min

  • Calculated Fields07:58
  • Calculated Items16:10
  • Delete and Add Calculated Fields05:44

Work with additional categories3 lectures • 23min

  • Group by Month and Week05:44
  • Group by Month not working07:25
  • Cumulative Values09:38

Building Dashboards1 lecture • 12min

  • Build Corona Dashboard11:42

We are done!1 lecture • 1min

  • Thank You00:45

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO