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.

Schedule

We’re planning a new run of this course, probably end of 2018 or beginning of 2019.

We’ve done this course in October 26 and 27, 2016 where we received positive feedback from our attendees!

Please note that by registering you accept our Event Conditions.

Interested already? Please take our survey

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’re planning a new run of this course, probably end of 2018 or beginning of 2019.

The training costs € 595.00 per day.

Registering for both days entitles you to a € 190 discount so that 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).

Interested in attending?

Please contact us: info@topexcelclass.com
+31 648 628 252

This class as an in-house training

The Excel VBA Masterclass has already been held both as an in-house training in February 2016 and as an open training on October 26 and 27 2016. 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