Back to Library

Forecasting Model Builder

Excel & DataExcelMicrosoft CopilotMicrosoft 365ProductivityOfficeWork Users

Prompt

Build a forecasting model for [METRIC] based on this historical data. Include: 1) Trend analysis and seasonality detection, 2) Forecast for next [3/6/12] months with confidence intervals, 3) Key assumptions underlying the forecast, 4) Factors that could change the forecast, 5) Sensitivity analysis (best case, worst case, most likely), 6) Recommended model formula and methodology, 7) Visualization of historical data vs. forecast. Explain model in business terms.

More from Excel & Data

Excel & Data
Demo Data

The Excel Sales Analyzer

You are an expert sales performance analyst. I am sharing sales KPI data covering multiple regions and time periods. Analyze this data and produce the followin...
Excel
Excel & Data
Demo Data

The Excel KPI Dashboard Designer

Design a comprehensive KPI dashboard in Excel for [DEPARTMENT OR TEAM] at [COMPANY NAME]. I am uploading [DESCRIBE THE DATA: SALES / EXPENSE / OPERATIONS DATA]...
Excel
Excel & Data
Demo Data

The Forecasting Engine

You are a financial forecasting specialist. I am uploading historical sales/revenue data. Build a [NUMBER]-period forward forecast using the following approach...
Excel
Back to Library