COVID-19 Campus Updates and Resources: Wearing a face mask and practicing physical distancing are required. Visit our Stay Healthy, Stay Safe. Navigating COVID-19 Together website for more information.

Spring 2021 Course List: This course list identifies face-to-face classes that will be delivered via Zoom at their scheduled days and times through March 19. All other courses will run as scheduled at their designated days, times, and locations.

Extended hours: Many offices are open 8:00am–6:00pm weekdays through January 22. Offices with extended hours include Student Services, Business Office, Financial Aid, and Admissions.

This Event has expired.

Excel Pivot Tables & Data Tables

Feb24

Date:
Monday, February 24, 2020

Time:
2:30pm–4:30pm

Location:
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

Tags

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