training

4.7

(147)

Microsoft Excel: Using pivot tables and filters professionally

Favorite Share Open as PDF (German) PDF FILE

Content

trainer

Reviews

Events

Contact

This training is held in German.

Working in Microsoft Office: Do you want to analyze your data in Excel quickly and efficiently in the future? Learn how to use pivot tables and filters. 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 results. Benefit from practical tips and tricks for practical use.

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 qualification measure after you have registered.

Your benefit

You will learn how to generate pivot tables from Excel data.
You can group and evaluate 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

Antonio Argibay da Silva

Methods

experts, practical tasks and exercises.

Please use a notebook with the Microsoft Office program installed (version 2016/2019/2021/O365).

We recommend that you work with two screens so that you can participate in the training in the best possible way.

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.

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.

Further recommendations for "Microsoft Excel: Using pivot tables and filters professionally"

Microsoft Excel: Basics course

Microsoft Excel: Advanced course

Microsoft Excel: Using formulas and functions efficiently

Microsoft Excel: Working with large tables

Excel tools for assistance

Excel tools in controlling: formulas and functions

Business Intelligence with Excel

Professional project controlling with Excel

Excel basics in accounting

Attendees comments

"I particularly liked the fact that it was explained very well and clearly, even though it is not an easy topic."

Kai Kraus

StepStone GmbH

Seminar evaluation for "Microsoft Excel: Using pivot tables and filters professionally"

4.7 from 5

with 147 reviews

training content:

4.5

Content comprehensibility:

4.8

Practical relevance:

4.3

Trainer expertise:

4.9

Participant orientation:

4.9

Method variety:

4.7

Joint online training

Booking number
31223

€ 660,- plus VAT

Details

1 day

Online

8 Events

German

Events

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)

1 day

In-person or Online

Request

Start dates and details

09.07.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 09.07.2025

09:00 am - 5:00 pm

22.09.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Monday, 22.09.2025

09:00 am - 5:00 pm

08.10.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 08.10.2025

09:00 am - 5:00 pm

03.11.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Monday, 03.11.2025

09:00 am - 5:00 pm

26.11.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 26.11.2025

09:00 am - 5:00 pm

10.12.2025

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 10.12.2025

09:00 am - 5:00 pm

20.02.2026

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Friday, 20.02.2026

09:00 am - 5:00 pm

25.03.2026

Live-Online

Details

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 25.03.2026

09:00 am - 5:00 pm

Sufficient places are still free.

Don't wait too long to book.

Fully booked.

Training is guaranteed to take place

The next booking ensures this course will take place

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Details

1 day

Limited number of participants

Booking number: 31223

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Details

1 day

Limited number of participants

Book later

You are welcome to make a non-binding advance reservation.

Book in advance

No suitable date?

You are welcome to be notified by e-mail as soon as new dates are released.

e-mail notification

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