Finance

Screening deals, valuations, and portfolios

In Excel, AI can support comparable-company analysis, DCF modeling, acquisition target screening, portfolio monitoring, and earnings analysis by combining internal strategy context with external financial and market data.

Why the human is still essential here

Investment and corporate finance professionals still need to challenge assumptions, assess strategic fit and risk, and make the final recommendation or investment decision.

How people use this

Comparable company set builder

AI assembles a peer group, pulls trading multiples, and structures a comps table so bankers or corp dev teams can refine the final valuation set.

Microsoft Copilot in Excel / S&P Capital IQ

Acquisition target shortlist

Copilot screens private and public companies against sector, size, growth, and geography criteria to produce an initial list of potential targets for diligence.

Microsoft Copilot in Excel / PitchBook

Portfolio earnings monitor

Investment teams use AI in Excel to summarize earnings releases, estimate portfolio impact, and surface names that need immediate follow-up analysis.

Microsoft Copilot in Excel / FactSet

Need Help Implementing AI in Your Organization?

I help companies navigate AI adoption -- from strategy to production. Whether you are building your first LLM-powered feature or scaling an agentic system, I can help you get it right.

LLM Orchestration

Design and build LLM-powered products and agentic systems

AI Strategy

Go from idea to production with a clear implementation roadmap

Compliance & Safety

Build AI with human-in-the-loop in regulated environments

Related Prompts (2)

Latest community stories (1)

News
Blog

Copilot in Excel: Built for the era of Frontier Finance

Across Financial Planning and Analysis (FP&A), Accounting, Tax, Compliance, and Treasury, Microsoft Finance runs Copilot in Excel in real workflows, spending less time hunting for information and rebuilding analyses, and freeing teams to spend time applying judgement to decisions. They shape it as much as they use it, telling us where it falls short and pushing the product toward the standard their own work demands. By the time it reaches you, it has already been pressure-tested by a finance organization operating at the frontier. 

Today, we’re introducing new features built for financial professionals to continue doing that with skills for repeatable workflows, new financial connectors for trusted data, and improved capabilities for traceability.

BJ
Brian JonesVP – Excel Product Group
Jun 25, 2026