Microsoft Excel Automation Training Course

Save Time & Money with Excel Automation

Want to save hours, if not days, when working with Excel?

Discover how relatively simple this can be with our Excel Automation Course!


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 timesaving world of Excel Automation.


There are 2 versions of this course:

A 2-day Public Course and a 2 or 3-day Onsite Course.

In both cases the full course content is covered in 1 day by using generic solutions. The benefit of the onsite course is that on the remaining day(s) we focus on your company’s actual automation requirements and help you to automate your very own Excel Processes.

Public Course: R5 500 per person

Corporate Course: from R13 750 per day

*Prices are exclusive of VAT

What you'll learn:

MS Excel Automation Training Course 

Customer Feedback

I would just like to thank Mark for his support over the training sessions, the team are totally pumped at what they learnt and are already putting it into practice which is saving them hours if not days of time.

– Patrick Mason, Kerry Ingredients

Public Courses


09h00 - 16h30 (Day 1)

08h30 - 16h00 (Day 2)


08h30 - 16h00 (Day 1)

08h30 - 16h00 (Day 2)



  • Enquire within

KwaZulu Natal


  • Enquire within

Not sure where to start ?

Make use of our Free 



  • What are Macros and VBA?

  • Recording a Macro

  • Tips and Tricks on Recording a Macro

  • Stepping through a Macro

  • Editing a Recorded Macro

  • VBA Code Snippets

  • Manipulating VBA Code Snippets

  • VBA Coding Basics

    • Objects, Properties and Methods

    • Object Hierarchy and VBA Context

    • Declaring and using Variables

    • Implementing basic loops and If statements



  • What is Power Query?

  • Connecting to various Data Sources

  • Manipulation of Source Data

  • Working with the Manipulated Data Table

  • Merging and Appending Data

  • Troubleshooting Connection Issues



  • Integration with PowerPoint and Word

  • Report Version Control

  • VBA or Power Query?

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


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

2020 | Copyright | Summit Solutions