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.
Automate and personalize Excel - with VBA! Learn how to take Excel to a new level with Visual Basic for Applications (VBA). Automate tasks, optimize processes and develop custom applications - hands-on and step-by-step.
NOTE:
To access your e-learning course with us, you need a Golem Career World customer account. To purchase your e-learning course, simply use the same e-mail 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
- Understand and use macros and VBA basics
- Efficiently automate and customize Excel workbooks
- Create user-friendly dialog boxes and forms
- Program dynamic interactions and event controls
- Master error handling and optimized data management in Excel
Requirements
- Basic knowledge of Excel (tables, formulas, basic functions)
- No prior knowledge of VBA required - everything is explained step by step
- Curiosity to rediscover Excel and automate processes
Who is the course suitable for?
- Excel users who want to deepen and automate their knowledge
- Data analysts and Office professionals who want to make processes more efficient
- Beginners in VBA who are looking for a practice-oriented introduction
Course details:
The Excel VBA Advanced course gives you the skills to use Excel more efficiently and in a more versatile way. You will learn how to use VBA and macros to automate tasks, develop custom applications and customize Excel's user interface. The course covers basics such as creating macros and using event controls, but also covers advanced topics such as error handling, interaction options and user-friendly forms. The goal is to provide you with tools to use Excel as a powerful and personalized tool - whether for data management, analysis or optimizing work processes.
After your purchase:
a.) Log in to your Golem Career World account and click on the relevant order. Then simply click on "View online" and off you go.
b.) You will receive an order confirmation after your purchase. Simply click on “View order” and you will be redirected to the checkout page, which will then show you the button “To my courses”. Click on this button and off you go.
c.) You can click on this link directly after purchase: "My e-learning courses"
d.) Have you used the price advantage and purchased access for several people? Please inform all authorized persons that a free Golem Karrierewelt account is required to access the e-learning courses. Those entitled to access will automatically receive an invitation to their account from us and must activate it once in order to access the courses.
Course content - 2 sections - 26 lessons - 3 hrs 44 mins Total duration
Chapter 1: Review VBA for Excel
1. What to expect in the course
2. Discover VBA - origins and basics
3. Customize the Excel interface and manage file paths
4. Use macros efficiently - understand absolute and relative references
5. Create a custom Excel database with buttons
6. Automatically sort data in Excel
7. Sort multiple data fields in Excel
Chapter 2: Advanced functions for automation
8. Controlling print events in the workbook with VBA
9. Programming reactions to double-clicks in the workbook module
10. Setting up reactions to right-clicks
11. Automatically recognizing and processing changes in worksheets
12. Reacting to cell selection changes in the workbook
13. Automatically creating actions for new worksheets
14. Monitoring hyperlink usage in workbooks with VBA
15. Dynamic reactions to cell selection in the worksheet
16. Automating actions when activating worksheets
17. Execute macros when exiting a worksheet
18. Event handling before double-clicking cells
19. Chained events and hyperlink navigation in VBA
20. Basics of user interaction - introduction to dialog boxes
21. Advanced use of MessageBox in VBA
22. Query user input - InputBox versus MessageBox
23. Error handling - integrate automatic messages in VBA
24. Add checkboxes to custom forms
25. Group radio buttons - organize radio buttons with frames
26. Create complex dropdown lists with ComboBox and ListBox
