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

  • Thursday 30th January 2025
  • Tuesday 25th February 2025
  • Wednesday 26th March 2025
  • Tuesday 29th April 2025
  • Tuesday 27th May 2025
  • Wednesday 30th July 2025
  • Tuesday 26th August 2025
  • Monday 29th September 2025
  • Thursday 30th October 2025
  • Tuesday 25th November 2025
  • Tuesday 16th December 2025
Back to all Courses