10 Advanced Excel Formula Examples | FREE Excel Course

[@HarshitSharma-wx9zc]

🤯dimaag ghum gaya bhaiya🤯

[@GoGetSP]

Get Unique list was difficult when I tried to understand for the first time I rewatched and got it. Happy about it , Thanks!!

[@lovemovies832]

You can just use "=unique" formula or you can just add filter and from there you can apply unique filter he is making everything complicated

[@balamira297]

Idk why this channel is underrated!

[@ldmlhome]

Your explanations are very clear, I appreciate your video’s tremendously!]

[@bangkit5097]

Thanks a lot sir. I watch your playlist since the 1st video but unfortunately after watch this exercise I just feel that I don't understand how to write the function at all :((

[@adetutu4413]

i relate bro

[@iliesboukhatem7803]

thank you so much for this useful video, these are great examples that could make my daily tasks easier!

[@technicalgolpo3781]

Awesome thank you for this course really learn a lot through this video

[@yash9625]

How to remmember all these.....do you provide practice sheets??? Any practice sheet links? Thanks

[@wayneedmondson1065]

Hi Sumit.. this video was very useful.. putting to work some of the functions you've covered prior in practical ways to solve problems. I love your examples and solutions. They cause me to think more critically about how to approach my own business problems. Thanks for offering this video series for free to the public.. very generous of you and of great benefit to the online EXCEL community who takes advantage of it. Thumbs up! PS - For your Example 10.. Extract Data using Drop Down List.. I worked with your method and then set about consolidating the Helper Column logic to put it all within a single array formula. This is what I came up with (requires entering with CSE): =IFERROR(INDEX(C$5:C$24,SMALL(IF(($I$3=$E$5:$E$24)*(ROW($E$5:$E$24)-ROW($E$4))=0,"",($I$3=$E$5:$E$24)*(ROW($E$5:$E$24)-ROW($E$4))),ROWS($E$5:$E5))),"") If you enter this formula in cell K5 and copy it right 3 columns and down 20 rows, you don't need the Helper Columns. It performs just as your example that uses the Helper Columns. I'm sure you already know this.. I'm still enjoying the experimentation process and learning. Thanks for the inspiration to take it a step further for my own education. Thumbs up!

[@GoGetSP]

I haven't understood the parentheses in excel for SUMPRODUCT formula. shouldn't it be before -3 operation?Thanks!

[@twj3674]

Omg, from excel to coding is so hard😵‍💫😵‍💫☠☠

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@roshabhandari]

Thank you so much for all your tips and tricks. It helped me a lot to work efficiently.

[@gokuvegeta9500]

You're Indian but your skin is so white somehow

[@rimmi_ram]

Sir agar me apka poora course youtub se hi krlu to Kia mujhe koi alg se computer course karne ki need to nhi hai na ??? Me apna resume bana ke job ke liye apply kar sakti hu na???? Sir pls tell me ?

[@trumpexcel]

Yes, the free Excel course is enough. You don't need to buy any other courses

[@rimmi_ram]

@@trumpexcel thank you so much for your reply, other offline courses for the same course asking 6000 rupee which I can't pay! And then I found your channel you are doing great job 👍 and your teaching style is just amazing I have learnt so many things In just two days please keep sharing your knowledge with us ,very helpful for me 🙂

[@Brian-tt]

at 28:04, since it's the quarterly value, how can you show the sum of 8800+8830+2150 instead of 8800? Thanks!

[@MHb789]

Didnt know that excel can get complex! How can I enhance logic building skills?

[@dariknour6051]

Why did you use rows D5:D5 in the getting unque list problem?.

[@lahiru954]

I appreciate the way of your explanation. And finally got with some valuable logics in Excel. Thank you so much

[@lolaadeoye3584]

Thanks so very much for sharing

[@MahendarMIB]

SIR, when I use V look up for cross checking data availability in other column and double click on it ( video at4.13) all cells displayed australia only but if I double click each cell then it displayed corresponding country . how to solve this sir?

[@khalid_4807]

at 22:38 how does he make the names available in cell E4

[@GoGetSP]

at 18:14 if I am sorting the list then it doesn't end up giving the last value???? Why is that? Thanks.

