
Co-Founder at Career Principles | Microsoft MVP
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.
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.
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.
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.
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.
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.
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.
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