In this one hour in person, instructor led short course, you will learn how to work with Excel Pivot Tables and Pivot Charts. Excel Pivot Tables are used to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot Charts are a great way to add data visualizations to your data. Topics will include learning how to create a Pivot Table; rearrange and then format the data; set filters including the use of Slicers and Timelines; and finally creating a Pivot Chart of the data in the Pivot Table. This workshop is aimed at beginner users of Pivot Tables.
Prerequisite: Completion of Excel Getting Started or equivalent knowledge.Length: 1 hour
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.
Location: 329 Armory Building
Training labs are located at the Armory Building (505 E. Armory, Champaign, IL). There are MTD bus stops at every corner of the building (northwest, southwest, northeast, northwest). It is best to enter the building at the southwest corner (4th & Gregory -- across from Huff Hall). There is an elevator just inside the southwest entrance. Exit on the third floor and turn left down the hallway.
Parking
Unrestricted metered parking is available in Lot E3 and along Sixth Street, south of Armory Street. There are 5 designated accessible parking spaces in Lot E3 (corner of Gregory & 6th). Contact the Division of Campus Parking and Transportation at (217)333-3530 or visit Parking at Illinois for more information.
Add this class to your calendar:Browse to the WebStore Events Calendar, select your course, select the calendar symbol , select your calendar format, open the file, and save the item to your calendar.
Technology Services
1211 Digital Computer Lab 1304 W. Springfield Ave. Urbana, IL 61801
Email: webstore@illinois.edu
Office of the Chief Information Officer