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

Jan 28, 2025

Ask episode

Chapters

Transcript

Episode notes

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: