Excel: Analyzing Data with PivotTables

Learning Objectives

  • Create, modify, and format PivotTables
  • Use summary functions and customized calculations
  • Group numbers and dates
  • Create filters and slicers
  • Search a PivotTable field list
  • Link and update PivotTables
  • Create pivot charts

Prerequisite Skills

  • Navigate an Excel spreadsheet
  • Create basic formulas
  • Sort and filter data
  • Work with tables
  • Manage named ranges

For a more in-depth look at the content of Excel: Analyzing Data with PivotTables, view the title contents below.

Expand Course Available

View Course in Expand

More information about this course

This online course is free to everyone and available for enrollment through IU Expand.

This course consists of a series of short lessons, examples, demonstrations, practice quizzes, and hands-on exercises.

To complete the course content, you will need:

  • a web browser and internet access to use the course material on IU Expand.
  • a copy of the software relevant to the training installed on your computer.