微软将Excel Copilot升级为金融工作流系统

Microsoft just turned Copilot in Excel into a finance workflow system

So it can follow team-defined methods, pull institutional data, and leave an audit trail for every workbook edit.

The new connectors bring finance data from FactSet, Morningstar, PitchBook, CB Insights, Daloopa, and S&P/Kensho into Excel, which means analysts can start from licensed market, private-company, filing, research, transcript, and fundamentals data instead of copying numbers by hand.

For Finance work its so important for AI to show the source, the formula path, or the exact cells it changed, because closing books, updating forecasts, and building valuation models depend on traceable numbers.

Microsoft’s answer is skills, where a team writes a SKILL.md file that tells Copilot how to run repeatable jobs like DCF models, 3-statement models, board packages, variance analysis, and monthly reporting.

Personalization and workbook rules make Copilot follow preferred formatting, naming, structure, and formula conventions, so the AI behaves less like a generic assistant and more like a junior analyst trained on the team’s house style.

Plan with Copilot forces the model to state which ranges, sheets, formulas, and assumptions it wants to touch before it edits, while Show Changes now labels Copilot’s edits beside human edits.