Introduction

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.

Follow Jeff Robson:

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 

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