Excel - Pivot Tables

This training covers the essential tools and techniques for creating, modifying and analysing Pivot Tables in Excel. It provides a practical approach to organising data, grouping information, performing calculations and using Pivot Charts for dynamic reporting.

  By the end of this training, participants will be able to:

• create and manage Pivot Tables

• group, filter and calculate data

• build and use Pivot Charts

• 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
  

At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.