HOW TO USE VLOOKUP EXCEL TUTORIAL FOR HR PROFESSIONALS // Excel function VLOOKUP explained with a real world application demonstration. VLOOKUP is a reference formula in Excel and it is the most helpful formula you can learn to use in Excel as an HR professional. It is a quick and easy way to insert columns of data from one spreadsheet into another based on a common reference cell between two spreadsheets. Learn how to use VLOOKUP so you can add a manager or salary column, for example, to an already existing spreadsheet. No need to enter data manually when you can use this reference formula. Watch this video to see how easy it is and leave a comment below if you have any questions for me on how to do this. Good luck!
__________
FREE DOWNLOADS:
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
RESOURCES:
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #MSExcel, #ExcelVLOOKUP, excel tutorials, how to use vlookup in excel, excel tips and tricks, excel tutorial, excel for HR, HR tech tutorial, microsoft excel, Sharon Smith HR
__________
PLAYLISTS:
Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
Excel Quickies (Under 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR