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

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

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:



Follow David:



Follow Jaq:



Follow Amber:



Follow Paul:



Follow Financial Modeler's Corner 



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

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(153)

Stop Letting AI Do All Your Thinking in Financial Modeling with Danielle Stein-Fairhurst

Stop Letting AI Do All Your Thinking in Financial Modeling with Danielle Stein-Fairhurst

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Danielle Stein Fairhurst to discuss how AI is reshaping financial modeling, what modelers need to do to stay relevant,...

13 Okt 20min

AI, Excel and the Changing Role of Financial Modelers with Danielle Stein Fairhurst

AI, Excel and the Changing Role of Financial Modelers with Danielle Stein Fairhurst

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Danielle Stein Fairhurst to discuss how AI is changing financial modeling, why modelers need to keep learning, and how...

6 Okt 49min

Poker, Probability, and Financial Modeling with Dan Mayoh

Poker, Probability, and Financial Modeling with Dan Mayoh

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Dan Mayoh to discuss his career in financial modeling, lessons from model auditing, and why he sees Excel as one of th...

29 Sep 46min

Financial Modeling, Deal Making, and the Skills Every Analyst Needs with Oren Klaff

Financial Modeling, Deal Making, and the Skills Every Analyst Needs with Oren Klaff

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Oren Klaff, Private Equity Fund Manager and bestselling author of Pitch Anything, to discuss how financial modeling ca...

22 Sep 20min

Building AI for the Top 1% of Excel Users with Peter Fuller

Building AI for the Top 1% of Excel Users with Peter Fuller

In this episode of Financial Modeler’s Corner, the Mod Squad, Ian Schnoor, Giles Male, and Paul Barnhurst, speak with Peter Fuller about AI-powered financial modeling and the rapidly changing future o...

15 Sep 50min

Pitch Anything's Oren Klaff: From Spreadsheet to Deal Table

Pitch Anything's Oren Klaff: From Spreadsheet to Deal Table

In this episode of Financial Modeler’s Corner, Paul Barnhurst speaks with Oren Klaff about how financial modeling can become a powerful tool for deal-making, investment decisions, and career growth. O...

8 Sep 49min

Why AI Makes Financial Modeling Best Practices More Important with Marli van Staden-Basson

Why AI Makes Financial Modeling Best Practices More Important with Marli van Staden-Basson

In this episode of Financial Modeler’s Corner, Paul Barnhurst speaks with Marli van Staden-Basson about best-practice financial modeling, AI, model design, and the skills needed to build reliable mode...

1 Sep 53min

What Separates an Excellent Financial Modeler From a Technically Good One with Diarmuid Early

What Separates an Excellent Financial Modeler From a Technically Good One with Diarmuid Early

In this episode of Financial Modeler’s Corner, Paul Barnhurst speaks with Diarmuid Early about what separates great financial modelers from technically capable ones, the rise of AI in financial modeli...

25 Aug 49min

Populært innen Business og økonomi

stopp-verden
dine-penger-pengeradet
rss-penger-polser-og-politikk
e24-podden
rss-borsmorgen-okonominyhetene
rss-skravla-gar
rss-pa-konto
livet-pa-veien-med-jan-erik-larssen
pengepodden-2
lederpodden
finansredaksjonen
utbytte
rss-orjasater
stormkast-med-valebrokk-stordalen
morgenkaffen-med-finansavisen
tid-er-penger-en-podcast-med-peter-warren
rss-markedspuls-2
okonomiamatorene
pengesnakk
liberal-halvtime