Excel – Targeted use of pivot tables

Program Language
This program will be conducted in German.

Who Should Attend
The pivot table training is aimed at anyone who already has a basic knowledge of Microsoft Excel and would like to expand their skills in the area of data analysis and evaluation. If you regularly work with large amounts of data and want to make your evaluations more efficient, flexible, and clearer, this training will provide you with the necessary know-how about pivot tables.
Solid basic knowledge of Excel is required to participate (e.g., confident use of the program interface, basic formulas, and functions).

What You Learn
The course teaches all important aspects of pivot tables in a practical and understandable way. The training covers the following topics:

• What are pivot tables and what are they used for?
• Creating and customizing pivot tables
• Best practice data sources
• Grouping, filtering, and sorting data
• Pivot charts: Visualizing evaluations
• Tips and tricks for efficient use of pivot tables

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

Your Benefits
In the future, you will

• Efficiently create and manage complex data models and reports in Power BI
• Apply advanced DAX functions and role concepts
• Design interactive and dynamic reports
• Use Power BI optimally in teams and with SharePoint