Week 003

Excel workshop

• Clean up data
  • Double-click at bottom-right of cell to auto-populate column
• Pivot Table
  • Excel auto-generates Year and Quarter fields according to when a date field is added
• RRI/RATE: CAGR
• Charting

Problem - Model - Solution Model:

• Data and Assumptions
• Calculation logic
• Output

Flow of model design always flows backwards

Problem is the result of SCQ Model essentially validates or invalidates the hypotheses generated Solution …

Four Steps:

• Define
• Design
• Build
• Validate

Recommendaton must be:

• actionable
• specific
• insightful