Waterloo - 180 Northfield Drive West

180 Northfield Drive West, Waterloo, Canada, N2L 0C7
Maximise opportunities in this forward-thinking city, a centre of knowledge that's home to several tech giants. Our well-conn...

Explore Our Courses

Excel VBA Introduction

14 Hours
This instructor-led, live training in Waterloo (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks. By the end of this training, participants will be able to:
  • Record and edit macros as required.
  • Write procedures using data from the sheet.
  • Create your own functions.
  • Handle an event (opening worksheet cell update etc.) by means of the handler.
  • Create a form.
Read more...

Visual Basic for Applications (VBA) for Analysts

21 Hours
The course is designed for users of Excel for creating analyzes and reports.
Read more...

Excel and VBA Programming for Audit and Finance Professionals

28 Hours
Please answer the following questions:
  • Is your daily work in Excel is a never-ending string of commands copy-paste?
  • Are you wasting time on repetition of similar operations to prepare the data for analysis?
  • Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results?
  • Rather than deal with data analysis and preparation of wasting time?
  • Do you have to manually verify the correctness of such data obtained from different systems?
  • Do you have to stay at work after hours or Excel to take books home because not doing during the day?
  • Is Your job is to prepare reports based on a large data set?
  • Do you feel that working in Excel, you come to a roundabout way of results?
If you can answer YES to one of the questions then it's time stop this nightmare. This training is for you. Find out how you can speed up your daily operations and get most out of MS Excel. WARNING After the training, your life will change dramatically. Activities, which occupied the whole day will take just a few moments. Are you ready for this?
Read more...

Last Updated:

Testimonials (6)

Trainer flexibility. Comprehensive answers to every question.

Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts

Machine Translated

The training was perfect in my opinion, opened my eyes to a lot of things that I was not aware of. Straight to the point with a lot of exercises, for some people it was too fast maybe but due to my background experience I did not feel that way.

Maen Hatoum - Red Bull GmbH
Course - Visual Basic for Applications (VBA) for Analysts

The specialist knowledge was amazing! The way that you took that and broke it up, so we could understand was awesome. I think i just have to start with the simple stuff. the Last Subject was a bit high level and I struggled to keep up but will get there :)

Zaskia Stanz - BMW
Course - Visual Basic for Applications (VBA) for Analysts

Detailed examples & training material.

KAREN LOUW - BMW
Course - Visual Basic for Applications (VBA) for Analysts

He was prepared and also give good pointers

Annemarie Van Aardt - BMW
Course - Visual Basic for Applications (VBA) for Analysts

Working on and using our own data/spreadsheets, where we could see how it would benefit us most.

Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction

Upcoming Courses

Other regions in Canada

Other Countries

These courses are also available in other countries
Online VBA training in Waterloo, VBA training courses in Waterloo, Weekend VBA courses in Waterloo, Evening VBA training in Waterloo, VBA instructor-led in Waterloo, VBA trainer in Waterloo, VBA instructor in Waterloo, VBA on-site in Waterloo, VBA one on one training in Waterloo, VBA instructor-led in Waterloo, Online VBA training in Waterloo, VBA private courses in Waterloo, VBA boot camp in Waterloo, VBA classes in Waterloo, Weekend VBA training in Waterloo, Evening VBA courses in Waterloo, VBA coaching in Waterloo
1