Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
Excel Advanced User
Excel Knowledge preferably Advanced Excel
Course Outline / Curriculum
Lesson 1:Visual Basic Editor
Topic A: Visual Basic for Applications A-1: Discussing VBA A-2: Preparing Excel for VBA A-3: Examining the VBE window
Topic B:Object programming B-1: Examining the Properties window B-2: Changing the object properties B-3: Using code to change object properties B-4: Using a method B-5: Associating VBA code with an event B-6: Executing VBA code by using a button
Topic C:The Object Browser C-1: Examining the Object Browser C-2: Searching in the Object Browser
Lesson 2:Programming basics
Topic A:Data basics A-1: Discussing data types and variables A-2: Discussing and declaring variables A-3: Using operators A-4: Using interaction functions
Topic B:Scope of variables B-1: Understanding procedure- and module-level scope B-2: Understanding public scope
Topic C:Scope of procedures C-1: Creating a Sub procedure C-2: Calling a Sub procedure C-4: Calling a Function procedure
Lesson 3:Control structures
Topic A:Decision structures A-1: Using the If Then statent A-2: Using the If…Then… Else statent A-3: Using the If… Then… ElseIf statent A-4: Using the Select Case statent
Topic B:Loop structures B-1: Using the For…Next loop B-2: Using the For Each…Next loop B-3: Using the Do While…Loop
Lesson 4:Custom dialog boxes
Topic A:User forms A-1: Adding a user form A-2: Adding controls to a user form
Topic B:Events B-1: Attaching an event handler to a control B-2: Validating data by using event handlers
Lesson 5:Debugging and error handling
Topic A:Errors A-1: Discussing types of errors
Topic B:Debugging B-1: Discussing debugging tools B-2: Setting a breakpoint B-3: Adding a watch expression B-4: Using Step Into B-5: Deleting a watch expression B-6: Working with the Immediate window B-7: Working with the Locals window
Topic C:Error handling C-1: Using the On Error GoTo statent C-2: Using the On Error Resume Next statent
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
Mon 12 Apr 2021
Wed 14 Apr 2021
Mon 14 Jun 2021
Wed 16 Jun 2021
Mon 9 Aug 2021
Wed 11 Aug 2021
Mon 4 Oct 2021
Wed 6 Oct 2021
For clients who want to enjoy the convenience of public transport,
consider the Gautrain.
Take the Gautrain to the Malboro station.
Purchace a R15 ticket for the Woodlands Office Park Shuttle Service.
The shuttle will come directly down Western Service road.
Ask to be dropped at the entrace to Western Woods Office Park.
For more information you can download
the official Gautrain brochure.
Bringing your own PC
It is very important that you have full administrator rights to your
computer so that any software needed for the course can be installed
Please ensure that you arrive at least 30min early on the first day
of training in order to get your PC setup correctly.
If this is not possible then it will be better to make use of our