மிக அருமையான பதிவு உங்களால் Excel-யில் பல விசியங்களை கற்றுக்கொண்டேன். மிகவும் நன்றி ஐயா. அடுத்த பதிவுக்காக காத்துக்கொண்டு இருக்கிறேன். 👍👍👍இப்படிக்கு உங்கள் மாணவன்............
Thanks for posting your comment. If you are so interested to learn these kinds of stuffs, do watch the following playlist: All Videos of Prabas MSOffice in Tamil - தமிழ்: ua-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
Sir, is it possible to get multilevel subtotal of large quantity of data, instead of selecting the required rows and getting subtotal for each selected items? Thanks in advance for your reply.
Hello i just have a question as in i need help in excel Is there any formula where i want a sum of nos in a cell in such a way that its total is less than or equal to a no. For ex .. in column a of excel there are 10 nos ranging from 2 to 100 and a given no is 79 sum of column should be such that it should be equal to 79 or closer to 79 Can u help?
Now it is working Mani. This comment really helpful Mani. The problem with the WordPress theme. I will make sure to address this issue in future updates. Thanks.
sorting is most important before applying subtotal. That was the mistake I was making. Thankyou.
Yes right 👍
மிக அருமையான பதிவு உங்களால் Excel-யில் பல விசியங்களை கற்றுக்கொண்டேன். மிகவும் நன்றி ஐயா. அடுத்த பதிவுக்காக காத்துக்கொண்டு இருக்கிறேன். 👍👍👍இப்படிக்கு உங்கள் மாணவன்............
நன்றி மாணவனே. கற்க கசடற.
HI Prabha.. It was fantastic video & Most useful .. Video presentation too excellent.
Thanks for appreciating us.
Intha tips, time waste aakama namma Job ah quick ah seiya use aakutha sir rompa Thanks sir 😊...
உங்கள் கருத்தை பதிவு செய்ததற்கு நன்றி. தொடர்ந்து PRABAS MS OFFICE பயணம் செய்யுங்கள். அடுத்த வீடியோ வில் சந்திக்கிறேன்.
Superb explanation in simple style.God bless you Prabhakaran.
Keep learning.
All Videos of Prabas MSOffice in Tamil - தமிழ்: ua-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
Last one week search the subtotal funtion very nice thank you sir
Hi sir videos are more useful to improve our knowledge thank you very sir
Thanks for posting your comment. If you are so interested to learn these kinds of stuffs, do watch the following playlist:
All Videos of Prabas MSOffice in Tamil - தமிழ்: ua-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
today i learnt new function.thanku sir
Happy learning
@@Prabasmsoffice again downloading problem sir., i think file has not uploaded fully kindy check problem solve issue sir
Sure
Useful videos.
I know this function very well. But some funtions i don't know before which i learn from this videos.
Happy to hear this impressive statement. Thanks Amjath Basha.
Useful video sir...
Thanks...
Yes SubTotal is one of the best concept. Hope you have watched the entire video and extracted as much as posible from the video.
Nice concept and learn from this video 👌
Recommend our videos with your friends.
@@Prabasmsoffice surely
Ultimate superb video.
Super sir.it is very useful this one and improve my skills.
Thanks Selva for your journey with Prabas MS Office. ua-cam.com/play/PLXqX9fbIzJMZI-JIQnOQSp1kEPRdvEtIY.html
நன்றி நன்றி நன்றி
I got Elaborate explanation about subtotal function.thanks for that..
Thanks for posting your comment buddy.
Awesome 👍
Super sir thank you
Thanks for your comment Raghavan. Keep learning and supporting.
Thank you very much. Can you able for Talley
நன்றி
வீடியோவை பார்த்து கருத்தை பதிவு செய்ததர்க்கு நன்றி.
Super 👌 explanation
Thanks Mani, keep learning.
Nice
Thanks, very much useful
Thanks for continuous journey with Prabas MS Office
As usual nice explanation from you sir
Appreciate your comment Akash Viji.
Please RING the BELL icon to receive more such Excel tips.
Sir, is it possible to get multilevel subtotal of large quantity of data, instead of selecting the required rows and getting subtotal for each selected items? Thanks in advance for your reply.
Thank you so much ji.....
Happy learning
Ok ji.....
Sema video sir
Thanks Raja, which part of the videos you like most?
Much useful Function
Yes, it is. Thanks for your comment.
Hello i just have a question as in i need help in excel
Is there any formula where i want a sum of nos in a cell in such a way that its total is less than or equal to a no.
For ex .. in column a of excel there are 10 nos ranging from 2 to 100 and a given no is 79 sum of column should be such that it should be equal to 79 or closer to 79
Can u help?
It looks like you have a simple question. Share your requirement to Prabas.MSOffice@gmail.com with a sample excel data.
Easily understand ur class
Sir Is it possible can we take 2 products for subtotal
2 heading For ex Area and sales manager
Practice file is available in:
www.prabastech.in/free-downloads/
Sir office 365 excel short cut pls tell
Sir ஒரு பெரிய work sheetல் உள்ள dataவை கூட்டும் போது ஒவ்வொரு பக்கத்தின் கூட்டுத் தொகையும் அவ் அவ் பக்கத்தின் கிழ் இடம் பெர என்ன செய்ய வேண்டும்
I will try to publish a video for your question
Ok sir Thx..
again downloading problem sir., i think file has not uploaded fully kindy check problem solve issue sir
Now it is working Mani.
This comment really helpful Mani. The problem with the WordPress theme. I will make sure to address this issue in future updates. Thanks.
Check and confirm.
@@Prabasmsoffice thank u sir.. bcoz now i am jobless...searching job.. ur every videos and updates are more important to me tat y..
HOW TO GET SUB TOTAL EVERY PAGE TO PRINT IN EASY WAY ?
Try to check the following option in the subtotal dialogue box:
Insert "Page Break Between Groups".
Try this and update your understanding...
Too much advertisements are coming
Its irutating
Thanks for your feedback, I will try to control this.
are you still receiving too much adds brother, i have instructed my technical team to reduce the adds.