Financial Modeler's Corner

How Excel Competitions Transform Data Professionals into Experts Using Power Query and VBA


Listen Later

In this episode of Financial Modeler’s Corner, host Paul Barnhurst aka The FP&A Guy talks about the electrifying world of Excel Esports at the Financial Modeling World Cup (FMWC) in Las Vegas. This special episode captures the energy and innovation of the event, showcasing interviews with top competitors, including Excel MVPs and data enthusiasts, while exploring how Excel competitions push the boundaries of modeling expertise.

The episode features Josh Aharonoff: Microsoft MVP, "Your CFO Guy," specializing in dynamic financial modeling and consulting. David Fortin: Excel expert, Microsoft MVP, and creator of the World of Warcraft-themed FMWC case study. Jaq Kennedy: UK-based actuarial consultant and Excel enthusiast, sharing personal stories and insights from the event. Amber Johnson: Industrial engineer turned Excel champion, known for her creative modeling approach.


Expect to Learn:

  • Insights into the competitive world of the Financial Modeling World Cup and the role of Excel Esports.
  • Unique perspectives on the creative use of Excel, from real-world modeling to themed case studies.
  • How Excel innovations like Power Query, dynamic arrays, and VBA are transforming data work.
  • Personal journeys of Excel enthusiasts and their favorite tips and tools.
  • Why participating in competitions like FMWC can rapidly enhance your financial modeling skills.


Here are a few quotes from this episode:

  • "I’ve spent 24 years working in Excel, and competing here has tripled my knowledge in just two years." - Jaq Kennedy
  • "Competing is less about beating others and more about seeing how much you’ve improved." - Amber Johnson
  • "Creating a case with input from Blizzard Entertainment was surreal—it brought my gaming passion into Excel." - David Fortin


The Financial Modeling World Cup is a celebration of creativity, community, and growth. Events like these provide an experience of learning from the best in the field, or simply embracing the love of Excel. 


Follow Josh:

  • LinkedIn - https://www.linkedin.com/in/joshaharonoff/
  • Website - https://www.yourcfoguy.com/


Follow David:

  • LinkedIn - https://www.linkedin.com/in/david-fortin-cpa-816b20b5/
  • Website - https://linktr.ee/Piggybankaccountant


Follow Jaq:

  • LinkedIn - https://www.linkedin.com/in/jaqkennedy/


Follow Amber:

  • LinkedIn - https://www.linkedin.com/in/ambernjohnsonwmu/


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’.


Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register. 


In today’s episode: 

[01:27] - Introduction and Event Overview

[03:39] - Interview with Josh Aharonoff and David Fortin

[10:12] - Horror Stories and Excel Lessons

[12:25] - Excel Preferences

[23:04] - Interview with Jaq Kennedy

[30:14] - Rapid Fire with Jaq

[33:27] - Interview with Amber Johnson

[42:22] - Closing Thoughts and FMWC Invitation

[43:02] - Giles Male's Anthem

...more
View all episodesView all episodes
Download on the App Store

Financial Modeler's CornerBy Paul Barnhurst AKA The FP&A Guy

  • 4.9
  • 4.9
  • 4.9
  • 4.9
  • 4.9

4.9

15 ratings


More shows like Financial Modeler's Corner

View all
Economist Podcasts by The Economist

Economist Podcasts

4,283 Listeners

HBR IdeaCast by Harvard Business Review

HBR IdeaCast

177 Listeners

The McKinsey Podcast by McKinsey & Company

The McKinsey Podcast

381 Listeners

CFO THOUGHT LEADER by The Future of Finance is Listening

CFO THOUGHT LEADER

120 Listeners

Trumponomics by Bloomberg

Trumponomics

349 Listeners

Wall Street Breakfast by Seeking Alpha

Wall Street Breakfast

1,029 Listeners

Inside the Strategy Room by McKinsey & Company

Inside the Strategy Room

171 Listeners

Dry Powder: The Private Equity Podcast by Hugh MacArthur, Bain & Company

Dry Powder: The Private Equity Podcast

146 Listeners

The Private Equity Podcast, by Raw Selection by Alex Rawlings

The Private Equity Podcast, by Raw Selection

32 Listeners

Coaching Real Leaders by Harvard Business Review / Muriel Wilkins

Coaching Real Leaders

652 Listeners

FP&A Today by Glenn Hopper

FP&A Today

47 Listeners

HBR On Strategy by Harvard Business Review

HBR On Strategy

84 Listeners

Rise Above The Numbers by FP&HEY

Rise Above The Numbers

5 Listeners

FP&A Tomorrow by Paul Barnhurst

FP&A Tomorrow

24 Listeners

Unpivot by UnpivotShow

Unpivot

5 Listeners