Save for later
Excel Data Lookup Function Playbook
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.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 0.6 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pratheerth Padman |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Microsoft instructor $62k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Microsoft CSR $81k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Microsoft Access Programmer $96k
SDE in Microsoft $106k
SDE @ Microsoft 5 $110k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 0.6 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pratheerth Padman |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course