From Campus to Spreadsheet: The Microsoft Excel Collegiate Challenge Journey
Financial Modeler's Corner
Excel's New Features: Lambdas and Dynamic Arrays
This chapter discusses the new features in Excel, such as lambdas and dynamic arrays, and how they can be used in financial modeling. It highlights the benefits of using a single function called depreciate to generate depreciation schedules and mentions the ease of entering formulas correctly using lambdas.
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 accreditation in Financial Modeling globally.
In this episode, we have a special treat for you with multiple guests who attended the Microsoft Excel Collegiate Challenge (MECC). At the beginning of November, Paul had the opportunity to spend a day at the University of Arizona campus and watch these students compete and talk to commentators, spectators, competitors, and faculty, and we have brought you a few of those interviews.
Listen to this episode as:
- Excel MVPs, Oz Du Soleil and Jon Acampora share why they attended the show, what they love about the competition, and the magic of Power Query
- The host of this competition, Prof David Brown talks about MECC.
- The winner, Patrick Chatain and 3rd-place finisher Benjamin Weber share their experiences.
- Missy and Teresa from Salve Regina University, talk about why they started with Excel as they were building out a data analytics business program.
- Craig Hatmaker shares everything about LAMBDA's and 5G modeling components.
Quotes:
“[How does MECC benefit students in the real world] Sometimes we get sponsors to actually write cases that are based on what they do . S o it gives them real-world experience of what they would be doing, which is invaluable w hen you're interviewing for a job . ....... ” - Professor David Brown
“ [Do you feel like you're better in Excel today for having competed] When I started competing, I didn't even know what Lambda, let alone dynamic arrays and all of that was. Now I know most of them and I think those are pretty good functions with pretty good use cases. So I think that made me a much better user in Excel. ” - 3rd Place Finisher Benjamin Weber
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.
Follow Oz du Soleil :
YouTube - https://www.linkedin.com/in/ozdata/
LinkedIn - https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ
Follow Jon Acampora :
Website - https://www.excelcampus.com/
LinkedIn - https://www.linkedin.com/in/jonacampora
Follow David Brown:
LinkedIn - https://www.linkedin.com/in/dr-david-c-brown/?trk=public_post_feed-actor-name
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 Paul:
Website - https://www.thefpandaguy.com/
LinkedIn - https://www.linkedin.com/in/thefpandaguy/
TikTok - https://www.tiktok.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
Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984
In today’s episode:
(00:43) Intro;
(01:44) Interview with Oz Du Soleil and Jo n A campora ;
(19:51) Everything about MECC with David Brown;
(25:43 - 26:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);
(27:30) Interview with Benjamin Weber ;
(36:34) Interview with Patrick Chat ain ;
(41:28) Interview with Missy and Teresa ;
(48:38) Interview with Craig Hatmaker;
(54:00) Outro.
Remember Everything You Learn from Podcasts
