1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Excel: Lookup Functions in Depth Preview

Excel: Lookup Functions in Depth

With Dennis Taylor Liked by 191,745 users
Duration: 1h 8m Skill level: Intermediate Released: 9/11/2020

Start my 1-month free trial Buy for my team

Course details

Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility. Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow.

Skills you’ll gain

Meet the instructor

Learner reviews

4.8 out of 5

6,130 ratings
  • 5 star
    Current value: 4,994 81%
  • 4 star
    Current value: 939 15%
  • 3 star
    Current value: 156 3%
  • 2 star
    Current value: 17 <1%
  • 1 star
    Current value: 24 <1%
  • Benjamin Kendrick Benjamin Kendrick

    Benjamin Kendrick

    HME Test Engineer at Reliability & Performance Technologies ( R&P )

    4/5 June 28, 2024
    i would recomend to people who are experienced with excel but not to beginners
    Helpful · Report
  • Maria B. Cabrera Maria B. Cabrera

    Maria B. Cabrera

    Sales Leader with extensive experience in CPG industry in Sales and Retail Marketing roles.

    5/5 June 26, 2024
    Practico!
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 4 quizzes
  • Learn on the go Access on tablet and phone

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play