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.

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
=============

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

[daleanderson]

What a great tutorial and thanks for the accompanying file and references to additional tutorials. You are doing a great job. Thank you for all the help you are providing. Super!!

[mingddo]

Your videos got me promoted in my firm this year so thank you!!!!

[andrewsimpson]

I've always found it much easier teaching people things like IF statements etc. using the Function Argument window as (at least in my experience) it's laid out in a way that's easier to understand. I remember when I was starting out on my Excel journey, seeing people write arguments in a single line always confused me but as soon as I was introduced to the function argument window it was like a lightbulb was switched on.

[alparkson]

Mynda, you are the star of YouTube ~~ I'm serious. Your tutorials are fact filled and so well presented. Thank you for all of your hard work.

[wayneedmondson]

Great summary! Even when you know these functions, there is always something new to learn and new ways to use them. Thanks for demonstrating. Thumbs up!!

[emile]

Thanks for the tips !
Subtotal exclude hidden rows from Autofilter and Advanced filter (even if the values aren't in a table, with both 9 and 109 argument)
adding 100 to the operator argument only applies to manually hidden rows (or hidden by an outline)

[fazalahmedshaikh]

You are the star ⭐ .. Love you❤. For me your videos are very relevant. I learned so many excel formulas and many more other things from you.

Super useful knowledge you are sharing with all of us. Thank you again.

[itskhalilb]

Excellent tutorial and the use of the index and match and also the subtotal - 10/10

[fransvanderwerf]

am addicted now ;) Great simplified explanations that stick. thank you so much! great presentations

[vijayarjunwadkar]

Thank you Mynda for this super useful video! I have been using most of them regularly, but found a lot of value addition and ideas through your examples! Keep up the great work! 😊👍

[HandelMcHandel]

Never learned so much in 24 minutes before- Thanks Mynda

[parahiamin]

I find writing pseudo code beforehand helps structure the formula and makes it easier to write. Really good tutorial on how to use these functions. Thanks!

[isabellaify]

Hi thanks for the super helpful video. I have one question: why do you use "fill without formatting" instead of "double click" to drag the formula down? thanks.

[shiffamohammed]

Thanks a lot Mynda, for such a useful and nicely demonstrated excel tutorial video.

[aryaa]

Bwaha I completely forgot about Ben 10. He used to be my sister’s cartoon crush. Great tutorial, currently on maternity leave so it’s nice to recap all the popular functions from time to time. Xx

[jimfitch]

Great tutorial, Mynda! Thanks. I regularly use most of these. Exceptions are AGGREGATE (which I basically ignored until now) & GETPIVOTDATA (which I’m using increasingly since you released that tutorial).

[Luciano_mp]

These are very useful functions. Great. Thank you Mynda!

[gesalerico]

Mynda, thank you so much for your videos!

[chrism]

Excellent Mynda. I rarely use AGGREGATE but I can definitely see uses for this. Thanks!

[ogpeta]

Good video, if you just can be a bit more articulate about how you get tha some important data first and after how the formula functions are applying !