Master VLOOKUP in Microsoft Excel
![](https://ecert.edvantageinternational.com/wp-content/uploads/2022/01/T14216-Master-VLOOKUP-935x572-1-870x440.jpg)
Master VLOOKUP in Microsoft Excel
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.
Syllabus
- 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
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 8 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.
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.
<p><strong>Self-Paced</strong></p><br>
<ul><li>3 Months Access</li>
<li>Course Code: T14216</li>
<li>No Instructor, Start Anytime </li>
<li>$187.00 USD</li></ul>
<ul><li>3 Months Access</li>
<li>Course Code: T14216</li>
<li>No Instructor, Start Anytime </li>
<li>$187.00 USD</li></ul>
Be the first to add a review.
Please, login to leave a review