Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor

https://is1-ssl.mzstatic.com/image/thumb/Podcasts221/v4/54/fb/d3/54fbd32e-dd67-3b11-a438-412e7acebb69/mza_3863298378298694845.jpg/600x600bb.jpg

The Adam Shilton Podcast

Adam Shilton

83 episodes

23 hours ago

Hello, my name’s Adam Shilton, I’m a Founder, Technologist & TEDx Speaker and I’m obsessed with answering the question “How can we become irreplaceable in the Age of AI?”. Join me as we support you on your journey to becoming more prosperous, more purposeful, and more profitable. Please like and subscribe. Extra Goodies? - Sign up for 'Programmed for Profit' for free at https://newsletter.adamshilton.com/subscribe - Find out more at https://www.adamshilton.com

Business

RSS

All content for The Adam Shilton Podcast is the property of Adam Shilton and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Business

https://d3t3ozftmdmh3i.cloudfront.net/staging/podcast_uploaded_episode/43086104/d54a1f6c88ca496d.jpg

Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069

The Adam Shilton Podcast

1 hour 13 minutes 25 seconds

1 year ago

Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069

Join Microsoft MVP Mark Proctor and Adam Shitlon as they delve into powerful tools like VBA and Power Query, and how they can revolutionize your workflow, automating tedious tasks and streamlining processes.

In this insightful episode, Mark addresses the common misconception that VBA is a dated language and explores its potential resurgence with the advent of AI. He also introduces the Unix philosophy, a framework for building scalable and maintainable automations. Additionally, they dive into the capabilities of Power Query, a powerful tool for data transformation and management. Tune in to gain valuable insights and stay ahead of the curve in the ever-evolving world of finance and technology.

------SHOW NOTES------

- Check out Excel Off the Grid - https://exceloffthegrid.com/

- Connect with Mark on LinkedIn - https://www.linkedin.com/in/markstephenproctor/

- Read Mark's hilarous LinkedIn post here - https://www.linkedin.com/posts/markstephenproctor_excel-is-not-a-database-conversation-examples-activity-7176512884670111744-NEWN

- See Mark's slide deck from the Global Excel Summit here - https://drive.google.com/file/d/1Q6mw6uAq6sl5tjp1AKQtH4fG0FyRCLAH/view?usp=drivesdk

------CHAPTERS------

- (00:00:00) - Mark discusses VBA's staying power within Excel
- (00:06:10) - Exploring the potential of AI to revive VBA
- (00:11:00) - Importance of data structure for effective automation
- (00:19:10) - Power Query: A game-changer for data transformation
- (00:26:50) - VBA vs. Office Scripts: Contrasting use cases
- (00:34:40) - Addressing concerns about VBA's perceived obsolescence
- (00:42:30) - Leveraging Power Query for data management
- (00:50:50) - The Unix philosophy: A framework for scalable automations
- (01:00:20) - Embracing a modular approach to automation
- (01:07:50) - Capturing ideas and staying productive on the go

And for more goodies, head over to www.techforfinance.com