Course Detail: CMP501 - ExcelŽ: Using Lookup Functions and Formula Auditing

Course Content:
- Use functions including: VLOOKUP, HLOOKUP, MATCH, INDEX, and TRANSPOSE
- Trace Cells: precedent and dependent cells, trace arrows, and more
- Watch and Evaluate Formulas
Prerequisite: Basic knowledge of ExcelŽ.
This class has two options to participate:
1. Fully in-person at Purdue Fort Wayne. Students will participate in the live sessions during the scheduled course days and times.
2. Fully online via Zoom. Students will participate in the live sessions during scheduled course days and times. (Online Course Requirements: Students should have access to MS Excel 2019 or newer, a reliable internet connection, and a computer camera and microphone).
You will be able to select the option that works for you (ONLINE or IN-PERSON) at time of registration.