Full 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: Nov.21, 2:30-4:30 PM with an optional 30 minute practice lab
Location: Information Technology Center, room ITC171
Instructor: Alec Muthig, UWIT Training
- Send questions regarding this course to firstname.lastname@example.org
- Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
- To attend this workshop remotely using ZOOM, enroll and see the course's main page for a Zoom link. With questions about Zoom, please email email@example.com.