Copilot Excel finance: from smart helper to workflow system
Copilot Excel finance is the combination of Microsoft 365 Copilot and Excel features that automate repeatable financial workflows, connect trusted market data, and provide traceable, reviewable analysis for teams running planning, reporting, and valuation models.
The real story is not another AI feature; it is Excel turning into a workflow engine for finance teams. Microsoft has introduced new skills for repeatable workflows, new financial connectors for trusted data, and improved traceability, all baked directly into Copilot in Excel. These capabilities are now generally available to Microsoft 365 Copilot customers across Excel for Web, Windows, and Mac, with features like personalization, workbook rules, pre-built skills and federated Copilot connectors already live. In other words, the spreadsheet many teams fight with every month is becoming an environment where automated financial workflows can run consistently, and where Copilot works more like a trusted analyst than a one-off assistant, proposing a path forward and making every change transparent and reviewable.
Skills: automated financial workflows you can actually standardize
Skills are the most important shift in Copilot Excel finance: they turn messy, tribal spreadsheet know-how into explicit, automated financial workflows. Microsoft is introducing skills that let teams define how Copilot should complete common processes such as building a DCF, closing the books, refreshing a monthly reporting model, or preparing a variance analysis. Instead of starting from scratch each time, a skill guides Copilot through the steps, applies the right structure and formatting, and helps produce an output that is easier to review, reuse, and trust.
This matters because finance work is rarely a single prompt; it is a sequence of checks, transformations, and sanity tests. The new skills let teams define structured processes for tasks like DCF modeling, variance analysis, and monthly reporting, reducing repetitive setup and ensuring consistency and accuracy. In practical terms, that means you can standardize DCF modeling Excel workflows—think @comps-analysis that builds a DCF, comparable company analysis, and sensitivity model for a company—so mid-level analysts and new hires follow the same playbook as senior staff. It is an explicit bet that process knowledge belongs in the tool, not buried in one person’s brain or a stale PowerPoint.
Markdown skills: turning SKILL.md into reusable financial expertise
The clever, and slightly radical, part of Copilot’s skills model is how it is defined: as markdown. A library of sample finance skills is now available, and teams can build their own custom skills using an open-standard markdown file. Save a SKILL.md file in your OneDrive, and Copilot will pick it up to build a three-statement model or a board package using the process you define for it. Users can create custom skills via open-standard markdown files, which Copilot reads to automate tailored financial processes.
That design choice makes Copilot Excel finance more than a black-box AI. It lets finance leaders encode how they want a DCF, close, or monthly pack to be built, then scale that expertise across workbooks without relying on brittle macros or opaque add-ins. Microsoft’s personalization features let you set preferences once and have Copilot apply them consistently, while workbook rules capture structure, naming, and formula conventions as a sheet in the workbook that follows the file. Custom skills are available today via the Insiders channel for Windows and Mac, with rollout to general availability across Excel for Web, Windows, and Mac next month, and partner-built skills are expected in Q3 2026. The implication is clear: markdown becomes the new policy manual for finance workflows.
Excel data connectors: grounding Copilot in real markets
Any serious finance workflow lives or dies on data quality. Copilot in Excel now connects directly to the data financial professionals rely on, bringing market data, fundamentals, and research directly into the workbook so analysis starts from the latest sources instead of manual data pulls. In addition to the LSEG and Moody’s connectors released earlier, Microsoft is expanding options with more financial data connectors for bringing public and private market data into Copilot in Excel.
These Excel data connectors include CB Insights for predictive intelligence on private companies and markets, Daloopa for audit-ready fundamentals from filings and investor materials, FactSet for financial and alternative data used by investment professionals, Morningstar for investment research and portfolio analytics, PitchBook for private capital market intelligence, and S&P Global – Deterministic Retrieval for structured access to S&P Global data. New connectors integrate data from CB Insights, Daloopa, FactSet, Morningstar, PitchBook, and S&P Global, bringing relevant financial, market, and company data directly into Excel. That means automated financial workflows can run on trusted, cited data instead of copy-paste jobs from PDFs. It also explains why the bar is so high: when AI enters finance, it has to show its work, use trusted data, and trace every calculation.
Why this matters now—and how teams should respond
There is a pattern to how new technology reaches the world: from the PC to the relational database to the cloud, it reaches developers first, and finance is often next. Copilot Excel finance is Microsoft’s attempt to prove that its AI can meet the same bar Excel has met for decades. Features are evaluated across graded levels of task complexity and benchmarks that reflect the work finance teams do every day, and Microsoft’s collaboration with the Financial Modeling Institute brings real-world financial modeling cases into the evaluation process.
For ordinary users, the impact is concrete: instead of spending hours hunting for information and rebuilding analyses, teams can spend more time applying judgment. Skills ensure repeatable, consistent workflows; connectors keep data fresh and grounded; and traceability features mean Copilot’s changes are transparent and reviewable, so it behaves more like a trusted analyst than a mysterious bot. The features are now generally available to Microsoft 365 Copilot customers on Excel for Web, Windows, and Mac, with custom skills in the Insiders channel and broader rollout next month. Finance leaders who ignore this shift risk locking their teams into manual work while competitors encode their best processes into SKILL.md files and let Copilot run the routine, so humans can focus on argument, not formatting.
