Contents
- Automate the data import with Power Query.
- Get to know the requirements for the systematic structure of workbooks.
- Use calculation functions to select partial datasets (XVERWEIS() etc.).
- Perform alternative calculations with calculation functions (FIRST VALUE(), IF() etc.).
- Protect data selection with control elements against input errors.
Please note:
The module is part of the webinar series "Excel snacks in controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.
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
- You will receive a brief and concise overview of the topic and compact knowledge on how to set up costing models that you can use for recurring reports.
- You will learn how you can reduce the effort involved in reporting through the interaction of workbook structure, dynamic calculation functions and control elements.
- You will learn how to prevent incorrect entries when selecting data by using control elements.
- The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.
Methods
Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.
Recommended for
The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner.
Start dates and details

Monday, 02.06.2025
11:00 am - 12:30 pm

Wednesday, 17.09.2025
11:00 am - 12:30 pm