Copilot Skills in Excel: Automating Financial Report Charts (Hands-On)

On June 25, 2026, Microsoft announced something for Copilot in Excel that sounds, on first read, like every other Copilot announcement of the past three years: new AI capabilities for finance professionals. Press coverage dutifully repeated the headline features — reusable “Skills,” new financial data connectors, change tracking — and moved on.

That’s a mistake. Buried in this release is the first version of Copilot in Excel that could plausibly change how monthly financial report charts actually get made. Not because the AI got smarter, but because Microsoft finally addressed the reason finance teams stopped trusting Copilot with reporting in the first place: it never did the same thing twice.

This piece looks at what Microsoft announced, what the Skills feature actually does when you point it at a real reporting workbook, and where the gap between press release and product still sits.

What Microsoft announced — precisely

Strip away the launch language and the June 25 announcement contains three concrete things, all now rolling out to Microsoft 365 Copilot customers on Excel for the web, Windows, and Mac:

1. Skills: repeatable instruction sets for Copilot. A Skill is a defined procedure that tells Copilot how to complete a recurring finance task — Microsoft’s own examples are building a DCF model, closing the books, refreshing a monthly reporting model, and preparing variance analyses. Brian Jones, VP of Microsoft’s Excel Product Group, framed the value plainly in the launch post: instead of starting from scratch each time, a skill guides Copilot through the steps and applies consistent structure and formatting, so the output is easier to review, reuse, and trust.

Two implementation details matter more than the marketing. First, Microsoft shipped a library of sample finance Skills at launch, so there’s something to test on day one. Second, custom Skills are plain markdown files saved to OneDrive — an open format, human-readable, shareable across a team. That’s an unusually un-Microsoft design decision, and a good one.

2. More financial data connectors. The announcement added CB Insights, Daloopa, FactSet, Morningstar, PitchBook, and S&P Global to the LSEG and Moody’s connectors Microsoft released in May 2026 — eight named finance data sources that Copilot can now pull from directly. Microsoft is also opening Skill distribution to partners, naming LSEG, Ramp, Rogo, Samaya AI, Velixo, and Vena as an initial group, with distribution through Microsoft Marketplace and the Microsoft 365 Admin Center.

3. Traceability. Copilot’s changes to a workbook are now explicitly tracked and attributable. For anyone who has watched an AI silently rewrite a formula in a board pack, this is the least glamorous and most consequential item in the release.

The question the press release doesn’t answer

Here’s what most coverage skipped: why does any of this matter for charts?

The answer is in what a monthly reporting Skill actually has to do. A financial reporting model isn’t a table of numbers — it’s a table of numbers plus the visual layer built on top of it: the variance bridge, the actual-vs-budget columns, the trend lines the CFO actually looks at. Every previous version of Copilot treated that visual layer as an afterthought. Ask it to “update the monthly report” and you’d get refreshed data and, if you were lucky, a new chart that looked nothing like last month’s — different colors, different axis scaling, different series order. The output was technically correct and practically useless, because a board pack that changes its visual language every month is a board pack nobody trusts.

Skills attack exactly this problem. Because a Skill encodes the full procedure — which ranges feed which outputs, what structure the result takes, how it’s formatted — the same request produces the same shaped result each cycle. The monthly reporting refresh Skill isn’t interesting because it’s AI. It’s interesting because it’s repeatable AI, and repeatability is the entire game in financial reporting.

If you want the broader picture of what Copilot can and can’t do with charts outside the Skills framework, our complete guide to creating charts with Copilot in Excel maps the full (and confusingly named) feature set.

Hands-on: running the finance Skills against a reporting workbook

We tested the sample finance Skills library against a realistic mid-size company reporting workbook: twelve months of actuals, a budget sheet, and a standard management-pack layout with a variance bridge and KPI trend charts.

The variance analysis Skill is the standout for chart work. Pointed at actuals and budget ranges, it produced a variance table with consistent structure and generated supporting visuals in the format the Skill defines — and, critically, produced the same structure on a second run with updated data. That second run is the test that matters. One-off chart generation has been possible since 2024; identical-twice generation is new.

The monthly reporting refresh Skill is more ambitious and more uneven. On clean, Table-formatted source data it refreshed the model and regenerated charts competently. On messier real-world sheets — merged cells, subtotal rows mixed into data — it did what every Copilot feature does with messy data: it guessed. The guesses are now at least visible in the change tracking, which is genuine progress, but “visible mistakes” is a lower bar than “no mistakes.”

Custom Skills are where finance teams should focus. Because a Skill is just a markdown file, you can write one that encodes your reporting pack: your chart types, your color logic, your ordering. In testing, a custom Skill specifying “diverging bar variance chart, favorable variances in one consistent color, sorted by absolute impact” was followed reliably. That’s a sentence that would have been fantasy in the 2025 version of this product. It’s worth being clear about the boundary, though: the Skill controls structure and procedure. Pixel-level chart formatting still sometimes drifts, and anything the Skill doesn’t specify, Copilot improvises.

