Copilot in Excel gets reusable skills, finance connectors, and better change tracking

Microsoft is expanding the capabilities of Copilot within Excel with three distinct additions aimed at both productivity and financial analysis. The update introduces reusable workflow skills, direct access to institutional financial data, and a more robust system for tracking changes made by AI.

#1 Reusable workflow skills

The first major addition is the ability to save and reuse Copilot workflows as ‘skills.’ Previously, you had to describe your desired outcome from scratch every time you wanted to perform a complex task. Now, if you create a specific workflow—such as formatting a report or analyzing a dataset—you can save it.

Once saved, these skills become available for future use. You can apply them to new data sets without re-prompting the AI, streamlining repetitive tasks and ensuring consistency across multiple spreadsheets.

#2 Institutional financial data connectors

For users who rely on Excel for financial modeling or market analysis, Microsoft is introducing new data connectors. These connectors allow Copilot to pull in institutional-grade financial data directly into your spreadsheets.

This means you can ask Copilot to analyze stock trends, retrieve historical pricing data, or compare financial metrics without manually copying and pasting information from external sources. The integration aims to bridge the gap between general spreadsheet usage and professional financial analysis tools.

#3 Improved change tracking

Finally, Microsoft is addressing a common pain point with AI-assisted editing: visibility. The update includes improved change tracking specifically for actions taken by Copilot.

You will now have better insight into what the AI changed within your workbook and when those changes occurred. This feature is particularly useful for collaborative environments or when auditing complex financial models, allowing you to distinguish between manual edits and AI-generated modifications with greater clarity.

What this means for you

If you use Excel for regular reporting, the reusable skills feature will save you significant time by eliminating repetitive prompting. For finance professionals, the new data connectors reduce the friction of gathering market data. Meanwhile, the enhanced change tracking provides a necessary layer of accountability and transparency when working with AI-generated content.

Source: Neowin

Source: Neowin

Over to you: Which of these updates—reusable skills or finance connectors—will you find most useful for your daily spreadsheet tasks?

You may also like

Zed Editor 1.7.2 update adds MiniMax M3 and OpenCode model improvements
Zed Editor 1.7.2 update adds MiniMax M3 and OpenCode model improvements