Create forecasting trendlines — AI Prompts for Microsoft Excel

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

Finance asked for four alternative forecasts with linear trendlines for revenue and costs for next…

Finance asked for four alternative forecasts with linear trendlines for revenue and costs for next 12 months. Create the forecasting sheet: plot monthly historical revenue and cost, add trendline formulas that project the next 12 months for both series, show the trend values as a table beside the chart, and label scenarios as Base, Upside (+5% growth), Downside (-3% growth), and Conservative (flat). Save the workbook and include a one-paragraph note on assumptions.

Improve — make it easier to accept

Before I show this to the VP of Planning, make the forecast easy to question: place the headline…

Before I show this to the VP of Planning, make the forecast easy to question: place the headline projected revenue for month 12 at the top, show the three inputs that most change the result, display a confidence band around the trendline or an alternate lines table, and flag any months where historical data is incomplete or anomalous.

Decide — diagnose the stuck moment

I created a linear trendline and month nine spikes unexpectedly despite steady history. Priya in…

My trendline projection gives an implausible spike in month nine.

I created a linear trendline and month nine spikes unexpectedly despite steady history. Priya in forecasting will ask if I baked in seasonality or a data entry error. I don’t know whether the model or the source data is wrong. What checks should I run first to diagnose whether this is a formula, an outlier in the historical series, or an inappropriate trend method, and which fix is safest to present at short notice?

Become — change the pattern

Over time I keep producing forecasts that miss by the same pattern: I use linear trendlines for…

Forecasts drift because I default to a single trend method for all series.

Over time I keep producing forecasts that miss by the same pattern: I use linear trendlines for series with seasonality or recent structural shifts and then defend the numbers in review. This undermines credibility. Which habits should I change when choosing forecasting methods, and what rapid validation steps will catch the top three modeling mistakes before sending forecasts to stakeholders?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Create charts for presentations Create client presentations of plan details.Create dashboards for stakeholders Create dynamic named formulas Create financial reports Create formulas for calculations Create new artificial substances and useful processes Define distribution of work according to production capacity Describe artifacts' physical properties or attributes, such as the materials from which artifacts are made and their size, shape, function, and decoration.Describe properties in terms of quantities

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt