Course description
In this course, learn how to maximize Excel’s functions and capabilities. Learn to work with databases and advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. Explore how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data using Excel's built-in Power Query tool, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Course details
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.
Ends: Jul. 15, 2024
Ends: Aug. 12, 2024
Ends: Sep. 16, 2024
Ends: Oct. 14, 2024
Registration dates
Not all courses are offered each term.
Spring 2024 registration opens March 11, 2024. Fall 2024 registration opens July 22, 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