Excel Problem-Solving Strategies for Financial Modelers to Build Robust Models with Liam Bastick
Description
In this engaging episode of Financial Modelers Corner, host Paul Barnhurst, aka "The FP&A Guy," sits down with Liam Bastick, Managing Director of Sum Product and a highly respected figure in financial modeling and Excel expertise. Known for his complex modeling work, quirky sense of humor, and love for a good challenge, Liam shares insights into the nuances of financial modeling, discusses his favorite Excel tips, and reveals his fascination with the evolving role of AI in modeling.
Liam Bastick is a seasoned corporate trainer, author, and financial modeling expert, with a focus on Excel, Power BI, and AI applications. With a career that includes awards like Microsoft’s Most Valuable Professional and the inaugural Lifetime Achievement, international recognition, and extensive teaching, Liam provides listeners with both practical advice and fascinating anecdotes from his career.
Expect to Learn:
Excel optimization tips and learn how to effectively use Quick Access toolbar Circular references and financial modeling horror story insightsChallenges and advantages of modeling in Power BIHow AI is changing financial modeling and what the future might holdLiam’s approach to problem solving to stay at the forefront of innovation
Here are a few quotes from Liam Bastick:
“The best tip I can give is to put the tools you use most often on the Quick Access toolbar. It’s underused but incredibly helpful.”“If you've got circular references in your model, you’re already on thin ice. They can lead to wrong answers and complete chaos.”“With AI, you can do the front-end and back-end work in financial modeling, but it’s still not there yet for the mechanics in the middle.”
In this insightful episode, Liam Bastick shared his passion for financial modeling, bringing both humor and depth to complex topics in Excel, Power BI, and AI. His reflections on adaptability, continuous learning, and challenging the limits of traditional tools serve as powerful reminders for anyone in finance or data analysis.
Follow Liam:
Website - https://www.sumproduct.com/LinkedIn - https://www.linkedin.com/in/liam-bastick-73a39114/
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’.
Visita...
In this episode of Financial Modelers Corner, Paul Barnhurst aka The FP&A Guy dives deep into the intersection of corporate development and financial modeling, focusing on mergers and acquisitions (M&A). Sean Corcoran, a seasoned expert with over 20 years in corporate development, shares...
Published 11/26/24
In this insightful episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes financial modeling expert Rachit Jain. They delve into the nuances of financial modeling, exploring the art of building accurate, reliable models and the importance of critical thinking...
Published 11/12/24