The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
€660
plus VAT.
€785.40
incl. VAT.
Booking number
31223
Venue
Online
.svg)
13 dates
€660
plus VAT.
€785.40
incl. VAT.
Booking number
31223
Venue
Online
13 dates
plus VAT.
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
In cooperation with
Working in Microsoft Office: Do you want to analyze data in Excel quickly and efficiently? Learn how to use pivot tables and filters and you will see how easy and efficient it is to use a pivot table. With the database functions and pivot tables, you can analyze large amounts of data optimally and always maintain an overview. Automation gives you the time to deal with the content of the results. Benefit from practical tips and tricks for practical use.
Contents
- Overview of the possibilities of pivot tables.
- Create pivot tables.
- Sensible structure of structured lists.
- Filtering, sorting and grouping.
- Auto filters and special filters.
- Display/layout options.
- Calculations within pivot tables.
- Conversion and layout of an existing pivot table.
- Visualization in pivot charts.
- Analyze data with dynamic pivot tables and pivot charts.
- Professional tips and tricks.
- Tips and tricks for using Microsoft Copilot.
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
- You will learn how to generate pivot tables from Excel data.
- You can group and analyze pivot table data.
- You can create and edit pivot charts.
- You will learn why the pivot table and pivot charts are a powerful analysis tool in Excel.
- You can present your results well.
trainer
Goetz Sattler
Frans Parren
Antonio Argibay da Silva
Arno Burger
René Pukall
Methods
experts, practical tasks and exercises.
Please use a notebook with the Microsoft Office program (version 2016/2019/2021/O365) for Windows installed.
We recommend working with two screens so that you can participate in the training in the best possible way.
Final examination
Recommended for
Anyone who works with Microsoft Excel 2016/2019/2021/O365 or the corresponding Microsoft Office versions for Windows, already has basic knowledge of Microsoft Office Excel and would like to expand their knowledge of pivot tables and pivot charts.
.svg)