Pro User
Timespan
explore our new search
​
ChatGPT: Best AI Tools for Finance
All about AI
Mar 16, 2026 8:00 PM

ChatGPT: Best AI Tools for Finance

by HubSite 365 about Kenji Farré (Kenji Explains) [MVP]

Co-Founder at Career Principles | Microsoft MVP

Microsoft guide to AI finance tools — Excel Copilot, Power BI and PowerPoint for research cleaning modeling and decks

Key insights

  • AI Research Tools
    Use tools like Fintool and AlphaSense to scan filings, transcripts, and news quickly. They surface relevant passages and speed up due diligence.
  • Data Import & Cleaning
    Tools such as Quadratic automate importing, deduping, and normalizing data so analysts spend less time on manual cleaning.
  • Excel Analysis Tools
    Use Copilot for quick formula work and Claude in Excel or Tracklight for multi-step models and complex workflows as add-ins inside spreadsheets.
  • Financial Modeling Example
    The video shows building a loan amortization table with an AI assistant to generate schedules, run scenarios, and validate calculations.
  • Presentation Tools
    Generate slide decks and refine visuals with AI in PowerPoint or dedicated tools like Bricks and Gamma to speed up investor-ready pitches.
  • End-to-End Workflow
    Combine research, cleaning, modeling, and presentation tools across the lifecycle; choose lightweight AI for quick edits and stronger models for complex tasks to save hours.

Video Summary and Context

In a recent YouTube video, Kenji Farré (Kenji Explains) [MVP] walks viewers through more than 100 AI tools and highlights those most useful for finance professionals in 2026. He frames the discussion around the typical workflow of a financial analyst, from research and data cleaning to modeling and presentation. Consequently, the video aims to show how different tools can be combined to speed up tasks while preserving analytical rigor.
Moreover, Kenji uses short demos and a clear chapter structure to guide viewers, which makes it easier to compare options and see tradeoffs in action. The chapters cover AI research tools, data import and cleaning, modeling and analysis, and presentation tools.


Research Tools: Finding and Verifying Information

Kenji highlights AI research platforms that can scan filings and news to surface relevant company information quickly. For instance, he points to Fintool and AlphaSense as services that help analysts find documents and extract key sentences, which reduces time spent on manual searches. However, he cautions that AI search can sometimes prioritize novelty over relevance, so analysts must verify outputs against primary sources.
Therefore, the tradeoff here is speed versus accuracy: AI speeds discovery but can introduce noise or miss context. As a result, human review and good sourcing remain essential parts of due diligence.


Data Import and Cleaning: Preparing Reliable Inputs

The video then turns to tools that import and clean financial data, where Kenji highlights Quadratic for automating normalization and transformation tasks. He shows how these tools can handle messy tables and inconsistent formats, which often consume many hours in real workflows. Nonetheless, he notes that automation can hide assumptions, so analysts should document transformations and spot-check results regularly.
In addition, Kenji points out integration challenges, such as compatibility with internal databases and version control, which force teams to balance convenience against traceability. Consequently, teams must weigh the productivity gains against the need for transparent data lineage.


Modeling and Analysis: Balancing Automation with Control

For data analysis and financial modeling, Kenji demonstrates both simple and advanced approaches inside Excel. He praises the COPILOT function for quick, small tasks and suggests Claude in Excel for larger, multi-step processes like building a loan amortization table. At the same time, he shows alternatives such as Tracklight, an add-in designed specifically for financial modeling, that offers structured workflows tailored to analysts.
Yet the video emphasizes tradeoffs: general-purpose LLM helpers can accelerate work but may hallucinate or misapply formulas, while domain-specific add-ins offer safer guardrails but sometimes limit flexibility. Thus, the best approach often combines automated assistance with strong review practices and versioned models.


Presentations and Storytelling: From Models to Decks

In the final workflow stage, Kenji covers tools for turning analysis into presentations, demonstrating Claude in PowerPoint alongside newer tools like Bricks and Gamma. He shows how AI can generate slide outlines and visuals rapidly, which helps translate complex financial arguments into a story. However, he warns that automated decks can flatten nuance, so analysts must shape narratives and verify figures before sharing externally.
Thus, the tradeoff is between speed and persuasive clarity: AI helps draft and prototype, but human judgment refines tone and ensures accuracy. Ultimately, effective presentation relies on both automated drafting and careful editorial control.


Tradeoffs, Risks, and Practical Recommendations

Throughout the video, Kenji repeatedly returns to a few core tensions: speed versus accuracy, convenience versus traceability, and single-tool simplicity versus multi-tool specialization. He recommends mixing tools based on task complexity and regulatory needs, and he urges teams to prioritize explainability and audit trails. For example, smaller ad hoc analyses can lean on conversational assistants, while formal models should use controlled add-ins with clear logs.
Furthermore, Kenji highlights challenges such as data privacy, licensing costs, and integration overhead, which can erode gains if not managed. Therefore, organizations should pilot tools, set guardrails, and invest in training so analysts can extract benefits without sacrificing compliance or quality.


Takeaway for Financial Analysts

Kenji Farré’s video provides a pragmatic tour of AI options for finance and frames each tool in the context of a real analyst workflow. He balances enthusiasm for productivity enhancements with caution about limitations, and he consistently recommends human oversight and clear documentation. As a result, the piece is useful for teams thinking about where to automate and where to retain manual controls.
In short, the right mix of research platforms, data-cleaning automation, modeling add-ins, and presentation assistants can materially speed up work, but firms must weigh costs, governance, and auditability before wide adoption. The video serves as a starting point for informed experimentation rather than a one-size-fits-all prescription.


All about AI - ChatGPT: Best AI Tools for Finance

Keywords

best AI tools for finance, AI tools for financial analysis, AI for personal finance, AI tools for investment research, AI-driven financial forecasting, AI accounting and bookkeeping tools, best AI tools for wealth management, AI-powered finance automation