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

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

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! 😊👍

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

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

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

Nice and easy, thanks for sharing!

As usual, a great presentation. thank you

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

Mynda, thank you so much for your videos!

Hi Mynda!Great Tutorial On These Really Important Functions...Thank You :)

This is great.I love this tutorial.😄

Really valuable content. Thank you.

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!

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

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

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

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.

Thanks very useful. So much to learn, so little time :-)

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)

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.

Very useful tutorial 👍 thank You

Never learned so much in 24 minutes before- Thanks Mynda

Many thanks for this video, very clear, I wish you to be close to me all my work day long :) you make my work life easier thanks from France

Very useful as usual

thanks for the wonderful content

Excellent dear, excellent!!!

Thank you or sharing!

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

Thank you Mynda! You are gorgeous as always!

Good explain

Love the tshirt!

Thanks

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).

Great

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 !

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.

Thank you Mynda for this handy tutorial. Although XLook up is running exactly to find values from the range, it is not spilled for dublicate values in a range like; {“apple”, “orrange”, “banana”, “apple”} {10, 5, 20, 15} - - it returns just 10 not 15. I think it must be improved to be returned results regarding dublicate values in same range. And I would like to learn what the differences between Getpivotdata and Cube formulas are? Thank you

how do you get the formuals to autofill down the column ? is that a key combination?

Hi Mynda! Thanks for this! And as usual, there was an easter egg in there... or part of one... that had nothing to do with the actual theme! You were building a formula and referencing a cell that was buried under the formula building dialog and you clicked a cell in the desired column a row or two below and then somehow moved it up to the correct row that was under the dialog... how did you get it to move?

5:24 For logical AND() and OR() prefer the mathematical notation, that's easier for huge number of conditions: see examples below: AND() => =IF(([@Popular]="Yes")*([@[Salary $k]] =IF(([@Popular]="Yes")+([@[Salary $k]]

Trivial, but XLOOKUP looks to me like an improved version of LOOKUP (in the same way XMATCH is an updated MATCH) - the syntax of the first three arguments is exactly the same as LOOKUP. VLOOKUP syntax is quite different (and loathsome IMO!). Funny thing is I have seen people using IFERROR with XLOOKUP a fair bit.

Is there any way to add xlookup in office 2016

Damn... I saved it to watch later ...why didn't i watch it ealrier. Sorry Mynda. Great video...

I discovered that the VLOOKUP between 2 workbooks is fine if both files on locally stored. However, when both workbooks are in the OneDrive folder the VLOOKUP does not appear to work in the same manner. I'm not sure if you are able to recreate this and do a video on how users are able to correct the problem.

Is it possible to view the cell references instead of the table column names, e.g., =IF(AND(B6="Yes",C6

download links are not in the description.

Can anyone help me the download the excel file? When clicked the link it took me a website but there is no excel file there.

lieber Lehrer, in plain English, what's the exact difference between AND & OR? Logically seem quite sim.

Maybe this will help me get a legal job before 30

Hi Mynda. 'Top 10 Most Important Intermediate Excel Functions?' That is brave of you! I suspect it depends upon the areas in which one works, personal programming style and, most importantly, the version of Excel one is targeting. Like one of your earlier respondents, VLOOKUP has always been on my 'avoid' list; it has its place, just not on my worksheet. I always found 'in-place' filtering to be a cheap and nasty technique (I do not wish to indulge in baby games of peek-a-boo with my data) so, for me, the SUBTOTAL tricks are of little relevance. Nowadays, I always use the FILTER function (that you did identify) to ensure the workbook shows what I intend and does not depend on the state of filters. Back in the day, this involved Advanced Filter with Extract, which was a bit of a mission. Now, for me, it is the Lambda that is overwhelmingly the most important function. It comes at a price, I have had to consign all legacy versions of Excel to the trash can along with the steam-driven abacus! Recently, I had the rewarding experience of taking a previously written Lambda function and copying it to another workbook and solving a challenging problem in one step. chandoo.org/forum/threads/calculating-a-moving-weighted-average-during-resource-scheduling.38231/page-3 Still, your title stated 'intermediate' and perhaps that cuts out LAMBDA, its little brother LET and the support crew SCAN, REDUCE, MAP and MAKEARRAY.

Thanks