✅ Advanced Excel Part 2: What-If Analysis, Goal Seek & Scenario Manager

1. What-If Analysis
Big picture: Shows how changing inputs affects results. Used for:
- Profit planning
- Budgeting
- Target setting
Excel tools inside it:
- Goal Seek
- Scenario Manager
- Data Tables

2. Goal Seek
One target, one variable. Goal Seek works backward.
You know: Final result
You change: One input value
Example: You want profit = 50,000. Profit formula: Profit = Revenue − Cost
Question: What revenue is needed?
Steps:
- Go to Data → What-If Analysis → Goal Seek
- Set cell: Profit cell
- To value: 50000
- By changing cell: Revenue cell
Result: Excel calculates required revenue.
Best use:
- Break-even analysis
- Sales target planning
- EMI or margin calculations
Limit: Works with only one changing cell, no multiple scenarios together

3. Scenario Manager
Multiple situations. Scenario Manager compares different cases.
You define: Multiple inputs, one result
Example: Sales forecast
Inputs: Price, Quantity, Cost
Scenarios: Best case, Normal case, Worst case
Steps:
- Data → What-If Analysis → Scenario Manager
- Add scenario
- Enter values for input cells
- Show summary
Result: Excel creates a comparison table.
Best use:
- Business planning
- Risk analysis
- Management presentations

4. Goal Seek vs Scenario Manager
Goal Seek:
- One target value
- One changing input
- Fast calculation
Scenario Manager:
- Multiple inputs
- Multiple cases
- Comparison view

5. Real-world example
Startup revenue planning:
- Goal Seek to find required sales
- Scenario Manager to compare optimistic vs pessimistic plans

6. Common mistakes
- Wrong formula cell selected
- Hardcoded values in formulas
- Too many changing cells in Goal Seek

Interview tip: Say this clearly. Goal Seek finds the input needed for a target result. Scenario Manager compares multiple business scenarios side by side.

Double Tap ♥️ For More