Это видео недоступно.
Сожалеем об этом.
Database Functions (DSUM , DAVERAGE , DCOUNT , DMAX , DMIN , DPRODUCT)
HTML-код
- Опубликовано: 19 авг 2024
- Database Functions (DSUM , DAVERAGE , DCOUNT , DMAX , DMIN , DPRODUCT)
Learn powerful Database functions in one video. Advantage of DSUM formula in hindi over SumIF Function.if you do not have xlookup in your excel there is no need to worry, you can learn DGET formula and it is great substitute of Vlookup & Index Function even in some aspect Database function is much better than lookup.
Download the Practice Workbook Direct Link here-drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Database Function-DatabaseFunctions.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#databasefunction#dsumformula#Innozant #exceldatabasefunction
Your comparative study makes one choose the right function. What a deep insight of the excel u have! Thanks
more i see you teaching more i like ur way of teaching.... u r making excel a childs play... thnku sir
Thanks my dear friend for such a lovely appreciation.Will always try to motivate all of you and give you dose of Success everyday
Sir....I like your teaching method
You cleared the concept
There are no doubt about this function
Thankyou Sir🙏🙏🙏
Thanks dear
Sir I appreciate the lessons and I learn too much things from you.Your teaching method is unparallel. The most valuable thing. You reply to all comments.you are very different to all excel youtuber.
Thanks Sandeep for your appreciation.Offcoure I am teacher by profession not business person 🙏😊,Will always try to give reply.Thanks for your support.Keep watching and share with your friend to learn.
I am writing again because Basic Excel playlist is very useful for me. I wish that I could found this channel earlier.
Thanks Dear.Keep Exploring
Sir, your teaching method is incredible.
Thank you so much Sir......!!
Thanks Satish ji..for your lovely feedback 🙏❤️
your teaching skills are unbeatable
Sir aap bahut accha samjhate hain mind blowing sir
Thanks Saxena ji..God bless You..achese Seekhiye aur aage badhiye life me
Sir aap bahut mast batate hai .Thank you sir
Thanks dear
Pahili bar aap ne dimag hi hila dala❤❤
☺️
Awesome Guruji...this one is awesome
Sir....One to One Surprise dete rahiye isi tarah...Aapko "PRANAM",
❤️👍
wah kya baat hai, you are superb
Thanks Arun ji
sir , thnxx allot for this video , i am regularly watching ur videos . i have learnt new things from ur videos thnxxx allot sir......
Thanks Vanshika for being part Of Inny Family,We welcome you to experience the taste of success dear ❤️🙏
Recommend you to finish Basic Excel Playlist first followed by Sort & Filter ,Data validation,What if Analysis, array,vlookup ,pivot & Dashboard 👍
Thank you so much sir
Sahi function hai , use kr skte isko bhi...!
Good sir 😊😊 keep it up
Thankyou Sir, you were amazing 😍🤩
Thanks you sir, actually I leared this topic earlier but you cleared all my doubts regarding this topic.
Thanks Hemant..DGET ka best advantage over vlookup and index..bht jald Video apke liye.😊❤️🙏
@@Innozant thanks you sir.
Thanks Sir!
Thank so much this formula
Thanks Kunal for watching and start learning 🙏😊❤️
Sir, Good Evening, I am regularly watching your videos. I have learnt new things from your videos. Thank you very much for your efforts as well enthusiasm to teach us.
Thanks Venkat,Hope you like the training methodology and able to understand the concept,Learn step by step, Assignment are there I'm description. God bless you.Have a blooming career ahead🙏❤️❤️
@@Innozant Thank you Sir
Thnq sir je bhi bohat use kruga abb main
Thats Good Gaurav ♥️🙏
waah sir waah maza aa gya!!
single criteria me to sumif sahi hai, par bat jab multiple criteria ki ho to Dsum jyada better hai. nestedif ki jagah Vlookup yaad aa gya.☺️
#Innozant
Very true but maine Dsum ka negative point bhi btaya hai uska bhi dhyan rakhen tabhi Sumit hi jyada use hota hai
Very nice sir your videos
Thanks
Thank you sir
D Function Simplicity makes the one choose it
Very helpful video Sir
Nice explanation.
Thanks dear❤️
Thankyou sir
Good teaching sir
Thanks Priyanka.Happy Learning ♥️
It is beneficial. Thank you sir
Thanks Pratima .Happy Learning ❤️
Super say vhi bahut upper
Great sir
Thanks Rahul ❤️🙏😊
Awesome sir. Thank you very much
❤️❤️❤️🙏🙏
Super se upr ho aap
Thanks Arti
Thank you sirji
Thanks dear
Sir you are fevolus 🙏👌
thanks Arti
great sir..🙏 helpful knowledge 🌷
Thanks Sandeep 😊❤️🙏 Happy Learning,Keep sharing
जबरदस्त सर
Thanks PK 🙏❤️
Thanks🙏🙏
Thanks Rupali
Nice👍👍
sir your style of teaching is amazing plz sir make videos on SQl if you can
Thanks Puneet ji..Will make videos on sql for sure
@@Innozant thanks sir i m eagerly waiting for it😊
Hello sir cahey Jo bhi database ho Hume koshish karni chahiye ki hum kaise cum space mai kaam karey. It is unique concept keep it up good night sir.thanku
Bikul sahi Satish optimization sabse important hota hai..kaam to sabko karna aata hai .but optimized approach matter.🙏😊❤️
Graet Sir
Very Very Nice...
Thanks Bhoopendra Ji..God bless ayou dear
@@Innozant always love u sir g...
Thanks
Thanks
Hi sir aajkal Google sheets in very demand uspar video tutorial banaye kyunki sir aap acchese described karte ho topics ko🙏❤️sir
Bht jald dear.
VERY GOOD
Thanks Sudipta ❤️
Great job Sir
Thanks Vinay🙏❤️Keep watching,Learn and share with your friends.
Sir ap ka parhane ka style bhoat acha hai.
Sir mujhe is me ek problem a rahi hai me agar Drage down kar raha haun to top value me total a raha hai niche wali value me error
So good 😍 sir.
Thanks
Mast 👍👍
Thanks
Nice
Wow
Thank you sir
great sir 🙏👌🏻
Thanks Karan❤️😊🙏
Good
Great
Thanks Supriya, Welcome you to experience the taste of Success.Happy Learning 🙏
Nice sir
Thanks Roshan,We welcome you to experience the taste of success.Learn-Enhance skills-Succussful career.
Sir. It is requested to you plz breaf week day function and work day function in very details .when should use week day function and when use work day function in very details. It is more requested you kindly breaf it that which work in which window or not exist in that window. Awaiting your reply plz. Regards
Hi, I have seen lot of videos of yours and it really helps. I am currently working as MIS Executive and would like to learn power pivot, power query and other advanced functions. Request you to share course details if you have any.
Regards,
Riyaz
Thanks for showing your interest,For more info kindly contact us directly, Contact details provided on innozant website
Sure..... Thanks
@@riyazhhakim3324 hlo
👍
Thanks Sujata
Exclent
Thanks dear ❤️
Bahut sundar
Sir can we use wildcard alongwith with these d functions and can you help me how we can use it
Sir
Sir, In Database function can we get the output for one name only if i want to get the output of two names what to do?
Hello, sir I am one of your subscribers . Sir but what if we have similar item names in our item list like mouse, mouse pad etc when is use DSUM function it sums the total of both mouse and mouse pad . How to solve this problem please?
sir dsum me bhi formula drag nhi ksr sakte na dget ki tarah ????
Nhi dear
Amit = 2700 (while using DPRODUCT) Plz explain
Sir mere 4 doubt he
1 Dsum function sum if or sumifs ka kam karta hein.
2 Dmax function max ifs ka kam karta he
3 D min, min ifs ka bhi kam krta he kya
4 D count , count if or count ifs ka bhi kam karta he
Criteria based saare function ke jagah laga sakt hain
Thanks 🙏🙏🙏🙏🙏🙏🙏
Hi Sir, In DSUM if im trying to get the value of Sony as well with same criteria my output comes wrong
Ouput comes same as Nokia
What should be select as a criteria?
Sir, Do wild cards work with database Dcount or Dcounta?
sir your videos are too good but the link to the practice workbook file is not working please have a look at it.......
Hi Anupam direct link is broken now but assignment master link is working fine
Sir, dcount() 0 ko bhi as a number pakad let Hain. Uska Kya solution ho sekta?
haan count kr lega 0 use..aap chahte kya hain ye btaiye phir deta hu solution
@@Innozant Sir data table mein see no. of pending amount nikal na tha, customer name ke upar base korke. Par pending amount column mein baki no. Ki tarah 0 bhi tha.
Tho Sir 0 pakad ne see galat ho jaiga na? Muje 0 ko nehi Lena tha.
सर लेकिन ये एक से ज्यादा row में निकलना है तो फिर इसमें दिक्कत होता है
क्योंकि ये बिना header के वर्क नही करता
sir aapne es video me bola he ki app Excel revisions series bhi layenge or Excel revisions series mil nahi Rahi aapke channel par
Proquest Series dear
Ok sir i am waiting your video with Passion 😉
Sir mera kahena galat nahi hai ke aap excel magician ho kyo ki mene abhi tak " d " function wala video dekha nahi hai
Kishore ji Mera bhi wada hai ye magic show apko Daily dekhne ko milta rhega.. Happy Learning and share with your friends to learn.
Sir esme ek bar me sirf "ek field" ko select kr sakte hai?
Haan Shwet iski limitations hain
@@Innozant ok sir
DGET DVAR, DVARP, DSTDAV, yeah bhi le aana sir
Yes..soon
Sir revision series kis naam se hai playlist me
Proquest assignment series
@@Innozant Thank you sir
Is sheet mai jo apne banai hai
sir when will come excel revision series.
Soon ...
App mis ka full course kraoge sir
Offcourse,Aap Dekh Rahe hinge Jaise video upload ho Raha hai Excel Ka so demo video nhi hai dear,Complete Course step by step Kara rhe Hain online available ,Jo students fees nhi kar skate hain afford unke liye Free course mile step by step.,Aage Kai saare playlist upload honge
Pdf milega kiya sir
Sir mujhe dca pro ka pura notes chaiye milega kya in hindi
No we don't have
Sir mein na same trick use Kiya fir bhi answer is 0
Same criteria all database formula
🙏❤️
Apne or confusion kr di
Kya confuse ho gye jasvir ji??
Sir kuch puchna
Sir mujhe dca pro ka pura notes chaiye in Hindi
Nhi hai humare paas .DCA nhi karate hain .. Industrial training karate hain dear
Sir aapke pair chunne hain
God bless you
If I have to find East OR west together then how it can be done?
Limitation of database function..we can do with vlookup easily❤️🙏
Apni photo chhoti karo yaar.
👍
abe tu screen ke uppar kyun baitha hai
Sushil ji aise hi language aap apne teacher aur parents ke liye use karte hain.?Great dear👍koi educated insaan aise language kaise bhala use kar skta hai..
SIR , WHEN I USE SUM(IFS) INSTEAD OF DSUM ,,,,I GOT DIFFERNET VALUES
Nice👍
Thank u sir
Thanks Akhtar sahab
Sir ap ka parhane ka style bhoat acha hai.
Sir mujhe is me ek problem a rahi hai me agar Drage down kar raha haun to top value me total a raha hai niche wali value me error
Nice
Thanks Ram,Learn and share with your friends.