Expiry Date and Alert Messages in Excel - Malayalam Tutorial

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

КОМЕНТАРІ • 286

  • @stranger69pereira
    @stranger69pereira 2 роки тому +8

    നിങ്ങൾ വളരെ Professional ആണ് 👑👏👑👏👑👏

  • @shafiactirur
    @shafiactirur 2 роки тому +3

    ഒരു രക്ഷയും ഇല്ല... നല്ല രീതിയിൽ explain ചെയ്തു തന്നു,... 👏

  • @LondonNTheWorld
    @LondonNTheWorld 2 роки тому +1

    വളരെ ഉപകാരപ്രദം.. കുറെ നാളായി ഞാൻ നോക്കിയിരുന്ന ഒരു സംഭവം.. തിരക്കുപിടിച്ച ജീവിതത്തിൽ ഏറ്റവും ഉപകാരപ്രദമായ സംഭവം... പലപ്പോഴും ധാരളം ടിൻ ഫുട് items expire ആയതിന്റെ പേരില് എടുത്തു കളയേണ്ടി വരുന്നു....വളരെ നന്ദി

  • @shijicsam6043
    @shijicsam6043 2 роки тому +6

    I was used to watch several other plat from but I never seen such simple and scratch to top classes 👍🏻

  • @samuelscarijohnson1432
    @samuelscarijohnson1432 2 роки тому +1

    Ee upakarathinu nandhi god blss you sir

  • @psh36
    @psh36 2 роки тому +2

    വളരെ ഉപകാരപ്പെട്ട വീഡിയോ share ചെയ്തിട്ടുണ്ട്

  • @delnaaloshious7505
    @delnaaloshious7505 Рік тому +1

    Thank you so much for sharing the valuable informations in UA-cam. All videos are Really helpful I can apply all those in my work life 🙏

  • @shijicsam6043
    @shijicsam6043 2 роки тому +1

    Insurance, License renewals etc...are simple now 👍🏻👍🏻👍🏻

  • @vallavilasreekumar4420
    @vallavilasreekumar4420 2 роки тому +1

    കാത്തിരുന്ന വീഡിയോ

  • @roopeshmadhavan2170
    @roopeshmadhavan2170 Рік тому +1

    വളരെ നന്നായിട്ടുണ്ട്.

  • @mahadevanv8268
    @mahadevanv8268 2 роки тому +1

    വളരെ നന്ദി സാർ

  • @noushadpuliyathazhath3276
    @noushadpuliyathazhath3276 2 роки тому +1

    Very useful…
    many thanks.

  • @rameesbasheer4083
    @rameesbasheer4083 2 роки тому +3

    Thank you sir for your great class very helpful 💕

  • @sabujalal
    @sabujalal 2 роки тому +1

    Very good information
    Thanks a lot

  • @manojkgeorge7314
    @manojkgeorge7314 2 роки тому +1

    very useful information... thankyou sir

  • @jovanraj5706
    @jovanraj5706 2 роки тому +1

    You’re a blessed teacher.

  • @LCVibeZ
    @LCVibeZ 2 роки тому +1

    I am new subscriber..really informative..thanks alot

  • @vinodknair1065
    @vinodknair1065 2 роки тому +2

    Brilliantly explained

  • @Arun-e7k6w
    @Arun-e7k6w 6 місяців тому

    Nice workshops.. Pls explain expiry in days base not in month..

  • @shafeekismail5348
    @shafeekismail5348 2 роки тому

    Sir, ethu polichoooo

  • @nasrakareem3633
    @nasrakareem3633 2 роки тому +1

    Thank you very useful video

  • @m4malayaliezzz
    @m4malayaliezzz 2 роки тому +1

    Storekeeper very useful 👌

  • @georgemathewizme
    @georgemathewizme 2 роки тому +1

    Superb.. really helpful

  • @keralavillagerecordskvr7979
    @keralavillagerecordskvr7979 2 роки тому +1

    Thankyou sir

  • @riyazmoidunny4588
    @riyazmoidunny4588 2 роки тому +1

    Very much helpful video

  • @sureshbabutg827
    @sureshbabutg827 2 роки тому +1

    Very informative. Very useful

  • @shafisalam3
    @shafisalam3 2 роки тому

    Thank You so much for valuable information, really, it is helpful❣️👍🏻

  • @alimonsvlog3395
    @alimonsvlog3395 2 роки тому +1

    superrrrrrrr sir

  • @randomlyrandom5816
    @randomlyrandom5816 2 роки тому +1

    Informative and great presentation

  • @sachimanakkadave6005
    @sachimanakkadave6005 2 роки тому +1

    Very usefull thinks

  • @007jerryjerold
    @007jerryjerold 2 роки тому

    amazing presentation.. Many thanks👏👏

  • @LivenExplorebySuhail
    @LivenExplorebySuhail Рік тому +1

    Useful, thank you

  • @thevinodiyyan
    @thevinodiyyan 2 роки тому +1

    സബ്സ്ക്രൈബ്ഡ്....

  • @fathemarafi
    @fathemarafi 2 роки тому +1

    Very informative

  • @sadikpazhankave5286
    @sadikpazhankave5286 2 роки тому +1

    Sir, you have done well. (Sadik - Doha Qatar)

  • @thankuish
    @thankuish 2 роки тому +1

    വളരെ ഉപകാരപ്രദം. 🙂👍🏻

  • @cmshihab4624
    @cmshihab4624 2 роки тому +1

    Thank you so much..

  • @soji_joseph
    @soji_joseph 2 роки тому +1

    Very useful 👍🏽

  • @anurajr8355
    @anurajr8355 2 роки тому +1

    NICE...

  • @adarshpl9728
    @adarshpl9728 2 роки тому +1

    Thank you very much

  • @manucp07
    @manucp07 2 роки тому +1

    Very clear and excellent 👏🏻👏🏻👏🏻

  • @bibinantonyarackel
    @bibinantonyarackel 2 роки тому +1

    Very useful…..

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

    Am a new subscriber of your channel.. very Well explained and being a non IT professional am surprised to know these vital informations … Thank you 🙏

  • @nelsonm3710
    @nelsonm3710 2 роки тому +1

    Awesome 👍 Thank you for sharing such simple tips. Very helpful

  • @rajeshdevendran5349
    @rajeshdevendran5349 Рік тому +1

    Super 👍

  • @maheshcycle
    @maheshcycle 2 роки тому +1

    Thank you for your information sir 🎈

  • @saleeshapkannur9910
    @saleeshapkannur9910 2 роки тому +1

    Thank you.very useful vide

  • @raneeshjcdecaux6970
    @raneeshjcdecaux6970 2 роки тому +1

    Thanks

  • @iismails
    @iismails 2 роки тому +1

    Powli voice 😍😍😍
    Please do RJ😎😎

  • @ashkuashkar3131
    @ashkuashkar3131 2 роки тому +1

    Super trick

  • @dijilchit
    @dijilchit 2 роки тому +1

    well explained thank you

  • @dileepsurendran1595
    @dileepsurendran1595 2 роки тому +1

    Good information

  • @FreeTimeKitchenTravel
    @FreeTimeKitchenTravel 2 роки тому +1

    Well explained. thanks

  • @jositgeorge2008
    @jositgeorge2008 2 роки тому +1

    Thanks....

  • @JIJONRD
    @JIJONRD 2 роки тому +1

    Thank you sir. Useful information. 👍🏻

  • @ishaquenaha5686
    @ishaquenaha5686 2 роки тому

    Oru transportation companiyile vehicle e oil change cheyyan nalla tip paranju tharo .. like oil change remainder for last change oil to current kilometre to target kilometre 🙏

  • @trajith
    @trajith 2 роки тому +1

    Good info, Your narration is excellent, keep it up

  • @ospadijaggu6187
    @ospadijaggu6187 2 роки тому +1

    excellent

  • @sunilkumarp4756
    @sunilkumarp4756 2 роки тому

    Very nice

  • @kmanoj392
    @kmanoj392 2 роки тому +1

    Wonderful job sir

  • @theowl7959
    @theowl7959 2 роки тому +1

    Sir great video

  • @padmakumarkurup7251
    @padmakumarkurup7251 2 роки тому +1

    Wonderful

  • @anz672
    @anz672 2 роки тому +1

    Great

  • @kiranvarghese18
    @kiranvarghese18 2 роки тому +1

    Sir expiring ne patti oru video cheyanne

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      Can you please explain the requirement with more details?

  • @sreerajeshkumar6131
    @sreerajeshkumar6131 2 роки тому +1

    Adipoli

  • @sunilkumararickattu1845
    @sunilkumararickattu1845 2 роки тому

    well explained 👌💅

  • @austinwillbe
    @austinwillbe 2 роки тому +2

    Thank you so much very details explanation of functions. I would like to know that any alerting function which can be incorporated with this; like an email or Desktop notification so that we will get alerts without opening the sheets.

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому +2

      Power Automate (Microsoft Flow) can be used for this purpose.

  • @sujithchandran4829
    @sujithchandran4829 2 роки тому +5

    Very well explained.Thank you!Just wanted to know why do you use -1 in case of EOMONTH function.I am clear about the usage of -1 in other functions say Expiry date calculation etc.

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      Please check my video on EDATE and EOMONTH functions in Excel.

  • @MrSalim382
    @MrSalim382 2 роки тому

    ഞാൻ മറ്റൊരു വീഡുയോയുടെ കമൻറ് ബോകിസിൽ ചോദിച്ചദുനുള്ള ഉത്തരം ഇതുലുണ്ട്🙏🙏

  • @9846956911
    @9846956911 2 роки тому +1

    Thanks a lot for your video. If an item is not available in the list, how can that be mentioned in excel using these formulas?

  • @nvjaleel6549
    @nvjaleel6549 2 роки тому +1

    Excellent class🥰🥰👍👍👍❤❤❤

  • @ababu9862
    @ababu9862 2 роки тому +1

    Thank you

  • @saadebrahimkutty2148
    @saadebrahimkutty2148 2 роки тому +1

    എവിടെയായിരുന്നു ഇത്രയും നാൾ? കിടു ടൂൾസ്

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      അത് ഞാൻ അങ്ങോട്ടല്ലേ ചോദിക്കേണ്ടത്😂

  • @sunuvinu007
    @sunuvinu007 2 роки тому +1

    Very very useful❤❤❤

  • @subjascp6176
    @subjascp6176 2 роки тому +2

    Very nice and helpful. How can we get result, without mentioning expiry days or validity date. Instead for choosing particular item or description in first column decide validity

  • @irshadtanur8944
    @irshadtanur8944 2 роки тому +1

    great information..

  • @renjithkumar.r1662
    @renjithkumar.r1662 2 роки тому +1

    Thank you so much sir, 🙏

    • @kumar7576plram
      @kumar7576plram 2 роки тому

      I am an exel user all of my works are related to exel so it's my pleasure to congrats you for your wonderful explanation about formula's in exel ....

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      Most welcome

  • @anoopdas2337
    @anoopdas2337 2 роки тому +1

    Very informative 👍🏻

  • @husen0075
    @husen0075 2 роки тому +1

    Super

  • @faasi341
    @faasi341 2 роки тому +1

    Very informative video and very good presentation, but only the concern is nothing displayed in status column after applying the formula, I have also checked your video about the errors in format, but unable to solve the issue.

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому +3

      Please try again with the same dates I have used in the video. It should work. After that you can experiment by changing the dates.

  • @abdulgafoor5604
    @abdulgafoor5604 2 роки тому +1

    Nice

  • @Shafeeqmelattur-
    @Shafeeqmelattur- 2 роки тому +1

    Usefull

  • @abrahampanicker8037
    @abrahampanicker8037 2 роки тому +1

    Nice one..
    Suggestion: Excel introduced few new functions nd here IFS can be used instead of nested IF..

  • @mohammedfarook5469
    @mohammedfarook5469 2 роки тому

    Room rent monthly alert 🚨 varunnna oru vedio cheyyumo

  • @Noyalvarghese
    @Noyalvarghese 2 роки тому

    Sales reports preparation excel sheets please do a video.Annual sales,monthly sales,client wise sales.sales below certain percentage .like that

    • @jositgeorge2008
      @jositgeorge2008 2 роки тому +1

      You can watch old videos.. All these are well explained in different videos 🤗... Please search...

  • @ShameerBestfood
    @ShameerBestfood 4 місяці тому

    Target totalsales percentage dailyrequirementsales- engine aan excel cheyyuka

  • @nowshadak
    @nowshadak 2 роки тому +1

    വ്യത്യസ്ത നങള്ളയ കോളങ്ങളിൽ നിന്നുള്ള ഡാറ്റകൾ ഒരു കോളത്തിലെയ്ക്ക് കൊണ്ട് വരാനുള്ള മാർഗങ്ങൾ പറഞ്ഞു തരാമോ ഏതെങ്കിലും വിഡിയോ ലിങ്കുകൾ ഷെയർ ചെയ്യുമോ

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      Please check my videos on COCATENATE, CONCAT Functions and Flash Fill in Excel.

  • @HarishGangadharan
    @HarishGangadharan Рік тому

    How to create a stock investment portfolio tracker showing sector wise allocation?

  • @ajmalkm1475
    @ajmalkm1475 2 роки тому

    Excel Murali😍

  • @mushthaqueahammed5262
    @mushthaqueahammed5262 2 роки тому

    thank you sir,
    number of working days in a month kanan ulla equation onnu tharamo?. athayath weekly oru holiday ozhivakki venam days calculation for month

  • @anascp7630
    @anascp7630 Місяць тому +1

  • @MuSiCMeDiAAaa
    @MuSiCMeDiAAaa 2 роки тому

    Hlo sir oru cellille data vechh mattaru cell kittunna value frist cellill mattam varuthiyalum secound cell value marathe lock cheyan pattumo?

  • @LondonNTheWorld
    @LondonNTheWorld 2 роки тому +1

    ശരിക്കും ഇപ്പോഴാണ് ചെയ്തു പഠിച്ചത്.. ഗൂഗിള് സ്പ്രെഡ് ഷീറ്റ് ൽ എങ്ങിനെ ഇത് ചെയ്യാം എന്നു പറയുന്ന വീഡിയോ ഉണ്ടോ? കളർ കൊടുക്കുന്ന ഭാഗം ചെയ്യാൻ കഴിയുന്നില്ല, അവിടെ വരെ ചെയ്തു...

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому +1

      I haven't tried this in GoogleSheets. But I am sure that it can be done.

    • @LondonNTheWorld
      @LondonNTheWorld 2 роки тому

      @@XLnCADMalayalam ok thanks...

  • @Thenewutuber85
    @Thenewutuber85 2 роки тому +1

    Sinte Excell class udemy allathe purchase cheyyan pattumo? Udemyl payment issue undakunnu..

    • @XLnCADMalayalam
      @XLnCADMalayalam  2 роки тому

      I suggest contacting the Customer service team of UDEMY.

  • @narayanannairp1667
    @narayanannairp1667 2 роки тому

    Nice& useful video.
    Is there any option to generate Alert on expiry date ,when we open the computer?

  • @ajeeshlal382
    @ajeeshlal382 2 роки тому +1

    👌👌👌

  • @shamsusha6618
    @shamsusha6618 8 місяців тому

    ok..day left onnum illathe verum expire date colum red colur and
    expre soon vere color engane kanikum .?
    for eg: id expire date 31:2:2023 ith id numbr and expire date enna rand colums ullu athil expire date colum alert and expire aavumbho red colur enn aakkanam athin kayiyumoo engane .?

  • @AR-wc1ie
    @AR-wc1ie Рік тому

    Accounts cheyyumbo. Rand column amount athil onninekal valutha matte column amount enkil gross profitum athinekal kooduthal aanenkil gross lossum. Ith namuk engane sett cheyyam functions upayogich.pls

  • @babu393
    @babu393 Рік тому

    എക്സ്പെയർ ആകാൻ പോകുന്ന സാധനങ്ങളുടെ എണ്ണം എങ്ങനെ കൗണ്ട് ചെയ്യാൻ പറ്റും. ഏകദേശം എക്സ്ട്രാ ആവുന്നതിന്റെ 30 ദിവസം മുമ്പ്. ടോട്ടൽ എണ്ണമാണ് കിട്ടേണ്ടത്. ഒന്ന് പറഞ്ഞു തരുമോ..