Top Excel Functions for Data Analysts and what functions you don’t have to waste time learning and why.

Download the example Excel file here: https://www.myonlinetraininghub.com/t...

- IF Formula builder tool: https://www.myonlinetraininghub.com/i...

- SUMPRODUCT function tutorial: https://www.myonlinetraininghub.com/e...

- XLOOKUP function tutorial: https://www.myonlinetraininghub.com/e...

- INDEX function tutorial: https://www.myonlinetraininghub.com/e...

- FILTER function tutorial: https://www.myonlinetraininghub.com/e...

- GETPIVOTDATA function tutorial: https://www.myonlinetraininghub.com/e...

- Introduction to Power Query tutorial: https://www.myonlinetraininghub.com/i...

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy  

0:00 Top Excel Functions for Data Analysts
0:44 IF Function
2:01 Nested IF Formulas
3:14 IFS Function
4:42 AND Function
5:43 OR Function
6:49 SUMIFS Function
8:42 XLOOKUP Function
10:07 INDEX & MATCH
12:17 FILTER Function
13:22 IFERROR Function
14:38 EOMONTH Function
15:59 EDATE Function
16:43 NETWORKDAYS.INTL Function
18:54 GETPIVOTDATA Function
20:24 UNIQUE Function
21:48 SORT Function
23:11 SEQUENCE Function
24:43 The functions you don't need to learn