The Mistakes in Structure and Data Thinking That Break Models with Mark Proctor

About this episode

Paul Barnhurst and Mark Proctor discuss the importance of structure and automation in financial modeling and Excel.

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…

People in this episode

Host: Paul Barnhurst

Guest: Mark Proctor

Topics covered

• financial modeling
• data analysis
• Excel automation
• Power Query
• Pivot Tables
• model structure
• efficiency in Excel

Keywords

• financial modeling
• data analysis
• Excel automation
• Power Query
• Pivot Tables
• VLOOKUP alternatives
• stakeholder-friendly models
• manual adjustments
• Excel efficiency

Mentioned in this episode

Organizations: Excel Off The Grid

More episodes of Financial Modeler's Corner

• The Critical Role of Communication and Standard Definitions in Financial Modeling with John Yeldham · June 9, 2026 · 51 min
• How Founders Mistake Models Only for Fundraising and What They Should Do With Ilyas Anis · June 2, 2026 · 45 min
• AI in Investment Banking for Analysts to Adapt as Workflows Change but Jobs Remain – Matan · May 19, 2026 · 19 min
• The Investment Banking Job Hasn't Changed Since 1990. AI Is Changing That with Wall Street Prep CEO Matan Feldman · May 12, 2026 · 47 min
• Financial Modeling for Analysts to Build Clear, Structured Models for Better Decisions with Shreya Bhatt · May 5, 2026 · 39 min
• AI in Finance for Professionals Dealing with Errors, Overhype, and Constant Learning Pressure · April 28, 2026 · 48 min