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.
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.
Not all courses are offered each term.
Fall 2026 registration is 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