About this course
  • Introduction
Data preparation techniques
  • Well-formed lists
  • Identify and create groups part 1
  • Identify and create groups part 2
Pivot Tables
  • Pivot Tables
  • Data charts - basics
Decision making formulas
  • Logical Functions
  • Database Functions
What-If analysis tools
  • Goal seek
  • Scenario management
Visual reporting
  • Data Slicers
  • Advanced lIst filters
  • Conditional formatting
Bonus Section - Power tools overview
  • SharePoint and Excel
  • PowerPivot and Excel
  • Key performance indicators
  • VLookup Bonus Video
  • Index and Match Bonus Video
  • Conditional Formats - The Cool Way
  • Power Pivot Quick Introduction
  • Hide that Sheet with a VBA Macro