Simple play icon Course

Excel 2016 Data Lookup Function Playbook

by Pratheerth Padman

In this course you'll learn 5 different functions that'll help you to quickly and efficiently look up required data in Microsoft Excel.

What you'll learn

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 2016 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.

About the author

Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Ready to upskill? Get started