If you use Excel regularly, you’ll know that the hard part is getting your information into the format you want.<\/p>\n
Perhaps you always present figures in a certain way.<\/p>\n
Maybe reports need specific headings.<\/p>\n
Perhaps your team uses formulas, naming conventions, or layouts that everyone is expected to follow.<\/p>\n
It\u2019s all repetitive. And repetition is just the thing AI is supposed to help with.<\/p>\n
Microsoft has been steadily building Copilot into Excel over the past couple of years.<\/p>\n
Some of the updates have been more useful than others, but this improvement feels like one that could make a difference.<\/p>\n
It lets you teach Copilot how you like things done.<\/p>\n
For example, you can tell it how you want currency displayed, how reports should be structured, or how certain types of data should be formatted.<\/p>\n
Once you’ve explained your preferences, Copilot remembers them and applies them automatically in future.<\/p>\n
If you’ve ever found yourself repeatedly asking Excel to make the same adjustments over and over again, this will be music to your ears.<\/p>\n
There’s another part of this update that could be useful for teams, too.<\/p>\n
Businesses often rely on shared spreadsheets where everyone is expected to follow the same rules.<\/p>\n
One person creates a report one way, somebody else does it differently, and before long there are three versions of what should be the same document.<\/p>\n
Microsoft is introducing workbook rules that can travel with the spreadsheet.<\/p>\n
The spreadsheet can contain instructions that help Copilot understand how that specific workbook should be handled.<\/p>\n
If the file is shared with colleagues, the rules go with it.<\/p>\n
That helps create consistency across a team without someone having to repeatedly explain how things should be done.<\/p>\n
This update moves AI beyond answering questions.<\/p>\n
Up until now, people have used tools like Copilot to help generate content, summarize information, or explain formulas.<\/p>\n
But this starts to feel more like teaching the software how your business works.<\/p>\n
That could make the results more useful because the AI has a better understanding of your preferences and processes.<\/p>\n
Of course, it doesn’t remove the need for human oversight.<\/p>\n
Spreadsheets can contain important business information, and any AI-generated output should still be checked before being relied on.<\/p>\n
That’s especially true when formulas, financial figures, or business reporting are involved.<\/p>\n
But for the everyday tasks that eat away at your time, this looks like a sensible step forward.<\/p>\n
If Excel can spend less time asking how you’d like something formatted and more time helping you get work done, that’s a change worth having.<\/p>\n
If you’d like to learn which AI tools inside Microsoft 365 could improve productivity for your team, we’d be happy to help. Get in touch.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you use Excel regularly, you’ll know that the hard part is…<\/p>\n","protected":false},"author":128,"featured_media":4439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-4438","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-richardson-blog"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t