Excel Genius 8: LOOKUP and INDEX MATCH

at The New York Public Library (Tech) - Manhattan

(62)
Course Details
Price:
Free 4 seats left
Start Date:

Tue, Oct 22, 10:15am - 12:15pm

Next start dates (1)

Location:
Manhattan
188 Madison Ave
Btwn E 34th & 35th Streets
New York, New York 10016
(Map)
Share:
Important:
Venue: Training Room 4
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 8

What you'll learn in this excel class:

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 world’s 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 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

Class 6: Lookup Functions

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

Skill prerequisites: Intermediate Excel

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.

Still have questions? Ask the community.

Map

Google Map

The New York Public Library (Tech)

All classes at this location

Start Dates (2)
Start Date Time Teacher # Sessions Price
10:15am - 12:15pm TBD 1 Free
2:30pm - 4:30pm TBD 1 Free

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 0 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at The New York Public Library (Tech) (62)

Similar Classes

School: The New York Public Library (Tech)

The New York Public Library (Tech)
CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here