Excel – Pivot table

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.

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