Duration: 1h 34m | Video: .MP4, 1280×720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 723 MB
Genre: eLearning | Language: English
Do you want to learn how to use the Vlookup function so you can apply it to your own job or business? Come join this easy to follow and engaging skill quest designed to take you from beginner to Vlookup pro! I will walk you through step by step how to use the VLookup formula with real world examples for you to practice along the way!
Key Features Of This Class
Hands-on Vlookup examples to practice after each lesson
Engaging class setup / structure
In-depth Class Project at the end to test your skills
Less than 2 hours
What You Will Learn
The purpose of the Excel Vlookup Function
The syntax of the Vlookup Formula (Lookup Value, Table Array, Column Index, Match Type)
The fundamental understanding of how the Vlookup function works
How to lookup values in a column and bring a matching value into a cell
How to lookup values in a column and bring multiple matching values into a column
How to perform VLookups between different sheets
Understanding absolute reference vs whole column table arrays
How to use multiple criteria to create unique lookup IDs
How to handle data on the left side of your table array comparing column
How to convert your Vlookup formula to values and when it’s important
How to convert your lookup ids to text or number quickly
How to use the TRIM formula and when it’s important to utilize
How to convert your range to a table and when it’s helpful for your VLookup
The top 10 common issues preventing your Vlookup from working / calculating and how to avoid them
And much more!
Who This Class Is For
Vlookup beginner level / no experience
Anyone who wants to improve their excel-related skills for their job or business
Anyone who wants to save time in excel by mastering the Vlookup function
Anyone looking to land a new job where understanding the Vlookup formula will help
Microsoft Excel 2013 or greater
About The Teacher
Founder of Skill Quests, an educational course creation company providing valuable skill-based training experiences that are engaging, interactive, and fun
Over 10 years of real-world Field Development, Data Analytic, and Microsoft Product Experience
Upon Completion Of This Class
I would love to hear your feedback and comments once you complete the course. Feel free to ask any questions and/or leave a review.
Feel free to follow us on our social media platforms.
So let’s get this quest started! I can’t wait to see your class projects!