Copilot for Finance, and What Your License Includes
Most people do not choose Microsoft Copilot. It arrives, because the company already pays for Microsoft 365 and somebody in IT switched it on, and then the question becomes what you can do with it.
That is the honest framing for this whole page. With Claude or ChatGPT you pick a tool and learn it. With Copilot you find out what your license includes and work from there.
So this starts with the license, because that is where everyone gets stuck, and then covers each surface in the order you are likely to reach for it.
Start here, because the license decides everything else
Microsoft 365 Copilot is a paid add-on. It is not included in a standard Microsoft 365 Business or Enterprise subscription, and this is the single most common reason someone reads a Copilot walkthrough, opens Excel, and finds the button missing.
There are also several products with Copilot in the name that are not the same thing. Copilot in Windows, Copilot Pro for individuals, Microsoft 365 Copilot for organizations, and Copilot Studio for building agents. They have different entitlements and different capabilities.
Before you spend an evening on any guide here, find out which one you have. the license section on Copilot for Excel covers how to check, and it is the fastest way to avoid wasting a weekend.
One thing worth knowing if you are the person making the case internally. Because it is an add-on, somebody has to approve it, which means you need a number rather than an opinion. Every walkthrough below is written on real finance work for that reason.
Excel, which is where finance meets it first
This is the surface that matters most to this audience and the one that changed most in the last year.
Two things worth knowing before you start. Agent Mode has a model picker, and it offers GPT-5.2 and Claude Opus 4.5, which means Copilot in Excel can be running the same Anthropic model as the Claude add-in. The comparison is no longer Claude’s model against Microsoft’s.
And the =COPILOT worksheet function ends on 14 September 2026. It shipped in August 2025, never reached general availability, and ends while still in preview. If you built formulas on it, those workbooks stop working that morning. Microsoft’s stated reason is that the function was non-deterministic, meaning the same formula with the same arguments could return different answers over time, which in a spreadsheet is disqualifying. The side pane is where that capability lives now.
- Copilot for Excel, revisited two years after I panned it. What changed, the license you need, and what still trips it up.
- Copilot finance skills, the ones Microsoft shipped into Excel in June 2026 and buried behind a settings button. What is in the box, and the two I wrote to fill the gap.
- Claude for Excel versus Copilot, the head to head after the model picker changed the premise. The difference that survives is behavioral: Claude explains before acting, Copilot acts then explains.
- ChatGPT versus Claude versus Copilot, all three run through a forecast build, scenario analysis and a CFO memo on the same data.
The prompts, on real finance work
The AI library for finance teams
The Copilot prompts I use in Excel and Outlook, the agent scoping template that keeps you under the query ceiling, and the license checklist. Free, and it lands in your inbox in about a minute.
Agents, and the ceiling the demo leaves out
Copilot agents are the part Microsoft is pushing hardest and the part with the most specific limit. There is a 25-query ceiling per agent conversation, and on a real month-end that number arrives faster than you expect.
It is not a reason to skip them. It is a reason to scope each agent narrowly rather than building one that is supposed to do the whole close.
- Copilot agents for finance, with Analyst and Researcher run against a real GL and POS file, the prompts, the output, and what your admin can and cannot see.
- How to build a Copilot Studio agent, building your own end to end. Answering from your numbers, then taking an action in SharePoint, then running on a schedule with an approval step in front of it.
- Microsoft Copilot Cowork, the newer surface, set up for finance work and taught a month-end.
The approval step in that middle one is the pattern worth stealing whatever tool you use. An agent that can act needs something between it and the general ledger.
The everyday version, for people who are not building agents
Most Copilot use in a finance team is not agents. It is someone trying to get a decent answer out of the side pane in Excel, Outlook or PowerPoint, and getting a shrug back because the prompt was too vague.
Microsoft Copilot tips for finance teams covers the prompts that hold up on finance work, the workflow patterns, and the governance questions that turn up the moment more than one person is using it.
If your problem is moving data between systems on a schedule rather than getting an answer, that is a different Microsoft tool. Power Automate for finance is the low-code route, and it is deterministic in a way Copilot is not, which for anything recurring is the point.
Where Copilot wins, and where it does not
| The situation | The honest answer |
|---|---|
| The data cannot leave the Microsoft tenancy | Copilot, and it is not close. This is the strongest argument for it and it decides a lot of enterprise deployments on its own. |
| Your company already pays for Microsoft 365 Copilot | Copilot, because the alternative is a second procurement conversation for a marginal gain. |
| You want the model to explain its reasoning before it changes the sheet | Claude for Excel. The behavioral difference is real and it comes from product design rather than model choice. |
| You need external market or credit data pulled into the model | ChatGPT for Excel, which has the named data connectors. |
| The job runs every month and has to be auditable | Neither. Power Query or Power Automate. A transformation is deterministic and a prompt is not. |
The last row is the one people skip. Reaching for AI on a recurring, audited process is usually the wrong instinct, and the fact that Copilot is already installed makes it an easier wrong instinct to follow.
Where to start this week
If you have a license and have not used it seriously, do this in order.
- Check which Copilot you have. Ten minutes, and it stops you following a guide for a product you do not own.
- Open a month you have already closed and ask Copilot in Excel to find the three largest variances and explain them. You already know the answers, so you can grade it.
- If that goes well, build one narrow agent on one question rather than a broad one on your whole close. The 25-query ceiling rewards narrow.
- Check what your admin can see before you put anything sensitive in it. That question is easier to ask before deployment than after.
And if you are still deciding whether Copilot is the right tool at all, the AI tools for finance guide sets it against the alternatives on the same finance work rather than on a feature list.
