SUBTOTAL Function in Excel | How to use Subtotal in Excel Explanation with Examples in Hindi
Вставка
- Опубліковано 29 вер 2024
- Learn how to use Subtotal feature of Excel step by step.
1.Subtotal using Sum Formula
2. Subtotal Manual method
3. Subtotal using Sumproduct and isformula function in excel
4. Subtotal using subtotal function in excel
5. Subtotal using Aggregate function in excel
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#subtotalinexcel #subtotal #Innozant #exceltipsandtricks #subtotalfunctioninexcel
Subtotal seems very hard to me but through this video it becomes as easy as ABC 😁😁😁
Thanks Archana..Happy Learning..Have. A great career ahead
Hii
@@Innozant
Sir really Aap naa Excel padane vaale Bhagban ho sir
Aap mere liye God ka diyaa hua ek वरदान ho sir
You are a Genius sir My God ❤❤❤ Love you sir ❤
Sir aapki Tarif ke liye Shebdha kam pad rahe hai sir ❤❤
Superb man.. maza aagaya yaar.. ek genuine problem bhi solve hogaya subtotal button se.. Outstanding ki list SAP se derive ki thi..maza hi agay
Thanks
Excellent 👍
This is what I searched for thank u 😊
Thanks Sir,Text thoda clear hota toh bahut aacha hota.
Thanks dear
Welcome sir
Powerful video sir G .....
Thank you ..mai bhi computer teacher hu
Thanks Karan..We welcome you then experience the taste of success..Happy learning ❤️👍
Nice teaching style and informative video. thanks for uploading
Thanks Naveen Ahmed Ji❤️
Sir mene aap ke video bahut dekhi hai
Thankyou sir,
Your videos helps me a lot before going towards MIS industry.
I hope your uploaded videos sufficient for freshers in MIS Interview.
👍
Thanks Anuj Ji .Happy Learning ❤️ dear
Hllo Sir,
=Isformula Me Values Cell Ko Dekhne Ki Konsi Shortcut Key Use Kri H ...?
Sir data select krke Alt + ; press krna hai aur fir paste😊
superb sir chaa gye
Sir Another great bunch of tips. You are the best many thanks. God bless Sir.
1.Method. Select Data - Go To special - Visible cell only - Copy Data - Paste
2.Method. Select Dat - Alt + ;
Good Sandeep,You are really a dedicated , Hardworking candidate.Acha nhi bht Acha kroge life me yadi Aisi Lagan cont.rakhoge to
Hi, m unable to paste Visible cells only, could you please assist, and even 2. Method doesn't work with me.
Thank you So much,
Sir can you please introduce some video tutorial on Ledger reconciliation with two sets of data, with real world example!
Ok .dear..noted.wil try this make the same
Love you ❤️
Sir you are best
Thanks Ravindra❤️❤️
Alt+; copy and past to destination cell, sir, am i right?
Thank you so much sir
Thanks dear❤️❤️
wow sir
Get Wow factor sir👍👍
Thanks
1 ques, after applying all this subtotal, when I wish to see data using filter in collapsed form, it gives blank data. How to make it happen????
sir, isme aisa ho sakta hai kya, jaise samsung, soni, del, ye sab product name ek sath arranged nahi hai, example kahi soni, fir del fir samsung is trah se arranged way me nahi hai, fir bhi subtotal hame sabko ikatha kar ke dikha de sabkuch,
Sir esme short kaise kia hai q ki short krne p Samsung pahle nhi a raha hai
Wow sir...👍
Thanks Rahul❤️
Beautiful
Thanks Arti
f9 to see the value in formula but to go back to the formula
Undo Ctrl z
Thanks sir
Aaj to aap bht padhai Kar re hain,.good...kya sab padh liye aaj
@@Innozant thnq sir but main apki shuru se videos ki Playlist dekh raha hu muje apka tech karne ka treeka bht pasand aur unique lgga muje advance excel ata hai i have a laptop but apke interview questions se kuj sikh raha hun sir thnq
pehle uttna hi copy kare Ctrl+C
then sir
we have to click F5
then ... click...... visible cell only ...
after all these work finnally
just Click Ctrl+ V
Good nitish
Please hepl me to login how to start
Go to special me ja kar visible cell olny
❤️👍
❤
👌👌
Past Special
???didnt get you
@@Innozant Paste Special By right clicking
Aap ka Dynamik pivottable dekha and sub total dekha bot are excellent
Ok dear..god bless you
Thanks sir.
ऐसे डाटा या (फ़िल्टर डेटा) को कॉपी करने के सबसे पहले डेटा को सलेक्ट करेंगे फिर Alt + ; को प्रेस करेंगें। फिर ctrl + c (copy) करके जहाँ पेस्ट करना है वहाँ पेस्ट कर देंगे।
Very Good.. Tejpal Ji😌❤️
Sir definition bata do subtotal ki
Taniya Ji.. Subtotal Function allow you to create groups and then perform various funcatios of excel e.g sum,count,average,max etc and it is very useful Function and helps in analyzing the data provided.👍🙏❤️
Hi Sir,
its not working table ?
Table data not working means? Didn't get you dear
Data sheet is there you just need to apply subtotal
alt+;
👍❤️
legends are not going to watch videos ,they just check comments.
Excel ki jaroorat hai muje or isko sikhnaa shuru hi kiyaa hai mane a week ago or bhut preshaan kiyaa isne muje ab tk.... Ab mane bhi thaan li hai... Iske piche ab paagal ho jaaungaa lekin isko sikhungaa.... Bhut hi siddhat se, mohabbat se, or.... Khelo dimaag se 🤨😁
That's great..this is what I expect from u dear
Group ungroup का जो program दिखाया वो सब मैनुअल program है..
इसको कुछ advanced मे दिखाए.. अब keyboard के rows select किए फिर ग्रुप किया मतलब manually.. कुछ ऐसा मैक्रो करके दिखाए जितने भी नाम है unique हो जाए first alphabet से short हो जाए फिर उनकी counting and total and extra information aa जाए और हर नाम के नीचे total आए फिर gap आए for अगला नाम आए और ये सब एक ही sheet मे आए and पूरी sheet मे अपने आप फूल customised border aaye तो लगे कुछ professional program देखा..
Ye Sab Automatically या just एक दो click मे आना चाइये.. और macro codding लिखनी नहीं है.. Just Macro करो Codding Apne आप आजाती है waise.
Main pending complaint ka data nikalta hu. Mere sabhi sabhi authority ka pending data hai or muje sabhi kya alg alg total received data chaiye to kaise hoga. Koi method bataiye
# Question how to copy only subtotal in excel ?
Ans: Step-1 select the range that you want to copy
Step-2 Press Alt+;
Step-3 Ctrl+ C
Step-4 Ctrl + p where you want to past the subtotal
Sir iska matlab isse badiya to sumproduct hai.. Wo bhii yahii kaam karta hai na...
Go to special & visible cell, copy & paste
Shortcut visible cells only?
Table ko select karke lock karna hai or copy karke hame jaha bhi data chahiye waha par paste karna hai
how to repeat row/columns headings in excel using subtotal
Sub se pehala select kar ka alt aur semi colon press karaga fer copy karaga
how to repeat row / columns headings in excel using subtotal
Should take value visible cell only select data range then alt+: then copy and paste
Sir mera ek problem hai excel mein if mein link share karun uska aap help karenge mere pls
Sir
Please bataye ki subtotal each page ke last me kaise hoga.
So beautifully explained....amazing..... Love to learn all the things from your videos only....
with lots of Respect
Anil from Bangalore
Namaste Ji. Thanks a lot....
Thanks Deenbandhu, Really means. A lot to me dear.
happy learning.Recommend you to start your learning journey from playlist Basic excek onwards .
Last ma alt+a+b kasy lag ha subtotal ka function ni arh h
Sub total data ko descending order me kaise kr sakte h
Sir Answer is your asked questions in this video Alt+; visible selected then copy then past where you want to show.
👍❤️
Alt+; for current selection and copy paste new sheet
Alt plus ; only visible data copy ya raha answer sir
by coping as picture then as shown on the screen then paste
Sir plz plz plz computer teacher ki job ka syllabus pda dijiye online....
Kya syllabus hai jo padhna chajye hain aap
Visual cell copy alt + ; and then copy the data..
Alt ; dabana se visible cell select hoga
Aapki video se suru kiya safar mera bhut Aage aa chuka h Sir aapki video se mne 40 function aise Sikh chuka hu Jinki koi mujhe agr Nind me Utha kr bhi kisi chij ka solution puche to m ek dam se Unka solution kr skta hu Tnx Sir Ji. ❤️
Great going
Hy... subtotal karte vk muzhe heading bhi dikhane ki wo kaise dikha u...
heading to rehta hi hai ya aap custom heading bana sakte hain
pranam Gurudev CTRL+G > ALT+S>visible cells only > then copy and paste am I right sir?
Very Good Mohit ...Aur Visible cells ka shortcut ? Jaldi batao❤️
@@Innozant I THINK SIR alt+;
Very Good Mohit❤️
1.... go to special and select visible cells only....then copy...paste
2......ALT+; then copy paste
Good ❤️👍
great,salute from pakistan
Ctrl Paste Special only text.
Visible cell only alt semicoma
Paste special me jakr hoga
Thanks you sir, shortcut for paste only visible data Alt+;
Yes ..Good Hemant 🙂♥️👍
Visible cels then copy paste
Love from Pakistan Sir you are best Excel teacher on UA-cam
Thanks Shah sahab..Really means a lot to me dear
Solution goto se bhi or alt+; se bhi ho jaega aapse hi sikha hai sir ji
Yes Nirmal
Sir Apka birthday kab ata hai?
Visible Cells Only Alt+;
Sir ek sheet mai table hai usme humne formating kiya hai aur second sheet par humhe sirf formating chahiye and third sheet par content without copy jaise krenge
Mujhe help ho jayegi...
sir file nahi mil rahi h iski
Alt+: use karna hai uske baad paste karna hai sir ji
Good
Mera sawal: agar ITEM wale column may single line ki jaga double line text ho to phir subtotal ossi column may apply ki surat may sahih kam nahi karta. Kia yeh sahih hai ya ghalat?
Alt+; then copy then use paste special. Am I right sir for visible cells only
Yes Prashant Ji you are right❤️👍
Same Answer👍
Thanks you boss....
Great sir
Paste visible cells
Excellent. Explained in a very simple & Understanding language. Doing a great job indeed.
Awesome video sir.
Thanks Sachin Ji🙏❤️
Thanks dear sir
zaberdust
First thing selection data then press alt ; then ctrl + c
Good 👍♥️
Paste special
Thikyou sir
Thank you sir for making videos on Excel. Wish I could find your channel earlier. Now I watch your videos and it helps me to clear doubts about excel formulas.
Thanks dear..Happy Learning
Pls guide me. I have a question. I have many employees. They are sending their daily attendance from different cities and villages. As I receive their attendance notification, I enter their attendance against their name and so on. At the end of the month a final sheet of attendance and after that a salary sheet is prepared.
My question is: as and when I enter attendance notification, the word P (Present), and similarly the word R ( Resigned) or T (Terminated) should appeared on 2nd sheet automatically. Is it possible?
Superb sir
Sir mujhe Excel apna paka karna chahta hu
Lagarar practice bus ek hi solution hai
Ok bhai
Very good
the way you taught us, it seems that kids will learn your topics quicker than ABC....
❤️❤️❤️❤️
Thankx
Awesome your questions answer Visible cells only
Answer dijiye..jaldi.. shortcut bhi bataiye
@@Innozant go to special
shortcut of visible cells only??