Course

Certified specialist specialist in controlling

Specific expertise for Excel applications in controlling

This course is held in German.
Excel is the tool of choice for controllers to solve various tasks. This course teaches basic working techniques for working efficiently with Excel in controlling. You will receive a sound introduction to Excel calculation functions, pivot tables, data import and data cleansing using Power Query for fully automated data analysis. This course lays the foundation for data evaluation and analysis with Excel in Controlling.

Certified specialist specialist in controlling

34.5 hours
Local. Digital - your choice: You have the option to choose between attendance or live online for the mandatory seminars.
E-learning:
approx. 1.5 hours
Controlling basics
Compulsory seminar 1:
Presence or live online
2 days
Excel for controllers
Compulsory seminar 2:
Presence or live online
2 days
Power Query: Extract and transform data to Excel and Power BI

E-test:
Online
approx. 1 hour.
Certified specialist specialist in controlling

As part of the course, you will complete an e-learning course and two compulsory seminars and qualify as a certified Excel specialist in controlling in four days. The content and topics are systematically coordinated and complement each other. We recommend that you attend the seminars in the order shown.

You decide when and where you complete which training within two years. You can book the seminars individually or at an affordable package price.

After attending the seminar, you can take the e-exam at a time of your choosing. After successfully completing the final exam, you will receive the certificate of Haufe Akademie “Certified Excel specialist in controlling".

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

With this course, you will acquire important Excel skills that you need in your day-to-day controlling work, develop concrete solutions for various issues and lay the foundation for your Excel skills as a controller.

  • As a controller , you will receive valuable tips and tricks on which feature and which function is best suited for which tasks in controlling.
  • You will learn how you can improve the structure, clarity, error-proneness and performance of your Excel solutions.
  • By using Power Query professionally, you will be able to improve your work efficiency in the time-consuming tasks of data preparation in Excel and Power BI.
  • You will learn how you can automatically import external data from various sources into your evaluations and how you can modify them so that you can evaluate your reports with the prepared data in just a few simple steps.
  • You will get to know the extensive toolbox of Power Query, from simple data changes such as splitting data into several columns to complex data transformations.
  • You will get to know Power Query by means of many practical examples and can thus apply what you have learned directly in practice.   
  • You document your learning success: After the qualification, you can take an e-exam and receive a certificate of the Haufe Akademie .

Recommended for

Specialists and qualified Employees with controlling and cost accounting tasks who have previously only used basic functions in Excel.

Basic knowledge of Excel is a prerequisite for participation. Special knowledge of Excel 365 is not required.

Final examination

Examination requirements

The prerequisite for passing the e-exam is successful participation in the two compulsory seminars.

We recommend that you take the exam shortly after the last seminar you attended.

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.

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.

Read more

Further recommendations for "Certified specialist in Controlling"

Further training together
Booking number
35328
€ 2.790,- plus VAT
approx. 4 days
2 compulsory seminars, e-learning 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)
approx. 4 days
2 compulsory seminars, e-learning and e-exam
In-person or Online
with certificate

Arrival via Deutsche Bahn

Train tickets to this event starting at € 51,90.

Read more

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.

Stephanie Göpfert

Head of Customer Service

*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.