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 two-day training course takes your VBA skills to the next level.

Here is some feedback from our attendees from previous masterclasses

Schedule

Training dates:
February 12 and 13, 2020.
Location: Utrecht, The Netherlands

Registration is closed.

Contact us for last-minute participation

Event Conditions

Content

During this two-day course, we teach these subjects:

Day 1

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 Optimisation

Day 2

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
Optimising a UDF

Course dates, Registration, Pricing

Training dates: We’ve tentatively set the training dates to February 12 and 13, 2020

The training costs € 595.00 per day.

Registering for both days entitles you to a € 190 discount so the total price for two days is € 995.00.

Included in this price is:

  • The training
  • All training materials
  • Catering (Lunch, coffee, tea, refreshments during the breaks)

Please note that prices do not include 21% Dutch VAT, which will be added to your bill (this is because this is a training provided in The Netherlands).

Register Now, Click Here!

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