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)
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!