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