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.
Instructor(s):Self-Study
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.
Hide Syllabus
Lesson 1
- Microsoft Excel LOOKUP Functions
- Using the VLOOKUP Function
- Things to Know when Using VLOOKUP
- Excel Features that are Helpful when Using VLOOKUP
- Exercise: Using an Absolute Reference
- Named Ranges
- Exercise: Using Named Ranges in Formulas
- And Function
- Exercise: Use VLOOKUP to Add a Product Description and Price
- Exercise: Use Absolute References within VLOOKUP
- Exercise: Use VLOOKUP to Obtain Letter Grades
- Exercise: Use VLOOKUP to Add Employee Information
- Exercise: Use VLOOKUP to Add Employee Phone Numbers
- Exercise: Use a Commission Table
- Exercise: Use Named Ranges to Merge Data
Hide Syllabus