Using VLOOKUP in Excel 2016: VLOOKUP Simplified with 5 Examples

What to be proficient in Excel? Learn how to use VLOOKUP explained in a simplified way with five examples. For more information and to learn more, please visit http://learn.kaceli.com.

In this video, we will cover the following areas related to VLOOKUP in Excel. This is a very powerful feature in the business environment or anyone that wants to be proficient in Excel. Here is what we will cover:
Concepts related to using VLOOKUP in Excel
Constructing the VLOOKUP formula using the functions wizard.
Looking up for a particular value in a data range.
Using VLOOKUP in conjunction with a dropdown list.
Merging data from multiple worksheets via VLOOKUP.
Using VLOOKUP in to extract data from another worksheet for mailmerges etc.
Creating an input form using VLOOKUP in Excel looking up the employee information by supplying the Employee ID.
Using VLOOKUP to calculate commissions on sales.

If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Video URL: https://youtu.be/sMeT-xuL2fQ
DATA File to follow along the video: https://kaceli.com/a/excel-2016-data-file/. See worksheet 21 once you open the Excel file.

Keep in touch:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Видео Using VLOOKUP in Excel 2016: VLOOKUP Simplified with 5 Examples канала Kaceli TechTraining