Course Description:

Special: UW accounts can take this course for free; email computer.training@uwyo.edu for the promo code by Jul.6.

Become an Excel master with this deep dive into VLOOKUP, which can be used for locating and returning related information, automatically classifying data, comparing two sets of data for matching or missing information, and more! 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 to learn the different ways that VLOOKUP can be used with financial, organizational, and research data. (2 hour session, with a 30 minute optional practice lab immediately following)

**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. (Our Excel: Formulas & Functions class is a great place to start!)

Date/Time: July 7, 1:30-3:30 PM (mountain) (plus an optional, recommended 30 minute lab)

Location: via Zoom (a meeting link will be provided after enrollment)

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.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).