Microsoft VBA for Excel
Overview:
This course is designed for Excel users who would like 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
What You Can Expect from CTO with onsite, customised Microsoft VBA for Excel Courses
When partnering with CTO for training in your business, you can anticipate:
- A chance to address specific skill gaps or develop process improvements through a clearer understanding of what your software tools can accomplish
- Highly skilled training professionals who have the well-developed skills necessary for advancing your understanding of Excel. Our facilitators are continually developing new skills and refining their existing abilities. Our clients find that our trainers are very adept at sharing their learning with others, and we’re confident you and your staff will enjoy the experience just as thoroughly.
- Training that goes right to the heart of what you need to learn, rather than spending valuable hours of your time recapping things you already understand. Our courses presume that those involved have a certain level of experience with Excel.
About Corporate Training Options
With nearly 30 years of experience in the computer training industry, CTO has presented high-value training for our clients across many industries. To develop new strengths through training, we equip your team with the tools necessary for enhanced productivity and long-term success. Discover how we can help you with Microsoft VBA for Excel Introduction training for your team. Call us today – 1300 667 660.
Course Details:
Prerequisites:
Programming in VBA – Using Microsoft Excel assumes the learner has a good knowledge of working with Excel.
The learner should be able to create and edit workbooks, enter formulas, copy, paste, and format data. The learner must also have a general understanding of personal computers and the Windows operating system environment and be able to use File Explorer to locate and copy files.
Learning Outcomes:
At the completion of this courseware participants will be able to:
- Create recorded macros in Excel
- Use the macro recorder to create a variety of macros
- 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
Microsoft VBA for Excel – Online Training
Online Training – Private Courses
You can book private, customised, online training for your organisation. To do this, please click on the Book Online Training button on this page.
The Microsoft VBA for Excel Online Training Workshops are presented by a CTO Facilitator, in a live virtual classroom.
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,650 | per day |
| 4-8 trainees | $1,980 | per day |
| Each additional trainee | $154 | per day |
