Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Those who want to take their Excel knowledge to the next level
  • Anyone who works with big data and wants to shorten the reporting processes with efficiency

What you’ll learn: 

  • Understand when to suppress and when not to suppress a formula error
  • Explore 5 intermediate skills of taming a pivot table’s calculations and formulas
  • Discover 7 intermediate skills of taming a pivot table’s display and layout
  • Understand 6 advanced skills of taming a pivot table
  • Recognize 10 keyboard shortcuts in working with a pivot table

Requirements: 

  • Basic Excel knowledge
  • Excel Pivot Table basics, example – be able to open one Excel file and build a simple pivot table, etc.
  • Ideally completed the Excel Pivot Table: How to Tame the Excel Beast! course

The course is presented in four parts. 

First, the course reviews 5 basic skills in building a pivot table learned in “Excel Pivot Table: How to Tame the Excel Beast!”

Second, we demonstrate 12 intermediate maneuvers to tame the Pivot Table beast. They include:

  • How to solve a formula error in a pivot table
  • How to show a Running total
  • How to show averages. What average?
  • How to count unique items

Third, we demonstrate 6 advanced maneuvers to tame the Pivot Table beast. They include:

  • How to update manual filtered list 
  • How to set up a customized sorting order
  • How to cut down big file size
  • How to generate pivot reports for all entities

Last, the course shows 10 keyboard shortcuts used in building a pivot table. They include:

  • Ctrl + T to convert data list to data table
  • Alt + N + V to create a pivot table
  • Alt + F1 to insert a pivot chart

Our Promise to You

By the end of this course, you will have learned intermediate pivot table uses and functions in Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about mastering Pivot Table in Excel.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Recap Of Pivot Table Basic 00:00:00
Instructor 00:00:00
How This Course Is Compared With “Other Similar Courses” 00:00:00
What You Will Get From This Course? 00:00:00
Practice Tests And Answers 00:00:00
Section 2 - Intermediate Taming Maneuvers – Calculations And Formulas
How To Solve A Formula Error In A Pivot Table 00:00:00
How To Show A Running Total 00:00:00
How To Show Averages? What Average? 00:00:00
How To Show A List Of Formulas Used 00:00:00
How To Count Unique Items 00:00:00
Section 3 - Intermediate Taming Maneuvers – Display And Layout
How To Customize Pivot Table Fields Window 00:00:00
How To Add Or Remove Fields Quickly 00:00:00
How To Turn Grand Total Off 00:00:00
How To Repeat All Row Labels 00:00:00
How To Quickly Open Value Field Settings 00:00:00
How To Keep Formatting Upon Update 00:00:00
How To Set Up A Schedule To Refresh Pivot Tables 00:00:00
Section 4 - Advanced Taming Maneuvers
How To Remove Old Data From The Filter 00:00:00
How To Automatically Update Manual Filtered List 00:00:00
How To Set Up A Customized Sorting Order 00:00:00
How To Cut Down Big File Size 00:00:00
How To Get Original Field Name For A Renamed One 00:00:00
How To Generate Pivot Reports For All Entities 00:00:00
Section 5 - 10 Keyboard Shortcuts
To Convert Data List To Data Table 00:00:00
To Create A Pivot Table 00:00:00
To Open Calculated Field Window 00:00:00
To Insert A Pivot Chart 00:00:00
To Refresh 1 Pivot Table 00:00:00
To Refresh All Pivot Tables 00:00:00
To Group Fields 00:00:00
To Ungroup Fields 00:00:00
To Filter Out An Item 00:00:00
To Open The Old Pivot Table Wizard Window 00:00:00
Section 6 - Conclusion
Takeaways 00:00:00
Next Course And Q&A 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel