Learn Microsoft Programming in VBA using Excel
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.
To undertake this course, participants must already have a good knowledge of Microsoft Excel – including: editing workbooks, entering formulas, copying, pasting and formatting data.
Glass Rock Solutions provides this training either as virtual (online) training or in-person (face-to-face).
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
Book now
Please fill out the form below and someone from our team will be in touch within the next 48 hours to get your training started.
GLASS ROCK CLIENT TESTIMONIALS
GLASS ROCK CLIENT STORIES
Simone Heaperman - Landcom Program Manager
When Simone Heaperman, the program manager, picked up the phone to speak with Preetie Shehkkar at Glass Rock Solutions, she had much to address and set right.
Jane Hodgen - Tata Consultancy Services
Tata Consultancy Services, a global technology leader with 450,000 employees worldwide, expect the best from anyone who works for them.
Stuart Freer - University of New South Wales
When Stuart Freer came to Australia, he was recruited as the Director, IT Service Delivery and Infrastructure, at the University of New South Wales.
WE ARE HERE TO HELP
CONTACT US TO FIND OUT HOW
Melbourne Office
Level 23, Collins Square Tower 5
727 Collins Street,
Melbourne Victoria 3008
Sydney Office
Australia Square, Level 33
264 George Street,
Sydney NSW 2000
We acknowledge the First Australians as the traditional custodians of this continent. We pay our respect to the elders of the community, past, present and future.