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: 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: www.myonlinetraininghub.com/e...
SUMPRODUCT alternative to SUMIFS: www.myonlinetraininghub.com/e...
AGGREGATE Tutorial: www.myonlinetraininghub.com/e...
XLOOKUP Tutorial: • Excel XLOOKUP Function...
VLOOKUP Tutorial: • Excel VLOOKUP Function...
INDEX Funciton - 5 things most people don't know about INDEX: • Excel INDEX Function -...
The amazing FILTER Function: • Excel FILTER Function ...
GETPIVOTDATA - after watching this video you'll love it: • I 💓 GETPIVOTDATA and w...
Take my Advanced Excel Formulas course: 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
Негізгі бет Ғылым және технология Top 10 Most Important Intermediate Excel Functions
Пікірлер: 112