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

“Experience the power of Vlookup in finding specific data in huge spreadsheet table!”

By ComSystem Solutions


PSMB Certified Training Provider • Comptia Authorized Delivery Partner • Pearson Vue Certified Test Centre • Registered with Ministry of Finance
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service maler@comsystemsolutions.com
comsystem@comsystemsolutions.com
Contact Customer Service +603-5162-8254 , +603-2201-4622
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
Dec 2019 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Mon 16 Dec 2019 9:00AM - 5:00PM
Fee Per Person:
RM550.00
Promotions:
  • Register before 06 Dec 2019 for only RM350 per person.
  • 20% Discount for the 2nd seat registration.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact ComSystem Solutions
Contact customer service +603-5162-8254
+603-2201-4622
Email customer service maler@comsystemsolutions.com
comsystem@comsystemsolutions.com
Delivery Methods
  • Language: English, Bahasa Malaysia
  • PowerPoint Presentation
  • Workshop
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

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 : maler@comsystemsolutions.com, comsystem@comsystemsolutions.com

Related Courses ›

Published by: ,
online learning icon Request for Online Training
Contact Us
Animated Progress Icon

Contact Assistant