• Icon 02.09.2020
  • Icon 3 h 30 mins
  • icon Formation à distance
  • Icon English
  • Icon IF094CJ
130,00 EUR

*

(+3% TVA)

Virtual classroom


In response to the current situation related to the coronavirus COVID-19, the House of Training is delighted to announce that this training is now accessible as a virtual class.


This format, perfectly adapted to any staff member aiming to develop their skills remotely, has various benefits:

  • It allows you to train yourself while avoiding any physical movement

  • Maximum efficiency is guaranteed due to an adaptation of session durations according to this kind of training

  • Regular interaction between the trainer and the learners is assured thanks to modern technology tools

Registration is easy!


If you wish to attend this training, please click on “S'inscrire” and choose “virtual classroom”.


In order to conveniently attend the virtual classroom, kindly review the following recommandations.

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

In collaboration with


Key Job

Prerequisites


Basic knowledge of Excel Functions

Lieu

Télécharger le planning PDF

mer. 02.09.2020 à 13h00

icon 3H30

Excel 2016 Pivot Tables

  • icon Classe virtuelle
    À distance

Vous souhaitez rester à jour sur notre offre de formation ?

Vous avez une question ?
Nous avons des réponses !