Highlight or Trigger Excel Cells a few days prior to the Expiry or Due Date | Prabas MS Office

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

Комментарии • 72

  • @sivakumark5530
    @sivakumark5530 2 года назад +1

    Excellant video very useful

  • @Knowtheunknow.withme
    @Knowtheunknow.withme 4 года назад +2

    Hi sir. I love your way of teaching 👏👏👏👏

  • @karthickrajalearn
    @karthickrajalearn 4 года назад +1

    Great Content
    It is useful for Bank Workers and Credit Card Holders

  • @cockracorsp224
    @cockracorsp224 4 года назад +1

    Ya.. super concept sir

  • @nansri1
    @nansri1 4 года назад +1

    Very useful... Thank you

  • @vairamm4234
    @vairamm4234 3 года назад

    Very Interesting Sir👌👌👌

  • @Prabasmsoffice
    @Prabasmsoffice  4 года назад +5

    We have migrated from .IN to .COM domain.
    Our old website will be inactive in few months, so please reach out to our new website prabastech.com for future updates.

  • @lakshmikanthanramas2444
    @lakshmikanthanramas2444 4 года назад +1

    Very new formulas Sir, thank you❤

  • @muthupandimuniyandi1439
    @muthupandimuniyandi1439 4 года назад +1

    Good Topic sir, Thanks

  • @ranjithrash5329
    @ranjithrash5329 3 года назад +1

    Good info bro

  • @nktrendings816
    @nktrendings816 4 года назад +2

    Super BRO

  • @marans22
    @marans22 4 года назад +1

    Well explained

  • @nruniverse5323
    @nruniverse5323 3 года назад +1

    சூப்பர் சார்

    • @Prabasmsoffice
      @Prabasmsoffice  3 года назад

      வீடியோக்களை தொடர்ந்து பார்த்துகொண்டு வருவதற்கு நன்றி.

  • @kenethnethan6249
    @kenethnethan6249 4 года назад +1

    Vedio superb boss, please explain how to do in 2010 excel

  • @Srinivasatax95
    @Srinivasatax95 4 года назад +3

    This Concepts it's good sir but Quarterly and month dude date Expiry that which formulas apply sir. And also explains for Retail shops Stocks Reduce time Alter msg which formula apply sir???

  • @mainudeens
    @mainudeens 3 года назад +1

    Nice

  • @perumalpazhani9876
    @perumalpazhani9876 3 года назад

    Sema 👏👏👏👏

  • @amalarajmstella2340
    @amalarajmstella2340 4 года назад

    Hi good evening sir, vary useful video, I'm waiting for filter video, only lock Colum not in row

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      ruclips.net/video/owoB5mkIA-E/видео.html

  • @rameshb3018
    @rameshb3018 3 года назад +1

    hi, sir how to convert a date format like mmm_yyyy
    example input is maybe nov-20 or november20 or 20th nov mean the expert output is Nov_2020. Please explain sir. Thank you

  • @apn6824
    @apn6824 4 года назад +1

    Nice presentation Prabhakaran...I have a doubt. When we use Sort or Filter function the date appears in normal number only. whether it can be changed by using date format ? Since the result populating in array concept whether this can be changed. Pls clarify...

  • @sachin0200
    @sachin0200 4 года назад +2

    hi sir, concept super, but i have doubt , while using filter, the datas are not coming in ascending order, how to sort ascending order while using filter option(timing11:27) .. how to use this concept in office 10,16,19 without (=sort, =filter)

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      Will try to make a new video for this. Thanks

  • @vivekanandhanvs5912
    @vivekanandhanvs5912 4 года назад +1

    Useful video Prabha sir.. But i dont have office 365 ..

  • @thiyakup7333
    @thiyakup7333 4 года назад

    Sir, very nice teaching and very useful, but i have windows 10, please advise how i can apply the above formula (Sort & filter) in windows 10

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      Install Office 365 and use these new Formulas.

  • @gobisekaran5102
    @gobisekaran5102 4 года назад +1

    Y date changed number format when you use formula sort and filter? Is anyways to unchanging dates? Pls explain. Little doubt

  • @kathirramankathir4261
    @kathirramankathir4261 3 года назад

    How to filter the product in same function sir,

  • @MySunil2010
    @MySunil2010 3 года назад +1

    Sir how to excellent expired date or month highlight in excel iam using raw material inventory

    • @Prabasmsoffice
      @Prabasmsoffice  3 года назад

      Share your Sample data to prabas@prabastech.com.

  • @mohamedmafas8389
    @mohamedmafas8389 4 года назад +1

    row unlock
    column lock

  • @Puviyalmatram
    @Puviyalmatram 3 года назад

    How to automate the date month year
    Due date due month due year can play be explained by automation. You explained for date. We want to know for the month and year

    • @Prabasmsoffice
      @Prabasmsoffice  3 года назад

      Sure, I will make a video for this. Stay tuned.

  • @VICKYVPS
    @VICKYVPS 4 года назад +1

    Sir filter ku video podunga

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      ruclips.net/video/owoB5mkIA-E/видео.html
      Advanced Filter is here

  • @MySunil2010
    @MySunil2010 4 года назад +1

    Filter video podunga

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      ruclips.net/video/GeyivlDm1Qg/видео.html

  • @k.sathish8540
    @k.sathish8540 4 года назад

    Sir
    Particular month start date la irundhu before 33 month start date formula sollunga sir
    Ex 01/09/2020. Before 16 month Enna month starting date varum

  • @balaandrews
    @balaandrews Месяц назад

    Bro filter alternative function video podunga bro..

    • @Prabasmsoffice
      @Prabasmsoffice  Месяц назад

      Sure 👍
      ruclips.net/video/F8Wthj4tvTM/видео.html

    • @balaandrews
      @balaandrews Месяц назад

      @@Prabasmsoffice I'm waiting that video 🙏

    • @Prabasmsoffice
      @Prabasmsoffice  Месяц назад

      ruclips.net/video/F8Wthj4tvTM/видео.html
      Hope you have watched this Excel Filter formula tutorial

  • @muruganc8737
    @muruganc8737 3 года назад

    How to automatically sent to mail filters option

  • @VK-uf5gz
    @VK-uf5gz 3 года назад

    Nuisance ad openings bro

  • @rasithali
    @rasithali 4 года назад +1

    நான் ஒரு excel பைல்ல குறிப்பிட்ட இதை மட்டும் filter செய்துள்ளேன் அதை மட்டும் காபி செய்ம்பொலுது hide ஆகி உள்ள மொத்த deatail காப்பி ரைட் செய்யப்பட்டுள்ளது ஆனால் எனக்கு அந்த பில்டர் மட்டும் காப்பி ஆக வேண்டும் அதற்க்கு என்ன பண்ண வேண்டும் ? ப்ரோ ப்ளீஸ் replay msg .தேங்க்

  • @Mages243
    @Mages243 3 года назад

    How to use vlookup in merged cells

    • @Prabasmsoffice
      @Prabasmsoffice  3 года назад

      This is a common problem. Please unmerge them for correct output.

  • @vmr8974
    @vmr8974 2 года назад

    Filter option podunga bro.

    • @Prabasmsoffice
      @Prabasmsoffice  2 года назад

      ruclips.net/p/PLXqX9fbIzJMbYPKtKne9hT5jsCxf-PE07

  • @oupaswoodshop1325
    @oupaswoodshop1325 Год назад

    Do you have this video in English?

  • @mugilannagooran9521
    @mugilannagooran9521 2 года назад

    Please explain sir vehicle RC 15 yrs experie , license batch experie 1yr. How to multiple filter in filter formula

  • @sredharbalaraman1387
    @sredharbalaraman1387 4 месяца назад

  • @vijayaraghavan6958
    @vijayaraghavan6958 4 года назад

    Xlookup from excel

    • @Prabasmsoffice
      @Prabasmsoffice  4 года назад

      ruclips.net/video/cg4aM0O0AcA/видео.html

  • @vinothkumar-fg3hd
    @vinothkumar-fg3hd 4 года назад +1

    Don't lock

  • @magimagi9053
    @magimagi9053 4 года назад

    No