Of all the Excel channels, your channel is the best for learning Excel. (All problem one solution) Maine aaj bahut you tube video dekhe per kisi per comment nahi kiya ye mera first comment hai jo mare ko karna pada....Such me aap great sikhate ho....
Thanks Hemant Ji,🙏❤️Aapke ye word mere liye gift se Kam Nahin hai..Meri humesha koshish hogi ki behtar content,easy to understand leke aau..jisse apke life me value add ho aur life me aap aage jayen Apne goal ke aur najdeek.Have a wonderful career ahead.🙏❤️
Sir You are an exceptionally clear teacher. Thank you so much for creating a teaching piece that is truly comprehensive and includes all learning types. I really loved this video, everything is explained in detail and in a simple way so even beginners can fully understand the formula.
Thanks Sandeep for such a wonderful commnent and appreciate my work.We always try hard to deliver best and easy to understand Content.Keep Learning ,Share and Support 🙏
Sir mera dil bol rha hai app ek din U tube p sabse jayda subscriber rhe ge. really bhot accha samjate hai mai daily learning ka rha hu step by step daily apni life value add kar rha hu.Apke liye dil se dua.
Oh thanks a lot Alam aap log sath denge do kya possible Nahi hai iss duniya me🙂♥️🙏bass support karte rahiye ham bhi Aapke liye behtareen content laate rahenge
Sorry mee galat tha. Pahley Salesperon aur uskey baad product sort karengey. Uskey baad salersperson ke end aur uskey baad product ke end me karenge. Kiya ab sahi h.
Hii sir apki videos bohot achi h, or apke samjha ne ka tarika bhi unique h, mere sare concept ache se clear ho rahe h thank you sir, sir mera ek question h ki me practice worksheet download nhi kar pa Raha hu plz provide karade😇😇😇
Sir discription me jo aap link dete ho.. Prectice k liya ya.. Jo bhi question dete ho usko excel sheet me kese lekar ate wahi same question ko.. Plzz bataiyega zaroor
Thank you very much for new content... I am happy to share my view in just two day of watching your tutorial.. You deserve more subscriber than this as your teaching technique is just wao.... I have been watching different channel for excel tutorial and accidentally came to your page .. iam confidently saying that you're better than other mentors..Just loved your content, and method... Love and respect from my side...💓
Thanks for your wonderful and valuable appreciation Saurabh Ji.Recommend your to start your Learning Journey from Playlist Basic Excel followed with Asvanced..Video in Sequence Playlist are available in video description
Sir your content is superb clearing.. I am your follower from the first day you lauch this channel. Sir it would be help is if bring the VBA series I want to learn VBA from you.
Thy Mukherjee Sahab for such a valuable and wonderful feedback.It will take time but surely you mag able to watch Power BI,SQL and VBA series step by step on your Innozant Channel.
hello sir , i can't find that homework questions that you have given us in this class , can't see on your drive under "excel substotal ttc and data validation". please help :(
I want similar stuff for unique count as well...what I mean is, whenever any particular name is selected through filter unique count of associated particular field pertaining to that name should be updated...I used sumproduct and countif..but that gives unique count of overall data... whenever any name is selected total of unique values remain same...plz. help...
sir, is there any solution to undo sorting? every time when i sort the data,im not able to undo the sorting. ctrl Z is not working in this case. what can i do in this situation if i have saved the file?
You cannot undo the sort after saving. The best to do before sorting, is to add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column
Under the data ribbon 2nd icon above the advanced filter there is a clear icon.That will take care of it or click o. Advanced and reset the criteria range.♥️
=SUBTOTAL(function_num, ref1, [ref2], [ref3], ...) Sir Ji! What about these optional argument [ref2], [ref3], ... can آپ elaborate for us. Thank you dil se.
@@Innozant this video is not fulfil the requirements.... Id. Amount. Subtotal 123. 150 123. 150 123. 200. 500 124. 150 124. 300 124. 150. 600 I want to calculate like this...
Very nice sir Sir I want to in tally I have group name call Bajaj ins. In bajaj ins. Two ledger 1.bajaj 10-11 debit ledger and 2. Bajaj ftr credit ledger But when doing pvoit filter, showing only in ledger I want your help how to slove Or sir u can send me your contact no. For call.
Sir
I really appreciate ur effort to help people understand the excel tricks/formulas...
Huge respect👍👍👍
Sir pahale , pruduct fir sales representative 😂 kitne achhe se clear samjhaya aapne.. thank you so much 🙏
Of all the Excel channels, your channel is the best for learning Excel. (All problem one solution)
Maine aaj bahut you tube video dekhe per kisi per comment nahi kiya ye mera first comment hai jo mare ko karna pada....Such me aap great sikhate ho....
Thanks Hemant Ji,🙏❤️Aapke ye word mere liye gift se Kam Nahin hai..Meri humesha koshish hogi ki behtar content,easy to understand leke aau..jisse apke life me value add ho aur life me aap aage jayen Apne goal ke aur najdeek.Have a wonderful career ahead.🙏❤️
Sir You are an exceptionally clear teacher. Thank you so much for creating a teaching piece that is truly comprehensive and includes all learning types. I really loved this video, everything is explained in detail and in a simple way so even beginners can fully understand the formula.
Thanks Sandeep for such a wonderful commnent and appreciate my work.We always try hard to deliver best and easy to understand Content.Keep Learning ,Share and Support 🙏
Bahot badiya sir. 3 layer k baad bhi layer hoti he ye nhi pata tha mujhe. Aapne toh pura subtotal ka chapter hi khol diya. Dhanyawad
Thanks Bhati Ji .Happy learning ..God bless you
Sir mera dil bol rha hai app ek din U tube p sabse jayda subscriber rhe ge. really bhot accha samjate hai mai daily learning ka rha hu step by step daily apni life value add kar rha hu.Apke liye dil se dua.
Oh thanks a lot Alam aap log sath denge do kya possible Nahi hai iss duniya me🙂♥️🙏bass support karte rahiye ham bhi Aapke liye behtareen content laate rahenge
Bahut badiya Sir ji.. I never worked on multiple sort or subtotal . Good to learn new stuff.
Best teacher
Really sir you are amazing ❤✨ and your teaching method and efforts really appreciable thankyou for this great and helpful content ❤
Thanks..Keep growing
@@Innozant thankyou sir ♥️
Kirak sir..maza ayega
good and very professional way of teaching, thanks for posting good educational videos
Thanks Adnan.Happy learning ❤️
excellent teacher
EKDAM SAHI KIYA H SIR AAPNEY.. kYUNKI AGAR PAHLEY PRODUCT KE END MEE KARENGEY TU EK PRODUCT BAHUT SARE SARESPERSON KE UNDER HOGA. kIYA ME SAHI HU.
Sorry mee galat tha. Pahley Salesperon aur uskey baad product sort karengey. Uskey baad salersperson ke end aur uskey baad product ke end me karenge. Kiya ab sahi h.
The way to explain is awesome 👌 👏
That's why I watch only your videos..
So appreciated
Thankx Sir🙏🙏🙏
Highly respected sir thank you so much❤
Amazing teacher
Sir very nice complete Idea of nested subtotal in excel I know advance knowledge about subtotal thank you sir
Thanks Pramod Ji..Have nice day.tc
Sir! You are great teacher
Thanks dear👍❤️
Bahout hi clear and nice explanation sir ji learning a lot from @innozant.
Thanks Shaik Javeed sahab
Hii sir apki videos bohot achi h, or apke samjha ne ka tarika bhi unique h, mere sare concept ache se clear ho rahe h thank you sir, sir mera ek question h ki me practice worksheet download nhi kar pa Raha hu plz provide karade😇😇😇
Thanks.
Already link diya hua ha8 video description me direct download krne ka
excellent of multi level sub total. it's very useful for MIS.
Thanks Prakash ji.Keeep learning 👍
Sir discription me jo aap link dete ho.. Prectice k liya ya.. Jo bhi question dete ho usko excel sheet me kese lekar ate wahi same question ko.. Plzz bataiyega zaroor
Thank you very much for new content... I am happy to share my view in just two day of watching your tutorial.. You deserve more subscriber than this as your teaching technique is just wao.... I have been watching different channel for excel tutorial and accidentally came to your page .. iam confidently saying that you're better than other mentors..Just loved your content, and method... Love and respect from my side...💓
Thanks for your wonderful and valuable appreciation Saurabh Ji.Recommend your to start your Learning Journey from Playlist Basic Excel followed with Asvanced..Video in Sequence Playlist are available in video description
Conceptual study❤
Bro kis video mee iska solution h ju aapney last mee question diya h karney ke liye. pls bata dey.
you are the best sir🙏
Thanks dear, ❤️
Amazing sir thank you
Sir your content is superb clearing.. I am your follower from the first day you lauch this channel. Sir it would be help is if bring the VBA series I want to learn VBA from you.
Thy Mukherjee Sahab for such a valuable and wonderful feedback.It will take time but surely you mag able to watch Power BI,SQL and VBA series step by step on your Innozant Channel.
Thank You
great work
Sir shall I have the practice work file which you have stated in the video. I couldnt find it in the link. Thanks in advance
Sir, my question is, how to paste the data summary with the link, I mean, if I change any data, that will reflect on the summary.
ThanQ for the efforts sir. You are amazing 🙏🏽
Thanks Pradeep Ji
hello sir , i can't find that homework questions that you have given us in this class , can't see on your drive under "excel substotal ttc and data validation". please help :(
Assignment master link is given in video description
Namaste sir, mera data multiple column wise sort nahi ho raha hai. 2016 version Mein. Aur ye kaise hoga please bataye sir
SIR,ZABARDAST------
Thanks Khalid Majeed Sahab
Beautiful
Super
very good sir
Great sirji thanks
Thanks Sarthak ❤️gm
Very very useful thank you sir
Thanks dear
Thanks you sir.
Thanks Hemant ❤️🙏
sir, mere m subtotal ka option inactive ho jata h data sort krne k bad....pls help...
Ok sir I try it thanku very much good night sir
Good..Good Night
Great sir thank youuuuu
Thanks Sonia..Happy Learning.Gn❤️🙏
First Comment 😁.
Oh.. Thanks ♥️👍🙏
Sir esska solution ka mile ga...You are great sir..
Thanks 🙏❤️
Nice vijan
Thanks Dear🙏❤️
amazing ....
Siri skka solution kya hai?
Sir woh home work qts ka solution do na please. Mene try kiya hai but verify karna hai🙏
Sir you are amezing I want learn bi and SQL sir would you please help me how can I join your course's
Sure ,You may join our Live classroom tra for the same.❤️🙏
Sir how to calculate grand total of all groups total , group total can be more than ten or twenty. I need it dynamic
Again use subtotal or aggregate
क्या बात क्या बात .....
God bles you.❤️❤️🙏🙏👍
This example is not downloading
What will I can do download it ??
You may download assignment master folder direct line no given in video description
Bhai Power Bi ke interview questions ki video banao
I want similar stuff for unique count as well...what I mean is, whenever any particular name is selected through filter unique count of associated particular field pertaining to that name should be updated...I used sumproduct and countif..but that gives unique count of overall data... whenever any name is selected total of unique values remain same...plz. help...
Your knowledge is outstandingly superb!
What is your name?
HC ARORA
Vaishali Ghaziabad UP
sir, is there any solution to undo sorting?
every time when i sort the data,im not able to undo the sorting.
ctrl Z is not working in this case.
what can i do in this situation if i have saved the file?
You cannot undo the sort after saving. The best to do before sorting, is to
add an ID column with numbers running from 1. Then if you want to restore
your sort, you can then sort on this column
@@Innozant
ok sir g
thank you 🙏😊
ese hi same problem advance filter me jb filter at another place krte h tb bhi ati h.
Filter on another sheet Ka step Maine adv filter me seekhaya hai dekhna use aap..pehle active cursor his sheet par Hoga output whin aayega sirf.ok.
@@Innozant no sir, mene vo nhi kha.voto mujhe ata h.mene bola tha ki advance filter me bhi undo(ctrl+z) nhi hota.😊
Under the data ribbon 2nd icon above the advanced filter there is a clear icon.That will take care of it or click o. Advanced and reset the criteria range.♥️
Sir we can do this easily with Pivot Table
offcourse we can do it using pivot.❤❤
❤️❤️❤️❤️❤️
Thanks sir
❤️🙂
Thanks sir.
File download nhi ho rhi he.
drive.google.com/file/d/1W0IcL4ZkG6nXeOMX-3AQvAIX7hD2zArq/view
plz, Click on the above link you will get the file and it is working.
Keep Learning ...
good video
Thanks Ram🙏❤️
=SUBTOTAL(function_num, ref1, [ref2], [ref3], ...)
Sir Ji! What about these optional argument [ref2], [ref3], ...
can آپ elaborate for us. Thank you dil se.
Nice sir ji
Thanks Dolly
अगर मैं सब टोटल को लास्ट वाले कॉलम में शो करना चाहूं तो कैसे करेंगे
Sub Total k formula k illawa sub total kaise kr skty hain...
Goto special-blank
@@Innozant how
@@Innozant please any video related to my question...
@@Innozant this video is not fulfil the requirements....
Id. Amount. Subtotal
123. 150
123. 150
123. 200. 500
124. 150
124. 300
124. 150. 600
I want to calculate like this...
ISKE LAST DO QUESTIONS KA SOLUTIONS KON SE VIDEO MEIN HAI??
Usi series me hoga aase Shrishthi..nhi mile to btana..will guide you.
@@Innozant ok sir
SUBTOTAL Shortcut Key For MAC
👍👍👍
FILE DOWNLOAD NAHI HO RAHI H SIR JI
Assignment master jo main link hai wahan se download kar lien..direct link abhi broken ho gya hai isliye maine master link de diya hai
@@Innozant Thank You Sir Ji
@@Innozant abhi esa koi din nahi jaata ki me aapki video na dekhu kaafi sikhne ko milta h sir Thank You Very Much
@@Ghumantug7 great...God bless you..Have a wonderful career ahead ♥️
Sir, kindly give English Subtitles for your videos.. It'll be more helpful.
Ok..will try
My excel is lagging when I am using subtotal function
?
Sir Telegram se send nahi ho rahi h pls share email id to main bheju aapko
TH-cam about section me email id diya gya h
@@Innozant Guruji! Maine apko bhej diya h. Paras k naam se & Guruji you are the best
Sir I have need a student regarding due for month amt rec'd revenue rec'd total revenue due and receive students ledger wise pls send 🙏
Sheet send kijiye aise aapki query nhi aara hai smjh kya puchna chahte h aap
Sir Solution
Which solution dear🙏
@@Innozant ess assignment ka jo diya tha apne
Very nice sir
Sir I want to in tally I have group name call Bajaj ins.
In bajaj ins. Two ledger
1.bajaj 10-11 debit ledger and
2. Bajaj ftr credit ledger
But when doing pvoit filter, showing only in ledger I want your help how to slove
Or sir u can send me your contact no. For call.
Kidnly share your workhseet 🙏❤️
Sir telegram I'd kya hai apki
@innozantofficial
excellent teacher
Thanks sir
Thank you
Beautiful