Print Course information
E-mail to a friend
Return to Course Catalog

Online Course Catalog Registration is now available for the MTP Fall 2025 catalog. Any adult aged 18 and older is eligible to register for classes. Permission must be granted by MTP prior to registration for younger participants for all classes, except Ageless Adventures. ADVANCED SEARCH SIGN IN OR CREATE AN ACCOUNT

Master VLOOKUP in Microsoft Excel   

Obtain valuable skills working with data in Excel in this self-paced, online course.

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.

 

 

Click Here For Additional Course Information
Requirements:

 

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • 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.

Instructional Material Requirements:

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

 

In this VLOOKUP in Microsoft Excel self-paced course, you will learn how to use the VLOOKUP function to work with data more effectively.

 
  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
 

What you will learn

  • How to effectively use the LOOKUP functions
  • Understand Excel features that are helpful when using VLOOKUP

How you will benefit

  • Gain more in-depth Excel skills
  • Increase your employability and value within any company
  • Gain confidence in your ability to used advanced Excel functions and features

Self-Study
Master VLOOKUP in Microsoft Excel
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.

Obtain valuable skills working with data in Excel in this self-paced, online course.

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.

 

 

Click Here For Additional Course Information
Requirements:

 

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • 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.

Instructional Material Requirements:

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

 

In this VLOOKUP in Microsoft Excel self-paced course, you will learn how to use the VLOOKUP function to work with data more effectively.

 
  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
 

What you will learn

  • How to effectively use the LOOKUP functions
  • Understand Excel features that are helpful when using VLOOKUP

How you will benefit

  • Gain more in-depth Excel skills
  • Increase your employability and value within any company
  • Gain confidence in your ability to used advanced Excel functions and features

Self-Study

Course Price: $109.00Course #: ILC156 
 

By registering, I agree to INDEMNIFY AND HOLD HARMLESS Master the Possibilities, Inc., Sidney Colen & Associates, Ltd., On Top of the World Communities, Inc., Horticultural Arts & Park Institute, Inc., Bay Laurel Community Development District, and any of their agents, directors, officers, representatives, volunteers and employees from any and all loss, damage, injury, action or cause of action resulting from the classes, events, or trips and/or equipment owned or operated or permitted to be used or operated or is used or operated. This Release Waiver and Hold Harmless Agreement includes those classes, events, or trips inside or outside of Master the Possibilities, Inc. For the full waiver, visit  https://www.masterthepossibilities.org/sites/default/files/PDF/WaiverofLiability.pdf .

If class is cancelled by the participant because of COVID positive results, there will still be a processing fee incurred by the participant.

Some Title



Your Selections

×