• views: 445
• date: 22 December 2021
• posted by: voska89

Become an Expert user of VLookup and XLookup
What you'll learn:
Become a Expert at using Vlookup in Excel
Learn Where and how to apply VLookup in Excel
Confident in applying Excel Vlookup or Excel XLookup on Multiple Dataset
Become proficient at using all the Lookup Formulas in Excel
Requirements
Basic Excel Knowledge
Understanding of How Excel Formulas work
Description
VLOOKUP and HLOOKUP are two of the most sought out formulas of Excel and is often used at work environment.
In this course you will learn a lot about VLookup and Xlookup - a newly launched formula of Excel.
You'll get to learn about the below scenarios
Using Vlookup and Xlookup on Simple Dataset
Using Vlookup and Xlookup on Date based Dataset
Using Vlookup and Xlookup on Text based Dataset
Using Vlookup and Xlookup to match and reference the approximate values
Using Vlookup and Xlookup to work with Wild Card characters in excel
Using Match () formula
Using INDEX () formula
Using INDEX () and Match () formula together
Some of the most common mistakes people tend to make and some of the most common errors you will face.
Vlookup has been critical for most of the tasks at work. However it had its disadvantages and if often time consuming if the data is complex. Xlookup arrived at the doorstep and resolved a lot of issues that was part of Vlookup and HLookup.
Yourexcelguy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine - whether it's for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.
About the Instructor: I'm a full time excel coach, I train people on Excel and that's something I really love doing.
Who this course is for
Beginner in Excel
Specialist in Excel




   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.