WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
Classroom training -  Fast track Excel VBA

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

  • Locations for Fast track Excel VBA coursesPossible locations:London, Manchester, Online
  • Next Fast track Excel VBA course locationNext classroom course:No classroom dates
  • Fast track Excel VBA course timesTime:09:30-16:30

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?

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).

Related Courses

Excel VBA macros

Introduction

2 day course

Advanced VBA

Advanced

2 day course

Other Visual Basic for Applications training resources

VBA exercises

VBA exercises

We've published our (many) VBA exercises online, for you to review.

View Excel VBA or Advanced VBA exercises

VBA skills assessment

VBA skills assessment

If you think you know VBA, put your knowledge to the test with our skills assessment tests.

View How well do you know Excel VBA? skills assessment tests

VBA blogs

VBA blogs

We've published a host of blogs on VBA, includng a full tutorial.

View VBA macros blogs

This page has 0 threads Add post