“Microsoft Excel” PivotTables

“Microsoft Excel” PivotTables
  • Event Category: Microsoft Office

The course schedule has not been scheduled yet. Please visit again soon.

ABOUT THE SEMINAR

“Microsoft Excel” PivotTables (“PivotTable”) are a powerful tool for data analysis and summarization. The course is focused on creating PivotTables: preparing data, creating summary tables and dashboards. Significant attention is given to the analysis of practical situations.

SEMINAR PROGRAM
  • Preparing data for “PivotTable” tables.
  • Creating PivotTables (“PivotTable”). “PivotTable” design window.
  • “PivotTable” layouts, subtotal rows. “PivotTable” settings.
  • Grouping PivotTable fields.
  • PivotTable data summarization algorithms.
  • Calculated PivotTable fields and items.
  • Filtering and sorting PivotTables. Filters (англ. Slicer), timeline (англ. Timeline). Filter connections (англ. Filter connections).
  • Function “GetPivotData”.
  • Conditional formatting for “PivotTable” tables.
  • Pivot charts (англ. PivotChart).
  • Creating dashboards (англ. Dashboad).
  • Practical situations of using PivotTables.