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 Registration 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

Schedule

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

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