Vlookup Training for Microsoft Excel

Microsoft Excel Vlookup Training Course Vlookup Training for Microsoft® Excel
By ComSystem Solutions
Microsoft Office Family:

Mastering Vlookup in Microsoft® Excel 2010/2013

Course Title:
Mastering Vlookup in Microsoft® Excel 2010/2013
Training Category:
Information Technology
Target Audience:
Anyone who need to perform frequent searches on large Excel spreadsheet tables and those who are familiar Excel formulas.
Duration:
1 Day
Public Training Events
Aug 2017 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Thu 10 Aug 2017 9:00AM - 5:00PM
Fee Per Person:
RM450.00
Promotions:
  • Register before 30 Jul 2017 for only RM350 per person.
  • For 3 paxs registration, the 3rd person will receive a complimentary seat.
  • For 2 paxs registration, the 2nd person will be entitled to 20% discount.
Register Now!

* Other terms & conditions apply.

Course Introduction ›

Microsoft Excel's VLOOKUP (vertical lookup) function is used to find specific data that stored in a spreadsheet table. If you have a large product or a customer contact list, VLOOKUP can help you find data that matches specific criteria, such as the price of a specific item or a customer's phone number.

Course Objectives ›

Upon completion of this Vlookup course, participants should be able to:

  • Enter VLOOKUP arguments in a formula.
  • Use VLOOKUP to find values in Excel lists or tables.
  • Avoid VLOOKUP errors.

Course Outline ›

DAY 1

VLOOKUP Function

  • Introduction to the VLOOKUP

Trouble Shooting VLOOKUP Problems

  • Formatting Your Data
  • Removing Hidden Characters in your Data

Using VLOOKUP in a Dynamic Range

  • Using Named Formulas
  • Using Tables

Alternatives to VLOOKUP

  • CHOOSE Function
  • INDEX Function
  • MATCH Function
  • OFFSET Function

VLOOKUP Tips & Tricks

  • Getting VLOOKUP to pick the latest entry
  • VLOOKUP from Different Sheets

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-5162-8254, +603-2201-4622
Email Customer Service E-mail : [email protected], [email protected]

Related Courses ›

Published by: ,