Build a Forecasting Model in Excel With AI Assistance Step by Step

Coding Liquids blog cover featuring Sagnik Bhattacharya for building a forecasting model in Excel with AI assistance, with forecast and scenario visuals.
Coding Liquids blog cover featuring Sagnik Bhattacharya for building a forecasting model in Excel with AI assistance, with forecast and scenario visuals.

You can build a forecasting model in Excel with AI by letting it outline the sections, suggest formula patterns and draft scenario tables while you decide the drivers and assumptions. Speed only matters if those assumptions stay reviewable, because forecasting work breaks when a polished model rests on unclear or weak business logic.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

The right use of AI is to accelerate structure, scenario framing, and repetitive setup while a human still owns the assumptions.

How Do You Build a Forecasting Model in Excel With AI?

To build a forecasting model in Excel with AI, use AI to accelerate the mechanics, not to replace judgement over drivers, assumptions, and scenario logic. The model becomes useful when the structure is clear enough to defend, not when it merely appears complete quickly.

  • You need to build a first-pass forecast more quickly.
  • The main uncertainty is around drivers and scenarios, not spreadsheet mechanics alone.
  • You can still review every major assumption before using the output.

Where Does AI Help When Building a Forecast Model?

When you build a forecasting model in Excel, AI helps by outlining model sections, suggesting formula patterns, drafting scenario tables, and helping you think about which drivers to test.

If you want a second pair of eyes on how AI could fit into your own forecasting workflow, I offer a one-to-one AI consultation.

What Must Stay Human-Owned in an AI Forecast?

In an AI-assisted forecasting model, revenue assumptions, seasonality judgement, risk adjustments, and business context must still be owned by the analyst or operator using the model.

How Do You Keep an AI-Assisted Forecast Model Reviewable?

To keep an AI-assisted forecasting model reviewable, separate assumptions, calculations, and outputs. Label the scenarios clearly and avoid burying AI-generated logic where stakeholders cannot inspect it.

If you want to learn Excel with Copilot, ChatGPT and Claude from an instructor, try The Complete Excel Course with AI Integration on Coding Liquids.

Worked example: demand planning model

A small retailer wants a first-pass demand forecast for the next quarter. AI helps draft scenario sections and formula structure, while the planner still decides the growth, seasonality, and downside assumptions.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Common mistakes

  • Treating AI-generated assumptions as if they were evidence.
  • Combining assumptions and calculations on one messy sheet.
  • Skipping scenario definitions because the draft model looks detailed enough.

When to use something else

If you need the Python side of deeper analysis, read Copilot in Excel with Python. If you need stronger finance-model basics first, financial modelling in Excel is still relevant.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Frequently asked questions

Can AI build a forecasting model for me?

Partly: AI can accelerate the mechanics, such as outlining sections, suggesting formula patterns and drafting scenario tables, but the drivers, assumptions and scenario logic must stay yours. A model is only useful when its structure is defensible, so review every major assumption before you rely on the output, and keep the AI-drafted parts where stakeholders can inspect them.

What must stay human-owned?

Revenue assumptions, seasonality judgement, risk adjustments and business context must stay with you. These are judgement calls that AI cannot own, even if it can format them neatly. The analyst or operator using the model owns them, because forecasting work breaks when a polished model rests on unclear or weak business logic.

How do I structure an AI-assisted model?

Separate assumptions, calculations and outputs into distinct areas, and label the scenarios clearly. Never bury AI-generated logic where a stakeholder cannot inspect it. This keeps the model reviewable, so anyone reading it can trace a number back to the assumption behind it and see which parts the AI drafted.

How do I sanity-check the forecast?

Test the assumptions at extremes, compare the output against history or actuals, and confirm each driver moves the result the way it should. If you cannot explain why a number moved, do not ship it. AI can help you think of which drivers to test, but the checking is yours.

What forecasting method should I use?

Match the method to the data: simple trend and seasonality for stable series, and driver-based models for businesses with clear levers. AI can suggest options, but you choose based on what you can defend. If you need stronger finance-model basics first, learn those before you ask AI to build on them.

Where does AI forecasting go wrong?

AI forecasting goes wrong when 'looks complete' gets confused with 'is right', so a tidy model rests on unexamined assumptions. Other failure points are treating AI-generated assumptions as evidence, mixing assumptions and calculations on one messy sheet, and skipping scenario definitions. Treat AI as a faster builder, not a substitute for understanding the business.

Related guides on this site

If you want to keep going without opening dead ends, these are the most useful next reads from this site.