If you use Excel regularly, the hard part is rarely the calculation. It is getting the information into the shape your business expects.
Figures presented a certain way. Reports with particular headings. Naming conventions everyone is supposed to follow and half the team quietly ignores. It is repetitive work, and repetition is exactly what AI is supposed to take off your hands.
Hi, I am Andy from Initial IT in Lichfield. We look after Microsoft 365, cyber security and IT support for small businesses across Staffordshire and the West Midlands, and this is one of the more practical Copilot updates we have seen in a while, so it is worth five minutes of your attention.
Key takeaways
- Copilot in Excel can now be taught your formatting preferences and will apply them automatically.
- Workbook rules travel with the file, so a shared spreadsheet carries its own instructions.
- This mainly helps teams where three people produce the same report three different ways.
- Figures and formulas still need checking. The rules govern presentation, not accuracy.
- Check what your existing licences already include before buying anything extra.
What has actually changed?
Microsoft has been building Copilot into Excel steadily for a couple of years. Some of it has been more useful than the rest. This one is worth knowing about.
You can now tell Copilot how you like things done. How currency should be displayed, how a report should be structured, how a particular type of data should be formatted. Once you have explained it, Copilot remembers and applies it next time rather than asking again.
If you have ever found yourself making the same three adjustments to every report you generate, that is the problem this solves.
The part that matters for teams
Most businesses run on shared spreadsheets where everyone is supposed to follow the same rules. In practice one person builds the report one way, someone else does it differently, and before long there are three versions of what was meant to be a single document.
Microsoft is introducing workbook rules that travel with the spreadsheet. The file itself can carry instructions about how it should be handled, so when you share it with a colleague the rules go too.
That is a quieter change than it sounds. It means consistency stops depending on somebody remembering to explain the house style to every new starter.
Why this is different from what Copilot did before
Until now, most people have used Copilot in Excel to answer questions: summarise this, explain that formula, draft this commentary. Useful, but reactive.
This moves it closer to teaching the software how your business works. The more it understands about your preferences and processes, the more useful its output becomes, because it is no longer guessing at house style every time.
Where you still need to be careful
None of this removes the need for a person to check the work.
Spreadsheets hold some of the most consequential information in a business, and AI-generated output should be reviewed before anyone relies on it. That goes double where formulas, financial figures or reporting to a board or a lender are involved.
It is worth being clear about what these rules do and do not cover. They govern how a report is presented. They do not verify that the numbers in it are right. A beautifully formatted report built on a broken lookup is still a broken report, and now it looks official.
The other thing worth checking is whether you can use this at all. Copilot features in Excel depend on your licensing, and we regularly find businesses either paying for capability they have never switched on or assuming they have something they do not. A quick look at your Microsoft 365 setup answers it in a few minutes.
Quick check: is your business ready for tools like this?
Our free AI & Copilot Readiness Quiz takes two minutes and shows you where your business stands: what is ready, what is missing and what to fix first. No marketing list.
Take the 2-minute AI Readiness Quiz
If you would like to know which AI features inside Microsoft 365 your team could actually use today, and which ones are worth waiting on, we are happy to take a look at what you already have.
Frequently asked questions
Do I need a Copilot licence to use this in Excel?
The advanced Copilot features in Excel sit behind a Microsoft 365 Copilot licence, which is an add-on to your existing plan rather than something included by default. Some lighter AI functionality is more widely available. Because Microsoft moves these boundaries fairly often, it is worth checking against your own tenant rather than a blog post.
Will the workbook rules work if I send the file to someone outside my business?
The rules are stored with the workbook, so they travel with it. Whether the recipient sees any benefit depends on whether they have Copilot themselves. Treat it as a consistency tool for your own team rather than something you can rely on externally.
Is it safe to let Copilot work on financial spreadsheets?
Within Microsoft 365 your data stays inside your tenant and is not used to train public models, which is the main thing people worry about. The practical risk is not data leaving, it is output being trusted without review. Set the expectation that AI-generated figures get checked the same way you would check a junior colleague.
Can this replace the templates we already use?
Not entirely, and it is usually a mistake to try. Templates lock down structure, whereas these rules guide how Copilot fills things in. They work well together: keep the template for anything that must not change, and use the rules for the formatting decisions people currently make by hand.
– Andy Price, Founder & MD, Initial IT · 01543 524 594 · hello@initialit.co.uk