Are LAMBDAs & Dynamic Arrays the future of Financial Modeling? A lively discussion with 4 modeling experts.
Financial Modeler's Corner
The Frustrations and Benefits of Dynamic Arrays in Financial Modeling
The chapter discusses the frustrations and benefits of using dynamic arrays in financial modeling. The speakers talk about the challenges of certain functions and share their experiences with different functions like sequence, let, unique, and others. They highlight the ability to build more complex logic and the potential for formula troubleshooting.
Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI), the most respected accreditations in Financial Modeling globally.
In this episode, your host, Paul Barnhurst is joined by 4 fabulous guests, namely, Jeff Robson, Danielle Stein Fairhurst, Craig Hatmaker & Ian Schnoor. They are all highly accomplished and respected modelers in the Financial Modeling profession. In this episode they share thoughts on Dynamic Arrays and LAMBDAs.
Jeff is a Financial Modeler, Business Analyst, International Trainer & Presenter. Danielle is a Financial Modeler, Author, and Corporate Trainer based in Australia. Craig is a retired Financial Modeler and is a 5G (fifth generation) modeling enthusiast, and Ian is the Executive Director at the Financial Modeling Institute (FMI), which is also the sponsor of this Podcast.
Listen to this episode as the guests talk about:
- Why it is important to keep current on the latest developments in modeling
- LAMBDAs what they are and how they could revolutionize financial modeling
- Dynamic Arrays, what they are, how they work, and what it is like to build a model using Dynamic Arrays
- How Dynamic Arrays will make auditing models easier
- The guest's favorite Dynamic Array formulas
Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.
Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.
Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit with this episode.
Follow Jeff Robson:
Linkedin: https://www.linkedin.com/in/jeffrobson/
Website: www.accessanalytic.com.au
YouTube: https://www.youtube.com/@AccessAnalytic
Follow Danielle Stein Fairhurst:
Linkedin: https://www.linkedin.com/in/daniellesteinfairhurst/
Website: https://plumsolutions.com.au/
Upcoming Events for Danielle Stein Fairhurst
Danielle is speaking at the global excel summit - Global Excel Summit 2024 | Microsoft Excel Event | Welcome
Upcoming webinar on Scalable models - https://www.linkedin.com/events/scalablemodelling-usingmsfabric7106464501708840960/
Follow Craig Hatmaker:
Linkedin: https://www.linkedin.com/in/craig-hatmaker-4449879/
Website: https://sites.google.com/site/beyondexcel/home
YouTube: https://www.youtube.com/@CraigHatmakerBXL
Building with Fast + 5G- https://www.youtube.com/watch?v=8Zl3yURsvdE&t=1s
Demo using 5G Components-
Intro 5G - Watch an Excel Model do something incredible using 5G methods - YouTube
Gist site to download Craig Hatmakers LAMBDAs for 5G modeling- https://gist.github.com/CHatmaker
Follow Ian Schnoor:
Linkedin: https://www.linkedin.com/in/ianschnoor/
Website: https://fminstitute.com/
Follow Paul:
Website - https://www.thefpandaguy.com/
LinkedIn - https://www.linkedin.com/in/thefpandaguy/
Instagram - https://www.instagram.com/thefpandaguy/
TikTok - https://www.tiktok.com/@thefpandaguy
Twitter - https://twitter.com/TheFPandAGuy
YouTube - https://www.youtube.com/@thefpaguy8376
Follow Financial Modeler's Corner
LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true
Subscribe to our Newsletter- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984
Quotes:
“Python brings a suite of libraries that can do some amazing things.”
“You don’t have to learn Python, Dynamic Arrays, or LAMBDAs for Financial Modeling, but you need to know it exists to stay relevant.”
“ Dynamic arrays force you to have consistent formulas. ”
“ LAMBDAs are functions that write functions using native excel functions. ”
“Learn the basics and start experimenting.”
In today’s episode:
(00:22) Intro;
(00:39) Introduction of Guests;
(03:30) Take on Python into Excel ;
(06:49) Addressing Security Issues ;
(07:32) What are Dynamic Arrays ;
(09:58) Use case of Dynamic Arrays;
(11:45) What is LAMBDA;
(18:20) FMI exams and Dynamic Arrays;
(21:57) LAMBDAs for 5G modeling ;
(24:13) How to use 5G modeling;
(26:29 - 27:15) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);
(28:59) Auditing Dynamic Array Models;
(33:30) Favorite spillable functions;
(36:58) The potential of a standard to use LAMBDAs and Dynamic Arrays;
(39:45) AI building Models;
(44:20) Advice for the audience;
(46:59) Advice on LAMBDAs;
(49:15) Advice for Modelers;
(51:42) Connect with Jeff, Danielle, Craig & Ian
(52:57) Outro
Remember Everything You Learn from Podcasts
