Advanced PivotTable Tricks - Useful Tips to Develop your PivotTable Skills

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
13 Lessons (1h 30m)
    • 1. Introduction

      2:14
    • 2. Two Reasons your PivotTable Counts Instead of Sums

      6:07
    • 3. You Must do This One Thing - Excel Tables

      6:48
    • 4. Grouping Dates and Times

      9:21
    • 5. Using the GETPIVOTDATA Function to Pull Data from a PivotTable

      9:22
    • 6. Going Beyond the Sum - 3 More PivotTable Calculations

      9:43
    • 7. Calculating the Difference to Previous Years/Months/Weeks

      5:16
    • 8. Create your own Calculated Fields

      3:41
    • 9. Using Conditional Formatting with PivotTables

      6:21
    • 10. Show Top Ten Results

      3:20
    • 11. Five Useful PivotTable Settings

      8:16
    • 12. The Power of Slicers

      10:29
    • 13. 7 Slicer Settings you Will Want to Change

      8:53

About This Class

d4875e94

In this class we will be delving into some advanced PivotTable tricks. We will be looking at taking your PivotTable knowledge deeper and further than the standard user.

During the class we cover advanced calculations such as calculated fields, ranking and comparisons to other field data. We look at the GETPIVOTDATA function also to pull data from a PivotTable.

We cover grouping date fields into years and months and then comparing values to previous years and months.

There are various PivotTable setting that can be changed to get more from them. Many users are unaware of these and don't have time to look. This class will show you them.

We finish with utilising Slicers to the fullest and the secret settings to take them to another level.

If this sounds like fun. Enrol and I will see you in the class.

Let's do this.