Microsoft Office training -  Fast track Excel VBA

VBA Training

Excel VBA programming - intensive three-day course

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, 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 - and why they are only available as tailored courses - see these notes.

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

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

  • Training topicAbsolute and relative recording
  • Training topicWhere macros can be stored
  • Training topicAssigning macros to buttons

Selecting cells

  • Training topicSelecting cells (absolute)
  • Training topicSelecting cells (relative)
  • Training topicSelecting to the end of a block
  • Training topicSelecting a range by its corners

The VB code editor

  • Training topicUsing Project Explorer
  • Training topicCreating modules
  • Training topicBasic subroutines and comments

Messages and variables

  • Training topicInput boxes and message boxes
  • Training topicDeclaring variables
  • Training topicOption Explicit
  • Training topicScope of variables
  • Training topicConstants

Visual Basic explained

  • Training topicThe Excel object model
  • Training topicObjects and collections
  • Training topicMethods and properties
  • Training topicGetting help in VBA

Loops and conditions

  • Training topicSimple IF conditions
  • Training topicMultiple IF and SELECT / CASE
  • Training topicThree main types of loop

Looping over collections

  • Training topicObject variables
  • Training topicLooping over collections

Event handling

  • Training topicAssigning macros to events
  • Training topicCancelling events

Functions

  • Training topicDeclaring functions
  • Training topicPassing arguments

Debugging and error handling

  • Training topicSetting breakpoints
  • Training topicStepping through macros
  • Training topicON ERROR statements

Forms

  • Training topicDrawing forms
  • Training topicAttaching macros to controls
  • Training topicValidating form input
From our ADVANCED VBA course

Links to other applications

  • Training topicReferencing other applications
  • Training topicInstantiating objects
  • Training topicWriting inter-application code

FileSystemObjects

  • Training topicReferencing FileSystemObjects
  • Training topicWorking with files and folders

FileDialogs

  • Training topicUsing FileDialogs
  • Training topicAllowing multiple selection

Working with text files

  • Training topicAvoiding using INPUT/OUTPUT
  • Training topicReading and writing text files

Covered if time allows If time

Linking to data

  • Training topicADO or Access Database Engine
  • Training topicReferencing the right library
  • Training topicOpening and using recordsets

Arrays

  • Training topicCreating and populating arrays
  • Training topicDynamic arrays
  • Training topicThe PRESERVE keyword

Passing arguments

  • Training topicByRef and ByVal
  • Training topicUsing optional arguments
  • Training topicUsing ParamArray

Covered if time allows If time

Advanced programming ideas

  • Training topicUsing functions in code
  • Training topicRecursive programming
  • Training topicEnumerations

Covered if time allows If time

Working with shapes

  • Training topicAdding shapes
  • Training topicPositioning shapes
  • Training topicFormatting 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?

View full list of benefits View full list of benefits

Sample customer feedback

"l thought the course was fantastic and really helpful and the training materials were of a really high standard. It is not often when going on a training course that you can work through the training and manual afterwards which is a credit to Wise Owl Training. I also wanted to thank your excellent trainer; his style of teaching was very good. He has a lot of patience with less experienced people like myself and was always willing to help us when we got stuck. I would definitely like to attend some other courses."

John Groves (Kinase Consulting Limited)

"The course was excellent. The trainer provided lots of useful tips and examples tailored to our requirements. The take-away material will be really useful as we capitalise on this training in our work."

Pat Watt (Skills Development Scotland (SDS))

"Brilliant manuals. Excellent link with the tutorials, exercises and trainer's content. The trainer was very helpful with answering our ad-hoc questions and bringing daily tasks to complex Excel. Thanks you and for the goodies too. I would definitely book a course with Wise Owl again."

Lydia Webster (Canal & River Trust)

"Very good trainer, approachable style, made the course content very easy to understand. All course materials were great and very useful. Great venue."

Myfyr Prys (Prifysgol Bangor University)

"(SQL) Really enjoyed how we were able to interact & discuss various ways and means. (SSRS) Very good content and delivery."

Amanda Harkett (Countrywide)

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