Excel Automation - Session 1 (26 July 2019)

July 26, 2019

 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


Share on Facebook
Share on Twitter
Please reload

Featured Posts

I'm busy working on my blog posts. Watch this space!

Please reload

Recent Posts
Please reload

Please reload

Search By Tags
Please reload

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions