Named Ranges and External Links Fixes for Finance Professionals to Build Accurate Models - Joel Steendam

Financial Modeler's Corner

Player FM - Internet Radio Done Right

추가했습니다 two 년 전

Paul Barnhurst AKA The FP&A Guy, Paul Barnhurst AKA The FP, and A Guy에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Paul Barnhurst AKA The FP&A Guy, Paul Barnhurst AKA The FP, and A Guy 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

Biscuits & Jam

1
The War and Treaty Are Getting Carried Away 46:55

1 day 전46:55

나중에 재생

리스트

46:55

The War and Treaty’s Michael and Tanya Trotter grew up in Cleveland, Ohio, and Washington, DC, respectively, but both have family roots in the South. They also grew up in the musical traditions of their churches – Tanya in the Black Baptist Church and Michael in the Seventh Day Adventist Church – where they learned the power of song to move people. After becoming a father at a very young age, Michael eventually joined the armed forces and served in Iraq and Germany, where he took up songwriting as a way of dealing with his experiences there. Meanwhile Tanya embarked on a singing and acting career after a breakthrough appearance in Sister Act 2 alongside Whoopi Goldberg and Lauryn Hill. Now, after a long and sometimes traumatic journey, Michael and Tanya are married, touring, winning all sorts of awards, and set to release their fifth album together, and their fourth as The War and Treaty. Sid talks to Michael and Tanya about the new record, Plus One , as well as their collaboration with Miranda Lambert, what it was like to record at FAME studios in Muscle Shoals, and how they’re blending country, soul, gospel, and R&B. Learn more about your ad choices. Visit podcastchoices.com/adchoices…

약 1년 전 51:02

MP3•에피소드 홈

In this episode, host Paul Barnhurst aka The FP&A Guy looks into Excel expertise with Joel Steendam. Joel shares his global experiences, technical know-how, and practical advice to improve Excel proficiency and financial modeling outcomes. Their conversation covers Excel tools, design principles, and the importance of curiosity and cultural awareness in professional success.

Joel Steendam is a global Excel expert and educator with a passion for helping professionals create better financial models. As a key member of PerfectXL, he develops software to improve spreadsheet quality, mitigate risks, and promote best practices in Excel. With a multicultural background and years of experience in financial modeling, Joel blends technical expertise with a deep understanding of how culture influences collaboration and problem-solving.

Expect to Learn:

Worst financial models and how to fix common spreadsheet issues.
Why named ranges and documentation are essential in financial modeling.
How Joel’s multicultural upbringing has shaped his professional approach and success.
Practical advice on staying curious and learning new Excel skills.
The role of tools like PerfectXL in auditing and improving spreadsheet quality for financial modeling.

Here are a few quotes from the episode:

"Even best practices, when misused, can have a massive negative impact on Excel models."
"PerfectXL’s tools focus on mitigating risks and improving model quality by emphasizing structure and consistency."
"If you build something on Monday that you don’t understand by Wednesday, you’re not building the right thing."

Joel Steendam shared his expertise on improving Excel models, staying curious, and navigating the challenges of financial modeling. Financial models are powerful decision-making tools, but they’re only as effective as their structure and design allow them to be. Joel provided invaluable lessons for both beginners and experienced modelers on structure, documentation, and tools.

Follow Joel:

LinkedIn - https://www.linkedin.com/in/joel-steendam/
Website - https://www.perfectxl.com/

Follow Paul:

Website - https://www.thefpandaguy.com  
LinkedIn - https://www.linkedin.com/in/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

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register. 

In today’s episode:

[01:49] - Introduction and Meet the Guest

[02:49] - Horror Stories in Financial Models

[04:28] - Key Takeaways from Bad Models

[06:45] - Joel’s Global Background

[10:18] - PerfectXL and Best Practices in Excel

[14:56] - Staying Updated on Excel

[18:03] - Advice for Beginners in Excel

[29:14] - Balancing Excel’s Flexibility and Risks

[36:12] - Fun Projects in Excel

[38:38] - Rapid-Fire Questions

[48:26] - Final Advice for Financial Modelers

69 에피소드

#MBA #Business #Podcasting Education #Paul Barnhurst AKA The FP&A Guy #Guys #Paul Barnhurst AKA The FP #Paul Barnhurst

Financial Modeler's Corner