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,
![](https://img-c.udemycdn.com/course/240x135/3702984_a490.jpg)
Rating: 0
Level: Intermediate Level
Duration: 1 hour
Instructor: Lenny Wu, MBA, CPA, CGA
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of coursescompany.com.
View Sitemap