1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Mastering Lookup Functions in Excel: Seven Powerful Formulas Preview

Mastering Lookup Functions in Excel: Seven Powerful Formulas

With Josh Aharonoff Liked by 535 users
Duration: 1h 15m Skill level: Intermediate Released: 6/4/2024

Start my 1-month free trial Buy for my team

Course details

Dive into the world of Excel lookup functions in this engaging crash course designed to enhance your data handling and data management skills. Join instructor Josh Aharonoff—also known as Your CFO Guy, who has hundreds of thousands of professional online followers on social media—as he offers an in-depth exploration of Excel's most widely used and important lookup functions.

Gain insights into a broad range of topics, such as detailed function syntax and the pros and cons of each function, along with practical exercises that will empower you to leverage your data more effectively. By the end of this course, you’ll be prepared to start using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, the powerful INDEX/MATCH combination, and GETPIVOTDATA. Whether you're just getting started or looking to refine your skills, this course is tailored to help you navigate your datasets with ease and greater confidence.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.7 out of 5

378 ratings
  • 5 star
    Current value: 285 75%
  • 4 star
    Current value: 72 19%
  • 3 star
    Current value: 16 4%
  • 2 star
    Current value: 4 1%
  • 1 star
    Current value: 1 <1%
  • Ravi Shankar Ravi Shankar

    Ravi Shankar

    Senior Talent Advisor | Hiring Data Storage Engineers | India & APAC Region | Hitachi Vantara | Ultra Marathoner

    4/5 May 28, 2025
    Highly recommended for beginners, as it effectively teaches the fundamentals of lookup functions
    Helpful · Report
  • Shivam Rai Shivam Rai

    Shivam Rai

    Google certified Data Analyst | Former Sales Executive & Pharmacist | Excel | SQL | Power BI | Python | R | Tableau | Machine Learning

    4/5 April 1, 2025
    Good for Beginners
    Helpful · Report
  • Mulyani Basri Mulyani Basri

    Mulyani Basri

    Petrophysicist and Technical Data Consultant at Shell Malaysia.

    5/5 March 18, 2025
    I learnt the lookup function so easily with this course.
    Helpful · Report

Contents

What’s included

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

Similar courses

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