Excel Automation - Session 1 (26 July 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

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

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