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: [ Ссылка ]
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: [ Ссылка ]
SUMPRODUCT alternative to SUMIFS: [ Ссылка ]
AGGREGATE Tutorial: [ Ссылка ]
XLOOKUP Tutorial: [ Ссылка ]
VLOOKUP Tutorial: [ Ссылка ]
INDEX Funciton - 5 things most people don't know about INDEX: [ Ссылка ]
The amazing FILTER Function: [ Ссылка ]
GETPIVOTDATA - after watching this video you'll love it: [ Ссылка ]
Take my Advanced Excel Formulas course: [ Ссылка ]
Connect with me on LinkedIn: [ Ссылка ]
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
