Microsoft Excel: Using pivot tables and filters professionally
4.7
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
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.
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.
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.
- Customized training courses
- Direct application in practice
- Efficient use of time and resources
Further recommendations for "Microsoft Excel: Using pivot tables and filters professionally"
You might also be interested in:
Ratings and feedback from our participants
Start dates and details
Thursday, 18.06.2026
09:00 am - 5:00 pm
Wednesday, 29.07.2026
09:00 am - 5:00 pm
Friday, 25.09.2026
09:00 am - 5:00 pm
Tuesday, 06.10.2026
09:00 am - 5:00 pm
Monday, 19.10.2026
09:00 am - 5:00 pm
Wednesday, 11.11.2026
09:00 am - 5:00 pm
Thursday, 26.11.2026
09:00 am - 5:00 pm
Monday, 14.12.2026
09:00 am - 5:00 pm
Wednesday, 03.02.2027
09:00 am - 5:00 pm
Friday, 26.02.2027
09:00 am - 5:00 pm
Wednesday, 10.03.2027
09:00 am - 5:00 pm
Training is guaranteed to take placeThe next booking ensures this course will take placeAbout 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.
Do you have any questions?
We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Munzinger Str. 9
79111 Freiburg
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
