Understand Excel's XLOOKUP, HLOOKUP, VLOOKUP, INDEX-MATCH
Learn problem-solving skills with Dynamic Arrays (SEQUENCE, SORTBY, FILTER,etc), XLOOKUP, HLOOKUP, VLOOKUP, INDEX-MATCH
3.75 (2 reviews)
15
students
11 hours
content
Sep 2024
last update
$19.99
regular price
What you will learn
Master the Dynamic array functions - UNIQUE, OFFSET, FILTER, SORT, SORTBY, RANDARRAY, and SEQUENCE function
Discover the power of combining INDEX and MATCH functions for advanced lookup tasks.
Learn the versatile features of XLOOKUP, XMATCH
Combine SEQUENCE, RANDARRAY, SORTBY, INDEX to generate random array of data
Dynamically creating a calendar - SEQUENCE and DATE and WEEKDAY
Mapping Data with VLOOKUP and INDIRECT function
Discover the beauty of using VLOOKUP and INDIRECT function
Learn to retrieve data from horizontal tables with HLOOKUP.
Discover how to use VLOOKUP for both exact and approximate matches.
Understand how to use CHOOSE, TRANSPOSE, COLUMN, COLUMNS, ROW, ROWS functions
Reverse a list with SEQUENCE, INDEX, ROWS functions
Loading charts...
5993750
udemy ID
27/05/2024
course created date
21/07/2024
course indexed date
Bot
course submited by