You are here

Excel Genius Class 6: VLookup and Index/Match

Excel Genius Class 6: VLookup and Index/Match


The New York Public Library (Tech)
188 Madison Ave
New York, NY 10016
Register for Course
Thursday, January 17, 2019 - 5:15am


This class will cover different kinds of functions used to search for information in a database, and work with the results. Topics include VLOOKUP, INDEX MATCH, & INDEX MATCH MATCH. Skills required: Be able to write functions Understand Absolute vs Relative Cell References Know how to write structured references a plus Note: Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the worlds most popular spreadsheet application. Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations. While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose. Class 1: Logic Functions Class 2: Conditional Stat Functions Class 3: Charts and Sparklines Class 4: Tables, Structured References, and Data Validation Class 5: Pivot Tables Class 6: Lookup Functions Class 7: Importing Data, String Functions, and Goal Seek Class Requirements Each Class will have its own set of specific requirements, but all classes will use the following skills: Data Entry Selecting Cells Copy and Paste Formatting Cells These are registration based classes and spots may fill up quickly. If for any reason we're unable to accommodate your registration, we will let you know as soon as possible.

Register for Course

Additional Sessions