Classroom Training

Excel VBA programming - intensive three-day course

Classroom training course - online version also available

3 days

If you're learninng to write VBA macros to automate what you do within Excel, for the majority of people our two-day Introduction to Excel VBA course will be perfect (it shows all the main syntax of VBA that you need to get going). However for those who want a little bit more - and are prepared to cover more topics in less time - this intensive three-day course covers all of the introductory course together with selected topics from the advanced one (the only big thing not covered is class modules, which we think are barely worth learning for VBA). For more information on how are fast track courses work see these notes.

Course details

Possible locations:London, Manchester, Online
Next classroom course:No classroom dates
Time:09:30-16:30

SCHEDULED DATES Course Contents - PDF

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our EXCEL VBA MACROS course

Recording macros and buttons

Absolute and relative recording
Where macros can be stored
Assigning macros to buttons

Selecting cells

Selecting cells (absolute)
Selecting cells (relative)
Selecting to the end of a block
Selecting a range by its corners

The VB code editor

Using Project Explorer
Creating modules
Basic subroutines and comments

Messages and variables

Input boxes and message boxes
Declaring variables
Option Explicit
Scope of variables
Constants

Visual Basic explained

The Excel object model
Objects and collections
Methods and properties
Getting help in VBA

Loops and conditions

Simple IF conditions
Multiple IF and SELECT / CASE
Three main types of loop

Looping over collections

Object variables
Looping over collections

Event handling

Assigning macros to events
Cancelling events

Functions

Declaring functions
Passing arguments

Debugging and error handling

Setting breakpoints
Stepping through macros
ON ERROR statements

Forms

Drawing forms
Attaching macros to controls
Validating form input

From our ADVANCED VBA course

Links to other applications

Referencing other applications
Instantiating objects
Writing inter-application code

FileSystemObjects

Referencing FileSystemObjects
Working with files and folders

FileDialogs

Using FileDialogs
Allowing multiple selection

Working with text files

Avoiding using INPUT/OUTPUT
Reading and writing text files

Covered if time allows If time

Linking to data

ADO or Access Database Engine
Referencing the right library
Opening and using recordsets

Arrays

Creating and populating arrays
Dynamic arrays
The PRESERVE keyword

Passing arguments

ByRef and ByVal
Using optional arguments
Using ParamArray

Covered if time allows If time

Advanced programming ideas

Using functions in code
Recursive programming
Enumerations

Covered if time allows If time

Working with shapes

Adding shapes
Positioning shapes
Formatting shapes

You only need a basic knowledge of Excel for this course. You'll find it easier if you have some programming experience, although this isn't essential. What you must have is a good aptitude for computers (otherwise this will be a l-o-n-g three days ...).

Why Choose Us?

No more than 5 people per class
Proper restaurant lunch included
479 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Really informative and good use of interaction. Engaging trainer who is clearly very passionate about SQL & always happy to answer questions/explain things further. Recommended by colleagues."

Alex Martin (URIS Group/Towergate Insurance)

"I have no previous Power BI experience to speak of but the course has given me much to consider. Copies of the course material and our individual works will be very useful reference points for the future, when I undoubtedly hit a brick wall! The trainer was extremely knowledgeable on Power BI, Power Pivots, DAX language and pretty much anything that we cared to throw his way - he's a very effective trainer, putting across a complex topic in a structured and cohesive manner. I believe that the online experience worked well. I'd certainly recommend this course, and Wise Owl to others. Also of particular attraction was that all 6 trainees were from Volac and there was plenty of opportunity to delve into areas of particular interest - though we did ultimately follow the course as originally presented."

Tim Whittal-Williams (Volac International Ltd)

"Our trainer was a great host, with the ability to convey the information in a clear and concise manner. The day was filled with information but kept a good pace that enabled us to get through the course with enough time to take breath and ask questions where needed."

Anthony Gray (Homes England)

"It was a busy three days, but we knew that before we booked. The trainer was superb, clearly instructing us with no repetition or waffle. The online aspect worked very well indeed, I'm sure the trainers must appreciate being able to see each attendees screen. A good email discussion with Wise Owl helped guide us to choose this course."

Kenton Reader (Reigate and Banstead Borough Council)

"We had an exceptional instructor who, as well as being incredibly knowledgeable, had the patience and understanding to adapt his teaching to each student. Would highly recommend for individual and team training. Course content was on point as well, which was the main reason to go with Wise Owl."

Tony Woolacott (British Tourist Authority)

There are lots more where these came from (or just refresh this page to change the quotes shown).