Skip to main content

Microsoft Excel Pivot Tables & Data Tables

ID : 4352   
« back to classes page
: 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.

Class Details

3 Sessions
Weekly - Tue

Business & Technology Center

James Flack 

CEUs : 0.6



Registration Closes On
Sunday, May 10, 2020 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
5/12/2020 - 5/26/2020 Weekly - Tue 3:30 PM - 5:30 PM Marshalltown, Business & Technology Center  Map, Room: 201 Computer Lab James Flack