• views: 436
• date: 25 February 2022
• posted by: voska89

What you'll learn
Learn how to use the Vlookup and Xlookup functions
Understand the use of Match and Index
Learn the new Xlookup function
Understand how to link one sheet to another sheet with formulas
Requirements
Understanding of Basic Excel worksheets and formulas
Description
In Microsoft Excel, sometimes there is a need to look up information from a table or from a different sheet, or to link the sheets together.
Excel has built-in functions called vlookup, hlookup, xlookup, and match and index and other functions to facilitate this process.
However, many people get very confused when using the vlookup and hlookup formulas. This course will really break it down so that anybody can understand and use these functions, and become more productive in Excel.
This course will show you how to do that with the following functions/formulas
- Vlookup - includes several examples and different variations of the vlookup function
- Hlookup - similar to the vlookup, but used when the data table is horizonal instead of vertical
- Xlookup - this is a new function which is simpler to use than the vlookup or hlookup.
- Match - usually used with the index function, so it is also called match/index
- Index - usually used with the match function
- Xmatch - anew function which simplifies the match / index
- Linking sheets with formulas
- Data Consolidation - adding sheets together that are similar
Learn how to use these functions in Excel from Tom Fragale, a Microsoft Certified Trainer with over 22 years of training experience, and a total of over 38 years of professional experience in the IT field
Who this course is for
Anyone who wants to increase their use and productivity in Excel

Homepage

https://www.udemy.com/course/excel-vlookup-xlookup-and-match-index-functions/

   
   
   

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.