◆ Excel · forecast

Contact Details

Maintain a single worksheet named Project Contacts with columns: Role, Full name, Company, Phone, Mobile, Email, Prima…

2heights
2tasks
1roles do it
See the prompt↓More forecast workflows

The same job, four prompts

do it · improve it · decide · become
AExecute — “help me do it”Maintain a single worksheet named Project Contacts with columns: Role, Full name, Company,…+
Maintain a single worksheet named Project Contacts with columns: Role, Full name, Company, Phone, Mobile, Email, Primary on-site contact (Y/N) — keep it as a formatted table, freeze the header row, and validate Role with a dropdown; update entries when subcontractors ask for a contact.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before I hand this to the site team, make the contacts sheet easy to scan and use on the phone…+
Before I hand this to the site team, make the contacts sheet easy to scan and use on the phone — show Role and Company first, surface the on-site primary with a coloured cell, add a Last‑confirmed date column and a quick filter for Trade so I can find who to call under pressure.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

How to do it

the tool · the steps · what to avoid
The tool
Forecast Sheet

The Forecast Sheet in Microsoft Excel helps you predict future values based on your historical data.

  1. 1

    Organize your data into two columns: one for time-based dates or numerical data, and one for corresponding values.

    Best practiceEnsure your time-based series data is ready before creating a forecast sheet.

  2. 2

    Select any cell within your range of data.

    RecommendationSelecting the entire range (e.g., A1:B13) is also effective.

  3. 3

    Click the Data tab in the ribbon.

  4. 4

    In the Forecast group, select Forecast Sheet.

    NoteThis button is also accessible via the shortcut ALT + A + F + C on Excel for Mac.

  5. 5

    In the Create Forecast Worksheet box, pick either a line chart or a column chart for your forecast visualization.

  6. 6

    Specify the Forecast End date by selecting it from the calendar.

  7. 7

    Click Options to adjust settings like Confidence Interval, Seasonality, or Fill Missing Points.

    NoteThe Forecast Sheet uses the FORECAST.ETS function, which employs the Exponential Smoothing (ETS) algorithm.

  8. 8

    Click Create to generate the forecast sheet.

    NoteA new worksheet will be added to your workbook containing the forecast chart and data.

For accurate cash flow analysis or budget planning, always verify your historical data for any errors before generating a forecast.

While the Forecast Sheet is a UI feature, Excel's underlying forecasting functions (FORECAST.LINEAR, FORECAST.ETS) can be used in VBA or other automation scripts.

Glossary

words on this page
Create Forecast WorksheetGenerate a new sheet containing a chart and future values based on historical time-series data.ExampleBased on last year's monthly sales, Excel generates a forecast worksheet predicting next year's sales trends.
Forecast SheetA tool that creates a new worksheet with a visual forecast and future predictions.ExampleThis feature can predict next quarter's sales and display the trends on a new sheet.
column chartA chart type that displays data in vertical bars, useful for comparing values across different categories.ExampleA chart shows sales for Q1, Q2, and Q3 as separate vertical bars for easy comparison.
line chartA chart type that displays data points connected by lines, ideal for showing trends over time.ExampleThis chart displays your company's stock price rising steadily over the past year.
FunctionA predefined formula that performs calculations using specific values in a particular order.ExampleUsing the SUM function quickly adds up a column of numbers.

The real tasks

1 of them
Keep a single, up-to-date list of project contact details and roles so I can call the right person when a subcontractor asks a question.

Who does this

1 roles
Architect

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.