Excel Pivot Tables

Seminarziel

To understand pivot tables, you need to work with them yourself. In this course we will create several pivot tables step by step from a set of sample data. With some experience, pivot tables can be created in minutes.

After the seminar you will be able to analyse data in pivot tables.

Inhalt

This course is also forms day one of the course "Excel for Analysts".

• Creating simple pivot tables
  • Row and column fields 
  • Calculated fields
• Planning and creating pivot table layout
  • Rearranging fields
  • Adding or removing fields
  • Pivot reports
  • PivotTables
  • Short format
• Show and hide results
  • Partial results
  • Summing rows and columns
• Show and hide details
  • Hide elements
  • Grouping data 
  • Features of number and date fields
• Excel functions for data analysis 
  • Value field properties
  • User-defined calculations
  • Calculating elements, fields and groups
• Slicers
  • Creating data slices
• Create and design PivotCharts
  • Create and edit charts based on
  • Print functions for PivotCharts
  • Save chart appearance as a separate template