Disclaimer: This e-learning course was fully translated with AI support. Subtitles are based on the original German version (see here). The video modules display the German user interface, but the spoken language is English, including English captions. Minor discrepancies may occur, with the German version being the authoritative reference.
Are you ready to take your Excel VBA knowledge to the next level? With our course “Learn Advanced Techniques in Excel VBA,” you will take your skills to a new level.
NOTE:
To access your e-learning course with us, you need a Golem Career World customer account. So, to purchase your e-learning course, simply use the same email address that you want to use to access the e-learning course. Your customer account is, of course, free of charge.
What you will learn in this course:
- Accessing developer tools and macro input windows
- Designing a database in Excel with your own buttons
- Sorting and filtering data
- Starting the search function with VBA
- Calling macros when opening, closing, and saving the file
- Responding to changes in the workbook
- Querying user input
- Adding input elements
- Backing up data in the database
After your purchase:
After purchasing the e-learning course, you have three options for accessing the course:
a.) Log in to your Golem Career World account and click on the corresponding order. Then simply click on “view online” and you're ready to go.
b.) You will receive an order confirmation after purchase. Simply click on “View order” and you will be redirected to the checkout page, which will then display the “Go to my courses” button. Click on this button and you're ready to go.
c.) Immediately after purchase, you can click on this link: “My e-learning courses”
Course details:
This course is specifically designed for advanced VBA beginners. You will learn how to access the developer tools and the macro input window, how to design a database in Excel with your own buttons, how to sort data automatically, how to start the search function with VBA, how to release all filters at the touch of a button, and how to back up the data in the database.
In addition, we will show you how to call macros when opening, closing, and saving the file, how to respond to changes in the workbook, how to ask the user for input, and how to add input elements.
We hope you enjoy this e-learning course and wish you every success!
Course content: 19 lessons – total duration approx. 2 hours:
1 Accessing the developer tools and macro input window
2 Designing a database in Excel with custom buttons
3 Automatic sorting of data
4 Sorting a second field
5 Starting the search function with VBA
6 Releasing all filters at the touch of a button
7 Saving data in the database
8 Automatically responding to changes in the workbook
9 Calling the macro when opening the file
10 Calling the macro when closing the file
11 Calling the macro when saving the file
12 Another way of calling the macro after saving
13 Call macro as soon as the worksheet is used
14 What if the user jumps to another location?
15 Respond to calculations
16 Respond automatically to other changes
17 Ask the user for input
18 Add the input elements
19 We test the input mask
