Why You Should Use Subtotal 👉 Most Ever Useful & Powerful 💪 Excel Formula ☑️
HTML-код
- Опубликовано: 11 сен 2024
- Why Subtotal Is Most Ever Useful & Powerful Formula of #Excel with continuous serial number. subtotal formula is very powerful and most ever useful formula of excel which work only on visible data. when we filter data then subtotal is best formula to make calculations on filtered visible data only. there are many functions inside subtotal such as sum count counta countif average max min etc. watch the video and this subtotal formula will work in all excel versions 2007 2010 2013 2016 2019.
#deepakeduworld
#Excel
#subtotal
#Excelmagictrick
Excel Data Tab : SubTotal Option In Detail | Best Explanation in Hindi • Excel Data Tab : SubTo...
How To Print Subtotal In Footer Of Each Page In Excel || Paging Subtotal • How To Print Subtotal ...
Download Training File drive.google.c...
if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#excel
#subtotalformula
#DeepakEduWorld
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Thank u !!
vary nice
शराब बहुत बढ़िया पढ़ाते हैं सर नमस्ते सर राम राम सर थैंक यू धन्यवाद जय माता दी जाए
😂
Wah Deepak Sir wah kya Kamal ka formula sikhaya aap ne
Very nice and thanks sir
Very Nice and easy to understand way explained.
SuperB video thank you for making this helpful video.
I've used subtotal formula for serial nos in a data sheet. But when I'm using filter, every time the last line of the data sheet is coming with the filter. Kindly can you solve the problem please.
Thanks you so much sir
Nice sir very useful formula.
Tahnk you sir aapne bahut acche se sikhaya.
Great Sir....Aaj se aap mere Online Computer Guru ho😘😘😘😘😘
Thanks Sir 😀
Very useful video sir thanks
Bhoot acha lagaa bahi
😊
Wah wah....bahut badiya
Very Nice.
Sir aap bahut best padhate hey ❤❤❤
Thank you so much 🙏
Very nice Video
Really good understanding
very useful sir thanks for sharing
nice information thanks for sharing
I like your tutorial very much. thank you
Very nice
Its very very important and useful formula. Thanks a lot.
I like your video
Good
Thanks
Subtotal bahut hi asan tarike se bataya aapne. Thanx👌👌👌👌👌
🤗🤗🤗😊😊😊
Great....
Nice Sir
Am@zing Formula sir g...
Very useful...🤝👍🏻
🤗
Very nice vidieo. TX
Very useful video
🤗🤗
Helpful video for everyone. Thanq Boss.
Uh are grt sir mai sbhi ko appka hi suggestion deta hu ....
😊😊
good slide
Very Very useful video..thanx sir 👍
Sir, Very Nice, Great, Superb,
Thanks Sir
😊
Very nice video
😊
Thank You Sir...
Bahot Badhiya Formuliya bataya aapne.
😇
Excellent, Sir.
Super
Very useful
😊
All your videos are useful...keep going
Great sir ji
Very use full
Awesome video hai sir... 👌👌
Aapke samjhane ka tarika har RUclipsr se different hai...
Aur aapka sound bhi bahut acha hai.... 😎
😊
मस्त था सर
Sir muze wahi attendance sheet mai work next month mai apne date ko kese rakhu
Nice video lekin aap sir eployee salary sheet banaye
really good
😊😊
Gud job sir 👍👍👍
Thank you Excellent Topic. Our Banaiye.
EXCELLENT VI
😊
Deepak bhai... Thank you so much.. Your videos are very helpful.. God bless you
Thanks.😄😄😄
thank u very much
😊
Good
Thanks for update knowledge
😊
लई भारी
Namaskar sirji
Thanks
Exlent video
Sum k liye to 9 hy agr minus ya mutuply krna hoga us k lite kya figure hoga?
Awesome!
Thank you man for sharing this.
I don't know the language you are using (apart from some English word you mentioned) but I got it all because you have simply explained it
👌👌👌👌
😊😊❤️❤️❤️👍👍👍👍
The SUM function will include filtered rows in its calculation while the SUBTOTAL function will exclude filtered data by only using the rows that remain visible after filters are applied.
🔥🔥
Mja agaya sirji
Good Teaching
sir item type bahut jyada hai, kaun se formula se item ka goshwara niklega.
Superrrrrrrrrrrrrrrrrrr
Nice info 👍
nice, thanks
Nice video.
But, Sir jab ma abc company filter kar raha hoo tab last row pa jo xyz company ha yo aa raha ha.
But, Sir serial number colum pa subtotal formula ma counta (3) ka formula charge karna ka bad hi asa horaha ha.
Koi vi colum sa kich vi filter karu to last wala row aa raha ha.
please help me sir.
ACCHA HAI, MAGAR 300 LINE HO TO KAM NAHI KARTA, MADLAB 300 KE BAD JAB 200 LINE AATA HAI TO 300 TAK NUMBER ISA HI REH JATA HAI
Sir thoda zoom krke dikhana tha ji counta kiya tb
nice work
Thanks sir very good
😊
I have a Question...agar hum iski ek main sheet banayein to kya yeh total waha Trf ho jayega...
you are best.
nic
Such a nyc video bhot kuch sikhne ko mila thanks for sharing this video.....
Alt +
nice sir
I am very impressed to know subtotal formula. Thank you sir.
subtotal formula ke jaisa hi cout ke liye formula hai kya
New Information Partner. #Success555
Sir subtotal ka or advanced video banavo jo hame useful ho thanks nice video 👍
🤗👍👍👍
Nyc
😊😊
Nice
jaise main subtotal formula me filter karta hu to total bata deta hai waise hai agar count jan na hai to kaise kareenge
make more vedio subtotal vedio sir, more example subtotal filter sir,
Very Nice Sir
But Aapne Complete Explaination Nahi Diya. Usme Har Formula Double H. Uska Use Kse Hoga?
Eid mubarak
Counta wale me jb hm filter krte hain to tu dusre item ka ek data last me aa jata hai kya kru
How to lock some column and row not editable please tell me
Nice video.
👌
Love The Video 👌👌👌
jai hind sir
Sir last me sl no wise subtotal nikalne me c3:c3 formula kiu lagaya ...ssmajme nhi aya. Wo jara explain kar de.
Agar sorting kare to 1,2,3,4...no ki position change hogi ki niii
pivot tabile sa same kam karsakte ha ?
Awesome …!!!!
Nice video ji