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 you basic working techniques for working efficiently with Excel in controlling. You will gain 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 of choosing between face-to-face or live online for almost all course modules.
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 specialist Specialist in Controlling in four days. The content and topics are systematically coordinated and complement each other. We recommend attending 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 choice. After successfully passing the final exam, you will receive the Haufe Akademie certificate "Certified Excel specialist in Controlling" according to the exam result.

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 important Excel skills that you will 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 to 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 to automatically import external data from various sources into your evaluations and how to modify it so that you can use the processed data to evaluate your reports 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 from the Haufe Akademie in addition to 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 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 close to 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

Travel at reduced rates by booking via the learning environment.

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 Monday to Friday 8:00 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.