Writing your first custom Skill turned out to be less intimidating than expected, and it’s worth describing the shape of the exercise because Microsoft’s documentation buries it. The file is ordinary markdown: a name, a description of when the Skill applies, and then the procedure written the way you’d brief a competent junior analyst. Ours read, in essence: take the Actuals and Budget tables; compute variance and variance percent by line; build a diverging bar chart sorted by absolute variance, one consistent color for favorable and one for unfavorable; place it below the table; title it with the reporting month. Saved to OneDrive, it appeared in the Copilot pane and executed the procedure on request. The revealing part was iterating on the file itself — vague instructions (“format it nicely”) produced drift between runs, while concrete ones (“sort descending by absolute variance”) held. A Skill, it turns out, is only as repeatable as the person who wrote it was specific. That’s a familiar lesson to anyone who has ever written a procedure for another human, which is exactly what a Skill is.

Where Skills sit in the wider Copilot machinery

It’s worth separating Skills from the two other 2026-era pieces they get conflated with. Agent Mode — generally available since April 2026 and now the default Copilot experience — is the execution engine: it plans multi-step tasks and acts directly in the workbook. Skills are best understood as the procedure layer that can direct that execution for recurring work; Agent Mode without a Skill improvises the procedure fresh each time, which is precisely the inconsistency problem finance teams complained about. Python in Copilot, rolled into Edit with Copilot in the April 2026 update, is the analytical muscle underneath: for statistical work and chart types Excel lacks natively, Copilot writes and runs Python on a dedicated analysis sheet. A monthly reporting Skill can lean on that runtime without the analyst ever seeing a line of pandas.

For chart work specifically, the practical hierarchy is: Skills for anything you produce more than once, Agent Mode for one-off multi-part builds, plain prompting for single charts. For the underlying chart engine — including where Copilot uses Python to generate visuals Excel can’t natively draw — see our deep dive on Copilot’s Python chart generation.

Announced vs. reality: the scorecard

What holds up: Repeatability is real and it’s the headline improvement. Skills as open markdown files are a smart, portable design. The sample library means the feature is testable today rather than a demo reel. Change tracking makes Copilot’s edits auditable for the first time, which is the difference between a toy and a tool in finance.

What’s oversold: “Automating” financial reporting is still generous. Skills automate the mechanical assembly — the refresh, the restructure, the chart regeneration. Judgment doesn’t come with it. A Skill will happily produce a beautiful variance chart from data containing a misposted journal entry. Someone still has to know the numbers.

What’s unknowable yet: The partner Skill marketplace (LSEG, Vena, Velixo and others distributing Skills through the Microsoft 365 Admin Center) could become the actually transformative piece — vendor-maintained Skills for standard reporting frameworks would be worth real money to mid-market finance teams. As of July 2026 it’s an announcement, not a shelf you can shop from. Watch this space; we will.

Who benefits: Microsoft, obviously — Skills deepen the moat around the Microsoft 365 Copilot subscription at exactly the moment CFO-office software vendors like Workday are shipping competing AI planning features. But the second-order beneficiary is the mid-market finance team that could never justify a dedicated FP&A platform. If a $30/user Copilot license plus a folder of markdown Skills gets you 70% of a reporting automation tool, the buy-vs-build math in a lot of finance departments just changed.

What to actually do with this

If your team produces a recurring management pack in Excel, the practical move is narrow and specific: take your most repetitive chart-producing task — for most teams that’s the budget-vs-actual variance pack — and write one custom Skill for it. Our budget vs actual dashboard tutorial covers the underlying model design that makes a Skill’s job easy, and if you’re building the reporting layer from scratch, start with the KPI dashboard build guide — Skills work dramatically better on well-structured workbooks than on inherited spreadsheet archaeology.

Then run the Skill twice. If the second output matches the first, you’ve just automated the worst hour of your month-end. If it doesn’t, you’ve lost an afternoon and learned exactly where the product stands. Either result is worth having.

FAQ

What are Copilot Skills in Excel?

Skills are reusable instruction sets, announced by Microsoft on June 25, 2026, that define how Copilot in Excel completes a recurring task — such as refreshing a monthly reporting model or preparing a variance analysis — so the output is consistent every time. Microsoft provides a sample finance Skills library, and custom Skills can be written as markdown files saved in OneDrive.

Do I need a special license for finance Skills?

Skills ship as part of Copilot in Excel for Microsoft 365 Copilot customers, across Excel for the web, Windows, and Mac. There’s no separate finance SKU as of the June 2026 launch.

Can Copilot Skills create charts automatically?

Yes — within limits. Skills that produce reporting outputs (variance analysis, monthly report refreshes) generate the charts those outputs define, and the Skill’s structure keeps the charts consistent between runs. Fine-grained visual formatting can still drift, and chart types outside the Skill’s definition are improvised.

How do custom Skills work?

A custom Skill is an open-standard markdown file stored in OneDrive that describes the procedure Copilot should follow — steps, structure, formatting rules. Because it’s plain text, it can be versioned, reviewed, and shared across a team like any other file.

Is this the same thing as Agent Mode?

No. Agent Mode is Copilot’s autonomous multi-step execution capability, generally available since April 2026. Skills are the reusable procedures that can direct that execution for recurring finance tasks. They’re complementary — and confusingly named, which is very much on brand for this product line.

Sources: Microsoft Excel Product Group announcement, June 25, 2026 (Brian Jones, VP); Microsoft 365 Copilot connector announcements, May–June 2026. All hands-on observations from testing against Excel for Windows and Excel for the web, July 2026.

HomeInsertPage LayoutFormulas

=VLOOKUP(A2, E:F, 2, FALSE)

Employee ID	Name	Department	Salary
101	Alice	Engineering	$120,000
102	Bob	Marketing	$85,000
103	Charlie	Sales	$95,000