Course description
In this course, learn how to utilize pivot tables to develop useful analysis models and reports within your company. Discover how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. Explore advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. Learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted.
Course details
Additional information: This course is offered through ed2go. Find out more about ed2go.
ed2go courses
Choose from instructor-moderated or self-guided courses designed to fit your schedule. Build professional skills, explore a new interest, or advance your career with convenient online learning.
Ends: Dec. 14, 2026
Ends: Jan. 11, 2027
Ends: Feb. 15, 2027
Registration dates
Not all courses are offered each term.
Fall 2026 registration is open.Winter 2027 registration opens November 2, 2026.
Delivery options
In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration
Online - Asynchronous: 100% online delivery, no scheduled day or time course requirements with the instructor, assigned due dates
Online - Synchronous: 100% online delivery, scheduled day and time course requirements with the instructor, assigned due dates
Hybrid: any combination of in person, timetabled, on campus, online, and hyflex delivery