Macros allow you to automate tasks in Excel. Converting manual, time consuming repetitive processes into a button click. This allows you to speed up your work and also delegate tasks more easily.
This is the companion course for Macro Essentials. You can build upon the skills you learned in the Essentials course and take your macros to another level.
This course assumes you are using macros and comfortable with editing recorded macros and creating VBA code from scratch.
Over 5.5 hours of video with lots of examples and detailed explanations. The pdf manuals are all very detailed. There is bonus content not included in the live webinars. Most sections include a quiz.
The course also covers advanced topics like
- Event macros - macros that run automatically
- Functions - create your own spreadsheet functions and reusable code
- Two separate workshop sessions that use real world examples to demonstrate how to create macros
- Create an Add-in to create audit reports for files
Level: Intermediate
Duration: 5.5+ hours
Price: AU$80