Ottawa - Albert & Metcalfe

116 Albert Street, Ottawa, Canada, K1P 5G3

Across the street from the World Exchange Plaza. The Ottawa Shaw Centre and CF Rideau Centre shopping mall 10 minutes...

Ottawa - 343 Preston

Regus, 343 Preston Street, Ottawa, Canada, K1S 1N4

On the top floor of a distinctive office tower that's highly visible from Highway 417, you'll find Regus 343 Prest...

Explore Our Courses

Excel VBA Introduction

14 Hours
This instructor-led, live training in Ottawa (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 ottawa, VBA training courses in ottawa, Weekend VBA courses in ottawa, Evening VBA training in ottawa, VBA instructor-led in ottawa, VBA one on one training in ottawa, VBA trainer in ottawa, VBA instructor in ottawa, VBA instructor-led in ottawa, VBA private courses in ottawa, Weekend VBA training in ottawa, VBA boot camp in ottawa, VBA classes in ottawa, VBA on-site in ottawa, VBA coaching in ottawa, Online VBA training in ottawa, Evening VBA courses in ottawa
1