This course will help you master many features in Microsoft Excel 2019/Office 365 that most users don't know exist. Learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from almost any data source. Please note: this course must be taken on a PC. It does not support MAC users or Chromebooks.
Additional information: This course is offered through ed2go. Find out more about 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.
Not all courses are offered each term.Winter 2024 registration opens November 27, 2023. Spring 2024 registration opens February 26, 2024.
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