Module 08: Copilot in Excel Advanced + Analyst
Lesson 08.3: Scenario Analysis and Forecasting Prompts
Lesson Promise
Use Copilot to explore scenarios and forecasts as decision support, not as guaranteed predictions.
Real-World Scenario
A founder wants to estimate how hiring, pricing, and conversion rate changes could affect the next two quarters.
Core Concept
Scenario analysis is about comparing assumptions. Forecasting is about estimating possible outcomes under those assumptions. Neither is a promise.
Ask Copilot to name inputs, baseline values, assumptions, sensitivity drivers, and uncertainty. A forecast without assumptions is decoration.
For high-stakes financial, legal, operational, or staffing decisions, Copilot output should be reviewed by qualified humans and checked against the source workbook.
Step-By-Step Workflow
- Define the baseline metric and time horizon.
- List controllable assumptions and external assumptions.
- Ask for conservative, expected, and aggressive scenarios.
- Request the calculation approach and sensitivity drivers.
- Test whether the scenario results match workbook formulas.
- Present scenarios with caveats and decision options.
Prompt Lab
Bad Prompt
Forecast our revenue.
Better Prompt
Create three revenue scenarios for the next two quarters using current revenue, conversion rate, average contract value, and sales headcount.
Expert Prompt
Build a scenario-analysis prompt for revenue planning. Use baseline revenue, pipeline, conversion rate, average contract value, sales headcount, churn, and implementation capacity. Produce conservative, expected, and aggressive scenarios, state assumptions, identify sensitivity drivers, explain formulas in plain English, and list manual checks before leadership uses this forecast.
Hands-On Exercise
Create a three-scenario table and ask Copilot which assumption has the biggest impact. Verify one formula manually.
Deliverable
A scenario-analysis note with assumptions, scenarios, sensitivity drivers, caveats, and verification checks.
Executive Analysis Review Checklist
Common Mistakes
- Turning one spreadsheet question into a confident executive recommendation without checking the data.
- Asking for forecasts without naming assumptions, time horizon, inputs, and uncertainty.
- Using charts or PivotTables that look polished but do not answer the decision question.
- Treating Analyst, Python, file upload, or advanced editing features as universally available.
- Sharing analysis that does not separate observed facts, assumptions, hypotheses, and recommendations.
Quiz / Checkpoint
What is the most important safeguard in forecasting prompts?
Make assumptions explicit and verify the calculation logic before treating the forecast as decision support.
Official Sources To Verify
- Get started with Analyst in Microsoft 365 Copilot
- Get started with Copilot in Excel
- Frequently asked questions about Copilot in Excel
- Get insights about numerical data with Copilot in Excel
- Get insights from text-based data with Copilot in Excel
- Create PivotTables with Copilot in Excel
- Create charts with Copilot in Excel
- Edit with Copilot in Excel
- File formats supported by Microsoft 365 Copilot
- Copilot Chat licensing explanation
Want your AI product explained to a large AI-native audience?
Kingy AI helps AI companies turn complex products into clear, useful YouTube videos that drive awareness, product understanding, demos, clicks, and search visibility.
