Course
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.Certified Excel Expert in Controlling course
Local. Digital - your choice: You have the option of choosing between face-to-face or live online for almost all course modules.
Compulsory seminar 1 (attendance or live online)
2 days
Excel tools in controlling: formulas and functions
Compulsory seminar 2 (attendance or live online)
2 days
Excel tools in controlling: Getting started with VBA programming
Compulsory seminar 3 (attendance or live online)
2 days
Business Intelligence with Excel
Select a training
Elective seminar (attendance or live online)
2 days
Excel for controllers
Elective seminar (attendance or live online)
2 days
Excel tools in controlling: in-depth VBA programming
Examination
E-exam: Certified Excel expert in controlling
As part of three mandatory seminars and one elective seminar, you will qualify as an Excel expert in controlling in 8 days. The content and topics are systematically coordinated and complement each other. By selecting the elective seminar, you can decide for yourself at which Excel knowledge level you start your qualification. You decide when and where you complete which course module within two years. You can book the modules individually or at an affordable package price.
After successfully passing the final exam, you will receive the "Certified Excel Expert in Controlling" certificate from the Haufe Akademie and the Mannheim School of Management (HdWM).
Learning environment
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
Your benefit
- 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.
Recommended for
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".
Final examination
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.
Further recommendations for "Certified Excel Expert in Controlling"
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 internally
Pricing upon request
- Customized training courses according to your needs
- Directly at your premises or online
- Cost advantage from 5 participants
- We contact you within 24 hours (Mon-Fri)
8 days
3 compulsory seminars, 1 elective seminar and e-exam
In-person or Online
with certificate
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.
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 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
