Top 10 Excel Functions you should learn in 2024

简介：

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 how to use and combine them, you can learn more. The ten functions are SUMIFS, XLOOKUP, FILTER, COUNTIFS, INDEX, EDATE, UNIQUE, TEXTJOIN, SORT, and IFERROR. Let's dive in. 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?