Course description
Learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. Please note: this course must be taken on a PC. It does not support MAC users or Chromebooks.
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.
End date: Feb. 13, 2023
End date: Mar. 20, 2023
End date: Apr. 17, 2023
End date: May. 15, 2023
Registration dates
Not all courses are offered each term.
Winter 2023 registration opens November 28, 2022. Spring 2023 registration opens February 27, 2023.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