[@geeiyer1]

very good and really helpful

[@ashoksethia9852]

HI, in the formula for closest match, if multiple PPL are having similar match , the formula would only pick one , and not show all of them, in that case how do we get all the name that meet the criteria???? if you could help

[@heeyaboruah9226]

At 35:04 it outlined or bordered the wrong one if anyone noticed

[@adilansari4663]

Hi Sumit it would be best if you just attached the used data in description. So it'll be helpful for practice.

[@matteobiancardi9581]

you can get it from his web page

[@darshanajain6033]

In the 4) get the last value in the list, since we are using vlookup approx match, the number in the list should be sorted in ascending order right?

[@bijogxazindagi7545]

i used this instead. =INDEX(Array,ROWS(Array))

[@bijogxazindagi7545]

he is just exploiting the loophole of this formula.

[@vaibhavmagar616]

Sir, to show last value in the column at 17:35 ,I use formula =vlookup(max(this range)+1,this range,1,1) & 19:45 I use formula =XLOOKUP(lookup value, lookup array, return array," ",match mode exact 0,search mode -last to first -1)

[@chiraggupta8967]

I appreciate you hard work

[@payaljain5497]

Superb...

[@venkatthota5]

super compilation

[@sofianotab2945]

Hello,I would like to ask,if we want to take the mean for each 7 values,what formula is needed?

[@krishikaagrawal8513]

how to know which formula to be used under which formula and when please help thda confusing hai

[@chetanagarwal9898]

Thank You for your videos, Sir. They are really helpful. How can I download the same excel file in which you are working for self practise?

[@chetanagarwal9898]

@@trumpexcel Thank You :)

[@kirandeepchoudhry9232]

Sir, I have one query how to hard core month in index with choose function.Plz reply I am not able to do it

[@MdRiyaz_BCH]

The Vlookup(rows formula is returning 0, Please help

[@chrmos6005]

What if we want to do that for multiple drop-down lists?(for my task 3)

[@PoojaChoudhary-zm3wf]

As soon as I press F4, my excel workbook gets closed, how do I lock my cells apart from pressing Shift + $ every time, can someone help with this?

[@ThalassaMavri]

Thank you! Very good information presented very clearly.

[@kanvaljitsingh6912]

Thanks. Good tutorial. Well crafted and delivered.

[@rushikeshkadam8350]

Awesome!!

[@tha2irtalib343]

So great , thanks.

[@vedpatel3231]

34:20 you don't have to do the minus just do =LEFT(C4,3) to get the 3 letters from the left

[@randomthoughts6208]

Sir need help regarding automation. In an excel file, I want to compare values of 2 different columns and depends upon the values want to have predefined text message in the third column. Which function is useful

[@ellisiverdavid7978]

Hi Mr. Atul! This can be solved using *IF* function, then apply *Conditional Formatting* too in the third column to make it appear more interactive. :) Let me know if you need more help, and if you want to, you may send me the sample file through LinkedIn or Facebook, then I'll edit it for you as my practice and as my way of helping people. Win-win for both of us. Stay safe!

[@MyVikas25]

​@@ellisiverdavid7978 Hello, I just saw this. Thanks for trying to help him. That was really kind of you.

[@vikas7428]

How to add percentage value in one cell value in the same cell. Please make a video.

[@vaidute2576]

hi, is there a file to download for this tutorial?thank you

[@hash_caul976]

No.mm

[@harishvaishnav7108]

Awesome

[@randomthoughts6208]

great sir

[@adetutu4413]

i’m confused by this video 🥺 someone help pls

[@ektapatil5574]

Didn’t get unique list😢

[@Naveenkumar-wf6jx]

what if multiple persons with same experience

[@samantamonaci9682]

can someone explain the use of trim formula as the correct version is on a different cell and when i try to substitute with the wrong sentence it gives me error. Cant understand the use as all these formulas dont fix the problem where it is but they just put everything in a different cell

[@sadhanks1924]

Strictly not for beginners 😂

[@adetutu4413]

1 star

[@e-shorts1352]

who is seeing as a kid

[@UniqueAB247]

What do you mean by this?

[@e-shorts1352]

the vids