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

This course will help you develop the ability to create the advanced functions and formulas you need to perform complex calculations in ExcelŽ. In addition, it will give you the skills to audit your workbook content to find, troubleshoot, and correct errors or issues in your ExcelŽ data.

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.

 Session Information: 22FCMP501

Schedule: Wednesday, February 8 (1 session)
Times: 05:30pm-08:30pm EST
Regular Registration (Registration deadline: 2/3/23) : $89.00

Instructors

Name Additional Resources
Todd Raines

Facility Detail

Purdue Fort Wayne Campus
Kettler Hall Rm 148
2101 E. Coliseum Blvd
Fort Wayne, IN 46805

Facility Resources
Campus Map - Click Here

Kettler Hall Rm 148