Excel - Pivot Tables

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

• Basic knowledge of Excel Functions
  

• Please specify the version and language of the software used (2013/2016/2019/365 in English, French or German