Microsoft Enhances Copilot in Excel for Financial Analysis and Modeling -- Redmondmag.com

Redmond Dispatch

Microsoft Enhances Copilot in Excel for Financial Analysis and Modeling

Microsoft has introduced new Microsoft 365 Copilot capabilities for Excel aimed at supporting financial professionals with data analysis, modeling and decision-making.

Some of the enhancements feature a new skills update allowing teams to define how Copilot applies formatting and structures based on how users already prefer, with personalization and workbook rule options. Expanded financial data connectors bring public and private market data into Copilot in Excel with connectors like CB Insights, Daloopa, PitchBook and more. Work IQ allows simplified prompts to unlock real scenarios for finance teams. Plan with Copilot outlines which ranges, worksheets, formulas and assumptions are intended for updating along with clarifying questions.

The updates are designed to help users perform complex financial tasks more efficiently by using natural language prompts to analyze datasets, identify trends and generate insights within Excel. The enhancements also assist with building formulas, creating reports and automating repetitive spreadsheet work. The updates aim to ensure that Copilot works more like a trusted analyst proposing a path forward and making every change transparent and reviewable.

Microsoft said the new features are intended to address the needs of finance teams working with increasingly large and complex datasets. By embedding AI directly into Excel, the company aims to reduce manual effort while helping users improve the speed and accuracy of financial analysis.

Posted by Redmondmag.com Editors on 06/29/2026

Featured

Microsoft Disrupts StegoAd Extension Campaign Affecting Up to 2.6 Million Users

Microsoft has disrupted a large malicious browser extension campaign that used hidden payloads, delayed execution and disposable developer accounts to evade detection while targeting users with ad fraud, credential theft and remote code execution capabilities.
Token Pricing May Force a Reality Check on Enterprise AI Costs

GitHub Copilot's shift to usage-based pricing could signal a broader move away from unlimited AI access as providers and customers confront the economics of large language models.
Microsoft, CrowdStrike Lead Forrester XDR Wave as Cloud and Identity Take Center Stage

Forrester’s latest extended detection and response platform evaluation puts Microsoft and CrowdStrike in the Leaders category, but the bigger story for cloud-focused security teams is how much the XDR market has changed.
Let Copilot Manage Your Outlook Calendar, Part 2

Copilot Calendar Instructions can help Outlook users automate meeting responses, but the feature depends on clearly defined rules rather than vague scheduling preferences.
Datacenter Backlash May Be About AI Trust

The rapid buildout of AI infrastructure is facing growing public resistance, but a new survey suggests the opposition may be rooted less in local datacenter projects than in broader distrust of artificial intelligence, Big Tech and who stands to benefit from the AI boom.