Microsoft Excel Automtion 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 1-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.

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

What you'll learn: MS Excel Automation Training Course 

MACROS - VBA

  • 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

 

​POWER QUERY

  • 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

 

FROM SOURCE TO REPORT

  • Integration with PowerPoint and Word

  • Report Version Control

  • VBA or Power Query?

Public Courses

2020 Course dates TBC

Course Costs (excl. VAT):

1-Day Automation: R2 270 

3-Day Advanced & Automation: R6 250

FLEXIBLE

PUBLIC & CORPORATE ONSITE EXCEL TRAINING

18 YEARS

DATA ANALYSIS, REPORTING  & EXCEL SPECIALISTS

COMPREHENSIVE

DEMO VIDEOS & RECAP SHEETS SUPPLIED

SUPPORT

ACCESS TO WEBINAR'S

& EXCEL TIPS

RELEVANT

SOLUTIONS BASED TRAINING WITH REAL LIFE EXAMPLES

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • improve my skills on microsoft excel
  • excel training for businesses
  • excel training help in Durban
  • learn the features of excel

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

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

MS Office Courses

2019 | Copyright | Summit Solutions