Courses

Information Technology

Excel Pivot Tables

Course Code: 01-04-D712

This class teaches you to use Microsoft Excel Pivot Tables to easily find important information in big data sets. Pivot Tables let you compare data and get answers without needing to write new formulas, copy and paste, or reorganize columns or rows. You'll also learn how to make basic tables and charts from an Excel sheet.

Performance Objectives: Upon completion of this course, you should be able to:

  • Create and customize Pivot Tables.
  • Nest fields.
  • Group data.
  • Calculate and customize statistics.
  • Filter data.
  • Use slicers.
  • Create and customize Pivot Charts.

Prerequisite: You need to have a good understanding of and experience with Excel tables, charts, and formulas prior to this class.

Intended Audience: All audiences.

Sales Tax Notice: Effective October 1, 2025 
In accordance with Washington State law (ESSB 5814), sales tax will be applied to all training services. In addition to the course cost, sales tax will be calculated based on your agency's location and added to your final invoice after the class is completed.