Background
The Future of Finance Lab brought together finance professionals and Excel enthusiasts for a deep dive into the evolving landscape of modern Excel, AI-powered tools, and the essential skills needed to thrive in a rapidly changing environment.
Hosted by Lance Rubin and featuring Microsoft MVP Danielle Stein Fairhurst, the session explored advanced Excel functions, the integration of AI, practical modeling strategies, and the importance of maintaining best practices in an era of automation. This session not only showcased technical demonstrations but also offered candid reflections on the challenges and opportunities facing today’s finance teams.
Fortnightly Nugget
Avoid “prompt decay” when working with AI tools—if your prompts start looping or producing errors, stop, reset, and start a new chat. In Excel, this is akin to breaking a circular reference: sometimes, the best way forward is a fresh approach.
Key Insights and Frameworks
The HACK Framework and Six Pillars
Lance Rubin opened by revisiting the “HACK” framework—Hygiene, Automation, Capability, and Knowledge—as a foundation for building robust Excel environments. The session emphasized the importance of getting your Excel “hygienic” before automating, and continually building knowledge to leverage new tools and technologies.
The Six Pillars of Excel fluency, process, and data—covered in previous sessions—were referenced as ongoing themes, with a focus on how AI is now woven into these pillars.
Modern Excel: Power Query, Dynamic Arrays, and Lambdas
The heart of the session centered on modern Excel features:
- Power Query: Both hosts reminisced about its evolution from an add-in to a core Excel feature, highlighting its role in data cleaning, transformation (ETL), and integration with Power BI.
- Dynamic Arrays and XLOOKUP: These functions, now mainstream in Excel 365, were praised for their ability to simplify and automate complex modeling tasks. Danielle’s top picks included SEQUENCE (for timelines), FILTER, SORT, and RANDARRAY (for Monte Carlo simulations).
- LAMBDAs: Custom logic creation with LAMBDAs was showcased as a game-changer for advanced users, enabling reusable, modular formulas.
AI in Excel: Promise and Pitfalls
The integration of AI—especially Copilot and agent mode—was discussed with both excitement and caution. Danielle noted, “People are starting to feel they don’t need to learn Excel anymore… but AI can produce overly complex formulas that lack best practice.” The consensus: AI is a powerful assistant, but human expertise remains essential for quality and clarity.
Practical Takeaways and Actionable Strategies
- Master the Basics: Understanding dynamic arrays and modern Excel functions is now non-negotiable. AI-generated solutions will increasingly use these features, so fluency is critical.
- Use Helper Columns and Rows: Danielle demonstrated practical techniques, such as using SEQUENCE and helper columns to make models fully dynamic and responsive.
- Error Checking and Validation: Always include dashboards, validation checks, and avoid hardcoding. Lance shared his standard AI prompt structure: “Always create a dashboard, always create validation and checks, and don’t leave me with Excel errors.”
- AI Prompt Engineering: Train AI tools (like TabAI) to remember your preferences—e.g., “never hardcode, always show workings”—to reduce the risk of hallucinations or poor practices.
- Balance Complexity and Clarity: Both hosts stressed the need to balance advanced functionality with model simplicity, tailored to the client’s readiness and understanding.
Notable Examples and Case Studies
- Solomon Islands Training: Danielle recounted adapting her training for Excel 2016 users, underscoring the importance of knowing your audience and being flexible with technology.
- Dynamic Cash Flow Modeling: Real-world demonstrations included dynamic cash flow models using helper rows, and debt schedules that automatically adjust based on user input.
- LAMBDA Libraries: The session highlighted pre-built Lambda functions (e.g., “corkscrew” for circular references), available from experts like Craig Hatmaker, and encouraged attendees to explore these resources for advanced modeling needs.
Important Quotes from the Session
- “What we’ve got to think about when working with AI… is that it does make mistakes, it does hallucinate, and working with these tools and working with modern formulas and functions and capabilities of Excel is becoming even more important.” — Lance Rubin
- “People are starting to feel they don’t need to learn Excel anymore… but AI can produce overly complex formulas that lack best practice. Our skill as modelers is deciding how complex or simple to make things.” — Danielle Stein Fairhurst
- “If you don’t understand some of these dynamic arrays and these formulas, using AI is not going to help you. It’s actually going to make you more confused.” — Lance Rubin
- “Always include a dashboard and charts for any tasks you’re working on. Always check your workbook for errors. Always include error and validation checks.” — Lance Rubin
Conclusion: The Future of Finance Lab—A Journey of Learning and Adaptation
This session encapsulated the core message of the entire Future of Finance Lab series: while technology and AI are transforming the finance function, the human element—curiosity, adaptability, and best practice—remains irreplaceable. The series has equipped participants with frameworks, tools, and mindsets to navigate ongoing change, emphasizing that continuous learning and critical thinking are the keys to success.
Call to Action
Ready to future-proof your finance skills?
Explore the full Future of Finance Lab series for in-depth sessions, practical resources, and expert insights. Whether you’re a seasoned modeler or just starting out, there’s always more to learn—and the journey is just beginning.
Check out the recordings, download the workbooks, and join the conversation as the world of finance continues to evolvecussions, and resource sharing, this ongoing and free series remains a must-attend for anyone looking to future-proof their finance skills.
Looking Ahead
The Future of Finance Lab is more than a webinar—it’s an interactive community dedicated to learning, sharing, and growing together. We invite you to join our next session, connect with peers, and continue building the skills that will define the future of finance.
For resources, recordings, and more, visit our Knowledge Hub and stay tuned for further updates!
You can find more content on Eloquens, including the FREE slides, PDF exports of Excel workbooks and premium content, including all AI-built models and the human-built solution and a comparison file can be found here.
The session was also recorded and is available to be viewed on YouTube.
Want to discuss how AI can transform your finance function? Get in touch with Model Citizn to learn more about our approach to AI-powered financial modelling and strategic implementation.
Want to take action? You can by clicking here
We just launched our AI-Powered series of FREE fortnightly sessions to unpack all the hype and give solid foundations to finance professionals. Join our Friday Future of Finance Lab by registering here.
Friday’s Future of Finance Lab
AI-Powered Accountant
Join our fortnightly community where finance professionals share insights, solve real challenges, and stay ahead of the AI revolution (max 50 attendees).
Key Benefits:
✅ Live Problem Solving – Bring work challenges
✅ Expert Insights – Practitioners not trainers
✅ AI Integration – Leverage AI in finance
✅ Networking – like-minded professionals
✅ Zero Cost – Completely free, always
What You’ll Get:
✅ – Fortnightly Focus Areas in the following areas
✅ – Financial Modeling Deep Dives
✅ – Data Analysis & Power BI Techniques
✅ – AI Applications in Finance
✅ – Open Forum & Case Studies Exclusive Resources
✅ – Meeting recordings and AI-generated summaries
✅ – Templates and tools shared during sessions
✅ – Resource library access
Who Should Attend:
✅ – Finance professionals wanting to upskill
✅ – Data analysts working with financial data
✅ – Anyone curious about AI in finance
✅ – Business leaders seeking data-driven insights
Buckle up and look forward to seeing you there!
AI Accounting Finance #CFO #FinancialModeling #AIAdoption #FutureOfWork