EXCEL PROGRAMMING USING VBA
April 20 - April 21£450
Enable Technology Ltd, in partnership with ECMS, is offering a two-day Excel Programming Using VBA course on Tuesday 20th and Wednesday 21st April 2021. 10:00am – 16:00pm each day. Training will be delivered online, directly to your computer desktop using Microsoft Teams. You do not need to have Microsoft Teams installed on your computer to join the class.
All you will need is a computer with a reasonable internet connection and a microphone to communicate with the tutor.
All delegates will receive an email invitation with a link to join the training prior to the session. You just need to click on the link to join the class. Each attendee will receive an electronic PDF training manual to keep for reference. Everyone is issued with an attendance certificate after the training.
The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.
At the completion of this course you should be able to:
- understand the Excel object model and VBA concepts
- work effectively with the main features of the VBA Editor window
- create procedures in VBA
- create and use variables
- create and work with user-defined functions in VBA
- write code to manipulate Excel objects
- use a range of common programming techniques
- create a custom form complete with an assortment of controls
- create code to drive a user form
- create procedures that start automatically
- write a variety of error handling routines
You need a working knowledge of Excel in order to attend this course. You should already be familiar with creating and editing workbooks, entering formulas, copy and pasting, and formatting data.
Price for one delegate: £450 + VAT (discounts available for multiple bookings)
Webinar delivery is supported by the ECMS. By enrolling on this event you are agreeing to share your data with the ECMS and with the Training Provider. The ECMS is required to collect and share your data in order to comply with its contractual obligations. For further information please refer to the ECMS Privacy Notice @ ECMS Privacy Notice
Enable Technology Ltd is a Training Associate of the ECMS.