Master Class on Pivot Table

Course Fee - INR 999 /- only

Why it's important!

Pivot table is the most powerful and easiest tool of access. There is no need for any formula while working on it. Most of the reports that we require in our day-to-day workings are possible with this feature of MS Excel. The data size is not an issue and even a change in data source will immediately update the corresponding reports. We can also build interactive charts in a user-friendly way.


Webinar - Pivot Table
  • Webinar - Pivot Table
Working Files - (Download)
  • Working Files - (Download)

Salient Features of the Course

πŸ‘‰ Introduction to Magic world of Pivot Table

πŸ‘‰ Good or Bad Data - Very Important for Pivot

πŸ‘‰ Commandments for Good Data

πŸ‘‰Convert Bad Data to Good Data - Quick Ways

πŸ‘‰ Combining Multiple Cross Sheets in to One Sheet

πŸ‘‰ Instant Analysis - No Formulas

πŸ‘‰ Handling fiscal years which do not start in January 

πŸ‘‰ Reports for Year, Qtr, Month even for Weeks with in seconds

πŸ‘‰ Create Ageing of Debtors/Stock with click of button

πŸ‘‰ Bin or Bucket Analysis

πŸ‘‰ Pivot Charts to Understand Data Better

πŸ‘‰ Amazing ways of viewing the same data from different points of view

πŸ‘‰Instant Running Totals and Ranking

πŸ‘‰ Conditional Formatting with in Pivots

πŸ‘‰ Formulas/Calculations with in and outside Pivot

πŸ‘‰ Drill down reports

πŸ‘‰ Month on Month Growth or Trending

πŸ‘‰ Month on Month Growth or Trending

πŸ‘‰ Creating Multiple reports with a click from a single Pivot Table

πŸ‘‰ Customize Reports

πŸ‘‰ Pivot Tables - Shortcomings & Disadvantages and how to overcome it

πŸ‘‰ How to Customize  Table default Display settings 

πŸ‘‰ How to Handle Big Data through Pivot Table

πŸ‘‰ How to make range dynamic or even will pick of a sheet name given in cell 

πŸ‘‰ Dashboarding - Overview

πŸ‘‰  Q&A


Obtain a digital certificate for completing this course

Get access to the working and business solution files

Get access to the webinar recording for 3 months

Get answers to all your queries