Master VLOOKUP in Microsoft Excel

Master VLOOKUP in Microsoft Excel

In this VLOOKUP in Microsoft Excel self-paced course, you will learn how to use the VLOOKUP function to work with data more effectively.
3 Months Access / 12 Course Hrs
  • Details
  • Syllabus
  • Requirements

Details

Master the VLOOKUP function in Microsoft Excel and gain valuable skills applicable in any workplace where data is used when you complete this self-paced, online course. You will learn to work with data more effectively using the VLOOKUP functions and other helpful features in Microsoft Excel.

Enrollment Options:
Self-Paced
3 Months Access Course Code: T14216
No Instructor, Start Anytime
£79.00 GBP

Syllabus

  1. Microsoft Excel LOOKUP Functions
  2. Using the VLOOKUP Function
  3. Things to Know when Using VLOOKUP
  4. Excel Features that are Helpful when Using VLOOKUP
  5. Exercise: Using an Absolute Reference
  6. Named Ranges
  7. Exercise: Using Named Ranges in Formulas
  8. And Function
  9. Exercise: Use VLOOKUP to Add a Product Description and Price
  10. Exercise: Use Absolute References within VLOOKUP
  11. Exercise: Use VLOOKUP to Obtain Letter Grades
  12. Exercise: Use VLOOKUP to Add Employee Information
  13. Exercise: Use VLOOKUP to Add Employee Phone Numbers
  14. Exercise: Use a Commission Table
  15. Exercise: Use Named Ranges to Merge Data

Requirements

Hardware Requirements:

This course must be taken on a PC device. A Mac OS is not compatible.

Software Requirements:

  • PC: Windows 8 or later operating systems.
  • Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
  • Microsoft Excel (not included in enrollment)
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites:

You will need basic skills with Excel to complete this online course.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.