Top Excel Functions for Data Analysts & What NOT to Waste Time Learning

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/top-excel-functions-for-data-analysts - IF Formula builder tool: https://www.myonlinetraininghub.com/if-formula-builder - SUMPRODUCT function tutorial: https://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs - XLOOKUP function tutorial: https://www.myonlinetraininghub.com/excel-xlookup-function - INDEX function tutorial: https://www.myonlinetraininghub.com/excel-functions/excel-index-function - FILTER function tutorial: https://www.myonlinetraininghub.com/excel-filter-function - GETPIVOTDATA function tutorial: https://www.myonlinetraininghub.com/excel-getpivotdata-function - Introduction to Power Query tutorial: https://www.myonlinetraininghub.com/introduction-to-power-query View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/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