
By ComSystem Solutions
Mastering Vlookup in Microsoft® Excel 2010/2013



By ComSystem Solutions
![]() |
![]() |
![]() comsystem@comsystemsolutions.com |
|
![]() |
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
Dec 2019 ›
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.
* Other terms & conditions apply.
![]() |
Request for Quotation |
![]() |
+603-5162-8254
+603-2201-4622 |
![]() |
maler@comsystemsolutions.com
comsystem@comsystemsolutions.com |
- Language: English, Bahasa Malaysia
- PowerPoint Presentation
- Workshop
- Computer Lab Work
- Certificate of Participation
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 ›
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 ›
|
|
![]() |
![]() |
Related Courses ›
- Microsoft® Excel 2010: Task Automation with VBA Using Macro
- Microsoft® Excel VBA for Non-Programmers
- Microsoft® Excel VBA Level 2: Developing Macro Applications
- Microsoft® Excel 2013 Basic & Intermediate
- Microsoft® Excel for Intermediate/Advance User
- More other Information Technology related courses