Learn advanced Excel PivotTable and PivotChart features to analyze and visualize large datasets for more informed, data-driven decision-making.

Course Objectives

  • Prepare data for PivotTable reporting and create PivotTables from various data sources
  • Analyze data by using PivotTables
  • Work with PivotCharts
Download course details

Upcoming Schedules

Course Prerequisites

Required

  • Understanding of spreadsheet concepts and be comfortable creating basic PivotTables
  • Working experience with Excel and PivotTables

Course Outline

Preparing Data and Creating PivotTables
arrow iconarrow icon

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source