It’s Friday afternoon. Your office manager is preparing the monthly financial report. The numbers are correct.
But the formatting isn’t.
- The currency columns are inconsistent.
- The headings don’t match last month’s report.
- Someone changed a formula.
- The spreadsheet your manager received from another employee looks completely different from the one everyone agreed to use.
Sound familiar?
Nobody is doing anything particularly complicated.
They’re just spending time making Excel behave the way the business expects.
Again.
Microsoft is working on an interesting improvement to Copilot in Excel that could make those repetitive frustrations less common.
Instead of constantly telling Excel what to do, you may be able to teach it how your business likes things done.
What If Excel Remembered Your Preferences?
Imagine telling Copilot:
“Our monthly reports use these headings, currency is always displayed with two decimal places, and these columns need to follow a specific format.”
Then imagine not having to explain those preferences every time.
That’s the idea behind Microsoft’s improvements. It’s not the kind of AI feature that makes headlines.
But for employees who spend hours preparing reports, it could be surprisingly valuable.
The best productivity improvements often eliminate work nobody enjoys doing.
The Bigger Problem Isn’t Excel. It’s Consistency.
Here’s another familiar situation.
Three employees prepare reports for the same business.
One uses different column headings. Another organizes information differently. The third has their own preferred formulas and formatting.
All three reports might be correct.
But now someone has to make them consistent before management can compare the information.
That’s where another improvement comes in.
Microsoft is introducing workbook-specific instructions that can accompany a spreadsheet when it’s shared with colleagues.
These rules help Copilot understand how that particular workbook should be handled, potentially making results more consistent across employees.
Think of it as giving Excel a little more understanding of how your company works, not simply what numbers are in the cells.
AI Should Learn Your Process, Not Create Another One
This is where AI starts becoming interesting for business owners.
Most conversations about AI focus on how quickly it can generate something.
- Write an email.
- Summarize a meeting.
- Analyze a document.
- Create a report.
But generating something quickly isn’t always the same as finishing the job.
If an employee spends five minutes generating a report and another 30 minutes fixing the formatting, checking the structure, and making it match company standards, how much time did AI really save?
The real opportunity is reducing the work that happens after AI produces an answer.
By remembering preferences and following workbook instructions, Copilot could help reduce some of that cleanup.
And that’s a much more useful business outcome than simply creating another impressive demonstration.
Don’t Let AI Become Your Accountant
There’s one important catch.
Just because AI understands how you want a spreadsheet formatted doesn’t mean you should automatically trust everything it produces.
Excel often contains information businesses depend on to make decisions.
- Revenue.
- Expenses.
- Budgets.
- Forecasts.
- Customer information.
- Financial reports.
A beautifully formatted spreadsheet with an incorrect formula is still an incorrect spreadsheet.
Let AI help prepare the report. Don’t let it become the person responsible for the numbers.
The Best AI Features May Be the Ones Nobody Notices
Business owners don’t necessarily need AI to do something revolutionary.
Sometimes you just want the monthly report finished without three rounds of corrections.
You want employees using the same format.
You want less time spent fixing spreadsheets.
And you want managers spending more time understanding the numbers instead of reorganizing them.
That’s what makes these Copilot improvements worth watching.
At ONE2ONE Tech Solutions, we help New Jersey businesses get more value from Microsoft 365, improve productivity, and adopt AI with appropriate security and oversight.
Because the goal isn’t to have AI do more impressive things.
It’s to help your employees spend less time on the little things that shouldn’t take so long.
