![Microsoft Excel Vlookup Training Course](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5xKWKVZzwD5rO5e5ubIhZlorQT15C6skG6bz-Uu_1bEb0OXkOKlSIlz3N1A5rovmmKWQlJSeelTiMYhJdEN-SfPn0QmXQykLI2ynW8d-2V3IGNOfzZLQjuu5dgMN9L7QmdEsxO2gnPtKY/s250-no/ms-excel-series.jpg)
By ComSystem Solutions
Mastering Vlookup in Microsoft® Excel 2010/2013
![PSMB Decoration Top](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkkiABQsIvNsHljML78byQixLG98LMHXtLacjOa42Nb_I6vY11a_RlbfOKuP31USyww9JcPnFY-4bRlUUaI8w3j9Je_RazAEY9_IvPDAKKTW-g3PSZ3jA9SyEHqHmtp92N4pDa0itSrwTz/w200-h47-no/psmb-deco-top.png)
![ComSystem Solutions Company Logo](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEius5c4KwfFDSrWF-lWoPeCPSJnMTJnnFcuJA9wBFDrv8eZBTsqEWlMYDNQWwW2tdz2LAWaV6UTUFmJQ4tid70w6UQeWcTNyfjn4Ycy-NSAgTiHNOMH31yI-W7PRg79fWkhjxEvq5EVp_Op/w130-h50-no/comsystem-logo-130x50.png)
![PSMB Decoration Bottom](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8OBVn0apF0q8uxialuFzXwGn_u8jzk9dk00i3FROb5BTm4tDBMuvDayHtkRUW6m0csu3EvQEfN3H7NpzI4HLH3eBJ5JCRNU7SfsKIYkk8KJcHMqeqRgC4t01SxY1mQ65DSFMxRoqS_r0w/w200-h28-no/psmb-deco-bottom.png)
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