What Tools Are Analysts Using to Automate Modelling Workflows?

September 7, 2026 By Yodaplus

Analysts automating modelling workflows today combine four layers: Excel with AI features built directly into the spreadsheet, general-purpose AI assistants like Claude and ChatGPT for drafting and research, purpose-built research platforms for data retrieval, and dedicated AI FP&A platforms once a model outgrows what one analyst can manage manually. Gartner’s latest CFO survey found AI adoption across finance functions climbed from 37% in 2023 to 59% today, with nearly 60% of CFOs planning to increase AI spend by 10% or more in 2026.

That growth is real, but it is worth being precise about what it actually changed. Here is the tool landscape analysts are working with right now and where each layer fits.

Excel Remains the Base Layer, Now With AI Built In

Spreadsheets are still the dominant surface for financial modelling, and that is not expected to change soon. The reason is not inertia. Excel remains the most flexible analytical surface available, and the AI features added between 2024 and 2026 have made it meaningfully more productive rather than replacing it.

Microsoft 365 Copilot brings AI assistance directly into live Excel workbooks, handling formula generation, pattern recognition, and natural language data analysis. Enterprise pilots report financial modelling running 30 to 40% faster with Copilot active, one of the most consistently cited productivity gains across AI tool categories. Copilot operates within an organisation’s existing Microsoft tenancy, keeping data inside the firm’s own environment rather than sending it to an external model provider, which has made it the lowest-friction starting point for many teams.

General-Purpose LLMs as the Unofficial Junior Analyst

Alongside Excel, general-purpose AI assistants like Claude and ChatGPT function as an informal extra set of hands, used for drafting commentary, structuring a model’s logic, and stress-testing assumptions before they go into a live spreadsheet. Wall Street Prep’s June 2026 comparison tested Claude, ChatGPT, and Microsoft Copilot Agent Mode against real investment banking standards, building a fully integrated three-statement model, giving analysts a concrete sense of where each tool actually helps versus where it still falls short on production-grade work.

These tools work best positioned as a reasoning partner rather than a model-building engine on their own. Analysts use them to sanity-check an assumption, summarise a filing before building it into a model, or draft the first version of variance commentary that a human then edits and finalises.

Purpose-Built Research and Data Platforms

A separate category of tools focuses specifically on data retrieval and research rather than modelling itself. Equity analysts commonly rely on platforms like AlphaSense, Kensho, and Kavout to search earnings transcripts, filings, and broker research quickly, feeding cleaner, pre-processed information into whatever modeling tool comes next.

These platforms solve a different problem than Excel or a general-purpose LLM. Instead of building the model, they compress the time spent finding and validating the inputs a model needs, which is often the more time-consuming part of the workflow for research-heavy roles.

Where Python and Code-Based Tools Fit In

For quant-leaning analysts and work that needs to scale or run automatically, Python and R inside dedicated platforms increasingly complement Excel rather than replace it. Custom backtests, regression analysis, derivative pricing scripts, and large-dataset extraction jobs are handled through code-based environments, with AI-assisted coding tools helping generate and debug that code faster.

Most finance teams end up running all three surfaces at once: Excel for bespoke, one-off modelling; a recurring dashboard tool like Power BI or Tableau for standard reporting; and a programming environment for anything that needs to scale beyond manual spreadsheet work.

AI FP&A Platforms for Scaling Beyond One Analyst’s Model

Once a model outgrows what a single analyst can reasonably hold in their head, purpose-built AI FP&A platforms with audit trails and explainability become the relevant evaluation category, rather than continuing to stretch a spreadsheet or a chat-based assistant further than it was designed to go. These platforms typically manage the full model lifecycle, covering building, refining, maintaining, scaling, governing, and communicating results, with governance features that a general-purpose tool does not offer out of the box.

What Analysts Are Actually Doing Day to Day

Despite the tool landscape expanding quickly, most analysts have not fundamentally changed their daily workflow. Analysts still open Excel, reuse existing templates, and build models largely the way they always have, with AI tools layered in for specific, bounded tasks rather than replacing the core process. Banks in particular are piloting a growing number of AI tools, but security concerns and uneven reliability have kept many deployments in an experimental phase rather than full production use.

Common Challenges in Adopting These Tools

Integration friction with Excel-centric workflows: Analysts depend heavily on Excel, and tools that require moving data in and out of a separate browser interface too often create enough friction to slow real adoption.

Over-reliance without questioning outputs Some analysts accept AI-generated figures without adequately verifying assumptions, particularly when a tool’s output looks polished and confident regardless of underlying accuracy.

Governance and transparency requirements Regulatory expectations require clear explainability for any AI-assisted output feeding into a decision, which not every general-purpose tool is built to provide.

Skill gaps in supervising AI output Analysts need new competencies in data literacy, scenario validation, and model oversight to use these tools effectively, and many firms are still building out that training.

Best Practices for Choosing and Using These Tools

• Start with Excel-native AI features for teams already running Microsoft 365, since the integration friction is lowest
• Use general-purpose LLMs for drafting, structuring, and stress-testing rather than as a final source of model figures
• Add a dedicated research platform when data retrieval and filing search, not modelling itself, is the biggest time cost
• Bring in Python or code-based tools once work needs to scale, run automatically, or be reproduced across many names
• Evaluate AI FP&A platforms specifically once a model outgrows what one analyst can manage manually
• Prioritize audit trails and explainability when selecting any tool whose output feeds into a client-facing recommendation
• Train analysts explicitly on scenario validation and model oversight rather than assuming tool familiarity alone is sufficient
• Test any tool against your own document types and modeling standards before trusting it on production work
• Keep judgment-heavy steps, interpreting numbers and defending assumptions, with the analyst regardless of which tools are adopted
• Reassess the tool stack periodically, since capability and reliability are both shifting quickly across this category

Future Outlook

Adoption is accelerating faster than workflow change itself, and that gap is likely to narrow as tools mature and analysts learn where each one genuinely helps versus where it still requires close supervision. Expect continued growth in AI spend from finance leadership, alongside a slower, more deliberate shift in actual daily practice as governance, explainability, and reliability catch up with current enthusiasm.

Conclusion

Analysts automating modelling workflows today are not replacing their core process with a single AI tool. They are layering Excel-native AI, general-purpose assistants, research platforms, and code-based tools around a workflow that still runs through the spreadsheet, with judgement and final sign-off staying firmly with the analyst.

Yodaplus helps financial services firms build the governance layer that makes this tool stack trustworthy at scale. Our enterprise AI solutions combine multi-agent AI with intelligent document processing and secure enterprise integrations, giving analysts the audit trails and explainability that general-purpose tools often lack, within a governance-first AI architecture built for regulated financial workflows.

FAQs