Certified Excel expert in controlling

Certified Excel know-how for effective controlling

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

Further information

Compulsory seminar 2 (attendance or live online)

2 days

Excel tools in controlling: Getting started with VBA programming

Further information

Compulsory seminar 3 (attendance or live online)

2 days

Business Intelligence with Excel

Further information

Select a training

Elective seminar (attendance or live online)

2 days

Excel for controllers

Further information

Elective seminar (attendance or live online)

2 days

Excel tools in controlling: in-depth VBA programming

Further information

Examination

E-exam: Certified Excel expert in controlling

Further information

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.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Further training together

Booking number
3772

€ 4.690,- plus VAT

Details

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

Request

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,500+ further training

620,000+ apprentices per year

Over 95% positive reviews

2,600+ trainers and coaches

18,000+ training courses held per year

Call us or send an email