Bootcamp: Microsoft Visual Basic for Applications (VBA) («BCVBA1»)

The bootcamp consists of three modules:

VBA Basics

• Introduction
• The Macro Recorder
• VBA Basics
• More VBA
• Built-in VBA functions
• Error handling

VBA deepening for Excel

• 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.