Name: Pivot Table Intermediate: Mastering Pivot Tables Like A Pro
Price: 199 USD

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