Excellent Workshop by DEEPAK, I Learn so much from this video,Generally i know basic Vlookup formula and now due to my job profile change i am thinking to do Advance EXCEL course classes but now after watching this wonderful video i am not going to join any class, thank you DEEPAK ji for such a wonderfull work, Because of you i saved my money god bless you:) You are Excel guru
00:00 Intro 00:37 Subtotal Formula 06:02 Sumproduct formula 07:34 Datedif formula 10:51 If formula 16:48 If And formula 23:10 If Or formula 29:09 Ifs formula 32:53 Switch formula 36:58 Sumif formula 40:39 Sumifs formula 42:45 Unique formula 43:55 Countif formula 45:34 Countifs formula 47:03 Averageifs formula 48:56 Vlookup formula 57:50 Iferror formula 59:12 Hlookup formula 01:03:42 Index formula 01:07:09 Match formula 01:09:03 Index + Match formula 01:15:55 Sum + Vlookup formula 01:17:13 Xlookup Formula 01:24:00 Picture Lookup formula 01:25:55 Sort formula 01:29:32 Filter formula 01:33:44 Trim formula 01:36:52 Dynamic formulas 01:38:47 Textsplit formula 01:40:15 Textjoin and Concatenate formula 01:42:59 Protect formula
Hello Sir, I have a Doubt. If any new function either we can learn from in your videos other wise how to know a new function can use properly step by step.
Hamen Sumifs aisa lagana hai jismen ek Creteria Range Column se select karni hai evam ek creteria raw range se select karna hai yadi koi help vedio ho to please batayen
Toh kaisi lagi ADVANCED FORMULAS ki ye master class dosto ?
Bahut useful
Thanks Deepak Sir 😊
@DeepakEduWorld very good & useful 👌 👍
@@DeepakEduWorld thanks so much sir
Bahut achha sir,,aapse bahut kuch sikhne ko milta hai.
Thank you for such a nice Technique
YOU TUBE KA PAHLA SABSE EXCELLENT EXCEL VIDEO...
THANKS....🎉❤
मुझे नहीं लगता इतना बेहतर तरीके से कोई excel formula समझा सकता है । जवाब नहीं गुरु जी । धन्यवाद ।
आपका Explaination खूब अच्छा है आपने कम समय में one shot में 30 फार्मूला समझा दिया 😊
Must Watch Video. Thank you so much for the Excel Sheet.
Excellent Explanation
Great video sir. Thank you😊😊
Excellent Workshop by DEEPAK,
I Learn so much from this video,Generally i know basic Vlookup formula and now due to my job profile change i am thinking to do Advance EXCEL course classes but now after watching this wonderful video i am not going to join any class,
thank you DEEPAK ji for such a wonderfull work,
Because of you i saved my money
god bless you:)
You are Excel guru
can u share vlookup trick with ur experience
Thanks for Educate to People Sir.🙏
Bahut shandar ❤
Thank you so much for this. I have this urge to learn more about Excel!
Keep exploring! Excel has so much to offer. 👍
I appreciate your hard work.
❤ many many thanks 🙏
Very good explanation thank you.
best video to learn excel formulas in a detailed way with examples
Thank you so much sir 😊
Great 👍
Very useful video with simple language and sample data
Bhai aapke video se bht aram se sab kuchh samjh aa jata hai 😊bht achhi tara se smjhate ho aap, thanks😊
Your are the Great one sir jee
Excellent sir 💯✅✅
Great Sir❤
Sir apki videos se e m ne Excel bht learn kya h. Bundle of thanks 🎉❤
Tank you Sir kya training file banaya hai sir ek dum jabar dast😍
Superb se bhi uperb
ua-cam.com/users/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH
ua-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
Thank you so much. Very well explanation.
excellent. kamaal kar diya
Picture quality also very good, thank you sir 🙏
gone through all the 52 videos. amazing. may God bless
Wow Superb sir its very helpful
Nice Tutorial
Very useful fungution in excel thank you much sir ji 🙏🙏🙏
😊😊
❤ thank you so much you are great bhaiya❤
Very good bro....waiting for more video
thanks a lot for your excellent work
Excellent video , explained very fine , and specially sample data with all formulas like -"icing on the cake"❤❤
Thank you sir ❤
Superb sir
Bohut Badiya I loved it
Bahut kuch sikhane ko mila sir ❤❤
Awesome Work Deepak! The way you teach is just fabulous. Keep going, you're helping many who cannot afford expensive courses.
It's my pleasure.. thanks 🙏
Awesome and greatful explanation
Deepak ji Awesome Excel formulla. But where u Learn, pls
Great video
Thanks ❤❤
Love you sir ...sch me aap jesa khi nhi pda...
Best God bless you 🙏
Thanku So much for useful information
Very useful video 📷
Too good..thanks
Thank you sir, very nice Sir
00:00 Intro
00:37 Subtotal Formula
06:02 Sumproduct formula
07:34 Datedif formula
10:51 If formula
16:48 If And formula
23:10 If Or formula
29:09 Ifs formula
32:53 Switch formula
36:58 Sumif formula
40:39 Sumifs formula
42:45 Unique formula
43:55 Countif formula
45:34 Countifs formula
47:03 Averageifs formula
48:56 Vlookup formula
57:50 Iferror formula
59:12 Hlookup formula
01:03:42 Index formula
01:07:09 Match formula
01:09:03 Index + Match formula
01:15:55 Sum + Vlookup formula
01:17:13 Xlookup Formula
01:24:00 Picture Lookup formula
01:25:55 Sort formula
01:29:32 Filter formula
01:33:44 Trim formula
01:36:52 Dynamic formulas
01:38:47 Textsplit formula
01:40:15 Textjoin and Concatenate formula
01:42:59 Protect formula
Pls share the download link pls
I never cmt on any video bt must say really excellent video and your Hardwork 🔥
Thanks g 🙏
Good work sir
ua-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
Pls subscribe
Nice 😊
Bahut achi hai ❤❤❤
Brilliant sir
आज तक का सबसे बेस्ट वीडियो है सर जी यहां कुछ लोग दो चार फार्मूला सिखाने के लिए कोर्स बेचते हैं।
ua-cam.com/users/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH
Thanks a lot for providing us practice file...
Sir aap kon sa software se video edit karte hai
Thanks so much sir
Bhai Excellent yr, Keep it up!!, God Bless U dear...Paid courses se badhiya class h aapki....
Thank you Sir.
Deepak you are best teacher
Thank you sir
Best part ye h ki apne practice file di ❤
super video
Hello Sir,
I have a Doubt.
If any new function either we can learn from in your videos other wise how to know a new function can use properly step by step.
Deepak sir too good
Excellent
sir ek video banaye & se koi bhee convatinat banate hai uska formating kaise karenge
ua-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
super sir
Best and useful video🙏. Sir Can you please give us some more practice data files...
How to find max value in a given data using index match function
thankyou
nice understanding tutorial
Bahut khub
VERY NICE
I like it
Sir mai aapke video dekhe bina hi phle like kar deta hu kyuki har bar aapse kuchh nya aur achchhi chij sikhne ko milta hai
Sir accounting ki bhi video banana start kriye na Tally prime ka please sir ham aap se hi study krte hai
Which excel u r using.. I have getting some error in some formula like ifs. This is not avilable in my excel
2021
Download link pls.
Very useful video thanks a lot ❤
Nice video
Thank you saab
brilliant
Super teaching
You are master
Thanks g 😊
Vote for pivot table tutorial
Hamen Sumifs aisa lagana hai jismen ek Creteria Range Column se select karni hai evam ek creteria raw range se select karna hai yadi koi help vedio ho to please batayen
Bhut mihnat lgde hai yr
Superb
Thanks
In which excel have you made this vedio sir, 2016or else?
Inventory management system in Excel pr Full video banao 🙏 for industrial use
Sir ji mera 2010 ka exel hay xlookup isme nahi hay to use karne ke liye kaunsa wala year ka exel download karna parega
good
Agar ek employee ko a saare formula aate hai ta job ke liye enought hai😊
Sir, pls let us know how can we compare portfolio performance with the benchmark(nifty50).
Awesome sirjee.....
but here i want to ask you dateif formula is not appear in my excel version 2021 how can i appear it?