All Videos Channels
  1. Aggregate Values in Excel Table using Array Formulas in One Cell

    Aggregate Values in Excel Table using Array Formulas in One Cell

    165
  2. Dynamic Aggregation using LET Function in Microsoft Excel (Dynamic Array Formula)

    Dynamic Aggregation using LET Function in Microsoft Excel (Dynamic Array Formula)

    3
  3. Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    4
    0
    31
  4. Summarize & Transpose Data & Remove Duplicates Ignoring Case (Dynamic Array Formula) in Excel

    Summarize & Transpose Data & Remove Duplicates Ignoring Case (Dynamic Array Formula) in Excel

  6. Excel Formula Lookup Multiple Results: Return headers based on matrix values

    Excel Formula Lookup Multiple Results: Return headers based on matrix values

    3
    0
    6
  7. Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)

    Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)

    4
    0
    83
  8. Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    1
  9. Why VLOOKUP is still relevant? How to solve #N/A, #REF etc errors in Excel

    Why VLOOKUP is still relevant? How to solve #N/A, #REF etc errors in Excel

    7
  10. Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    3
    0
    9
  11. Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    3
    0
    16
  12. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    10
  14. Quick And Easy Tips For Understanding Ribbon Navigation And The Quick Start Menu

    Quick And Easy Tips For Understanding Ribbon Navigation And The Quick Start Menu

    28
  15. Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    3
    0
    15
  16. Basic to Advanced Lookup Formula in Excel

    Basic to Advanced Lookup Formula in Excel

    30
  18. Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)

    Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)

    3
    0
    125
  19. Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)

    Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)

    4
    0
    14