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
Macro, VBA पर full series अच्छे से बनाएं, office real queries को ऑटोमेट करना सिखाएं l मेरे पास बहुत सी Queries है, please help करे l 🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹 सीखते रहो, सिखाते रहो l हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
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
Sir, IFS formula not working in all version of excel. Reason - Make sure that you have Office 365 subscription with version 1601 (Build 6568.2025) and above! If you have in your new laptop an earlier version of Excel or Excel 2016 as a one-time purchase, it is normal to see the #NAME? instead of IFS function, because it's not defined in these versions of Excel.
Sir biometric attendance ki class nahi mil rahi hai pls mujhe bahut jaruri hai ye class agar video nahi ho to aur bana dena hame bahut problem ho rhi hai sir 😢😢😢😢
Sir mera ek problem mere pass kuch stores ke Identifying numbers hai.Ab company softwares se jo data nikalta hu usme se left formula use karke Identify number ko alag kar leta hu.Lekin agar identify number alphanumeric ke jagah agar sirf Number a jata hai toh Identify Nehi hota hai.For example agar Identify number D655 hai toh uska sale large number of data se xlookup karke nikal jata hai lekin agar identify number agar suppose 4039 jo full numeric number hai yeh data xlookup se fetch Nehi hota hai.iska koi solution hai toh dijiye please🙏🙏🙏🙏🙏
Sir medical shop k liye excel mein stock kaise manage kare items boxes mein purchase hota lekin sale loose quantity mein hota price kaise different kare
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.
YOU TUBE KA PAHLA SABSE EXCELLENT EXCEL VIDEO...
THANKS....🎉❤
मुझे नहीं लगता इतना बेहतर तरीके से कोई excel formula समझा सकता है । जवाब नहीं गुरु जी । धन्यवाद ।
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
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
Must Watch Video. Thank you so much for the Excel Sheet.
आज तक का सबसे बेस्ट वीडियो है सर जी यहां कुछ लोग दो चार फार्मूला सिखाने के लिए कोर्स बेचते हैं।
th-cam.com/users/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH
best video to learn excel formulas in a detailed way with examples
Bhai aapke video se bht aram se sab kuchh samjh aa jata hai 😊bht achhi tara se smjhate ho aap, thanks😊
Excellent Explanation
Love you sir ...sch me aap jesa khi nhi pda...
gone through all the 52 videos. amazing. may God bless
I never cmt on any video bt must say really excellent video and your Hardwork 🔥
Thanks g 🙏
Very useful video with simple language and sample data
Nice Tutorial
Deepak you are best teacher
Bahut kuch sikhane ko mila sir ❤❤
Superb sir
Thank you so much sir 😊
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
Tank you Sir kya training file banaya hai sir ek dum jabar dast😍
Great 👍
Picture quality also very good, thank you sir 🙏
Bahut shandar ❤
Very good explanation thank you.
Excellent video , explained very fine , and specially sample data with all formulas like -"icing on the cake"❤❤
I m an excel student but watch your video desperately 😌
Best God bless you 🙏
Superb se bhi uperb
th-cam.com/users/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH
th-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
Bhai Excellent yr, Keep it up!!, God Bless U dear...Paid courses se badhiya class h aapki....
excellent. kamaal kar diya
Thank you so much. Very well explanation.
Thank you sir ❤
❤ many many thanks 🙏
Great video
Very useful fungution in excel thank you much sir ji 🙏🙏🙏
😊😊
Your are the Great one sir jee
Brother All excel video like God blessing you your native place.
I am native Chennai tamilnadu.
Excellent sir 💯✅✅
Brilliant sir
Great Sir❤
Good work sir
th-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
Pls subscribe
Bohut Badiya I loved it
❤ thank you so much you are great bhaiya❤
Bahut achi hai ❤❤❤
Thank you Sir.
Thanks a lot for providing us practice file...
Deepak sir too good
Thanku So much for useful information
Thanks so much sir
thanks a lot for your excellent work
Thanks ❤❤
Very good bro....waiting for more video
Wow Superb sir its very helpful
Thank you sir, very nice Sir
Thank you sir
Very useful video 📷
Excellent
nice understanding tutorial
Bahut khub
Nice 😊
Download link pls.
Very useful video thanks a lot ❤
Too good..thanks
Super teaching
super sir
Thank you saab
VERY NICE
Inventory management system in Excel pr Full video banao 🙏 for industrial use
sir ek video banaye & se koi bhee convatinat banate hai uska formating kaise karenge
th-cam.com/users/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3
Nice video
Best and useful video🙏. Sir Can you please give us some more practice data files...
Superb
Sir, pls let us know how can we compare portfolio performance with the benchmark(nifty50).
Vote for pivot table tutorial
brilliant
Agar ek employee ko a saare formula aate hai ta job ke liye enought hai😊
You are master
Thanks g 😊
Macro, VBA पर full series अच्छे से बनाएं, office real queries को ऑटोमेट करना सिखाएं l मेरे पास बहुत सी Queries है, please help करे l
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
Bhut mihnat lgde hai yr
Thanks
good
Welcome sir
Bhut vip
Which excel u r using.. I have getting some error in some formula like ifs. This is not avilable in my excel
2021
Video dekh kar excel sik seke ga
Excel ke kai sare formula aapse hi sikha
Awesome sirjee.....
but here i want to ask you dateif formula is not appear in my excel version 2021 how can i appear it?
Sir accounting ki bhi video banana start kriye na Tally prime ka please sir ham aap se hi study krte hai
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
We can write all these prompts by chatgpt....
In which excel have you made this vedio sir, 2016or else?
Mera ek request Hai
Excel ka insert tab k upor ek details vedio banaiye
Sir excel ke sare formulas kaise yaad rakhe
Sir, IFS formula not working in all version of excel. Reason - Make sure that you have Office 365 subscription with version 1601 (Build 6568.2025) and above! If you have in your new laptop an earlier version of Excel or Excel 2016 as a one-time purchase, it is normal to see the #NAME? instead of IFS function, because it's not defined in these versions of Excel.
Bhai switch function ki jagha konsa use kr skta hoon mere Excel mei switch nhi hai hai
Sir biometric attendance ki class nahi mil rahi hai pls mujhe bahut jaruri hai ye class agar video nahi ho to aur bana dena hame bahut problem ho rhi hai sir 😢😢😢😢
Sir apnay day book banna seekhya tha plz us may yeah btaya k agar bank wise payment check karni han tun kasay kary gay
Yani k hum agar koi date searche kary tun us date ko kon say account may kitni amount I yeah btaya plz
Sir ji mera 2010 ka exel hay xlookup isme nahi hay to use karne ke liye kaunsa wala year ka exel download karna parega
Sir mera ek problem mere pass kuch stores ke Identifying numbers hai.Ab company softwares se jo data nikalta hu usme se left formula use karke Identify number ko alag kar leta hu.Lekin agar identify number alphanumeric ke jagah agar sirf Number a jata hai toh Identify Nehi hota hai.For example agar Identify number D655 hai toh uska sale large number of data se xlookup karke nikal jata hai lekin agar identify number agar suppose 4039 jo full numeric number hai yeh data xlookup se fetch Nehi hota hai.iska koi solution hai toh dijiye please🙏🙏🙏🙏🙏
Sir medical shop k liye excel mein stock kaise manage kare items boxes mein purchase hota lekin sale loose quantity mein hota price kaise different kare