Top 10 Most Important Intermediate Excel Functions

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 !

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

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.

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

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)

Thanks

Mynda, thank you so much for your videos!

Thank you Mynda! You are gorgeous as always!

Maybe this will help me get a legal job before 30

Very useful tutorial 👍 thank You

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.

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.

Love the tshirt!

Very useful as usual

Never learned so much in 24 minutes before- Thanks Mynda

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!

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

Good explain

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.

Really valuable content. Thank you.

As usual, a great presentation. thank you

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

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.

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

Excellent dear, excellent!!!

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

thanks for the wonderful content

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

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

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

Is it possible to view the cell references instead of the table column names, e.g., =IF(AND(B6="Yes",C6<100),C6*$H$5,"Nil") instead of =IF(AND([@Popular]="Yes", [@[Salary $k]]<100),[@[Salary $k]]*$H$5,"Nil")?

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

Thanks

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

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

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

Is there any way to add xlookup in office 2016

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?

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

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

Great

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.

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

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

This is great.I love this tutorial.😄

Thank you or sharing!

Nice and easy, thanks for sharing!