Microsoft Office training -  Excel VBA macros

VBA Training

Automating Excel with Macros Training Course

£695 + VAT for most venues (£850 + VAT for London)

2 days

Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).

Course details

  • Locations for Excel VBA macros coursesLocations:London, Manchester
  • Next Excel VBA macros course locationNext course:Thu 24 October 2019
  • Excel VBA macros course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

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

Covered if time allows If time

Referencing other applications

  • Training topicLinks to Word or Access
  • Training topicWorking with files and folders

Delegates should be comfortable with using Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"The trainer was great throughout both days, energetic and explained complicated concepts well. Would happily attend another Wise Owl course."

Adam Sykes (Bott Co Solicitors Ltd)

"Great trainer - very clear, easy to understand and set a perfect pace for everyone on the course. Great level of detail and fantastic content - all very useful. The booklet and exercises are super helpful both in the training and after. Lovely venue & perfect lunch choices. Honestly best course I've been on yet!"

Katie Stevenson (Barbican Insurance Group)

"The trainer was brilliant, a genuinely nice guy with a wealth of knowledge. Looking forward to my Advanced VBA course in the near future. The course is laid back, lets you wear your own 'out of office' clothing and the complementary lunches were lovely."

Tashan Jackson (Partners for Improvement in Islington Ltd)

"The course was very interesting and I have learnt a lot, that will benefit me in my current job. The tutor was very professional and knowledgeable and was always keen to help and explain in details if something wasn't understood."

Jekaterina Velikanova (Partners for Improvement in Islington Ltd)

"Very friendly, helpful and relaxed environment. Would definitely recommend to colleagues."

Josie MacKinlay (Brother UK)

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

Scheduled Excel VBA macros training dates

Here are the Excel VBA macros courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 24-25 October 2019 2 £695 Book places
Thu/Fri 07-08 November 2019 2 £850 Book places
Tue/Wed 19-20 November 2019 2 £695 Book places
Tue/Wed 17-18 December 2019 2 £850 Book places
Tue/Wed 14-15 January 2020 2 £695 Book places
Thu/Fri 06-07 February 2020 2 £850 Book places
Thu/Fri 05-06 March 2020 2 £695 Book places
Tue/Wed 24-25 March 2020 2 £850 Book places
Thu/Fri 30th Apr/1st May 2020 2 £695 Book places
Tue/Wed 05-06 May 2020 2 £850 Book places
Thu/Fri 04-05 June 2020 2 £695 Book places
Tue/Wed 07-08 July 2020 2 £850 Book places
Tue/Wed 14-15 July 2020 2 £695 Book places
Tue/Wed 18-19 August 2020 2 £850 Book places
Tue/Wed 15-16 September 2020 2 £695 Book places
Tue/Wed 13-14 October 2020 2 £850 Book places
Thu/Fri 05-06 November 2020 2 £695 Book places
Thu/Fri 19-20 November 2020 2 £850 Book places
Tue/Wed 08-09 December 2020 2 £695 Book places
Date(s) Venue
24/10
07/11
19/11
17/12
14/01
06/02
05/03
24/03
30/04
05/05
04/06
07/07
14/07
18/08
15/09
13/10
05/11
19/11
08/12

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite VBA training at your offices (we'll even provide and set up the computers).

Related Courses

Advanced VBA

Very advanced

2 day course

Excel Advanced

Advanced

2 day course

Excel Business Modelling

Advanced

2 day course

Other Visual Basic for Applications training resources

VBA exercises

VBA exercises

Teletubbies, Wombles, Elmer the elephant - there are all sorts of exciting exercises on VBA programming published on this site!

View Excel VBA or Advanced VBA exercises

VBA videos

VBA videos

We've created a suite of videos explaining different aspects of VBA (although people learn best from other people, we've found).

View Excel VBA - Basics, VBA User Forms, VBA - advanced, VBA - working with files, VBA - linking applications, Built-in VBA functions, VBA - working with data, VBA - scraping websites, Excel VBA - pivot tables, Excel VBA - charts or VBA - working with Outlook videos

VBA skills assessment

VBA skills assessment

You can test your VBA knowledge by seeing how it stacks up relative to that of others at this skills assessment site.

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

VBA blogs

VBA blogs

There's a full-blown online tutorial included in the blogs we've published on Visual Basic for Applications.

View VBA macros blogs

This page has 0 threads Add post