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
36175
Venue
Online
.svg)
2 dates
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
36175
Venue
Online
2 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
This two-day training is aimed at users and developers who have a basic knowledge of VBA and want to further automate tasks and processes in Excel. You will learn many methods for automating your Excel workbooks.
Contents
1. the Excel object model
- The object hierarchy
- The most important Excel objects
- The most important enumeration objects
- References to the active element
2. working with cells and areas
- Cell and area addressing
- The Range object
- The Cells method
3. working with tables and workbooks
- Addressing tables and workbooks
- Managing workbooks
4. error handling
- Catching errors
- Using Visual Basic test aids
5. event-controlled programming
- Event procedures on the table and workbook levels
- Auto macros
6. automation with Excel
- Simple controls
- ActiveX controls
- Calling up and controlling Excel and dialog windows
- Save user settings in the registry
- Merge data from multiple tables
- String functions
7. forms
- Use of UserForms
- Definition and programming of control elements in forms
- Importing data into forms
- Save form data
8. text files
- Differentiate between types of text files
- Reading and writing text files
- Importing text files into Excel spreadsheets
9. improvement of runtime and program stability
- Screen refresh
- Control of the recalculation
10. tips and tricks from the field
Your benefit
- Deepen your VBA knowledge in Excel
- Create your own formulas and dialogs
- Programming the fully automatic creation of reports
- Confident and independent solution of applications from daily practice with VBA in Excel
- Understanding of the Excel object model
- Stable and secure implementation of your programs
trainer
Daniel Lisak
Jörn Schramm
Methods
This course consists of training training and is led by a 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
Power users, users and developers who work with Excel, already have previous knowledge of VBA and would now like to deepen their knowledge of Excel programming. No VBA basics are taught in this course. Very good knowledge of Excel and VBA is required.
.svg)
