Before Copilot changes your budget: ask for a change plan

Many small teams have one Excel file everyone trusts, even though nobody really wants to touch it. The budget. The price list. The staffing schedule. The cash flow forecast. The file where a formula from 2021 still works, as long as nobody drags the wrong cell two rows too far.

That is why Microsoft’s latest Excel signal is more practical than it first sounds. Copilot in Excel is not just about getting faster answers. Microsoft’s support docs now describe three habits smaller teams can use right away: plan mode before editing, controllable workbook changes, and reusable skills for repeat spreadsheet work.

This is not only for finance departments with twenty analysts. It matters to a restaurant planning staff hours, a consultant checking revenue, a nonprofit reconciling grants, or a school trying to understand next term’s resource needs. The useful move is simple: make the AI produce a change plan before it starts writing into the workbook.

Source: Microsoft Support: Get started with Copilot in Excel

What Microsoft has actually added to Excel

Microsoft describes Copilot in Excel as a tool that can build and edit workbooks, create formulas, make charts, identify insights, and work in three modes: edit, plan, and chat. Plan mode is the key here. Instead of changing the workbook immediately, Copilot creates a structured plan the user can review and confirm before work continues.

Microsoft’s skills support page describes the next layer: a skill gives Copilot instructions for repeatable tasks. Custom skills are stored in OneDrive and defined with a SKILL.md file. In plain language, that lets a team write down how a spreadsheet job should be done so the AI does not need the full method explained every time.

Source: Microsoft Support: Use skills with Copilot in Excel to complete repeatable tasks

For a smaller team, that translates cleanly. You do not need to start with a DCF model or corporate reporting pack. You can start with one recurring spreadsheet job:

• update this week’s cash flow forecast
• compare actual sales with budget
• find cost lines that look unusual
• draft a first purchasing plan
• summarize which assumptions changed since the last version

The second important part is the workflow. Microsoft says plan mode lets Copilot generate a step-by-step plan instead of acting immediately in the workbook. For a small team, that is already a useful shift: see what the AI intends to do, remove what is wrong, and let only approved parts move forward.

That may sound like a small detail. In real work it is the difference between "AI changed my budget" and "AI proposed these five changes, on these rows, for these reasons".

Why this matters when there is no finance department

In a smaller business, finance work is usually scattered. The owner may keep the forecast in Excel. A colleague owns the price list. The accountant has the official answer two weeks later. Someone else knows why a supplier cost was unusually high, but that context is not written in the workbook.

AI can help here, but only if the work remains reviewable. A good AI-assisted spreadsheet routine should not feel like a black box rewrote the numbers. It should feel like a careful junior colleague saying: "I plan to check these sheets, compare these assumptions, and suggest edits here. Do you want me to continue?"

It is also a better way to evaluate AI purchases. Microsoft Learn lists Microsoft 365 Business Standard with Copilot and Microsoft 365 Business Premium with Copilot as generally available from July 1, 2026 for SMB customers. The same document mentions new and extended Copilot offers for smaller organizations. In practice, more small teams will meet Copilot inside their normal Microsoft setup, not as a separate experiment.

That can be useful. It can also become another layer on top of messy routines. Excel is a strong first test because the result is visible, changes can be reviewed, and the team quickly sees whether AI saves time.

Source: Microsoft Learn: July 2026 announcements - Now available: Microsoft 365 Business with Copilot SKUs

Start with a change plan, not automatic editing

Pick a workbook where a mistake would be noticed but would not break the business. An internal budget follow-up is better than the official customer price list. A copy of the staff schedule is better than the original. A forecast sheet is better than the accounting file.

Run the work in two steps.

Step 1: ask for the plan. Copilot should not edit the file immediately. It should first show which sheets it wants to read, which ranges it wants to compare, which formulas or assumptions it wants to check, and which questions it needs answered.

Step 2: approve selected edits. Once the plan looks reasonable, Copilot can create suggestions, mark affected cells, and write a short explanation. A human decides what actually gets saved.

A simple routine looks like this:

1. Save a dated copy of the workbook.
2. Mark which sheet is the working sheet and which sheet is the reference.
3. Ask Copilot to write a change plan without editing.
4. Read the plan and remove anything outside the task.
5. Let Copilot make suggestions in the copy.
6. Review changes in the workbook history or change view.
7. Write a short note: what changed, why, and who approved it?

This is not a brake. It is what lets AI work in real files instead of staying in demo chats.

Copy-paste prompt: make the budget reviewable

Use this prompt in a copy of an Excel workbook. Replace the bracketed parts.

You are helping me review an Excel workbook before anything changes.

Goal: [for example update this week’s cash flow forecast / compare actual sales with budget / find cost lines that look unusual]

Important sheets: [sheet names]
Reference period: [date/week/month]
Known assumptions: [for example opening hours, hourly rate, raw material cost, student count, campaign period]

First, create only a change plan. Do not edit any cells yet.

The plan should include:
1. which sheets and cell ranges you want to read
2. which formulas or assumptions you want to check
3. which variances you are looking for
4. which questions you need to ask before editing
5. which edits you would suggest, grouped as "safe", "needs human judgment", and "do not touch automatically"

After I approve the plan, you may create suggestions in the copy of the file. Each suggestion must include the cell reference, a short reason, and a reference to the supporting material in the workbook.

The point is not to write the perfect prompt. The point is to move AI work from "redo my budget" to "show me how you plan to change my budget".

Write one Excel skill for repeat work

If the same spreadsheet job comes back every week, write down the method. It does not have to be advanced. A simple SKILL.md can include:

• the goal of the routine
• which sheets are normally used
• which assumptions must always be checked
• which edits require human approval
• how the result should be summarized
• which rows or sheets Copilot must never change without a clear yes

A shop might create a weekly forecast skill. A school might create a term follow-up skill. A consultant might create a utilization and revenue skill.

The useful part is that a skill makes the method less dependent on whoever happens to sit at the computer. When the instruction lives next to the files, the routine becomes easier to improve, review, and hand over.

Microsoft’s support docs also explain how built-in and custom skills can be managed, enabled, disabled, and invoked directly with an @mention. Check what is actually enabled in your own tenant before building a routine around it.

Three Excel workflows to test this week

Pick one focused workflow and run it on a copy.

Budget versus actuals: Ask Copilot to find the five largest variances, but first make it describe which rows and assumptions it plans to compare. Useful for owners who want to see what changed without reading the whole accounting export.

Staffing versus demand: Compare schedule, sales, and booking data. Ask the AI to flag where the load looks odd, but let a human decide whether anyone should actually be moved.

Price list or proposal template: Ask Copilot to look for old prices, missing margins, and formulas that no longer follow the template. The change plan matters even more here. Price changes should be reviewed, not slipped in.

Once one of these workflows works, Hammer can help turn it into a cleaner Tool Forge routine: the right file copies, clear permissions, secret handling where integrations are involved, approval steps, and a run log that does not require the team to become technical.

This is the mature way to use AI in spreadsheets

The brave path is not giving AI open access to every finance file. The brave path is letting AI move closer to the real work, but in a form people can understand.

Ask for the plan first. Review the cells that change. Save the receipt. After two or three runs, you will know whether Copilot in Excel is just another button or whether it actually helps the team make better decisions faster.