Excel Pivot Tables - Seminar / Kurs von GFU Cyrus AG

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