Работайте офлайн с приложением Player FM !
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
Manage episode 411443416 series 3442672
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
79 эпизодов
Manage episode 411443416 series 3442672
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
79 эпизодов
Все серии
×
1 How to Use AI to Gain a Human Edge: My 3-Pillar Approach to Staying Ahead [Future Finance Podcast] 46:57

1 How to Create an Unfair Advantage: Standing Out in the Age of AI - Hasan Kubba 1:09:12

1 Unlocking Python: From Misconceptions to Mastery with Tony Roberts 1:18:05

1 Global Finance Summit Keynote - AI & Machine Learning in Finance: Transformative Applications 1:03:41

1 Power Automate: Turn Manual to Magnificent and Create Massive Value - Damien Bird | Ep.072 1:20:58

1 AI Overwhelm: How to Keep Up in the Age of Furious Change - Dave Hartley | Ep.071 1:03:10

1 Accounting Meets Art: How to Use Visuals as the Ultimate Productivity Tool - Mike Manalac | Ep.070 1:14:39

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

1 Projection vs Reality: Avoid These Financial Modelling Mistakes - Danielle Stein Fairhurst | Ep.068 41:42

1 Beyond Benchmarks: Will Whizzy Tech Make You a Better Finance Team? - It's Not All About the Numbers | Ep.065 51:21
Добро пожаловать в Player FM!
Player FM сканирует Интернет в поисках высококачественных подкастов, чтобы вы могли наслаждаться ими прямо сейчас. Это лучшее приложение для подкастов, которое работает на Android, iPhone и веб-странице. Зарегистрируйтесь, чтобы синхронизировать подписки на разных устройствах.