Copilot in Excel analyses historical data trends and generates forward-looking scenarios, such as “forecast next quarter sales by region assuming 5% market growth” or “model budget impact if headcount increases 10%.” It creates what-if tables, sensitivity analyses or growth projections with charts, letting users tweak assumptions conversationally. This empowers managers to test decisions quickly without advanced modelling skills, supports more informed planning meetings, and reduces reliance on finance teams for routine forecasts.