Course Overview

Easily retrieve data from large datasets and elevate your spreadsheet proficiency in this training course, "Lookup Functions in Excel to Maximize Your Efficiency and Impact." Lookup functions are powerful tools that allow you to extract specific information from tables and databases based on certain criteria. Throughout the course, you will delve into diverse lookup functions, refining your proficiency in effectively retrieving and analyzing data within Excel.

Discover how VLOOKUP and HLOOKUP work, when to use them, and how to overcome their limitations. Create dynamic and accurate formulas to retrieve data from different columns and rows, even when your lookup value isn't in the first column. Combining INDEX and MATCH functions will unlock the ability to perform versatile lookups regardless of your data's structure.

Delve into the XLOOKUP function to perform two-way lookups and handle complex scenarios effortlessly. Learn to create unique lists using the UNIQUE function, and see how the CHOOSE function simplifies lookups by combining random number generation with specific criteria.

This course offers step-by-step guidance and practical examples to acquire a valuable skillset for boosting productivity and Excel proficiency.

Learning Objectives:

After taking this course, You'll be able to:

  • Implement VLOOKUP and HLOOKUP to retrieve data effectively.
  • Integrate INDEX and MATCH for non-sequential data retrieval tasks.
  • Utilize XLOOKUP to execute complex two-way lookups effortlessly.
  • Generate unique lists using the UNIQUE function and utilize the CHOOSE function to simplify random-based data.

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
9/13/2023
Duration
50 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • Yes
Downloadable Resources
  • Exercise Files
  • Transcripts
Completion Criteria
  • Visit all pages
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our

Privacy Policy.