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 May 2024
  • Tuesday 25th June 2024
  • Tuesday 30th July 2024
  • Wednesday 28th August 2024
  • Wednesday 25th September 2024
  • Tuesday 29th October 2024
  • Thursday 28th November 2024
  • Wednesday 18th December 2024
Back to all Courses