Excel – Expanding and extending functions

Program Language
This program will be conducted in German.

Who Should Attend
The Excel advanced training is aimed at users who have already learned the basics of Excel or have already completed the Excel basic training and want to take their knowledge to the next level. Advanced functions are taught, which will make your everyday work much easier, regardless of your professional expertise. The course is based on the knowledge and skills taught in the Excel Basic training (Please note: We differentiate between the basic course and the beginner course).

What You Learn
The course teaches the most important functions for everyday work and covers a wide range of features. The training covers the following topics:

• Advanced functions (Mathematical, Statistical, Date, Logic, Lookup)
• Relative & absolute cell references
• Deepening conditional formatting
• Pivot tables
• Pivot charts
• Dashboards with the help of Pivot

How You Learn
This is an interactive course with practical units in which you can directly apply what you have previously learned and thus better memorize it. The course takes place virtually via MS Teams or on site. A laptop with Excel is required, a mouse is recommended.

Your Benefits
In future, you will

• get the necessary tools to work faster, more efficiently and more comfortably with Excel
• have an overview of the possibilities of Excel that make your daily work easier