Top 10 Most Important Intermediate Excel Functions

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/top-10-intermediate-excel-functions

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/excel-if-and-or-functions-explained

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

AGGREGATE Tutorial: https://www.myonlinetraininghub.com/excel-aggregate-function

XLOOKUP Tutorial: https://youtu.be/2ViMm-wuM3U

VLOOKUP Tutorial: https://www.youtube.com/watch?v=4-5-TBhOP6Q

INDEX Funciton - 5 things most people don't know about INDEX: https://www.youtube.com/watch?v=pP7AMLJa0Vc

The amazing FILTER Function: https://www.youtube.com/watch?v=ZCQAweoAdOw

GETPIVOTDATA - after watching this video you'll love it: https://www.youtube.com/watch?v=LDf_ORnSCu4

Take my Advanced Excel Formulas course: https://www.myonlinetraininghub.com/advanced-excel-formulas-course

Connect with me on LinkedIn: https://www.linkedin.com/in/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