• views: 427
• date: 26 March 2024
• posted by: voska89

In-depth tutorial on Excel lookup functions: XLOOKUP, VLOOKUP, HLOOKUP, MATCH, XMATCH, INDEX, UNIQUE, SORT and FILTER
What you'll learn:
Locate data with MATCH, INDEX and XMATCH functions
Learn VLOOKUP, HLOOKUP and XLOOKUP Excel functions
Find matching data without using external lists
Other functions with LOOKUP capabilities
Requirements:
No previous experience is needed
Description:
Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility. Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow.For many Excel users, some of the most important functions they use are lookup functions. In this course, I'll be covering many of those functions, including the widely used VLOOKUP, as well as the all-important XLOOKUP, destined to replace both VLOOKUP and HLOOKUP, while expanding the capabilities of both of those functions. I'll also be showing you some of the newer dynamic array lookup functions, like unique, filter, sort, and sort by, changing the way you use Excel and opening up new horizons as you work with formulas and functions.
Who this course is for:
Intermediate Data Analysts wanting to learn in-depth Excel lookup functions
Homepage

https://www.udemy.com/course/mastering-microsoft-excel-lookup-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.