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 |