FR
EN
Details
Goals
Analyze your data with Pivot Tables.
Prerequisite
Basic knowledge of Excel Functions.
Contents
Introduction
-
Organize your data in a list layout
-
Create a Pivot Table
-
Select data in a pivot table
-
Add data to a pivot table
-
Remove data from a pivot table
-
Update data in a pivot table
-
Recommended Pivot Tables (version 2013 and later)
Views
-
Hide/Show items in a pivot table
-
View details (drill down)
-
View the source data
-
Add/Remove subtotals
Groups
-
Grouping items in a pivot table
-
Automatically group numeric values
-
Automatically group date values
-
Ungroup
Calculations
-
Create calculated fields
-
Use calculated fields
-
Use a pivot table value in a formula
Options
-
General options of PivotTables
-
Change options
Pivot Charts
-
Create a PivotChart
-
Manipulate a PivotChart
Sign up
Next session(s)
Tue.
01
Jul.
Formation online de 13h30 à 17h00 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
04
Aug.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Wed.
06
Aug.
Online cours from 1:30 pm to 5:00 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)
Fri.
19
Sep.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Wed.
08
Oct.
Online cours from 1:30 pm to 5:00 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)
Wed.
29
Oct.
Formation online de 13h30 à 17h00 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
15
Dec.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)
Mon.
15
Dec.
Online cours from 1:30 pm to 5:00 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)
To go further
These courses
may be of interest to you
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!