section 1
  • Welcome to Office Ninja Training
Introduction
  • EXERCISE FILES
White Belt Training
  • 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
Black Belt Training
  • 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