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

  • Monday 29th September 2025
  • Thursday 30th October 2025
  • Tuesday 25th November 2025
  • Tuesday 16th December 2025
  • Tuesday 27th January 2026
  • Tuesday 17th February 2026
  • Monday 30th March 2026
  • Tuesday 28th April 2026
  • Wednesday 27th May 2026
  • Wednesday 24th June 2026
  • Wednesday 29th July 2026
  • Thursday 27th August 2026
  • Wednesday 23rd September 2026
  • Tuesday 27th October 2026
  • Tuesday 24th November 2026
  • Monday 21st December 2026
Back to all Courses