Course Highlights
  • Master Excel Pivot Tables
  • Learn to Harness these skills to get a raise
  • Solve World Hunger
Curriculum

1 Topic
Welcome to Office Ninja Training

1 Topic
EXERCISE FILES

16 Topics
Subtotals
Exercise: Subtotals
Answer: Subtotals
Pivot Table Concept
Creating Your First Pivot Table
Exercise: Create a Pivot Table
Answer: Create a Pivot Table
Check your knowledge
Changing The Values Field Settings
Exercise: Changing the Values Field Settings
Answer: Changing Value Field Settings
Drill To Feature
Answer: Drill-To Feature
Formatting And Pivot Table Design
Exercise: Formatting and Pivot Table Design
Answer: Formatting and Pivot Table Design

14 Topics
Adding And Manipulating Multiple Fields
Exercise: Adding and Manipulating Multiple Fields
Answer: Adding and Manipulating Multiple Fields
Filtering And Slicing Pivot Data
Exercise: Filtering and Slicing Pivot Data
Answer: Filtering & Slicing Pivot Data
Creating Pivot Table Dashboards
Exercise: Creating Pivot Dashboards
Answer: Creating Pivot Dashboards
Pivot Charts
Exercise: Pivot Charts
Answer: Pivot Charts
Putting It All Together
Answer: Putting It All Together

  Write a Review

Excel Deep Dive: Pivot Tables Workshop

Go to Paid Course