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:

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