PLU | Excel Data Lookup Function Playbook (2019 EN)

Company: Pluralsight
Author: Pratheerth Padman
Full Title: Excel Data Lookup Function Playbook
Year: 2019
Language: English
Genre: Educational: Spreadsheets
Skill Level: Advanced
Price: -
-
Files: MP4 (+ Exercise Files, Subtitles .SRT, Slides .PDF)
Time: 00:33:43
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 250 kbps
Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



In this course you'll learn 5 different functions that'll help you to 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.


Lessons:
1. Course Overview
01. Course Overview
2. Looking up Data with the LOOKUP, HLOOKUP, and VLOOKUP Functions
02. Module Introduction
03. LOOKUP Function
04. Demo: Looking up Data with the LOOKUP Function
05. VLOOKUP and HLOOKUP Functions
06. Demo: Looking up Data with the VLOOKUP and HLOOKUP Functions
3. Looking up Data with the MATCH and INDEX Functions
07. Module Introduction
08. INDEX Function
09. MATCH Function
10. Demo: Combining the INDEX and MATCH Functions
11. Why Choose INDEX-MATCH over VLOOKUP?
12. Course Summary and Feedback

Our members see more. Join us!
-------------
Our members see more. Join us!