Coronavirus (COVID-19) Information

Hawkeye will continue in an online format for course instruction and services for the remainder of the semester. See the full announcement.

Buildings are closed. Faculty and staff are working remotely and can be reached via email or phone.

We are updating the Coronavirus (COVID-19) Information web page as soon as new information is available. Students, faculty, and staff will also receive notifications via their Hawkeye email and the Hawkeye Alert. If you have any questions, please email

Excel Pivot Tables & Data Tables


Monday, June 01, 2020


Cedar Falls Center 114

Map and Directions

Learn to analyze data with Pivot Tables that allow you to view and organize your Excel data quickly and easily! Pivot Tables are the main focus of this course, but you will also learn to build, sort and filter lists of information, work with the Excel Table feature, and use the database functions like DSUM. You will create Pivot Tables and Pivot Charts/Report, organize and format Pivot Tables, perform calculations on a Pivot Table, and create and modify Pivot Charts. A discussion of Power Pivot is included in this class and you will learn how to link multiple Workbooks with a Key Field, treating Excel like an Access Database. Once linked, you will be able to analyze the data using built-in Pivot Tables. Textbook is included. Prerequisite: Excel Level One course or equivalent experience.

Pre-registration required.

View complete course and registration information


  1. continuing education
  2. continuing education computers and technology
Back to top