logo-slvexpert

VOTRE

FORMATION

Excel training workshop – Pivot table for controller and analyst

$ 395

AF3660

Webinaire
6 heures (9h à 16h)
Anglais
Aussi disponible en entreprise

RÉSUMÉ :

Pivot tables are interactive tools that allow grouping and summarizing large amounts of data in a concise table format. With pivot tables, you can explore data interactively. This training is intended for both novices and experienced users who wish to clarify certain less obvious features. By the end of this training, you will master all the available options, be able to customize your tables, and ensure the integrity of your data.
Voir plus
Content
  • Introduction
  • Start the PivotTables Wizard
    • Creating a table
    • Creating the pivot table
  • Display mode
  • PivotTables options
    • Layout and formatting
    • Totals and filters
    • Viewing
    • Impression
    • Data
    • Replacement text
  • Grouping data
    • Date
    • Number
  • Filtering data
    • Inside the PivotTable
    • With the use of segments and chronological segments
  • Formatting PivotTables
    • Parameters of the values fields
    • Field settings
    • Layout and printing
  • Custom Calculated Fields Preprogrammed
  • Calculated Fields
  • Pivot charts
  • Manage tables relationship

CALENDRIER :

20/05/2025WebinaireMarcel Dubé
21/08/2025WebinaireMarcel Dubé