Excel - Pivot Tables

Inter-company training

Who is the training for?

All public

Duration

3,50 hours(s)

Language(s) of service

EN

Next session

15.12.2025
Location
L'adresse sera fournie ultérieurement

Price

190,00€

Prerequisites

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

Goals

Analyse your data with Pivot Tables

Contents

  • 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

Next session

Datum
City
Language and price
15.12.2025
L'adresse sera fournie ultérieurement
EN 190,00€
16.01.2026
L'adresse sera fournie ultérieurement
EN 190,00€
06.05.2026
L'adresse sera fournie ultérieurement
EN 190,00€

These courses might interest you

EN
Day
Software - Office software - Word processing software - Word software
02.03.2026
EN
Day
Software - Office software - Spreadsheet software - Excel software
16.03.2026