Excel VBA

This course is aimed at those delegates who have a need to develop integrated spreadsheet solutions using Microsoft Excel. Typically these may be senior I.T. staff or “super users” who need to be able to produce in-house “turn key” systems.

Who Should Attend:
Advanced users needing to develop integrated automated solutions in Microsoft Excel.

Prerequisites:
Prior attendance on the Complex Functions and Macros Excel course, or a very thorough knowledge of the product, is recommended for all delegates.
The course is 100% hands-on and, although no previous programming experience is required, it should be pointed out that programming in the VBA environment forms the majority of the course so an understanding of basic programming techniques would also be desirable.

 

Two Day Course

Course Outline (PDF)

Course Objectives:

  • Excel Macros 
  • Writing Visual Basic Code
  • Variables 
  • User Defined Functions 
  • Visual Basic Objects
Excel Green Logo Microsoft. Green book with white x in centre
Price: £450 + vat

Dates

  • Wednesday 29th July 2026
  • Thursday 27th August 2026
  • Wednesday 23rd September 2026
  • Tuesday 27th October 2026
  • Tuesday 24th November 2026
  • Monday 21st December 2026
  • Tuesday 26th January 2027
  • Tuesday 23rd February 2027
  • Tuesday 23rd March 2027
  • Wednesday 21st April 2027
  • Tuesday 25th May 2027
  • Tuesday 22nd June 2027
  • Tuesday 27th July 2027
  • Wednesday 25th August 2027
  • Tuesday 28th September 2027
  • Wednesday 20th October 2027
  • Wednesday 24th November 2027
  • Wednesday 15th December 2027