Excel Toronto Meetup - LAMBDA Secrets from a World Champion - Michael Jarman

The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totaling more than 4,000. ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇 Register for free as a member of the group: https://www.meetup.com/MSExcelToronto Thank you to Sheetcast for sponsoring the MS Excel Toronto. Sheetcast allows you to build web applications with Excel. Small teams can use it for FREE. https://sheetcast.com ACCESS THE EXERCISE FILES shared by the presenter available to the group members in the discussions area on Meetup. The MS Excel Toronto Meetup group sessions are organized and run by Celia Alves - https://www.linkedin.com/in/celiajordaoalves/ Gráinne Dugan - https://www.linkedin.com/in/grainneduggan1/ Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscribenewsletter Learn how to automate your Excel reports – FREE Masterclass here: https://snapreportschamp.com/course About this session: Session Title: LAMBDA Secrets from a World Champion| Michael Jarman Session recorded live on January 29, 2025 SESSION DETAILS In this session, Michael Jarman will provide a preview of how he approached building LAMBDAs to win this year's Microsoft Excel World Championship and how these lessons have translated into his everyday working life. ABOUT THE SPEAKER Michael Jarman is the Head of Model Development at Operis (where he has worked since 2014), but is perhaps more well known for being the reigning Microsoft Excel World Champion. He has seen plenty of success in Excel previously, having won ModelOff in 2018 and having six other podium finishes. Find more about Lee's work and connect with her: LinkedIn: https://www.linkedin.com/in/michael-jarman-excel/ Timestamps: 00:00:00 Celia Alves MS Excel Toronto news and upcoming events 00:09:00 Celia Introduces Michael Jarman 00:10:35 Michael Jarman introduces himself and the presentation 00:14:20 Overview of LAMBDA Functions, their uses, and the importance of understanding when to use them. 00:17:00 Creating a Simple LAMBDA Function & other options, function to split text into individual characters using LET Function 00:25:30 Explanation of the LET function and its benefits in simplifying and organizing formulas, steps to convert a LET function into a LAMBDA function 00:35:55 Pros and Cons of LAMBDA Functions, advantages and potential drawbacks of using LAMBDA functions in Excel. 00:45:00 When to Use LAMBDA Functions, identifying repetitive tasks and deciding when to create LAMBDA functions. Edge Cases and Error Handling 00:52:45 Best Practices for LAMBDA Design, tips on designing LAMBDA functions to be intuitive, well-documented, and error-resistant 01:06:00 Q&A Session 01:29:00 Closing remarks and ticket draw, final thoughts