All Content
Timespan
Most Excel Functions are USELESS ~ FOCUS on These 10 Instead
Nov 1, 2022 12:00 AM

Most Excel Functions are USELESS ~ FOCUS on These 10 Instead

External YouTube Channel

Excel has 400+ FUNCTIONS, and most of these are a WASTE of time. If you want to get good with Excel in a short time, focus on these 10 instead. Once you know...

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?