Webinar
This webinar is held in German.
Pivot tables are an important tool for the ad hoc analysis of large amounts of data in Excel. With just a few mouse clicks, data can be analyzed from different perspectives, provided the appropriate data structure is available. In this module, you will learn how to create an optimal raw data structure for a pivot report and which basic working techniques are available for data analysis. Based on this, you will explore advanced functions to analyze large amounts of data even more flexibly in the future and present your results.
Contents
Choose 4 Excel snacks!
- Prepare simple lists and data tables manually or with Power Query for pivot analyses.
- Get to know the basic working techniques of pivot tables (arranging, filtering, sorting, calculating data, etc.).
- Create additional grouping characteristics in pivot tables.
- Calculated fields in pivot tables - understanding benefits and limitations.
- Process data from pivot tables in Excel.
Please note:
The module is part of the webinar series "Excel Snacks in Controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- You will receive a brief and concise overview of the topic and compact knowledge of the essential working techniques with which you can create ad hoc analyses.
- You will get to know the functions in pivot tables with which you can create additional grouping characteristics in order to flexibly adapt the data presentation to the respective report object.
- You will learn how to use calculated fields to integrate additional key figures into pivot tables without having to make time-consuming adjustments to your basic data.
- You will acquire the necessary knowledge to evaluate the possibilities and limitations of further processing data from pivot tables.
- The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.
Methods
Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.
Recommended for
The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner.
Joint online training
Start dates and details
02.06.2025
Live-Online
Booking number:
35318
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Course
zoom
Days & Times
1 module of 1.5 hours each.
Monday, 02.06.2025
09:00 am - 10:30 am
17.09.2025
Live-Online
Booking number:
35318
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Course
zoom
Days & Times
1 module of 1.5 hours each.
Wednesday, 17.09.2025
09:00 am - 10:30 am
Training is guaranteed to take place
Booking number:
35318
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
Booking number:
35318
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
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
Do you have any questions?
We are there for you Mon - Fri 8 a.m. - 5:00 p.m.
*Mandatory fields
FAQs
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Haufe Akademie GmbH & Co. KG
Munzinger Str. 9
79111 Freiburg
Munzinger Str. 9
79111 Freiburg
A brand of
The company
About our offer
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
Special offers
Contact & Support
