Excel 2016 - Pivot Tables

Basic knowledge of Excel Functions

Analyse your data with Pivot Tables

• Introduction
• Organise 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
• 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