Excel Is Learning Your Rules: Less Faffing With Spreadsheets, More Getting The Job Done

Summary (Key Takeaways)

• Most people reckon AI in Excel is just about crunching numbers faster; the bigger change is that Copilot can now learn how you like things done and do it for you.
• You can teach it how to format figures, lay out a report and follow the way your business does things, and it’ll remember it for next time.
• New workbook rules can travel with the file, so when you share a spreadsheet everyone’s working off the same setup instead of three different versions.
• For a busy workshop that means less time wrestling with spreadsheets and more time getting jobs done.
• It doesn’t take the human out of it: anything with real figures, prices or money in it still needs checking before you rely on it.

The Real Hassle With Spreadsheets Isn’t The Maths

If your business uses Excel, and most workshops, garages and manufacturers do somewhere, whether it’s for job sheets, price lists, stock or quotes, you’ll know the fiddly bit isn’t the adding up. It’s getting the thing to look and read the way you want it. Maybe you always lay your figures out a certain way. Maybe your job sheets need specific headings. Maybe there’s a way the office does quotes that everyone’s supposed to stick to. None of it’s hard. It’s just the same faffing about, over and over, and that’s exactly the sort of repetitive job AI is meant to take off your plate.

Microsoft’s been slowly building Copilot into Excel over the last couple of years. Some of it’s been handy, some less so. But this latest change is one that could actually make a difference on the ground, because it lets you teach Copilot how you like things done. You can tell it how you want prices shown, how a report should be laid out, or how a certain type of information should be formatted, and once you’ve explained it, it remembers and does it automatically next time. If you’ve ever found yourself asking Excel to make the same tweak for the hundredth time, that’s good news.

Excel That Learns How You Work, Not Just What You Ask

Up to now, most people have used Copilot to knock out a bit of text, summarise something, or explain a formula they didn’t recognise. Useful enough, but you have to ask it every single time. This new bit is different. By letting you teach it your preferences, Copilot starts to understand how your business actually works rather than just answering one question at a time, and that tends to make what it gives back more useful, because it’s shaped around how you do things. Think of a quote that always needs laying out the same way, a stock sheet with its own headings, or a weekly jobs summary the office expects to see in a familiar format. If Copilot can reliably churn that out the way you like it, your people spend less time reformatting and more time actually getting work done. That’s the same reason it’s worth being straight about whether these tools genuinely help or just add noise, which is exactly what we weighed up when we asked whether Microsoft really is right that Copilot is the best productivity app in Windows 11.

Rules That Travel With The Spreadsheet

There’s another part of this that’s handy if more than one person touches the same files. Loads of businesses run off shared spreadsheets where everyone’s meant to do things the same way. In reality, one person sets a report up one way, someone else does it differently, and before long you’ve got three versions of what should’ve been one spreadsheet. If you’ve ever had to sort out which copy of the price list is the right one, you’ll know the time that wastes.

Microsoft’s bringing in workbook rules that travel with the spreadsheet itself. The file can carry instructions that tell Copilot how that particular workbook should be handled, and when you share it with the office or a supplier, those rules go with it. So you get everyone working off the same setup without someone having to keep explaining how it’s meant to be done. For a workshop, that’s less confusion, fewer mistakes, and less time lost sorting out which version is the right one, the same sort of practical, everyday win we talked about when we looked at how Windows 11’s speed upgrade keeps the workshop moving.

Why This Actually Saves You Time

It’s easy to write this off as “Excel tidies things up a bit”, but on a busy day those minutes add up. Here’s where it genuinely helps:

• Less re-typing and re-formatting: Every time you fix the same layout by hand, that’s a few minutes gone, and a chance to fat-finger a figure. Let the software do it the same way every time and you cut out both.
• Everyone singing from the same hymn sheet: When every quote and job sheet comes out looking the same, the office, the shop floor and your customers can all read them without having to work out where everything is.
• Fewer daft mistakes: Consistent, tidy spreadsheets make an odd figure stand out, instead of getting lost in a mess of different layouts.

None of it’s flashy. But add it all up across every person, every spreadsheet, every day, and it’s real time back in the day, time better spent on the actual jobs than on wrestling with a spreadsheet.

Where You Still Need A Person In The Loop

Here’s the important bit, and it’s one worth saying plainly. This doesn’t mean you can take your eye off it. Spreadsheets often hold the stuff that really matters, customer prices, supplier costs, quotes, figures that go out with your name on them. Anything the AI produces still needs a proper look from a person before you rely on it, and that goes double where there are formulas, prices or money involved.

The catch is that when something comes out looking neat and tidy, it’s easy to assume it’s right. A quote that’s laid out perfectly can still have a wrong number in it. Copilot formatting your spreadsheet beautifully tells you nothing about whether the figures underneath actually add up. So treat what it gives you as a good start, not the finished job, and have someone check the numbers before it goes anywhere near a customer. That’s the same reason it’s worth knowing where your business information actually ends up when it’s flying between systems and tools, something we went into in our post on whether your data is actually as secure as you think.

A Simple Way To Use It Without Getting Caught Out

You don’t need to overthink this. A few sensible habits keep you on the right side of it:

• Agree how things should look first: Decide as a business how your quotes, job sheets and price lists are meant to be laid out before you teach Copilot. That way it’s doing it your way, not just one person’s way.
• Keep an eye on the shared files: If rules are built into a spreadsheet everyone uses, someone should know what those rules say and update them when the way you work changes.
• Always check the figures: Anything with prices or money in it gets a proper read by a person before it goes out. Read it, don’t just glance at it.
• Be sensible about what’s in there: Have a think about what customer and supplier information sits in these spreadsheets and keep it protected like you would anything else.
• Tidy up now and then: As Copilot changes and the way you work shifts, go back and check the preferences you’ve set still match how you actually do things.

The Bottom Line For Busy Businesses

If Excel can stop asking how you’d like everything formatted and just get on and help you do the work the way you like it, that’s a change worth having. For all the boring, repetitive spreadsheet jobs that quietly eat your day, this looks like a sensible step forward. The move from AI that just answers questions to AI that learns how your business works is a genuinely useful one. The trick is simple enough. Let Copilot take the repetitive formatting off your team’s plate, get your spreadsheets coming out consistent, and keep a person in charge of checking the figures that matter. Do that and you get the time savings without the risk of a dodgy number slipping through. If you’d like a hand working out which bits of Microsoft 365 and Copilot could genuinely save your team time without causing you grief, we’re happy to help, and it sits right alongside the everyday reliability work we talked about when we looked at how Windows 11 is getting faster and less annoying. Get in touch with EC Computers and we’ll keep it plain, practical and focused on keeping your work flowing.