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.
Additional information: This course is offered through ed2go. Find out more about ed2go courses.
ed2go online courses are designed for working professionals and those seeking to gain personal advancement. If you are enrolled in a program, carefully review the requirements of your program before registering to ensure the course code and title match the requirements in your program.
Not all courses are offered each term.Fall 2022 registration opens July 25, 2022. Winter 2023 registration opens November 28, 2022.
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 with no assigned day or time requirements, independent course completion
Online - Synchronous: 100% online delivery with scheduled day and time course requirements
Hybrid: any combination of: in person, timetabled, on campus, online, and hyflex delivery