MS Excel Toronto Meetup - Microautomations: Excels Little Secret - Erik Oehm
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
_______________________________________________________
Session recorded live on April 26, 2023
An Excel super-nerd comes out of hiding to rant and rave about his favorite subject. Come along on a discovery tour of what makes Excel great and learn how features like dynamic arrays, lambdas, power queries, macros, and even ChatGPT, can be used as building blocks to turn Excel into your own personal Iron Man suit.
---------------------
About the Speaker: Erik Oehm
Erik Oehm is a self-proclaimed Excel super-nerd with over 25 years of experience in Excel automation. He is the owner and Chief Automation Officer of Oehm Automation, a software consultancy focusing on Excel automation for the investment industry and developer of Excel based automation tools. Erik has written no books and has 38 followers on Twitter.
--------------
Find more about Erik's work and connect with him:
LinkedIn: / excelrobot
GitHub: https://gist.github.com/ExcelRobot
YouTube: / @excelrobot
Twitter: / excelrobot
Instagram: / excelrobot
---------------------
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:09:25 - Celia Introduces Erik Oehm
00:12:10 – Erik introduces himself
00:19:00 – Erik’s disclaimers – Laziness leads to automating Excel
00:25:15 – Next step after automation, automate the process of automation (micro-automation)
00:31:45 – Microsoft’s dilemma and ways to add your own features or functions to Excel
00:42:00 – Intro to Micro-automations
00:59:10 – Micro-automation Example 1 (Paste sequence, name parameters, substitute text, fill to the right)
01:13:55 – Micro-automation Example 2, pasting data, formatting sheets and data, filtering tables, dynamic arrays, copy/filter by values, open URL, Goto Special similar values, paste over similar values
01:33:45 – Micro-automate everything
01:40:00 – Discussion of Erik’s micro-automation tool – OA Robot (.xll file)
01:44:25 – Example of how you can create a micro-automation
01:55:00 - Questions and Wrap up