Jan 14, 2023 9:27 PM

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

External YouTube Channel

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.myonli

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