Sharpen your VBA knowledgeIt 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 |
ScheduleRegistration |
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 | Introduction |
Event classes | |
Object classes | |
Classes of classes | |
Efficient coding (part 1 and 2) | Efficiently exchanging information with Excel |
Measuring Performance | |
Breaking the rules | |
Fast VBA Algorithms | |
Index Sort | |
Micro Optimization | |
Error handling | Concepts of error handling |
What is an error handler | |
Methods to handle errors | |
Userforms | Design |
Events, methods, properties | |
Using in an OO way | |
Add-ins | When to use an add-in |
How to develop add-ins | |
Creation | |
Rules (do, don’t) | |
Installing | |
Updating Add Ins | |
UDFs | 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