Vlookup Training for Microsoft® ExcelBy 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 Training
|
 Register for Public Training
|
maler@comsystemsolutions.com
comsystem@comsystemsolutions.com |
|
+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
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:
* Other terms & conditions apply.
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 |
For Other Inquiries
Contact ComSystem Solutions
|
|
+603-5162-8254
+603-2201-4622 |
|
|
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 ›
|
|
|
Call : +603-5162-8254, +603-2201-4622
|
|
E-mail : maler@comsystemsolutions.com,
comsystem@comsystemsolutions.com
|
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
