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

Hours: 24
Credits: 1
Prerequisites: None
Corequisites: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

ed2go courses


These 6-week online courses are designed for working professionals and those seeking personal advancement. From the start date, students have access to their courses 24/7. There are no live lectures or specific days and times students must be logged in. Each Wednesday and Friday, the instructor releases a lesson, for a total of 12. There is a 2-week period at the end of the course to complete the final exam.

Dates
Day/Time
Delivery
Campus
Cost
Availability
Starts: Oct. 16, 2024
Ends: Dec. 16, 2024
Day/Time:
Campus: Online
Cost: $197.00
Starts: Nov. 13, 2024
Ends: Jan. 13, 2025
Day/Time:
Campus: Online
Cost: $197.00
Starts: Dec. 18, 2024
Ends: Feb. 17, 2025
Day/Time:
Campus: Online
Cost: $197.00

Registration dates

Not all courses are offered each term.

Fall 2024 registration opens July 22, 2024. Winter 2025 registration opens November 4, 2024.

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