1000+ Courses for Free

  1. Great Learning
  2. Free Courses
  3. It & Software

VLOOKUP in Excel Free Course

VLOOKUP in Excel

star 4.57  Beginner level 1.5 learning hrs 63.5K+ Learners

Learn to use Excel formulas and VLOOKUP to retrieve data from the same worksheet, other sheets, and separate workbooks. Enroll in this free VLOOKUP course to build practical spreadsheet skills.

Instructor:

Edwin Thomas

VLOOKUP in Excel

star 4.57  Beginner level 1.5 learning hrs 63.5K+ Learners
Sign up with Email

63.5K+ learners enrolled so far

Stand out with an industry-recognized certificate

Start learning

10,000+ certificates claimed, get yours today!

Get noticed by top recruiters

Share on professional channels

Globally recognised

Land your dream job

Certificate Image

Skills you will gain

Excel VLOOKUP

Excel Formulas

Excel Functions

MS Excel

What you'll learn

  • Build formulas using Excel's order of operations.
  • Apply VLOOKUP to pull data from another sheet.
  • Retrieve data with VLOOKUP across separate workbooks.
  • Find the smallest and largest values with formulas.

    • Key Highlights

    Get free course content

    Master in-demand skills & tools

    Test your skills with quizzes

    About this course

    This free VLOOKUP course introduces you to the Excel formulas and functions needed to work with spreadsheet data. You’ll learn how to enter, copy, edit, and hide formulas, understand the order of operations, and use functions within a workbook. The course then covers VLOOKUP in Excel, starting with its purpose and basic usage before showing you how to retrieve information from a table in the same worksheet, a different worksheet, or a separate workbook.

    You’ll also learn how to copy a VLOOKUP formula and retrieve multiple values at once. The lessons cover finding the smallest and largest values in a dataset, helping you work with common spreadsheet calculations. By the end, you’ll be able to explain how Excel formulas and functions work, use VLOOKUP to look up and retrieve data across worksheets and workbooks, and apply basic formulas to find key values. This course is suitable for beginners who want to learn VLOOKUP and build practical Excel skills.



    Stand out with an industry-recognized certificate

    Start learning

    10,000+ certificates claimed, get yours today!

    Get noticed by top recruiters

    Share on professional channels

    Globally recognised

    Land your dream job

    Certificate Image

    Course outline

    Agenda to Formulas and Function

    What is a Formula in Excel

    How to enter a formula

    Precedence order of operations

    How to Enter, Copy, Edit and Hide a Formula

    What is a Function

    Function in workbook

    Summary on Formulas and Functions

    Agenda to Vlookup Function

    What is Vlookup

    Vlookup function in the same sheet

    Vlookup function in a different sheet

    Vlookup function in a different workbook

    Copy Vlookup Function

    Multiple Values at once

    Smallest and Largest Value

    Summary on Vlookup Function

    Get access to the complete curriculum once you enroll in the course

    View Full Course

    This course is ideal for

    • Beginners wanting to learn essential Excel formulas.
    • Students and job seekers building spreadsheet skills.
    • Working professionals who look up data in Excel daily.
    • Learners who want a VLOOKUP in Excel certificate.

    VLOOKUP in Excel

    rating icon 4.57

    1.5 Hours

    Beginner

    Sign up with Email

    63.5K+ learners enrolled so far

    Get free course content

    Master in-demand skills & tools

    Test your skills with quizzes

    Level up with advanced skills & become job ready with Pro+

    Subscribe to Pro+ today to build skills with 50+ Pro courses and prep for jobs with advanced AI tools.

    PRO
    Pro+ course thumbnail image
    partner logo
    Master Data Analytics in Excel
    2 projects 5.5 hrs video content

    Practice exercises

    Certificate from Microsoft

    AI Resume Builder

    AI mock interviews

    Start 7-Day Free Trial

    Get course + certificate with Pro+ subscription

    Trusted by 10 Million+ Learners globally

    star

    4.6
    star

    4.89
    star

    4.94
    star

    4.7

    Learner reviews of the Free Courses

    4.57
    ★★★★
    ★ ☆
    ★
    ★
    ★
    ★
    ★
    73%
    ★
    ★
    ★
    ★
    ☆
    19%
    ★
    ★
    ★
    ☆
    ☆
    5%
    ★
    ★
    ☆
    ☆
    ☆
    1%
    ★
    ☆
    ☆
    ☆
    ☆
    2%
    Reviewer Profile
    janani

    5.0

    ★★★★ ★
    India
    “VLOOKUP function in Excel: Search and return values”
    The lookup_value must be in the first column of the table_array. If range_lookup is set to TRUE (or omitted), the data in the first column of your table must be sorted in ascending order for VLOOKUP to work correctly. If range_lookup is set to FALSE, Excel will return an error if an exact match is not found.
    Read More
    Reviewer Profile
    Bhawana Bahuguna

    5.0

    ★★★★ ★
    India
    “Excel formulas and functions: Edit, copy, and find them”
    The VLOOKUP function, learning how to use it in the same sheet, across sheets, and even from different workbooks. We also learned to copy the VLOOKUP formula, retrieve multiple values like product name and price simultaneously, and find maximum and minimum values.
    Read More
    Reviewer Profile
    Hassain .

    5.0

    ★★★★ ★
    India
    “Microsoft Excel and the VLOOKUP function”
    I liked the way of teaching and providing the certificate. Providing the certificate for free is good for students who are interested in studying certificate courses and improving their skills.
    Read More
    Reviewer Profile
    Reshma

    4.0

    ★★★ ★ ☆
    India
    “Easy to follow instructions and quizzes”
    This course is less than 1 hour but I've learned the basics of VLOOKUP in this short time. I'm glad that this course is free. Thanks for offering these amazing courses.
    Read More
    Reviewer Profile
    Zahedul Alam (BICSc Lead Assessor)

    5.0

    ★★★★ ★
    United Arab Emirates
    “For the first time, I found a perfect and amazing explanation about VLOOKUP”
    Appreciate a lot for the amazing content and explanations.
    Read More
    Reviewer Profile
    Debarati shit

    4.0

    ★★★ ★ ☆
    India
    “VLOOKUP learning and basic computer learning”
    I wanted to learn VLOOKUP in the last 3 months but I couldn't find anything in-depth that was free with a certificate. Thank you for the help.
    Read More
    Reviewer Profile
    Praveen Kumar

    5.0

    ★★★★ ★
    India
    “VLOOKUP, HLOOKUP, SUM, percentage, and date and time”
    It was a very awesome experience with great learning. I really got a lot of information about MS Excel. I think every student should appreciate and approach the great learning program for enhancing and gaining their knowledge.
    Read More
    Reviewer Profile
    Sanya Gomez

    5.0

    ★★★★ ★
    India
    “VLOOKUP Excel Certificate Course”
    It was great doing the VLOOKUP Excel course, as I have gained knowledge and increased my Excel skills.
    Read More
    Reviewer Profile
    Prashanthini

    5.0

    ★★★★ ★
    “VLOOKUP formulas and uses in detail”
    Good teaching and better knowledge about the VLOOKUP. Interesting way of teaching.
    Read More
    Reviewer Profile
    supriya priya

    5.0

    ★★★★ ★
    India
    “VLOOKUP in Excel: How to copy the VLOOKUP value and find min and max”
    There are two instructors in this section and their teaching skills and given examples are very useful.
    Read More

    What our learners enjoyed the most

    Our course instructor

    instructor img

    Edwin Thomas

    Research Analyst

    IT & Software Expert

    learner icon
    304K+ Learners
    video icon
    4 Courses
    Edwin Thomas is a Research Analyst at Great Learning, where he applies his analytical mindset and structured approach to support high-quality content development and research. He has completed courses in crisis management, brand management, and social media management, giving him strong insights into modern business strategy and digital communication. With prior experience at Great Learning managing LMS content and building dashboards, he combines technical proficiency with operational understanding. Skilled in tools such as Python, SQL, and Tableau, he leverages data-driven thinking to produce clear, accurate, and impactful learning materials for a wide range of learners.

    Frequently Asked Questions

    Will I receive a certificate upon completing this free course?

    Yes, upon successful completion of the course and payment of the certificate fee, you will receive a completion certificate that you can add to your resume.

    Is this course free?

    Yes, you may enroll in the course and access the course content for free. However, if you wish to obtain a certificate upon completion, a non-refundable fee is applicable.

    What will I learn in this free VLOOKUP in Excel course?

    You’ll learn Excel formula and function basics, how to use VLOOKUP to retrieve information, and how to work with data across the same worksheet, different worksheets, and separate workbooks. The course also covers copying VLOOKUP formulas, retrieving multiple values, and finding the smallest and largest values.

    Is this VLOOKUP course suitable for beginners?

    Yes. This is a free VLOOKUP in Excel course for beginners. It starts with the basics of Excel formulas and functions before introducing the VLOOKUP function and its applications. You don't need advanced Excel knowledge to follow the lessons.

    Which topics are covered in this VLOOKUP training course?

    The course covers entering, copying, editing, and hiding formulas; the order of operations; Excel functions; VLOOKUP basics; using VLOOKUP within the same sheet, across different worksheets, and across workbooks; retrieving multiple values; and finding the smallest and largest values.

    What skills will I gain from this course?

    You’ll develop skills in working with Excel formulas and functions, looking up and retrieving spreadsheet data, using VLOOKUP across sheets and workbooks, copying formulas, retrieving multiple values, and identifying the smallest and largest values in a dataset.

    Will I learn how to use VLOOKUP across multiple Excel worksheets and workbooks?

    Yes. You’ll learn how to apply VLOOKUP within the same worksheet, use VLOOKUP across sheets, and retrieve information from different Excel workbooks

    Will I learn how to copy and reuse a VLOOKUP formula?

    Yes. The course covers copying the VLOOKUP function so you can reuse the formula when retrieving information from spreadsheet data.

    Will I learn how to use VLOOKUP to retrieve data from different Excel worksheets?

    Yes. You’ll learn to apply VLOOKUP to find information within the same worksheet and retrieve matching data from other worksheets and workbooks.

    Will I learn how to copy a VLOOKUP formula in Excel?

    Yes. You’ll learn how to copy the VLOOKUP function and retrieve data using the copied formula

    Will I learn to reuse VLOOKUP formulas for multiple data entries?

    Yes. You’ll learn how to copy the VLOOKUP function and reuse formulas when working with spreadsheet data.

    Will this course teach me how to find the smallest and largest values in Excel?

    Yes. You’ll learn how to find the smallest and largest values using Excel formulas.

    Will I learn how to use VLOOKUP across multiple Excel workbooks?

    Yes. The course teaches you how to use VLOOKUP across different workbooks to retrieve information from another Excel file.

    Is there any limit on how many times I can take this free course?

    Once you enroll in the Vlookup in Excel course, you have lifetime access to it. So, you can log in anytime and learn it for free online.

    Can I sign up for multiple courses from Great Learning Academy at the same time?

    Yes, you can enroll in as many courses as you want from Great Learning Academy. There is no limit to the number of courses you can enroll in at once, but since the courses offered by Great Learning Academy are free, we suggest you learn one by one to get the best out of the subject.

    Why choose Great Learning Academy for this free Vlookup in Excel course?

    Great Learning Academy provides this Vlookup in Excel course for free online. The course is self-paced and helps you understand various topics that fall under the subject with solved problems and demonstrated examples. The course is carefully designed, keeping in mind to cater to both beginners and professionals, and is delivered by subject experts. Great Learning is a global ed-tech platform dedicated to developing competent professionals. Great Learning Academy is an initiative by Great Learning that offers in-demand free online courses to help people advance in their jobs. More than 5 million learners from 140 countries have benefited from Great Learning Academy's free online courses with certificates. It is a one-stop place for all of a learner's goals.

    What are the steps to enroll in this Vlookup in Excel course?

    Enrolling in any of the Great Learning Academy’s courses is just one step process. Sign-up for the course, you are interested in learning through your E-mail ID and start learning them for free online.

    Will I have lifetime access to this free Vlookup in Excel course?

    Yes, once you enroll in the course, you will have lifetime access, where you can log in and learn whenever you want to. 

    Subscribe to Academy Pro+ & get exclusive features

    $29/month

    No credit card required

    Learn from 40+ Pro courses

    Access 500+ certificates for free

    700+ Practice exercises & guided projects

    Prep with AI mock interviews & resume builder

    Recommended Free Microsoft Excel courses

    Similar courses you might like

    Related IT & Software Courses

    50% Average salary hike
    Explore degree and certificate programs from world-class universities that take your career forward.
    Personalized Recommendations
    checkmark icon
    Placement assistance
    checkmark icon
    Personalized mentorship
    checkmark icon
    Detailed curriculum
    checkmark icon
    Learn from world-class faculties
    • Personalized Recommendations

      Placement assistance

      Personalized mentorship

      Detailed curriculum

      Learn from world-class faculties

      50% Average salary hike
    • Post Graduate Program in Cyber Security

      McCombs School of Business at The University of Texas at Austin

      Post Graduate Program in Cyber Security

      20 weeks · Online

      Know More

    Popular Topics to Explore

    Free Microsoft Excel Courses
    Free Software Courses
    Free Computer Courses
    Free ChatGPT Courses
    Free AI Courses
    Free Data Science Courses
    Free Python Courses
    Free Machine Learning Courses
    Free Cybersecurity Courses
    Free Management Courses
    Free Healthcare Courses
    Free Safety and Compliance Courses
    View All Topics

    Relevant Career Paths >

    Other IT & Software tutorials for you

    Enroll For Free