The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
.svg)
.svg)
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36174
Venue
Online
.svg)
4 dates
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36174
Venue
Online
4 dates
€ 1.290,–
plus VAT.
€ 1.535,10
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
Learn the fundamentals of Visual Basic for Applications (VBA) programming in Microsoft Office applications in this two-day training . The focus is on VBA in Excel, although other Office apps are also touched on.
Contents
1. introduction
- Basic concepts
- VBA use - When is VBA suitable?
- Examples for the use of VBA
- Security settings
- The Visual Basic Editor
2. the macro recorder
- The recording
- Save macro
- Analyzing a recorded macro
- Execute a recorded macro
- Fix errors, deactivate/skip lines of code
3. vba basics
- Basic syntax in modules, procedures and functions
- Upper and lower case
- The key word WITH
- Comments
- Use of variables
- Constants
- Option Explicit
- Naming conventions
4. even more VBA
- Procedures
- Functions
- The MsgBox
- The direct window
- Local and global variables
- Arrays or fields
- IF...THEN...ELSE
- SELECT...CASE
- InputBox
- Loops FOR...NEXT, WHILE...WEND, DO...LOOP
- The Project Explorer
5. built-in VBA functions
- Text functions
- Date functions
- Mathematical functions
- Information functions
- Convert data types
6. error handling
- Handling runtime errors
- Troubleshooting (debugging)
Your benefit
- Optimal introduction to Office programming
- Confident implementation of what you have learned thanks to a clear structure and systematic approach
- Acquire solid basic knowledge
- Translating workflows and processes into the VBA programming language in order to tap into a high level of automation potential
- Mastering the VBA development environment and the most important tools for program creation and troubleshooting
trainer
Daniel Banholzer
Daniel Lisak
Methods
This course consists of training training and is led by a:m trainer who:supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
Final examination
Recommended for
This course is aimed at power users, PC administrators and developers who want to get started with the automation of processes in Microsoft Office applications. No programming knowledge is required. Very good knowledge of Word and Excel is required.
.svg)
