{"podcast":{"title":"Financial Modeler's Corner","slug":"financial-modeler-s-corner-6436942","podcast_index_feed_id":6436942,"rss_url":"https://feeds.captivate.fm/financial-modeler/","website_url":"https://www.thefpandaguy.com/blog-3-1","image_url":"https://artwork.captivate.fm/4cfd37c6-8a1b-41af-8a5f-9088347c91f4/230616-cover-3000x3000px-60.png","author":"Paul Barnhurst AKA The FP&A Guy","episode_count":135,"summary":"Financial Modeler's Corner is a podcast where we talk all about the art and science of financial modeling with distinguished Financial Modeler's from around the globe. Financial Modeler's Corner is hosted by Paul Barnhurst, aka The FP&A Guy, a global thought leader in the field of finance. The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling.","last_synced_at":"2026-06-10T00:17:31.977505+00:00","page_url":"https://stenobird.com/podcast/financial-modeler-s-corner-6436942"},"episode":{"title":"The Mistakes in Structure and Data Thinking That Break Models with Mark Proctor","slug":"the-mistakes-in-structure-and-data-thinking-that-break-models-with-mark-proctor","published_at":"2026-05-26T11:00:00+00:00","page_url":"https://stenobird.com/podcast/financial-modeler-s-corner-6436942/the-mistakes-in-structure-and-data-thinking-that-break-models-with-mark-proctor","show_page_url":"https://stenobird.com/podcast/financial-modeler-s-corner-6436942","url":"https://www.thefpandaguy.com/blog-3-1","audio_url":"https://op3.dev/e/episodes.captivate.fm/episode/fafc6e30-16c7-4c57-bac4-d87df18ca8e3.mp3","summary":"In this episode of Financial Modeler’s Corner, host Paul Barnhurst (aka The FP&A Guy ) is joined by guest Mark Proctor. Together, they discuss the intricacies of financial modeling and data analysis, with a focus on building efficient models and leveraging automation in Excel. Mark shares his deep expertise on why structure is key, how to automate tedious tasks, and how Excel continues to evolve to meet the demands of modern financial professionals. Mark Proctor is a seasoned financial professional with a background in accounting and finance, an Excel MVP, and the founder of Excel Off The Grid, a platform dedicated to improving efficiency and effectiveness in Excel. With decades of experience, Mark's insights are invaluable for anyone looking to optimize their use of Excel for financial modeling and beyond. He has helped countless professionals streamline their work through better data structure and automation techniques. Expect to Learn Financial modeling vs. data analysis Automation in Excel with Power Query & Pivot Why VLOOKUP is outdated and modern alternatives Building flexible, stakeholder-friendly models Reducing manual and repetitive Excel tasks Here are a few quotes from Mark Proctor: \"Hard-coding is the enemy of a flexible financial model. Once you start hard-coding, you lose the ability to see what's really driving the model.\" - Mark Proctor \"One of the key takeaways from bad models is that manual adjustments should always be documented and trackable.\" - Mark Proctor As Excel continues to evolve with powerful features like dynamic arrays and advanced automation, the tools discussed in this episode are essential for anyone looking to keep pace with the future of financial modeling. Mark’s emphasis on mastering the basics and thinking structurally will…","meta_description":"In this episode of Financial Modeler’s Corner, host Paul Barnhurst (aka The FP&A Guy ) is joined by guest Mark Proctor. Together, they discuss the int…","key_points":[],"chapters":[],"topics":[],"duration_seconds":3000,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/financial-modeler-s-corner-6436942/episodes/the-mistakes-in-structure-and-data-thinking-that-break-models-with-mark-proctor/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/financial-modeler-s-corner-6436942/the-mistakes-in-structure-and-data-thinking-that-break-models-with-mark-proctor.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}