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

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 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 41641
    حجم: 5117 مگابایت
    مدت زمان: 655 دقیقه
    تاریخ انتشار: ۱۸ آذر ۱۴۰۳
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید