Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Excel Data Lookup Function Playbook

via Pluralsight

Overview

Learn 5 functions that'll help you quickly and efficiently look up required data in Microsoft Excel.

Imagine that you’ve been given a Microsoft Excel worksheet with tons of data - hundreds or even thousands of rows, and thousands of columns. The task you’ve been given is to extract maybe 10 or 20 values from 2 or 3 columns and use that to create a much smaller worksheet to fulfill some need. If you’ve been doing that manually so far, this course is exactly what you need. In this course, Excel Data Lookup Function Playbook, you'll explore 5 different functions that’ll help you to look up data quickly and efficiently. In the first module, you'll go through 3 different functions: LOOKUP, VLOOKUP, and HLOOKUP. Next, you'll examine the behavior of the INDEX and MATCH functions, both individually and when combined. When you're finished with this course, you'll know how to quickly and efficiently look up data in Microsoft Excel.

Topics:
  • Course Overview
  • Looking up Data with the LOOKUP, HLOOKUP, and VLOOKUP Functions
  • Looking up Data with the MATCH and INDEX Functions

Taught by

Pratheerth Padman

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Excel Data Lookup Function Playbook

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free