Most Excel users know the basic functions like SUM, COUNT, AVERAGE etc. Therefore, in this tutorial I’m going to cover the 10 most important intermediate level Excel functions every Excel user should know. Watch the video for an introduction to each function, and then dive deeper by following the links below.
Download the file here: https://www.myonlinetraininghub.com/t...
Note: there’s technically 17 functions covered in this tutorial, but a few of them do the same thing as other functions, or are very similar, so I’ve only counted 10 ;)
More Tutorials
=============
IF Functions Explained: https://www.myonlinetraininghub.com/e...
SUMPRODUCT alternative to SUMIFS: https://www.myonlinetraininghub.com/e...
AGGREGATE Tutorial: https://www.myonlinetraininghub.com/e...
XLOOKUP Tutorial: • Excel XLOOKUP Function Definitive Gui...
VLOOKUP Tutorial: • Excel VLOOKUP Function Both Uses an...
INDEX Funciton 5 things most people don't know about INDEX: • Excel INDEX Function 5 Secret Featu...
The amazing FILTER Function: • Excel FILTER Function + Trick to Rear...
GETPIVOTDATA after watching this video you'll love it: • I GETPIVOTDATA and why you should too!
Take my Advanced Excel Formulas course: https://www.myonlinetraininghub.com/a...
Connect with me on LinkedIn: / myndatreacy
0:00 Introduction
0:38 IF
2:01 Nested IFs
3:37 IFS
5:24 IF(AND...
6:25 IF(OR...
7:32 SUMIFS
9:25 SUBTOTAL
12:20 AGGREGATE
14:01 XLOOKUP & VLOOKUP
15:25 INDEX & MATCH
17:36 FILTER
18:40 IFERROR & IFNA
19:57 EOMONTH
21:17 EDATE
22:02 GETPIVOTDATA