Spreadsheets: Analyzing Data With Pivot Tables

Learning Objectives

  • Create a pivot table
  • Filter a pivot table
  • Sort a pivot table
  • Work with multiple value fields
  • Add custom calculations to a pivot table
  • Refresh and update a pivot table
  • Create a PivotChart (Microsoft Excel) or chart (Google Sheets)

Prerequisite Skills

  • Enter data into a worksheet
  • Work with formulas and functions
  • Navigate between worksheets in a workbook

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.