Course Description:

This workshop covers the use of Excel’s versatile and essential VLOOKUP function, along with additional related functions (HLOOKUP, INDEX, and MATCH). We will use a wide range of examples, from financial through research data, to explore these functions. (2 hour session, with a 30 minute optional practice lab immediately following)

VLOOKUP is useful for locating and returning related information, automatically classifying data, comparing two sets of data for matching or missing information, and more!

Prerequisites: This is an intermediate-level course. To participate, you should have at least a basic working knowledge of Excel spreadsheets AND some experience writing simple formulas.

Date/Time: Apr.17, 2:00-4:00 PM (+30 min optional lab)

Location: Information Technology Center, room ITC171

Instructor: Alec Muthig, UWIT Training

Important Information:

• Send questions regarding this course to computer.training@uwyo.edu
• Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
• If you are not on campus and would like to attend this course remotely via Zoom, please email a request to computer.training@uwyo.edu at least 24-hours before the listed start time.  Remote course attendance is not available for all workshops, and may have specific requirements.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).