Excel SubTotal Function & Formula in Tamil | Sum vs Sub Total | Prabas MS Office

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 73

  • @Mskms-wm2pv
    @Mskms-wm2pv 9 місяців тому

    sorting is most important before applying subtotal. That was the mistake I was making. Thankyou.

  • @colours3465
    @colours3465 4 роки тому +4

    மிக அருமையான பதிவு உங்களால் Excel-யில் பல விசியங்களை கற்றுக்கொண்டேன். மிகவும் நன்றி ஐயா. அடுத்த பதிவுக்காக காத்துக்கொண்டு இருக்கிறேன். 👍👍👍இப்படிக்கு உங்கள் மாணவன்............

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      நன்றி மாணவனே. கற்க கசடற.

  • @Ridetoright111
    @Ridetoright111 4 роки тому +3

    HI Prabha.. It was fantastic video & Most useful .. Video presentation too excellent.

  • @sujithathankaraj5059
    @sujithathankaraj5059 4 роки тому +1

    Intha tips, time waste aakama namma Job ah quick ah seiya use aakutha sir rompa Thanks sir 😊...

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      உங்கள் கருத்தை பதிவு செய்ததற்கு நன்றி. தொடர்ந்து PRABAS MS OFFICE பயணம் செய்யுங்கள். அடுத்த வீடியோ வில் சந்திக்கிறேன்.

  • @apn6824
    @apn6824 4 роки тому +2

    Superb explanation in simple style.God bless you Prabhakaran.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Keep learning.
      All Videos of Prabas MSOffice in Tamil - தமிழ்: ua-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html

  • @praburaja4301
    @praburaja4301 4 роки тому

    Last one week search the subtotal funtion very nice thank you sir

  • @jayashreeb6273
    @jayashreeb6273 4 роки тому +1

    Hi sir videos are more useful to improve our knowledge thank you very sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      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

  • @dm-zd5nu
    @dm-zd5nu 4 роки тому +2

    today i learnt new function.thanku sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Happy learning

    • @dm-zd5nu
      @dm-zd5nu 4 роки тому +1

      @@Prabasmsoffice again downloading problem sir., i think file has not uploaded fully kindy check problem solve issue sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Sure

  • @amjathbasha9828
    @amjathbasha9828 4 роки тому +2

    Useful videos.
    I know this function very well. But some funtions i don't know before which i learn from this videos.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Happy to hear this impressive statement. Thanks Amjath Basha.

  • @mummaiahsakthivel7355
    @mummaiahsakthivel7355 4 роки тому +2

    Useful video sir...
    Thanks...

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      Yes SubTotal is one of the best concept. Hope you have watched the entire video and extracted as much as posible from the video.

  • @sachinsathish7484
    @sachinsathish7484 4 роки тому +1

    Nice concept and learn from this video 👌

  • @venkateshm6261
    @venkateshm6261 3 роки тому

    Ultimate superb video.

  • @asaltselvam1647
    @asaltselvam1647 4 роки тому +1

    Super sir.it is very useful this one and improve my skills.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks Selva for your journey with Prabas MS Office. ua-cam.com/play/PLXqX9fbIzJMZI-JIQnOQSp1kEPRdvEtIY.html

  • @sureshrajan3152
    @sureshrajan3152 4 роки тому +1

    நன்றி நன்றி நன்றி

  • @ranjithrash5329
    @ranjithrash5329 4 роки тому +1

    I got Elaborate explanation about subtotal function.thanks for that..

  • @itsmenm8399
    @itsmenm8399 4 роки тому +1

    Awesome 👍

  • @vijayaraghavan9400
    @vijayaraghavan9400 4 роки тому +1

    Super sir thank you

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks for your comment Raghavan. Keep learning and supporting.

  • @vu3wrrindore.hamoprator.388
    @vu3wrrindore.hamoprator.388 4 роки тому +1

    Thank you very much. Can you able for Talley

  • @6070avm
    @6070avm 4 роки тому +1

    நன்றி

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      வீடியோவை பார்த்து கருத்தை பதிவு செய்ததர்க்கு நன்றி.

  • @Manikandan-eh1hj
    @Manikandan-eh1hj 4 роки тому

    Super 👌 explanation

  • @adhithiyakumarvijayakumar3882
    @adhithiyakumarvijayakumar3882 3 роки тому +1

    Nice

  • @subramaniamramamurthy7548
    @subramaniamramamurthy7548 4 роки тому

    Thanks, very much useful

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks for continuous journey with Prabas MS Office

  • @akashviji8245
    @akashviji8245 4 роки тому

    As usual nice explanation from you sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Appreciate your comment Akash Viji.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Please RING the BELL icon to receive more such Excel tips.

  • @prakashsathyapriya
    @prakashsathyapriya 4 роки тому +1

    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.

  • @sanjaikumar2510
    @sanjaikumar2510 4 роки тому +1

    Thank you so much ji.....

  • @rajasanthosh9617
    @rajasanthosh9617 4 роки тому

    Sema video sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks Raja, which part of the videos you like most?

  • @AnbarasuAnnamalai
    @AnbarasuAnnamalai 4 роки тому

    Much useful Function

  • @pratimjh
    @pratimjh 4 роки тому +3

    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?

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      It looks like you have a simple question. Share your requirement to Prabas.MSOffice@gmail.com with a sample excel data.

  • @ramkumarv1661
    @ramkumarv1661 4 роки тому +1

    Easily understand ur class

  • @kannank9772
    @kannank9772 3 роки тому

    Sir Is it possible can we take 2 products for subtotal

    • @kannank9772
      @kannank9772 3 роки тому

      2 heading For ex Area and sales manager

  • @Prabasmsoffice
    @Prabasmsoffice  4 роки тому +1

    Practice file is available in:
    www.prabastech.in/free-downloads/

    • @purush4305
      @purush4305 4 роки тому

      Sir office 365 excel short cut pls tell

  • @abdulraheem9942
    @abdulraheem9942 4 роки тому

    Sir ஒரு பெரிய work sheetல் உள்ள dataவை கூட்டும் போது ஒவ்வொரு பக்கத்தின் கூட்டுத் தொகையும் அவ் அவ் பக்கத்தின் கிழ் இடம் பெர என்ன செய்ய வேண்டும்

  • @dm-zd5nu
    @dm-zd5nu 4 роки тому

    again downloading problem sir., i think file has not uploaded fully kindy check problem solve issue sir

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      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.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      Check and confirm.

    • @dm-zd5nu
      @dm-zd5nu 4 роки тому

      @@Prabasmsoffice thank u sir.. bcoz now i am jobless...searching job.. ur every videos and updates are more important to me tat y..

  • @lathakannan7812
    @lathakannan7812 4 роки тому +1

    HOW TO GET SUB TOTAL EVERY PAGE TO PRINT IN EASY WAY ?

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Try to check the following option in the subtotal dialogue box:
      Insert "Page Break Between Groups".
      Try this and update your understanding...

  • @kaviyarasu315
    @kaviyarasu315 4 роки тому

    Too much advertisements are coming
    Its irutating

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks for your feedback, I will try to control this.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      are you still receiving too much adds brother, i have instructed my technical team to reduce the adds.