training training
This training is held in German.
Have you already gained some experience with the automation of controlling tasks? In this training , you will learn how to expand your VBA automations, make them more efficient and integrate them better into your Office environment. You will learn how to create meaningful controlling evaluations even more efficiently and within seconds at the touch of a button and receive comprehensible and practical solutions. Increase your VBA skills and improve your ability to implement your own ideas in VBA.
Contents
Direct implementation on your own laptop!
Programming techniques
- In-depth conditional calculations.
- Deepening the construction of iterations.
Knowledge for efficient programming
- Programming of arrays.
- Modularization.
Thinking outside the box
- Working with and importing file formats.
- Introduction to OLE automation.
- Cooperation with databases.
Design professional applications
- Dynamize user-defined dialogs.
- Use of document properties.
Extend Excel functions
- User-defined table functions.
- Controls on a worksheet.
VBA practical knowledge and examples
- A key practical example is used to illustrate the content taught.
- Further examples present effective solutions for typical problems in controlling.
The above content is implemented in an add-in with important business management functions that is immediately available to participants.
Please bring your own laptop to the training . You can find more detailed installation instructions under Methods.
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- After completing this seminar, you will have a sound knowledge of VBA programming, will be able to create efficient code and will be able to further expand your knowledge on your own initiative.
- You have important knowledge for creating modular solutions and can handle control constructs with confidence.
Methods
Lecture, presentation, interactive work, exercises, discussion.
A key practical example is used to illustrate the content taught.
You will need your own laptop to participate.
Please observe the following installation instructions:
Microsoft Office Professional Plus from 2016 or Microsoft Office 365 with permission to create and execute macros, edit whitelists and create and initialize add-ins. NotePad++ should also be installed. Please check in advance that VBA is enabled.
Recommended for
Specialists or qualified Employees with controlling, business intelligence or cost accounting tasks who want to deepen their basic knowledge and get to know an efficient programming style.
For this training , knowledge from the training "Excel tools in controlling: Getting started with VBA programming" is required.
Ideally, participants will have attended the beginners' course and gained a few weeks' experience in VBA programming.
Attendance conditions
Good knowledge of Excel and basic knowledge of VBA programming corresponding to the contents of the seminar "Excel Tools in Controlling: Getting Started with VBA Programming" are required. Find out here which Excel skills are required for this training . The training is suitable for you if you are allowed to use VBA applications.
Further recommendations for "Excel Tools in Controlling: Advanced VBA Programming"
Excel tools in controlling: formulas and functions
Excel tools in controlling: Getting started with VBA programming
Business Intelligence with Excel
Interactive and dynamic dashboards with pivot in Excel
Power BI: The modern business intelligence tool
Power Query: Extract and transform data to Excel and Power BI
Attendees comments
"As always, well-prepared and well-chosen lecturer. He presented the topic in an exciting way with his relaxed manner."
Max Schäfer
Stadtwerke Reutlingen GmbH
Seminar evaluation for "Excel tools in controlling: in-depth VBA programming"
4.3 from 5
with 98 ratings
training content:
4.2
Content comprehensibility:
4.2
Practical relevance:
4
Trainer expertise:
4.6
Participant orientation:
4.5
Method variety:
4.3
On-site training together
Booking number
2877
2877
€ 1.490,-
plus VAT
2 days
in 2 locations
2 Events
German
Joint online training
Start dates and details
03.07.2025
Cologne
Booking number:
2877
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Thursday, 03.07.2025
09:00 am - 5:00 pm
Friday, 04.07.2025
09:00 am - 5:00 pm
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
15.12.2025
Live-Online
Booking number:
32989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Monday, 15.12.2025
09:00 am - 5:00 pm
Tuesday, 16.12.2025
09:00 am - 5:00 pm
26.02.2026
Live-Online
Booking number:
32989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Thursday, 26.02.2026
09:00 am - 5:00 pm
Friday, 27.02.2026
09:00 am - 5:00 pm
16.06.2026
Live-Online
Booking number:
32989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Tuesday, 16.06.2026
09:00 am - 5:00 pm
Wednesday, 17.06.2026
09:00 am - 5:00 pm
30.09.2026
Berlin
Booking number:
2877
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Wednesday, 30.09.2026
09:00 am - 5:00 pm
Thursday, 01.10.2026
09:00 am - 5:00 pm
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Booking number:
2877
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Details
2 days
Limited number of participants
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Booking number:
32989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Details
2 days
Limited number of participants
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.
About us – The Haufe Akademie
Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.
Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.
A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.
Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.
2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email
Do you have any questions?
We are there for you Mon - Fri 8 a.m. - 5:00 p.m.
*Mandatory fields
FAQs
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Haufe Akademie GmbH & Co. KG
Munzinger Str. 9
79111 Freiburg
Munzinger Str. 9
79111 Freiburg
A brand of
The company
About our offer
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
Special offers
Contact & Support
