With certificate
Upon successful completion, you will receive a recognized certificate that documents your newly acquired skills.
Certified Excel expert in controlling
Certified Excel know-how for effective controlling
This course is held in German.
Excel is the tool of choice for controllers to solve various tasks. This course covers everything from the basic techniques for working efficiently with Excel to the development of data models, the creation of KPIs and the concise visualization of analysis results in interactive reports. As part of the individual seminars, the course offers a sound introduction to all data analysis tools relevant to controlling. These include Excel calculation functions, pivot tables, Power Query, Power Pivot and the most important visualization tools.
Certified by the Hochschule der Wirtschaft für Management (HdWM), Mannheim
This further training was designed in cooperation with the Mannheim University of Applied Management Sciences and follows the university's quality standards in terms of overall concept, content, trainers and examinations. This means that attendees benefit from high-quality qualifications with guaranteed topicality, high practical relevance and excellent trainers.Recommended procedure
Required modules
1
Excel tools in controlling: Getting started with VBA programming
2 days
in one place and online
2
3
Excel tools in controlling: formulas and functions
2 days
in one place and online
Elective modules
Exam
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
- With this course, you will acquire all the relevant Excel skills you need in your day-to-day controlling work and develop concrete solutions for various issues.
- You will learn how complex functions and formulas can make your work easier.
- With suitable functions and formulas, you can prepare your controlling results better and present them more effectively.
- You will learn how to make function-controlled changes to your controlling reports in fractions of a second and how to create innovative reports that immediately present the latest results to managers without any knowledge of Excel.
- You will learn what you need to automate your Excel applications.
- You will receive an easy-to-understand and practical introduction to programming, VBA (Visual Basic for Applications) and macros from an experienced controller.
- You will familiarize yourself with the basics of data analysis and learn how to use Microsoft BI tools.
- You will learn how to use the tools to create data models, calculate key figures, prepare reports, analyze and visualize data.
- You document your learning success: After the qualification, you can take an e-exam and receive a certificate from the Haufe Akademie and the Hochschule der Wirtschaft für Management (HdWM), Mannheim "Geprüfte:r Excel-Expert:in im Controlling" in addition to the confirmation of participation according to the exam result.
Specialists and qualified employees with controlling and cost accounting tasks who have previously only used basic Excel functions.
A good knowledge of Excel is required to complete the mandatory seminars. Please check whether you have the prior knowledge required for the compulsory seminars. The required basic knowledge is also taught in the elective seminar "Excel for controllers".
Examination requirements
The prerequisite for taking the e-exam is successful participation in the three compulsory seminars "Excel Tools in Controlling: Formulas and Functions", "Excel Tools in Controlling: Getting Started with VBA Programming" and "Business Intelligence with Excel" as well as an elective seminar. We recommend taking the exam shortly after attending the last seminar.
Exam contents
The contents of the compulsory seminars are relevant to the examination. You will work on practical tasks and knowledge questions.
Form of examination
The e-exam is an online-based exam on your PC and lasts 60 minutes. You can take the exam in the comfort of your own home at a time of your choosing. The exam is based on single or multiple-choice questions. Once you have completed the exam, you will immediately see whether you have passed or failed. The certificate will be sent to you afterwards.
Your Benefits at a Glance
Open Badges
Add your digital badge to career networks and show what you can do.
Fully covered
For on-site events, this includes:
- a shared lunch on each full- training day
- refreshments during breaks
All learning materials at a glance
Once you have registered, you will find all relevant information, services, and course materials for your program in your app or online learning environment.
Further training together
Booking number
3772
3772
€4,690
plus VAT
8 days
3 compulsory seminars, 1 elective seminar and e-exam
with certificate
German
Please book the training course here. You can select the individual components of the course and the payment method in the shopping cart.
Train several employees
Price upon request
8 days
3 compulsory seminars, 1 elective seminar and e-exam
In Person or Online
Appointment scheduled on an individual basis
with certificate
- Customized training courses
- Direct application in practice
- Efficient use of time and resources
100% non-binding inquiry
Feedback within 24 hours
Or schedule an appointment and get personalized advice
Arrival via Deutsche Bahn
Travel at reduced rates by booking via the learning environment.
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.
3,600+ continuing education courses
690,000+ apprentices per year
Over 95% positive reviews
2,600+ trainers and coaches
19,000+ training courses held per year
Call us or send an email
Do you have any questions?
We are there for you Monday to Friday 8:00 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
Certified Information Security
Saved to wish list
Text saved to the clipboard