Print

Excel - Pivot Tables

Inter-company training
House of Training - Voir la fiche de cet organisme

How long does the training course last?

 3,50 hours(s)

In which language(s) is the training course taught?

EN

When will the next session take place?

 09.12.2026
See details
Where does the training course take place?
 L'adresse sera fournie ultérieurement

How much does the training course cost?

240,00€

Who is organising this training course?

Fondation créée en 2015 par la Chambre de Commerce et l’Association des Banques et Banquiers Luxembourg (ABBL), la House of Training est un organisme agréé de formation professionnelle continue qui s'engage à contribuer activement à la compétitivité et à l'attractivité du Luxembourg en développant les compétences de ceux qui font vivre son économie.

What are the 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

What are the aims or the skills being targeted?

Analyse your data with Pivot Tables

What does the training course cover?

  • 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

When will the next session take place?

    Datum
    City
    Language and price
  • 09.12.2026
    L'adresse sera fournie ultérieurement
    EN 240,00€

How to contact the training provider?

House of Training

These courses might interest you