Thanks to share video . All though I was appreciated for my excel skill but you teach me clear all my doubts and make me more confident. Request you to make more video in comparison with Excel and Google sheet in tandem . Rest personally i like your dressing sense...especially T-Shirt. and you are very handsome . Hope I will not miss even a single video of you. I am your fan.
Thanks Kiran for your compliment you really made my day! Seems like you are a new member of Innozant family. I hope that here, you will get enough content to satisfy your needs and upgrade your skills.
I have no new words to appreciate your teaching skills as everyone else has already appreciated so much in the comments. Still i would like to mention that you are too good and gifted with excellent presentation skills. I will continue to go through every single video of yours.
Sir, you are simply amazing, how easily you have made this excel learning fun, I bet no one would ever find learning excel more interesting than learning it on your channel..
Dear Sir. Thanks very much...though im late in getting your videos but its very informative .i have been looking for many doubts of mine for a very long time...great teaching skills...
Hi friend, I want to understand whether I can combine Multiple comparative sheet into single comparative wherein I can refer different department in one
Sir, maja aa gaya apaki ye video dekhkar. Sir, Kaya aisa koi tareeka nahi hai jisase ham Uniqe value ki Drop down list ko bana sake vo bhi Bina Kisi Duplicate value ko remove kiye. Mera matlab hai ki ham drop down list banane ke liye pahale poore data se jisaki drop down list banani hoti hai usako copy karate hai then Usako Kisi place par paste karate hai then vaha par duplicate value ko delete karate hai then Drop down list banate hai. Isame ek problem ye aati hai ki Hame Unique value ki ek alag column ya row banani parati hai.
sir mera iterview hua tha or maine practice qustion to solve kar diya tha but theorical question aise the jo thore hatke the v looup kiya hai ager iss type ke hote to bhi koi problem nahi matlab 20 question the optional type ke ek test liye or bola ki tick karte jao ager iss type ke qustion bhi aap series mai dal do to sir phir to therical qustion mai bhi pakka ho jaunga
Good Morning dear, Complete excel hi karaya gya hai dear playlist wise. Aap announcement playlist me jaake ek video hai mis learning process use dekhiye ki kaise seekhna hai step by step Ya video description me bhi link diya gya hai videos in sequence playlist. Happy learning
very nice sir . kafi best concept diya hai aaap nay maine udemy m paid courese liye hain par itna acha aaap say samaj main aya hai please muje suggested krin muje excel dasboard expertise k liye muje kiya kiya krna chaye muje sahi say path samj nhe ah rha hai baisc and advance k udemy k courses kr rha hoon ...par mera concept tu clear kafi ho jata hai par chezoon ko analysis krne m msla ho rha hai ,,,,aaap bahot slow slow best chezain samajate hain so plz guide krin muje b ,,,meri sawal say kafi logon ko fayda hoga
Sawai sahab conceptual part sahi kijiye formulas ka..conditional formatting ,dashboard aur chart acha kijiye ,jyada se jyada example attempt karne ki koshish kiya kijiye usse dheere dheere aapko analizw karna aa jayega kis situtation me kya usw krenge ..
@@Innozant thanks so much sir main doubra aaap ki basic playlist start ki hai bahot acha lag rha hai ...apni baki doston ko share krunga aaap k chaneel ko malik aaaap ko kuhsh rkhe 1:basic formule 2:vlookup, hlookup, if conditon ,conutsif sumifs , chart , piovt table, sirf ye zruri hai dashboard k liye ya phir macros and vba b lazmi hai ??? muje abi tak confusion hai sir
Good Morning Surbhi,Ye basic custom Grouping example hai isliye combo box ko group nhi kiye,Aage Dashboard videos me apko dekhne ko milega🙂❤️🙏 Thanks . Happy Learning 🙏
Respected sir.. Kya mujhe Chart and Dash Board ka alag se pura learnig video mil sakta he....if possible please share me.. This is very urgent sir.. Thank you..
Thanks to share video . All though I was appreciated for my excel skill but you teach me clear all my doubts and make me more confident. Request you to make more video in comparison with Excel and Google sheet in tandem . Rest personally i like your dressing sense...especially T-Shirt. and you are very handsome . Hope I will not miss even a single video of you. I am your fan.
Thanks Kiran for your compliment you really made my day! Seems like you are a new member of Innozant family. I hope that here, you will get enough content to satisfy your needs and upgrade your skills.
Thankyou Sir.....No words, totally speechless.....Great sir,great teaching...🙏
I have no new words to appreciate your teaching skills as everyone else has already appreciated so much in the comments. Still i would like to mention that you are too good and gifted with excellent presentation skills. I will continue to go through every single video of yours.
Thanks dear... Really means a lot.Keep Learning ❤️
Very good teaching skill Sir, it will be really helpful. 👏
My god sir, You are simply amazing... I love learning these things from you
Thanks Hardik
We can learn something new from your each vedio of excel in a very easy and precise way...please keep continue. Thanks a lot sir!!!
Thanks Saurabh ji❤🙏🙏
@@Innozant SQL N MIS relation
Thanks Sir
May you b happy all the time..Ameen
I found best excel course on TH-cam. Keep it up!
Thanks dear..Keep Learning ❤️
Very nice.
Agar aapki video sequence me dekh li to koi paid excel course ki jarurat hi nhi hai
Thanks for educating ppl for free of cost
Thanks Riddhi...God bless you .Keep learning..Keep exploring ❤️👍 have a wonderful career ahead
Hr kaam perfect hota h apka, apko dekh kr pta lgta h, hme to kaafi kn knowledge h abhi🙏👌
Thanks Arti itna trust ke liye and for appreciation.
really good video sir.
Soo easy to learn with this ....and the most easy too understand.. amazing sir
Thanks Dear for such a valuable feedback,It's really mean a lot to me.
Sir, you are simply amazing, how easily you have made this excel learning fun, I bet no one would ever find learning excel more interesting than learning it on your channel..
Thanks JK . Really means a lot that me .God bless You dear❤️👍
@@Innozant sir, i am able to select both objects in same time
Sir,as I'm new to your channel🧐 🤔but the way of your explanation is awesome👌 🤗a big salute 🫡deserves you ❤💐
Thanks dear..Keep learning ❤️
Very nice Sir. Thanks a lot..
Sir All your videos are really helpful. You explain each and every thing in great depth.
Thanks Sandeep Ji,May it bring value to your life.
Aap bahut easily samjhate ho superb sir..
Thanks Dharmendra Ji.. Happy Learning dear..🙏❤️
Very good video Sir
Awesome video Sir
Sir, you are really a good teacher. You know very well what questions will come in learners mind. Nice 🙏
Thanks Harivansh,Hope you understand and learn the concept I am trying to deliver.
@@Innozant Yes Sir, Your every video is easy to understand.
wonderful video sir apka jassa Koi nhi sir 👌🏻👍🏻👍🏻
Thanks Karan Kapoor Ji,Keep learning dear.
What a great video
Ati-Sundar...!
Dear Sir. Thanks very much...though im late in getting your videos but its very informative .i have been looking for many doubts of mine for a very long time...great teaching skills...
Thanks Nitin Ji..Happy Learning. We welcome you to experience the taste of succes with Innozant Seed of Success
shukriya guru ji❤
Thank you sir 😊😊
Superb sir
Sir, you learn things very easily, so thank you. 🙏🙏🙏
Thanks Laxmi for wonderful feedback and you are able to learn concept very easily through the video.It really motivates me a lot.
11:15, tum tum na rhe... 😂
Sir I really like ur teaching style
Hahahaha..😀Thanks Amit ji .Love u dear..God bless You
Sir amazing explain thanks 🙏🏻 for sharing the wonderful 😊 knowledge ❤️
Thanks Priyanka..Means a lot to me..ajeeb exploring ❤️
very nice sir
Must sir 👌👌👌
Mashaallah 🙏 mai badia or badia bnana chahti hu
Mashaallah 🤣♥️♥️♥️
Hi friend, I want to understand whether I can combine Multiple comparative sheet into single comparative wherein I can refer different department in one
Sir I can understand easily so thankyou very much
Thank you Bhoopendra ji.Keep learning.
Very explanatory ... thank you sir..🙏🙏🙏😊
Thanks Siddharth ji
Sir mai to fan ho gaya aapka.....😀
Thanks Jitendra for a wonderful feedback.its my pleasure dear..Khush rahiye..seekhiye aur aage badhiye life me
Thank you sir.... Appreciate your work
Thanks dear❤️
Super Guruji. Please also teach how to present the same to the power point to show much more beautiful
Thanks Makesh sahab..happy learning
Nice basic dashboard k leye achi h vedio
Thanks virendra,step by step bus seekhte rehna h.
Sir hum log UNIQUE function ka use kr k bhi unique value nikal skte hai na!!!
linked pic 8:45...how to move this to different sheet..??? , example when source data & dashboards are kept on different sheets...
Nice video sir
Thanks dear ❤️
Thank🙏
Thanks Manoj
you are really nice bro
THANKS..keep learning
Sir aap ye 2 object ek sth Kay select krte ho grouping k liye plzz btao naa
very nice explaination.thanks
Thanks Sarang Ji❤️🙏Happy Learning dear
well explained!!
Thank You
Thanks dear
You made me think that I can learn it. I had left it earlier... So, I shall be with you.
Thanks..Thats good .Keep it up
sir pivot ki picture cut karke second sheet me le ja raha hu to font clear nhi aa raha h
Sir, maja aa gaya apaki ye video dekhkar.
Sir, Kaya aisa koi tareeka nahi hai jisase ham Uniqe value ki Drop down list ko bana sake vo bhi Bina Kisi Duplicate value ko remove kiye.
Mera matlab hai ki ham drop down list banane ke liye pahale poore data se jisaki drop down list banani hoti hai usako copy karate hai then Usako Kisi place par paste karate hai then vaha par duplicate value ko delete karate hai then Drop down list banate hai. Isame ek problem ye aati hai ki Hame Unique value ki ek alag column ya row banani parati hai.
Thanks dear..Aapke life me.value add ho raha hai..acha laga aapse ye baat sunke.keep learning 👍❤️
sir mera iterview hua tha or maine practice qustion to solve kar diya tha but theorical question aise the jo thore hatke the v looup kiya hai ager iss type ke hote to bhi koi problem nahi matlab 20 question the optional type ke ek test liye or bola ki tick karte jao ager iss type ke qustion bhi aap series mai dal do to sir phir to therical qustion mai bhi pakka ho jaunga
optional question ke series already hain..quiz Sunday Playlist
Thank you so much 🥰
Thanks ❤️
Sir ji aap ek video industrial excel par bhi banao bilkul shruaat se..
Haan Dharmendra Ji pehle concept wale topic finish kar Lete Hain phir Jaise aplogon ki requirement hogi will make video .. Thanks for suggestions.🙏❤️👍
sir how to drag a row completly without using mouse
Using F2 And Ctrl key
is example m combo box kyu nhi use kia
Awesome Thank you
Thanks dear
pls explain also when u do..its very confusing....
Sahi hai
🙏🙂♥️
Hi sir Good Morning muzhe pura excel sikhna hai app ek video banahiyei jisamei pura excel ka course ho
Good Morning dear, Complete excel hi karaya gya hai dear playlist wise.
Aap announcement playlist me jaake ek video hai mis learning process use dekhiye ki kaise seekhna hai step by step
Ya video description me bhi link diya gya hai videos in sequence playlist.
Happy learning
Sir freeze Karne ke liye Kon sa shortcut key use karte ho... Please bataiye
F4
very nice sir . kafi best concept diya hai aaap nay maine udemy m paid courese liye hain par itna acha aaap say samaj main aya hai please muje suggested krin muje excel dasboard expertise k liye muje kiya kiya krna chaye muje sahi say path samj nhe ah rha hai baisc and advance k udemy k courses kr rha hoon ...par mera concept tu clear kafi ho jata hai par chezoon ko analysis krne m msla ho rha hai ,,,,aaap bahot slow slow best chezain samajate hain so plz guide krin muje b ,,,meri sawal say kafi logon ko fayda hoga
Sawai sahab conceptual part sahi kijiye formulas ka..conditional formatting ,dashboard aur chart acha kijiye ,jyada se jyada example attempt karne ki koshish kiya kijiye usse dheere dheere aapko analizw karna aa jayega kis situtation me kya usw krenge ..
@@Innozant thanks so much sir main doubra aaap ki basic playlist start ki hai bahot acha lag rha hai ...apni baki doston ko share krunga aaap k chaneel ko malik aaaap ko kuhsh rkhe
1:basic formule
2:vlookup, hlookup, if conditon ,conutsif sumifs , chart , piovt table, sirf ye zruri hai dashboard k liye
ya phir macros and vba b lazmi hai ???
muje abi tak confusion hai sir
Combo list bhi group krna chhaiye tha na so that easy rhe jb hum is pure group ko dashboard pr paste kre to.....
Good Morning Surbhi,Ye basic custom Grouping example hai isliye combo box ko group nhi kiye,Aage Dashboard videos me apko dekhne ko milega🙂❤️🙏 Thanks . Happy Learning 🙏
@@Innozant gd mrg sir 🙏 thank you
Step by step seekhiye aur koi bhi kbhi issue Aaye to aap Telegram/Whatsapp Kar sakte hain..Wil guide you. Happy Learning ❤️🙏
Sir yeh last me Grouping kaise kiya uska thoda samjha nhi, Kaise kiya isme two objects join
Again repeat kren ek baar video aayega samajh
Sir unable to get total count through countifs but its works with sumifs
Why .? With countif you may able to do the same
Sir through countif it counts only number of products and u have not selected the range of values for outcome
Very useful
Thanks dear Arabinda🙏🙏🙏❤️❤️
Mangya sir g aap ko
Thanks Sonu🙏❤️
Sir dashboard ka video banate rahiye plz
Haan aayega dashboard video series
There should be sumifs instead of counifs.... M I correct sir...
Wheet dear?
Respected sir..
Kya mujhe Chart and Dash Board ka alag se pura learnig video mil sakta he....if possible please share me..
This is very urgent sir..
Thank you..
Dashboard series is there
इस फार्मुले में कालम B काउन्ट कर रहा जबकि काउन्ट कालम C करवाना है , कृपया समस्या का निराकरण कीजिए।
i think there should be Sumifs instead of Countifs, as we need to sum all ranges and not count..
Yes
Haan wahi to countif se bus count kar raha hain sum to aa nhi raha
Mera to Total nahi lag raha
Sir.. do you also take SQL classes...If yes, please let me know i can connect with you..Thanks in advance
Yes we are running SQL Classes,You may connect us for more information
@@Innozant please let me know if there is any contact number?
Sir how did you select these two data while doing grouping.. I can only select one
With ctrl key
Thanks sir ❤
Thanks Ravi
❤
How to connect to chart in dynamic?
What iutput youal are expecting now
Sir ye dashboard wali series se pahle chart series dekh lu kya kyuki chart nhi aata hai
Pehle chart phir dashboard pe move kren
@@Innozant ok sir
How to copy paste this dashboard from excel to email? Pls help
There is no need to copy paste .link collaboration kr skte h
🙏
Ye data Noorain Sir ka hai
Sir dashboard practice k liye Excel files kaha se milegi
Video description me link hai download kar lijiye
Sir practice file download nhi ye wali vedio ki
Direct link diyabhyabhai practice file ka..open for download
Sir practice file download nahi hi rahi
Master assignment folder jo 2nd link hai wahan se download kar lijiye
Sir Total thek Nahi Aaa raha COUNTIFS ka
??
Sir grouping nahi ho rahi he group open nahi ho raha he
Kaunsa version hai aapka office..issue hona ni chaiye
🙏🙏🙏🙏🙏🙏🙏🙏
4:40 anap shanap chart banate ho...🤣🤣🤣🤣🤣🤣
😊
AAP KI VIDEO QUALITY BOHAT BILLER YA KHARAB HY
Koi issue nahi hai video me .check again dear
🌟🌟🌟🌟🌟