Most Excel Functions are USELESS ~ FOCUS on These 10 Instead

In this Video

0:00 - Most Excel functions are useless

0:42 - Number 1 function - SUMIFS

1:52 - XLOOKUP function

2:40 - How to get multiple values with lookup? (FILTER function)

3:43 - COUNTIFS Function

5:49 - INDEX Function

6:40 - The most important function

6:57 - EDATE Function

7:50 - TEXTJOIN Function

8:25 - Using TEXTJOIN in a FUN way

9:07 - UNIQUE Function

9:57 - SORT Function

11:05 - IFERROR Function

11:52 - What if you don't like FUNCTIONS?