Excel VBA Masterclass


Sharpen your VBA knowledge

It is easy to find beginner and intermediate level Excel VBA training. But what if you’re a more experienced Excel VBA developer already and want to sharpen your VBA skills?

This is a unique opportunity to be trained by an industry expert and Excel MVP: Jan Karel Pieterse!

This training course takes your VBA skills to the next level.

Here is some feedback from our attendees from previous masterclasses

Schedule

Our Next On-line training starts soon. Session dates:

May 18, 20, 26, 28, June 2, 4

Registration

Register now

Contact us for in-house or bespoke on-line options

Event Conditions

On-line training

The training is presented to you using Microsoft Teams. The training comprises of 6 sessions of approximately 2.5 hours. During each session our trainer presents the training topic using a live video connection. All training sessions are recorded so participants can view the session again if needed. Also, participants get access to the Teams area where they can chat with the trainer and each other, share files and download training materials. This Teams area will be open to participants for one month after the last session.

Content

During this course, we teach these subjects:

Class modules

Read more about this subject here

Introduction
Event classes
Object classes
Classes of classes
Efficient coding (part 1 and 2)

Read more about this subject here

Efficiently exchanging information with Excel
Measuring Performance
Breaking the rules
Fast VBA Algorithms
Index Sort
Micro Optimization
Error handling

Read more about this subject here

Concepts of error handling
What is an error handler
Methods to handle errors
Userforms

Read more about this subject here

Design
Events, methods, properties
Using in an OO way
Add-ins

Read more about this subject here

When to use an add-in
How to develop add-ins
Creation
Rules (do, don’t)
Installing
Updating Add Ins
UDFs

Read more about this subject here 

Do’s and don’ts
Pro’s and cons
Optimizing a UDF

Course dates, Registration, Pricing

Our next training will be on-line only. The 6 sessions are  scheduled for these dates:

May 18, 2020
May 20, 2020
May 26, 2020
May 28, 2020
June 2, 2020
June 4, 2020

Tentatively and depending on the timezones of the participants, sessions are scheduled for 19:00 to 21:30 Amsterdam DST time.

All sessions will be recorded and participants will have access to the training site until one month after the end of the training.

Register now

This class as an in-house training

The Excel VBA Masterclass has already been held both as an in-house training and as an open training. If you are interested in setting up this masterclass in-house at your company, please contact us: info@topexcelclass.com

Top Excel classes, training and events