Course package
BCVBA1
Bootcamp: Microsoft Visual Basic for Applications (VBA) («BCVBA1»)
In this 5-day Microsoft Visual Basic for Applications (VBA) bootcamp, you will learn how to use VBA efficiently for your needs and optimise your processes in Microsoft Office across the board.
Vendor code
VBGLN, VBXLS
Duration
5 days
Price
3'700.–
Course documents
VBA courseware
Course facts
- Expanding VBA knowledge from the basics to comprehensive programming in Microsoft Office
- Deepening VBA knowledge in Microsoft Office applications to a large extent
- Understanding the object models of Excel and Word
- Expanding and customising the ribbon and backstage view
The bootcamp consists of three modules:
- Introduction
- The Macro Recorder
- VBA Basics
- More VBA
- Built-in VBA functions
- Error handling
- The Excel Object Model
- Working with cells and ranges
- Working with tables and workbooks
- Error handling
- Event-driven programming
- Automate with Excel
- Forms
- Text files
- Improving the duration and stability of the programme
- Practical Tips and tricks
Microsoft Office programming with VBA
- Getting to know and repeat object models
- Early Binding vs. Late Binding
- Foundation: Access
- Foundation: Excel
- Foundation: Word
- Ribbons and Backstage
- Tips and Tricks
This course is delivered in a classroom setting and is supported by additional learning content such as webinars or e-learning.
This course is aimed at VBA programmers and developers who want to learn Visual Basic for Applications (VBA) from the ground up and extend and deepen their knowledge (regardless of the Microsoft Office application).
Very good knowledge of Microsoft Office, especially Microsoft Excel, is required.