Pivot Table Tricks

In this video, we will learn about the following foundation tricks of Pivot Table:

  • Understanding the layout
  • Sort
  • Mathematical Calculations
  • Drill down the details
  • Pivot Chart Shortcut – F11
  • Grouping (Dates)
  • Grouping (Numbers)
  • Slicers & related settings
  • Conditional Formatting
  • Change Data Source & Refresh


Please download the practice file from below:

Download


Refer the last video lecture to see how to use Pivot Table in the Google Sheets. Click Here