training training
This training is held in German.
Are you annoyed by tedious routine tasks in controlling? Excel VBA is a powerful tool for a variety of applications such as automation of recurring tasks, financial modeling and analysis, data validation, development of user-defined functions and formulas, creation of dynamic dashboards. The focus of the seminar is on the automation of Excel tasks. You will receive an easy-to-understand and practice-oriented introduction to VBA programming. This knowledge will save you time and increase the accuracy of your decision templates.
Contents
Direct implementation on your own laptop!
Get to know the tool for automation
- Record or program macros.
- The VBA editor.
- The Excel object model.
The first steps in the right direction
- Routines (procedures and functions).
- Variables, constants and data types.
- Simple control structures.
- Runtime errors and error handling.
Manage information for controlling tasks
- Create and integrate dialogs.
- Use built-in dialogs.
Safe handling of the most important objects
- Create, open, save and close folders.
- Working with spreadsheets.
- Working with cells and areas.
Controlling meets VBA programming
- Module and routine design.
- Introduction to add-ins.
VBA practical knowledge and examples
- Central practical example: Editing and preparing an import file. This task includes opening the file in Excel and cleaning it up using VBA, converting it into a reportable format and finally saving it under a new file name. This central practical example is used to illustrate the content taught.
- Further examples present effective solutions for typical problems in controlling.
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
- In an easy-to-understand and practical introduction, you will learn the basics of a clean, clear, maintainable and comprehensible programming style that leads to stable solutions.
- After successfully completing this course, you will understand how VBA code works, know the necessary basics of VBA programming and be able to develop smaller solutions independently.
- You know the most important ways of working with Excel objects to carry out analyses, create reports or automate processes.
Methods
Lecture, presentation, interactive work, exercises, discussion.
The content taught is illustrated using a key practical example.
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 automate routine activities in Excel and would like to learn the basics.
participants should have sufficient knowledge of Windows and solid knowledge of Excel - as taught, for example, in our training "Excel Tools in Controlling: Formulas and Functions" - and have gained sufficient experience in the use of Excel. Programming skills are not required.
Attendance conditions
Good knowledge of Excel is required. No basic knowledge of VBA programming is required. Find out here which Excel skills are required for this training . The required basic knowledge is also taught in the"Excel for controllers" training course. The training is suitable for you if you are allowed to use VBA applications.
Further recommendations for "Excel Tools in Controlling: Getting Started with VBA Programming"
Excel tools in controlling: formulas and functions
Excel tools in controlling: in-depth 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
"I liked the company-related approach to the newly acquired knowledge. It was not the first Haufe training and there has never been a problem and the seminars have all been great so far."
Carolin Heinzelmann
MGH GussTec GmbH & Co. KG
"I liked Mr. Seelhöfer's patience and calmness. The content was conveyed very well."
Simone Bittl
Max Planck Society
"I liked the structure for conveying the learning content."
Emmanuel Rosenkranz
Samson AG
"I liked the work on the examples and being able to participate myself. Very good knowledge transfer in a short time. Good structuring and time management."
Alexander Schmitz
BLG Handelslogistik GmbH & Co. KG Koblenz
"I particularly liked the practical examples. It was a good course and the seminars are of a high quality."
Daniel Richter
Reich GmbH
"I liked the trainer's explanation of VBA/Excel."
Sebastian Adenacker
AGES Maut System GmbH & Co. KG
"I was impressed by the course. Good structure, nice and relaxed atmosphere, good content."
Jan Heinrichsdorff
Zurich Group Germany
Seminar evaluation for "Excel tools in controlling: Getting started with VBA programming"
4.3 from 5
with 458 reviews
training content:
4.3
Content comprehensibility:
4.3
Practical relevance:
4.2
Trainer expertise:
4.7
Participant orientation:
4.1
Method variety:
4.2
On-site training together
Booking number
8691
8691
€ 1.490,-
plus VAT
2 days
in 3 locations
3 Events
German
Joint online training
Start dates and details
01.07.2025
Cologne
Booking number:
8691
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Tuesday, 01.07.2025
09:00 am - 5:00 pm
Wednesday, 02.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.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
17.09.2025
Live-Online
Booking number:
32230
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Wednesday, 17.09.2025
09:00 am - 5:00 pm
Thursday, 18.09.2025
09:00 am - 5:00 pm
26.11.2025
Hamburg
Booking number:
8691
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Wednesday, 26.11.2025
09:00 am - 5:00 pm
Thursday, 27.11.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.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
08.12.2025
Live-Online
Booking number:
32230
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Monday, 08.12.2025
09:00 am - 5:00 pm
Tuesday, 09.12.2025
09:00 am - 5:00 pm
19.02.2026
Live-Online
Booking number:
32230
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Thursday, 19.02.2026
09:00 am - 5:00 pm
Friday, 20.02.2026
09:00 am - 5:00 pm
09.06.2026
Live-Online
Booking number:
32230
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Tuesday, 09.06.2026
09:00 am - 5:00 pm
Wednesday, 10.06.2026
09:00 am - 5:00 pm
25.08.2026
Live-Online
Booking number:
32230
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Tuesday, 25.08.2026
09:00 am - 5:00 pm
Wednesday, 26.08.2026
09:00 am - 5:00 pm
28.09.2026
Berlin
Booking number:
8691
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Monday, 28.09.2026
09:00 am - 5:00 pm
Tuesday, 29.09.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.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Training is guaranteed to take placeThe next booking ensures this course will take place
Booking number:
8691
€ 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.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Booking number:
32230
€ 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
