Cette formation est proposée sous forme de formation à distance. En savoir plus

Description

Objectives

Analyse your data with Pivot Tables

Programme
  • 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
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


Conditions

Course Material

The training material will be handed out at the beginning of the course.

Location
Classe virtuelle
A distance
Calculate the itinerary

Sessions et horaires

Télécharger le planning (PDF)

  • Wed 22.05.2024

    13:30 à 17:00

    3H30

    Excel 2016 Pivot Tables

    Classe virtuelle

Télécharger le planning (PDF)

  • Tue 18.06.2024

    13:30 à 17:00

    3H30

    Excel 2016 Pivot Tables

    Classe virtuelle