Excel Pivot Table Intermediate

Excel Pivot Table Intermediate

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:

o How to solve a formula error in a pivot table

o How to show a Running total

o How to show averages. What average?

o How to count unique items

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

o How to update manual filtered list

o How to set up a customized sorting order

o How to cut down big file size

o How to generate pivot reports for all entities

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

o Ctrl + T to convert data list to data table

o Alt + N + V to create a pivot table

o Alt + F1 to insert a pivot chart

Mastering Pivot Tables like a PRO

Url: View Details

What you will learn

• Intermediate to Advanced Excel skills that will help you
• - to ace your Excel skills,
• - to find state-of-the art Excel functions,

Rating: 0

Level: Intermediate Level

Duration: 1 hour

Instructor: Lenny Wu, MBA, CPA, CGA