Starting with the basics, learn ways to structure and format worksheets for clarity and efficiency. Discover how to modify a worksheet's structure by inserting, deleting, and formatting rows and columns, and explore formatting options to make the data visually appealing and easy to interpret. Examine calculation capabilities, starting with simple formulas and progressing to aggregate functions. Practice using references to cells and ranges, troubleshoot formula errors, and explore tools like autofill and quick analysis to save time and streamline workflow. Advanced techniques will also be introduced.
Additional information: This course is offered through ed2go. Find out more about ed2go.
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.
Not all courses are offered each term.
Winter 2026 registration is now open.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