))
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
Manage episode 411443416 series 3442672
Content provided by Adam Shilton. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Adam Shilton or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ro.player.fm/legal.
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
77 episoade
Distribuie
