Organize and Analyze
  • Introduction: The Current State
  • Instructions on Getting the Company Data
  • Organizing Raw Data (Filters)
  • Automate the Process (SUMIFS)
  • Data into Information (Conditional Formatting)
  • Putting Everything Together (Pivot Tables)
  • Assignment - Revenue Analysis Report
Draw Insights
  • A Better Assessment
  • Instructions on Getting the Company Data
  • Benchmark Against Competitor Performance (Date Ranges)
  • Performance Metric #1 - Occupancy (COUNTIFS)
  • Performance Metric #2 - ADR (AVERAGEIFS)
  • Putting Everything Together (Dollar Signs)
  • Bonus Lecture - Set Next Year's Goals