Mark Proctor
Excel MVP, founder of Excel Off the Grid, and an experienced finance professional with a background in accounting, FP&A and financial modelling; focuses on Excel automation, Power Query/Power Pivot and improving efficiency in financial analysis.
Best podcasts with Mark Proctor
Ranked by the Snipd community
7 snips
Apr 9, 2024 • 1h 13min
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
Join Microsoft MVP Mark Proctor as he discusses the resurgence of VBA with AI, Unix philosophy for scalable automation, and the power of Power Query in data transformation. Gain valuable insights to streamline processes in finance and technology.
Oct 29, 2024 • 48min
The Secrets to Automating Data Integration and Reporting in Excel With Mark Proctor
Mark Proctor, an Excel MVP and founder of Excel Off the Grid, shares his wealth of knowledge in automating Excel for finance professionals. He discusses the importance of structured data and the evolution of Excel tools like Power Query and Power Pivot, reshaping how analysts work. Mark emphasizes the need to move away from outdated functions like VLOOKUP to enhance efficiency. He also offers practical strategies for making financial models user-friendly and highlights the future role of AI in financial modeling, stressing the irreplaceable value of human judgment.
