Learn basic Excel | #11 Excel vlookup, hlookup functions - basic
Get the practice excel file: https://drive.google.com/file/d/0B48_...
Watch the entire video: click on the link: http://hocexcelcoban.com/ or click on the link: http://goo.gl/VIKJuR
Receive new videos: Click on the subscribe button or send your email/facebook address to tund@bkindex.com
Support and answers: join the fanpage / hocexcelcobanvanangcao and the discussion group: / excelonline
Find this video again: type in the keyword to search for the vlookup excel bkindex function
Give me a small gift: click like, or comment (comment) under the video, or share it with your friends you
Thank you very much.
The video guides you on how to use the vlookup function, how to use the hlookup function in excel and combine it with other functions to solve practical problems.
In this video, you will learn Excel with the following functions:
how to use the vlookup function in excel (vlookup excel)
how to use the hlookup function in exel (hlookup excel)
how to use the iferror and isna functions to handle situations with the vlookup function
how to use conditional formatting to quickly detect errors (conditional formatting excel) with the vlookup function
using data validation in excel (data validation excel) with the vlookup function
combining additional string processing functions in Excel with the vlookup function.
Product created by BKIndex Group (http://bkindex.edu.vn)
You can find this video by typing the following search keyword on youtube: vlookup excel bkindex function
I introduce to you the PI O'LE learning model to learn skills more effectively
Step 1. Practice You should be using Excel for your daily work. If you have not used it yet, you should do a practice exercise to learn (register with us on facebook group)
Step 2. Interaction During the process of working, doing exercises, if there are some problems, you will discuss and ask questions. You can join the following discussion group: / excelonline
Step 3. Watch videos (Online) or study (Offline). You watch videos online or study at the center
Step 4. Read the textbook (Theoretical Lecture). Reading an entire course will give you a broad perspective on the issue you are interested in. Although this may not be used right now, it will help you a lot in the future.
Step 5. Test. You can make a practice Excel file to summarize what you have learned. Practice Excel file link: http://goo.gl/AihvI5
This video will support you in learning Excel 2007, learning Excel 2010, learning Excel 2013
On this page of the site you can watch the video online Learn basic Excel | #11 Excel vlookup, hlookup functions - basic with a duration of hours minute second in good quality, which was uploaded by the user Learn Excel 09 November 2014, share the link with friends and acquaintances, this video has already been watched 196,799 times on youtube and it was liked by 1 thousand viewers. Enjoy your viewing!
