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