Understand Excel’s XLOOKUP, HLOOKUP, VLOOKUP, INDEX-MATCH

سرفصل های دوره

Learn problem-solving skills with Dynamic Arrays (SEQUENCE, SORTBY, FILTER,etc), XLOOKUP, HLOOKUP, VLOOKUP, INDEX-MATCH

1. Introduction

1. Introduction

2. Introduction to Basic Excel Dynamics

1. Introduction to Excel - part 1.

2. Introduction to Excel - part 2

3. How to Use the Search Bar in Office 2021

4. Find, Replace, Wildcard

5. Introduction to Excel - part 3

6. Data Validation

7. Creating data as a list

8. Introduction to Formula and Basic Arithmetic Operators

9. Logical Operators in Excel

10. Concatenating in Excel

11. Relative vs Absolute Referencing - Part 1

12. Relative vs Absolute Referencing - Part2

13.1 spill range multiplication table.xlsx

13. Understanding Spill range and spill range reference - multiplication table

3. Creating an Array Formula Constants

1. Array Formula - Part 1

2. Array Formula - Part 2

4. INDEX-MATCH Functions

1.1 Lookup-Dynamic Array Files.zip

1. INDEX, MATCH functions

2. MATCH function - Match type

3. Nesting MATCH inside INDEX function - part 1

4. Nesting MATCH inside INDEX function - part 2

5. CHOOSE, TRANSPOSE, COLUMN, ROW Functions

1. CHOOSE, TRANSPOSE functions

2. COLUMN, COLUMNS, ROW, ROWS functions

6. LOOKUP, VLOOKUP, HLOOKUP Functions

1. LOOKUP, VLOOKUP functions

2. VLOOKUP Function again

3. Nesting MATCH function inside VLOOKUP

4. HLOOKUP Function

5. Absolute Referencing in table array using HLOOKUP

6. MATCH and HLOOKUP combined

7. Using VLOOKUP to find duplicate values in 2 array of data

7. Combining VLOOKUP and HLOOKUP Functions

1. VLOOKUP and HLOOKUP combined - part 1

2. VLOOKUP and HLOOKUP combined - part 2

8. ADDRESS, OFFSET, HYPERLINK, FORMULATEXT, INDIRECT functions

1. ADDRESS Function

2. OFFSET function

3. HYPERLINK, FORMULATEXT, INDIRECT functions

9. Mapping data with VLOOKUP and INDIRECT Function

1. Mapping Data with VLOOKUP and INDIRECT function - scenario 1

2. Mapping Data with VLOOKUP and INDIRECT function - scenario 2

3. Evaluating the VLOOKUP and INDIRECT mapping

10. VLOOKUP and RANDBETWEEN, INDEX and RANDBETWEEN Functions

1. VLOOKUP and RANDBETWEEN - generate random data - Part 1

2. VLOOKUP and RANDBETWEEN - generate random data - Part 2

3. INDEX and RANDBETWEEN - to generate random data

11. XMATCH Function

1. XMATCH Function

2. XMATCH - search mode

12. XLOOKUP Function

1. XLOOKUP - part 1

2. XLOOKUP - part 2

3. XLOOKUP - 2 Way Lookup

4. XLOOKUP - [if not found] and [match mode]

5. XLOOKUP with multiple criteria

6. XLOOKUP with logical criteria

13. UNIQUE and FILTER Functions

1. UNIQUE function

2. FILTER function

3. FILTER function on column data

14. SORT and SORTBY Functions

1. SORT function

2. SORT function - sort by columns - [by cols] being TRUE

3. SORTBY function

4. Custom sort - SORTBY with LEN function

5. Custom sort - SORTBY with MATCH function

6. SORTBY with TEXT function - Custom sort dates

7. SORTBY with MONTH or DAY functions - Custom sort dates

8. SORTBY function on headings of your data

9. SORTBY and COLUMN to reverse the order of a column list

10. SORTBY and ROW to reverse the order of a row list

15. RANDARRAY Function

1. RANDARRAY function

2. RANDARRAY with CHAR to generate random alphabets

3. RANDARRAY with DATE and EDATE functions

16. SEQUENCE Function

1. SEQUENCE function - part 1

2. SEQUENCE function - part 2

3. ROUNDUP and SEQUENCE - repeated numbers

4. MOD and SEQUENCE - repeated sequence

5. SEQUENCE with TRANSPOSE, ROMAN, TEXT functions

6. SEQUENCE with DATE and EDATE functions

7. Reverse a list with SEQUENCE, INDEX, ROWS functions

8. Reverse a list with SEQUENCE, SORTBY, ROWS functions

9. Alphabetic sequence with SEQUENCE, CHAR

10. Generate sequence of time - SEQUENCE, TIME and HOUR

11. SEQUENCE, RANDARRAY, SORTBY, INDEX to generate random array of data - Part 1

12. SEQUENCE, RANDARRAY, SORTBY, INDEX to generate random array of data - Part 2

13. Filtering every nth value in a data - FILTER and MOD and SEQUENCE - part 1

14. Filtering every nth value in a data - FILTER and MOD and SEQUENCE - part 2

15. Dynamically creating a calendar - SEQUENCE and DATE and WEEKDAY - part 1

16. Dynamically creating a calendar - SEQUENCE and DATE and WEEKDAY - part 2

17. Dynamically creating a calendar - SEQUENCE and DATE and WEEKDAY - part 3

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy