November 22, 2026

Microsoft Advances AI for Finance with Specialized Copilot Skills and Enhanced Traceability in Excel

Controllable by Design

Perhaps the most critical requirement for finance professionals is the ability to audit and control the AI’s output. In a field where "black box" solutions are unacceptable, Microsoft has focused on making Copilot’s actions entirely transparent. A finance team must know not just the final number, but exactly how that number was derived.

To meet this need, Microsoft has introduced "Plan with Copilot." Before the AI takes any action in a spreadsheet, it can now outline its intended path. This includes specifying which cell ranges it will modify, which formulas it will write, and what assumptions it is making. This allows the user to review and course-correct the AI’s logic before any changes are committed.

Once changes are made, the traceability continues. Every edit made by the AI remains linked back to the affected cells. Furthermore, these edits are now explicitly attributed to Copilot in the "Show Changes" pane, appearing alongside the edits made by human collaborators. This level of attribution ensures that the AI functions as a "trusted analyst"—proposing a path, explaining its methodology, and leaving a clear, reviewable trail of its work.

This approach acknowledges that the role of the finance professional is changing. The job is shifting away from the manual construction of models and toward the review and refinement of models generated by AI. By providing these control mechanisms, Microsoft is ensuring that the human remains the final authority in the financial reporting process.

Availability and Rollout

The new suite of features is being rolled out progressively to Microsoft 365 Copilot customers. Currently, personalization, workbook rules, pre-built skills, and the federated Copilot connectors are generally available across Excel for the Web, Windows, and Mac. The "Plan with Copilot" feature and the attribution in the "Show Changes" pane are also now available to general users.

For those looking to build more bespoke solutions, custom skills are available today via the Insiders channel for Windows and Mac, with a full rollout to general availability expected next month. Looking further ahead, the integration of partner-built skills from the broader finance ecosystem is slated for the third quarter of 2026.

As these tools become more deeply integrated into the daily workflows of finance departments worldwide, the expectation is that the "Excel of the future" will be less about the manual entry of data and more about the orchestration of intelligent agents. By grounding these agents in the specific rigors of financial modeling and data integrity, Microsoft is attempting to ensure that the next wave of technology in finance is as transformative as the spreadsheet itself.