Top Excel Functions for Data Analysts & What NOT to Waste Time Learning
150.7 هزار بار بازدید -
2 سال پیش
-
Top Excel Functions for Data
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: www.myonlinetraininghub.com/top-excel-functions-fo…
- IF Formula builder tool: www.myonlinetraininghub.com/if-formula-builder
- SUMPRODUCT function tutorial: www.myonlinetraininghub.com/excel-sumproduct-an-al…
- XLOOKUP function tutorial: www.myonlinetraininghub.com/excel-xlookup-function
- INDEX function tutorial: www.myonlinetraininghub.com/excel-functions/excel-…
- FILTER function tutorial: www.myonlinetraininghub.com/excel-filter-function
- GETPIVOTDATA function tutorial: www.myonlinetraininghub.com/excel-getpivotdata-fun…
- Introduction to Power Query tutorial: www.myonlinetraininghub.com/introduction-to-power-…
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: 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
2 سال پیش
در تاریخ 1401/10/22 منتشر شده
است.
150,768
بـار بازدید شده