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.

• IF Formula builder tool: www.myonlinetraininghub.com/if-formula-…

https://www.myonlinetraininghub.com/if-formula-builder

• SUMPRODUCT function tutorial: www.myonlinetraininghub.com/excel-sumpr…

https://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs

• XLOOKUP function tutorial: www.myonlinetraininghub.com/excel-xlook…

https://www.myonlinetraininghub.com/excel-xlookup-function

• INDEX function tutorial: www.myonlinetraininghub.com/excel-funct…

https://www.myonlinetraininghub.com/excel-functions/excel-index-function

• FILTER function tutorial: www.myonlinetraininghub.com/excel-filte…

https://www.myonlinetraininghub.com/excel-filter-function

• GETPIVOTDATA function tutorial: www.myonlinetraininghub.com/excel-getpi…

https://www.myonlinetraininghub.com/excel-getpivotdata-function

• Introduction to Power Query tutorial:

www.myonlinetraininghub.com/introductio…

https://www.myonlinetraininghub.com/introduction-to-power-query

In this Video

0:00 Introduction

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