Excel Pivot Tables
- Total time
- Location
- At location, Online
- Starting date and place
Excel Pivot Tables
Provider rating:
Starting dates and places
placeKöln 6 Mar 2026 |
computer Online: Zoom 6 Mar 2026 |
placeKöln 12 Jun 2026 |
computer Online: Zoom 12 Jun 2026 |
placeKöln 11 Sep 2026 |
computer Online: Zoom 11 Sep 2026 |
placeKöln 11 Dec 2026 |
computer Online: Zoom 11 Dec 2026 |
Description
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
To understand pivot tables, you need to work with them yourself. In this course we will create several pivot tables step by step from a set of sample data. With some experience, pivot tables can be created in minutes.After the seminar you will be able to analyse data in pivot tables.
Inhalt
This course is also forms day one of the course "Excel for Analysts".-
Creating simple pivot tables
- Row and column fields
- Calculated fields
-
Planning and creating pivot table layout
- Rearranging fields
- Adding or removing fields
- Pivot reports
- PivotTables
- Short format
-
Show and hide results
- Partial results
- Summing rows and columns
-
Show and hide details
- Hide elements
- Grouping data …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
To understand pivot tables, you need to work with them yourself. In this course we will create several pivot tables step by step from a set of sample data. With some experience, pivot tables can be created in minutes.After the seminar you will be able to analyse data in pivot tables.
Inhalt
This course is also forms day one of the course "Excel for Analysts".- Creating simple pivot tables
- Row and column fields
- Calculated fields
- Planning and creating pivot table layout
- Rearranging fields
- Adding or removing fields
- Pivot reports
- PivotTables
- Short format
- Show and hide results
- Partial results
- Summing rows and columns
- Show and hide details
- Hide elements
- Grouping data
- Features of number and date fields
- Excel functions for data analysis
- Value field properties
- User-defined calculations
- Calculating elements, fields and groups
- Slicers
- Creating data slices
- Create and design PivotCharts
- Create and edit charts based on
- Print functions for PivotCharts
- Save chart appearance as a separate template
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.