Summary (Key Takeaways)
- Most people picture AI in Excel as faster number crunching; the more significant shift is that Copilot can now learn how your firm likes things done and apply those preferences automatically.
- You can teach Copilot how currency should display, how reports should be structured and which conventions to follow, and it will remember them for next time.
- New workbook rules can travel with a spreadsheet, so when a file is shared the rules go with it, helping a team stay consistent without constant re-explaining.
- For regulated firms, this is less about convenience and more about accuracy, consistency and defensible, repeatable processes.
- It does not remove the need for human oversight: any AI output touching formulas, financial figures or client reporting must still be checked before it is relied upon.
Why “Teaching” Your Spreadsheet Is A Bigger Shift Than It Sounds
If your firm runs on Excel, and almost every professional practice does somewhere, you will know that the genuine effort rarely lies in the calculation itself. It lies in getting the information to look, read and behave exactly the way your firm expects. Figures have to be presented in a particular way. Reports need specific headings and a familiar structure. Your team follows naming conventions, layouts and formula patterns that everyone is expected to honour. None of that is difficult, but it is endlessly repetitive, and repetition is precisely the kind of work that AI is supposed to take off your hands.
Microsoft has been building Copilot into Excel steadily for a couple of years now. Some updates have landed better than others. This one feels different, because it moves Copilot from answering questions to learning your preferences. You can tell it how you want currency displayed, how a report should be laid out, or how a particular type of data should be formatted, and once you have explained it, Copilot remembers and applies it automatically next time. For anyone who has found themselves making the same formatting request over and over, that is a quietly meaningful change.
For a regulated firm, the significance runs deeper than saved keystrokes. When software starts to internalise how your firm does things, you are no longer simply using a tool, you are encoding your working practices into it. That is an opportunity and a responsibility in equal measure, and it deserves to be approached with the same care you would give any other change that touches how client information is handled.
From Answering Questions To Learning How Your Firm Works
Up to now, most people have used Copilot to generate content, summarise information or explain an unfamiliar formula. Useful, certainly, but essentially reactive. You ask, it answers. The new direction is different in character. By letting you teach it your preferences, Copilot starts to understand your processes rather than just responding to individual prompts, and that tends to make its output more genuinely useful because it is shaped by how your firm actually operates.
Consider a suitability report in an IFA practice, a set of year-end schedules in an accountancy firm, or a completions summary in a mortgage brokerage. Each has an established format that colleagues, and sometimes clients and auditors, have come to expect. If Copilot can reliably reproduce that format, your people spend less time reformatting and more time on the judgement that clients are actually paying for. This is the same reasoning behind treating productivity tools as something to be assessed properly rather than adopted on faith, a theme we examined when we asked whether Microsoft Copilot really is the top productivity app in Windows 11.
Workbook Rules That Travel With The File
There is a second part of this update that matters a great deal for teams. Firms rely constantly on shared spreadsheets where everyone is meant to follow the same rules. In practice, one person builds a report one way, a colleague does it slightly differently, and before long there are three versions of what should have been a single, consistent document. Anyone who has tried to reconcile competing versions of the same workbook before a deadline knows exactly how much time that quietly costs.
Microsoft is addressing this with workbook rules that can travel with the spreadsheet itself. The file can carry instructions that help Copilot understand how that specific workbook should be handled, and when it is shared with colleagues, those rules go with it. The effect is consistency across a team without someone having to keep explaining the house style by hand. For a regulated firm, that consistency is not cosmetic. Repeatable, predictable processes are the foundation on which governance and audit-readiness are built, which is exactly why we treat seemingly small platform changes as decisions worth weighing rather than background noise, a point we made in our look at how Windows 11’s quiet performance overhaul became a governance question.
The Governance Upside: Consistency, Accuracy And Defensibility
It is tempting to file “Excel formats things automatically” under convenience. In a regulated environment, that undersells it. Consider three dimensions where it genuinely matters:
- Accuracy: Manual reformatting is a classic point at which small errors creep in, a transposed figure, a mis-pasted column, a heading that no longer matches the data beneath it. The less manual handling a report requires, the fewer of those quiet opportunities for error.
- Consistency: When every fee-earner produces the same report in the same structure, reviewers, compliance officers and clients can read it confidently, knowing where everything sits. Consistency is also what makes an anomaly stand out, because the eye is not distracted by presentational differences.
- Defensibility: Regulators, auditors and cyber insurers increasingly expect firms to demonstrate that controls operate consistently. Standardised, rule-driven outputs are far easier to evidence than a patchwork of individual styles.
None of this is dramatic on its own. But good governance rarely fails because of one headline event; it is eroded by an accumulation of small, unmanaged inconsistencies. A tool that gently enforces your firm’s standards, applied the same way every time, is a genuinely useful ally in keeping that erosion at bay.
Where Human Oversight Must Stay Firmly In Place
For all its promise, this update does not, and must not, remove the human from the loop. Spreadsheets routinely hold some of the most important information a firm possesses: client financial positions, fee calculations, management figures, regulatory returns. Any AI-generated output should still be checked by a competent person before it is relied upon, and that is especially true wherever formulas, financial figures or formal business reporting are involved.
The subtlety worth naming is that polished output is persuasive. When a report arrives correctly formatted and confidently laid out, it looks finished, and a finished appearance is very easily mistaken for a correct result, particularly by a reviewer who is busy or tired. Formatting is not the same as accuracy. Copilot applying your house style flawlessly says nothing about whether the underlying numbers, logic and assumptions are sound. The professional obligation to check the substance remains entirely with your people. This is the same discipline we encourage firms to apply to where their data lives and who can reach it; if you have not revisited it recently, it is worth asking honestly whether your data security is genuinely keeping pace with your business.
A Simple Framework For Adopting Copilot’s Memory Safely
If you want to turn an interesting feature into a genuinely safe benefit, a short, sensible framework helps:
- Agree the standards first: Decide, as a firm, what “correct” formatting and report structure actually look like before you teach them to Copilot. The tool should reflect an agreed house style, not one person’s habits.
- Own the workbook rules: Treat rules embedded in shared workbooks as controlled content. Someone should be responsible for what those rules say and for reviewing them when processes change.
- Keep a human checkpoint: Mandate that anything client-facing, or anything feeding a regulatory or financial output, is reviewed by a qualified person before it leaves the building. Read properly, not skimmed.
- Mind sensitive data: Be clear about what information may sit in Copilot-enabled workbooks and how it is protected, in line with your existing data governance.
- Review periodically: As Copilot evolves and your conventions change, revisit the preferences and rules you have set so they do not quietly drift out of step with current practice.
Handled this way, the feature stops being a novelty and becomes part of how your firm maintains disciplined, consistent, defensible working practices.
The Bottom Line For Professional Firms
If Excel can spend less time asking how you would like something formatted, and more time helping your people get the work done to a consistent standard, that is a change worth welcoming. For the everyday, repetitive tasks that steadily erode billable time, this looks like a sensible step forward, and the move from AI that merely answers to AI that understands your processes is a meaningful one.
The balance to strike is simple to state and important to hold. Let Copilot take the repetitive formatting and structuring off your team’s plate, encode your firm’s standards so consistency becomes the default, and keep a qualified, accountable person firmly in charge of checking the substance. That is how a regulated firm captures the efficiency without inheriting the risk. If you would like to understand which AI features inside Microsoft 365 could safely improve productivity for your team, and how to govern them properly, we would be glad to help. These foundations sit alongside the everyday reliability work that keeps a firm running smoothly, a theme we explored when we looked at how Windows 11 is finally addressing what has been frustrating your team. Get in touch with Absolutely PC.
What next?
One of my passions is helping businesses to succeed and if I can help you save some money as well – even better. You can fill out our contact form, phone us or click on the appointment button below and let’s start a conversation to see if I can help your business. Our guarantee:
- There are no hidden charges – this is a 100% free 15 minute consultation with no hidden charges.
- We will never spam you or sell on your contact details.
- We will treat your information with absolute confidentiality.
Other Posts for you to Enjoy
