Most of us who work in Excel do what we call repeatable tasks. Each Day, Week or Month we clean up the same data, merge the same files or create the same report. Each time the process is the same but with different data. Wouldn’t it be great if we could get Excel to do most of that repeatable work for us?
The good news is that we can, and we don’t need to be Computer Programmers to achieve it either! By combining Excels Advanced Tools of Power Query and Macros (VBA), This course will expose you to the time saving world of Excel Automation.
This is a 6-week course of 1.5 hours each. In the first 4 weeks we will use generic solutions to introduce these powerful tools and their capabilities. In the last 2 weeks Participants will be encouraged to submit their own reallife automation requirements and we will endeavour to resolve these during the Webinar sessions.
Covered in this Video:
Recording a Macro
Tips and Tricks on Recording a Macro so that they can be re-used for a different dataset
Stepping through a Macro
Editing a Recorded Macro
Using VBA Code Snippets