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:London, Manchester
Next course:Thu 06 February 2020
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The content of this course are as follows:

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

Covered if time allows If time

Referencing other applications

Links to Word or Access
Working 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?

No more than 6 people per class
Proper restaurant lunch included
515 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

"The Excel VBA macros course had great resources including a manual to keep for future reference. The trainer was very helpful and able to answer all questions including our own-macro specific questions. The course speed and content was tailored throughout to match the audience and incorporated effective interaction throughout both days."

Lisa Johnstone (Axis-Shield Diagnostics Ltd)

"The whole course has been really useful, friendly and just a great course. Given me lots of ideas to take away. Trainer is supportive and helpful. Great 2 days! Highly recommended by a number of colleagues."

Becky Leason (Department of Health)

"Very well delivered - the trainer is positive and enthusiastic with a well rounded knowledge of Excel. It is clear he enjoys VBA and this is reflected in the delivery of the course. Clear and concise website, good online reviews, I am looking to roll out a lot of VBA within my job. A+"

Jake Orr (MVF Global)

"The course was very interesting and interactive. I've attended previous courses (as have colleagues). Will attend further courses."

David Williamson (National Nuclear Laboratory)

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

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 06-07 February 2020	2	London	£850	Book places
Thu/Fri 27-28 February 2020	2	Manchester	£695	Book places
Tue/Wed 24-25 March 2020	2	London	£850	Book places
Thu/Fri 30th Apr/1st May 2020	2	Manchester	£695	Book places
Tue/Wed 05-06 May 2020	2	London	£850	Book places
Thu/Fri 04-05 June 2020	2	Manchester	£695	Book places
Tue/Wed 07-08 July 2020	2	London	£850	Book places
Tue/Wed 14-15 July 2020	2	Manchester	£695	Book places
Tue/Wed 18-19 August 2020	2	London	£850	Book places
Tue/Wed 15-16 September 2020	2	Manchester	£695	Book places
Tue/Wed 13-14 October 2020	2	London	£850	Book places
Thu/Fri 05-06 November 2020	2	Manchester	£695	Book places
Thu/Fri 19-20 November 2020	2	London	£850	Book places
Tue/Wed 08-09 December 2020	2	Manchester	£695	Book places

Date(s)	Venue
06/02	London
27/02	Manchester
24/03	London
30/04	Manchester
05/05	London
04/06	Manchester
07/07	London
14/07	Manchester
18/08	London
15/09	Manchester
13/10	London
05/11	Manchester
19/11	London
08/12	Manchester

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

Other Visual Basic for Applications training resources

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

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

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

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