10 Advanced Excel Functions with Downloadable Reference Guide

Use these 10 advanced Excel functions to tackle common tasks that are not represented by any one function. You’ll have to combine functions or create complex formulas to do them. Please follow along with the free downloadable reference guide. You are welcome and encouraged to copy and distribute this guide.

Contents 0:00
1. NESTED IF 1:14
2. INDEX-MATCH 2:07
3. EXTRACT DOMAIN 3:18
4. CHOOSE RANDOM 4:13
5. COUNT WORDS 5:16
6. MOST FREQUENT 6:56
7. OFFSET-SUM 8:38
8. SUM n ROWS 10:54
9. LAST VALUE 12:23
10. INDIRECT-MATCH 14:53

#seletraining #excel #functions

[entrepreneursduesiecle]

it was a kind of video that I was really looking for. Thanks so much

[monikaverma]

You are an angel for sharing your expertise! Thanks

[sbatsia]

These advanced functions combine with the essential functions, are Impressive and very practical for using excel !!!

[gba]

Thank you very much for your lavish generosity!

[erickbourdin]

Wow I am always amazed by the power of excel and you present it in a very didactical way
Thank you ... Great video
Erick

[Lethesys]

Wow, im really impressed, helped a lot with lately problems of mine. Thank you!

[LotfyKozman]

Really very practical and valuable video. Thanks

[samenamest]

Thanks for the suggestion from my comment in your Advanced Tips & Tricks video. I was introduced to Index-match maybe two years ago, and it had me kicking myself for all those extra columns added to make vlookups work. Some of the other combinations I would not have thought of but can see how useful they could be.
I get an odd joy out of formulas that extract data from text, maybe because of all the time it saved me when given a data entry task.
I also want to up-sell the power of using list data validation for cells in a formula.

[anako]

Thanks very much. Very clear and useful.

[thinkexcel]

Great video! Very impressive and covered a number of function

[georgetosounidis]

Great video indeed and useful material from your website! Thanks for this :)

[CarlosMoreno-vwir]

Awesome knowledge!! Thanks so much for sharing

[virajmoghe]

Amzing video as usual. You explain the concept in such a simple and lucid manner. I have one querry (not related to this video) I may be wrong as well. Is there any option/function by which we can filter the rows just the way we filter columns? Thanks a lot

[kmzi]

Very useful, it's cover all the small function

[dannyleung]

Who needs nested IF when we have IFS? Or MAX(IF when there is MAXIFS?

[naimapedrono]

Hello, thank you for the video. I do need help: how to apply nested if if I want a specifi word when the cell contains another word, there are 7 of them?

[waqasamin]

Good day to u Sir,
Is there any way to unhide all sheets with a single click...
I mean I have a bunch of worksheets, I have hide them, when need to unhide i have to unhide each worksheet one by one... too lengthy

[bhushandeo]

Hii, why does =SUMPRODUCT(LEN(TRIM(B7:B8))-LEN(SUBSTITUTE(B7:B8, " ", ""))+1) work, but =SUM(LEN(TRIM(B7:B8))-LEN(SUBSTITUTE(B7:B8, " ", ""))+1) doesn't work, anyway we are summing over a 1D array, so why not use SUM instead of SUMPRODUCT?

[livingwaters]

I couldn't find the reference guide.

[SaurabhSingh-tdbd]

Keep camera more closer to the screen.