Template for Stock [ Inventory ] Management in Excel || Excel Malayalam Tutorial

Stock [ Inventory ] Management in Excel - Stock Maintain in Excel ( Malayalam ) - Stock Register In this video you will learn how to manage stock in excel with inventory management - If you need to maintain stock in excel then this Fully Automatic Stock register will help you to manage sale, purchase, sales return, purchase return and inventory of stock. You can use this as Stock register template in excel to maintain your automatic stock report.
#StockRegister #StockManagement #InventoryManagement
++++++++++++++++++++++
Download file used in the video: drive.google.com/drive/folder...
Learn VLOOKUP - • Learn Basic VLOOKUP in...
Learn Pivot Table - • Learn Pivot Table in 1...
Learn How to Build Interactive Dashboard (MIS) - • Build Interactive Dash...
Learn SUMIF Function - • How to Use SUMIFS and ...
Learn How to Create Dropdown List - • Create Data Validation...
Learn VBA Macro - • Learn VBA Macro in 5 M...
++++++++++++++++++++++
Let’s connect on social media:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan
++++++++++++++++++++++
If you want to find out more about how to learn excel in Malayalam or excel Malayalam tutorial, you must click: www.rowscolumns.com
Download file used in the video: www.rowscolumns.com/free-exce... To learn Excel in English Click on : • FREE Excel Course (Bas...
View my comprehensive courses: laurelss.com/instructor/952 To learn Excel in English Click on: • FREE Excel Course (Bas...
++++++++++++++++++++++
This KZread channel is managed by Mohammed Alfan Excel is one of the most widely used and powerful programs in the world. It is used in every sector and industry, from small businesses with only a few employees, to large multinational companies. In this video, Mohammed AlFan, who is a skilled Excel user, shows you how to create a simple, but effective spreadsheet. He goes through many useful tips and tricks that will help you build a successful spreadsheet. learn excel in English by watching this video, as it will teach you how to use the excel program in a short amount of time. People who searched for learn excel in Malayalam likewise searched for excel Malayalam tutorial in on KZread, as most professionals are not getting the simple excel tips and tricks through other Channels. Please subscribe to this channel to get the latest updates on excel and start learning Microsoft excel Malayalam tutorial through this skills to succeed by alfan channel.

Пікірлер: 217

  • @SafnaMkhan
    @SafnaMkhan2 жыл бұрын

    Adipoli ayitund..Thank you so much for sharing this... Keep up your good work👌🏽.. Great effort... Iniyum othiri ithupole ulla informational(excel based) videos expect cheyyunnu😊..

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Pleasure is mine😊 definitely I will👍👍👍

  • @jithuvdinesan92

    @jithuvdinesan92

    6 ай бұрын

    E file kittan vella vazi undo bro? Excel sheet.🥹​@@rows_columns

  • @SIFUIRSHAD
    @SIFUIRSHAD Жыл бұрын

    എനിക്ക് അറിയുന്ന അറിവ് ഒന്നും അല്ല ഇനിയും 10000 മടങ്ങു പഠിക്കാൻ ഉണ്ട്‌ എന്ന് എന്നെ മനസ്സിലാക്കിപ്പിച്ച വീഡിയോ 👍👍👍👍

  • @rows_columns

    @rows_columns

    Жыл бұрын

    🙏❤️

  • @adminorange9520

    @adminorange9520

    5 ай бұрын

    😀

  • @aymanmoideenkoya4138
    @aymanmoideenkoya4138 Жыл бұрын

    Informative & cool presentation. Very good subject matter expertise combined with excellent teaching skills .

  • @vishnupp5944
    @vishnupp59442 жыл бұрын

    Hey Bro, Your video are good and useful. Saw one of your interviews. And we both have been exactly travelling in the same root. Happy to see your videos and growth

  • @safarhassan6873
    @safarhassan68732 жыл бұрын

    Amazing good effort , keep it up

  • @8606850690
    @8606850690 Жыл бұрын

    ഒരുപാട് excel Tutorial കണ്ടിട്ടുണ്ട്... ഇത് വേറെ ലെവൽ💥

  • @rows_columns

    @rows_columns

    Жыл бұрын

    😊🙌

  • @shridharan
    @shridharan2 жыл бұрын

    Excellent. You have covered a lot within a short period.

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊

  • @mrshabeermp
    @mrshabeermp2 жыл бұрын

    Explained in detail. You are blessed with excellent teaching skill. 👏

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks a ton Shameer Bro😊

  • @svlog1624
    @svlog16242 жыл бұрын

    Thank You Bro really useful god Bless you and your family

  • @brejeshbroono8585
    @brejeshbroono8585 Жыл бұрын

    Thank you very much❤

  • @Nothingdxb
    @Nothingdxb2 жыл бұрын

    Very informative and excellent presenatation. നിങ്ങളുടെ എല്ലാ ക്‌ളാസ്സുകളും മിസ്സാവാതെ കാണാറുണ്ട്. Excel ഇത്രയും എളുപ്പമാണെന്ന് നിങ്ങളുടെ വീഡിയോ കണ്ടതിന് ശേഷമാണ് മനസ്സിലായത്. ഇനിയും പുതിയ പുതിയ ടെക്നിക്കുകളും വീഡിയോകളും പ്രതീക്ഷിക്കുന്നു. നിങ്ങളുടെ ക്‌ളാസ്സുകൾ മലയാളത്തിൽ മാത്രം ഒതുങ്ങിപ്പോകരുത്. ലോകം മുഴുവൻ കാണാൻ വേണ്ടി English tutorial കൂടി ചെയ്ത് കൂടെ ....

  • @muhsinkannookkara
    @muhsinkannookkara2 жыл бұрын

    Fantastic job bro thank you very much ❤️❤️

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊👍

  • @rameekannur9032
    @rameekannur90322 жыл бұрын

    Well Explained ,Thank you sir...

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    👍

  • @aestheticmedia4304
    @aestheticmedia4304 Жыл бұрын

    Great job bro ❤

  • @youtubeismyguide1281
    @youtubeismyguide12812 жыл бұрын

    My brother, thankyou very much, it's awesome,🌹

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊

  • @AdhidevusWorld
    @AdhidevusWorld2 жыл бұрын

    Thanks

  • @adhimithran3368
    @adhimithran3368 Жыл бұрын

    Good explanation and very useful for startups. Keep doing.

  • @rows_columns

    @rows_columns

    Жыл бұрын

    Thanks bro😊

  • @aswathyshara6637
    @aswathyshara663710 ай бұрын

    Thanks Sir orupadu usefull ayirunnu ready vedio

  • @rows_columns

    @rows_columns

    7 ай бұрын

    Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊

  • @rafeeque1992
    @rafeeque19922 жыл бұрын

    you deserve appreciation😍

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks for ur recognition😊🤝

  • @mbaguy3549
    @mbaguy35492 жыл бұрын

    Bro your tricks are really helpful🔥🔥

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Man😍

  • @SarathKumar-sb4tr
    @SarathKumar-sb4tr2 жыл бұрын

    Very helpful and well explained.... 👌👌👌

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks a ton😊👍

  • @mohammadbasheer9185
    @mohammadbasheer91852 жыл бұрын

    Well done 👍 bro, appreciate you

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😊

  • @ahmedanoop
    @ahmedanoop2 жыл бұрын

    Super 👌🏻 Thanks....

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    😻

  • @ashkar_yusuf
    @ashkar_yusuf Жыл бұрын

    Excellent💯😍😍😍

  • @kerlamplym579
    @kerlamplym5792 жыл бұрын

    Very useful ...thank you for this....

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thank you bro😊

  • @noorunooru2598
    @noorunooru259825 күн бұрын

    Brilliant ❤

  • @zrtech9469
    @zrtech9469 Жыл бұрын

    Excellent bro

  • @steephants
    @steephants Жыл бұрын

    If there are more items, is it possible to create without a drop down list? For example if there are 500 item, to find it from the drop down list is very difficult. So is there any other option to enter it manually with automatic updation? Thanks

  • @tphariprabha
    @tphariprabha Жыл бұрын

    Sir, super, its very helpful, can u make an edit option on this software for purchase and sale?

  • @mohamedaslamkm
    @mohamedaslamkm Жыл бұрын

    വളരെ ഉപകാരപ്രദമായ ഒരു വീഡിയോ ആണിത്, thax. ഇതിൽ invoicing/billing കൂട്ടി യോജിപ്പിച്ചു കൂടെ, കസ്റ്റമറുടെ ഡീറ്റെയിൽസ് അടക്കം ?

  • @nigilv.d4237
    @nigilv.d42372 жыл бұрын

    Good work keep it up thanks a lot sir for sharing ur knowledge. Really appreciated.

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Pleasure is mine dear😊

  • @ajmalpibrahim2909

    @ajmalpibrahim2909

    2 жыл бұрын

    Please send mobile No

  • @aachu4u1
    @aachu4u1 Жыл бұрын

    Good work and effort, sir ith namuk multi systemil (eg:pc 1,pc2,pc3) control cheyyan pattumo

  • @anzm1983
    @anzm19832 жыл бұрын

    Superb...

  • @basheertm117
    @basheertm1172 жыл бұрын

    Great work thanks

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Most welcome😊

  • @aravindtr3436
    @aravindtr3436 Жыл бұрын

    Thank you sir

  • @prasanthcalicut
    @prasanthcalicut2 жыл бұрын

    Alfan bhai... Very Awsome..👌👌👍👍

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Prasanth Bhai😊

  • @askary007
    @askary0072 жыл бұрын

    Wow super Mr Alfan❤️❤️❤️👌👌👌

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Bro😍

  • @goodthings2433
    @goodthings2433 Жыл бұрын

    nice video brother ❤️ I have a doubt Pivotal data rang lekk data add cheyyunathinausharicch pivot able auto update aavuoo Atho refresh adikendi verumo

  • @nikhilpadikal
    @nikhilpadikal2 жыл бұрын

    Excellent video..Very useful..Could you please share the template

  • @musthafamusthafa5284
    @musthafamusthafa52842 жыл бұрын

    Bro vere level aan👏🏻

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Man🥰

  • @adarshsuraj2930
    @adarshsuraj29302 жыл бұрын

    Very Good explanation brother. Great work 👍. Can you help me with barcode scanning. I have clothing business. So when I sell a product for example t shirt, I will scan it via mobile bar code scanner and then it will be updated in my excel inventory sheet (Google sheets). I have tried searching online and found out a add-on plugin in excel called Scan it to office. But the problem is it's paid software. Is there any other way to do it. With add-on or with add-on for free.

  • @mehfilm256
    @mehfilm256 Жыл бұрын

    Thank you for video. But I am facing an issue that my macro is being overwritten over the previous line.

  • @vishnuprasad8642
    @vishnuprasad86422 жыл бұрын

    Enikkoru stationary shop und.. Athile salum, purchasing add cheyyan hlp cheyyamo

  • @mohdahnas692
    @mohdahnas69210 ай бұрын

    Ithil purchase automation cheythathinu shesham ,purchase cheytha data purchase sheetilekku transfer aavunnundu, But avide new data varan row aadyam thanne insert cheythu vekkenda aavashyam undoo. Automatically next rowsil varan valla vazhiyum undo

  • @saifudheensp145
    @saifudheensp1452 жыл бұрын

    Thank you for good information Jhan joli cheyyunna company stock receive and issue matrame ullu enik picture attached stock file anu vendathu world il cheythu kondirikkunnund Excel il manage cheyyan pattumo can you help

  • @mukeshulapoor
    @mukeshulapoor2 жыл бұрын

    Very good presentation 👍

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Bro

  • @linslinson
    @linslinson2 жыл бұрын

    Hai bro, Oru doubt eppol oru purchase entry add cheyythu athinushesham bill number mathram enter cheyythu aa purchase details recall cheyyan pattumo

  • @unnikrishnan.
    @unnikrishnan.4 ай бұрын

    Very good explanation ❤

  • @rows_columns

    @rows_columns

    4 ай бұрын

    Glad you think so!

  • @sreejithpt8742
    @sreejithpt87422 жыл бұрын

    Bro I did as per your direction and it was amazing but whrn i try to work on it later an error occured Cannot rum macro file name. xlsm!Macro1.the macro may not be available in this workbook or all macros may be disabled Please help me with this

  • @usmanthottathodi4022
    @usmanthottathodi402210 ай бұрын

    Can you give a detailed tutorial of 'school/college management system' including fee details?

  • @ABDULSALAM-jc1eb
    @ABDULSALAM-jc1eb Жыл бұрын

    Same time above one items engne purchase and sales cheyyan kayiyum pls explain

  • @ganeshrpai2
    @ganeshrpai2 Жыл бұрын

    Multiple batch,multple products, multiple customer, multiple purchase party okke ulla inventory ledger excel il cheyyunnath enganeyan?

  • @shafeereranhikkal7040
    @shafeereranhikkal70402 жыл бұрын

    Tnk you sir

  • @8606850690
    @8606850690 Жыл бұрын

    What if when purchasing Multiple Items in single invoice. How can be entered.

  • @entertainmentvlogs965
    @entertainmentvlogs965 Жыл бұрын

    Ee systethil multi item sale engane cheyyam ennu paranju tharavo

  • @rizvanichu7867
    @rizvanichu78672 жыл бұрын

    Sir.. Ithile sale kodukumbo stock kurayunath shop and store eathilanne kuranu poondathe enne kodukan pattumboo

  • @muhammednaseef4555
    @muhammednaseef45558 ай бұрын

    Sir macro recordinginu shesham copy chyithitt purchasil paste special adicheppo date inu pakaram 45677 ingene numbersaan verunned endha chyyended ...adhvereyulled ellm crrctaayitt poonnundaayirunnu

  • @litheshp7819
    @litheshp78196 ай бұрын

    Couldn't do copy and paste in choose product space in dashboard...is it any chance

  • @rejimathew6341
    @rejimathew63412 жыл бұрын

    How to add more than one products in a particular firm

  • @amasm6666
    @amasm6666 Жыл бұрын

    ee video yude 11minut 20 seconds muthal parayunna data validation cheyyaan nokiyitt pattunnilla .stock master worksheetil click cheyyaan pattunnilla athonnu pranju tharumo

  • @thasleemthachu4594
    @thasleemthachu45948 ай бұрын

    Bro stock list oru new item add cheyynmnkil ath automatically dashboard search cheyyumbol varumo ? Plz reply

  • @mohamedajmal8805
    @mohamedajmal8805 Жыл бұрын

    Great content. Bro , നമുക്ക് dropdown പകുതി അടിക്കുമ്പോളെക്ക് അതല്ലെങ്കിൽ dropdown ൽ search എങ്ങനെ ചെയ്യാം എന്ന് വിശദീകരിക്കാമോ?

  • @sijothekkanath4697
    @sijothekkanath4697 Жыл бұрын

    how to select dropdown list short cut key,

  • @sanilkumar6996
    @sanilkumar6996 Жыл бұрын

    Hiii When i execute the macro for print pdf I'm getting error code "Run time error 1004"

  • @rinto4
    @rinto4 Жыл бұрын

    Customer wise item ledger undakkan pattumo

  • @PraseethasS
    @PraseethasS3 ай бұрын

    Billing um koode ulla software undo inbuild. Please reply

  • @prashobpallot5458
    @prashobpallot545810 ай бұрын

    Sir, date is automaticaly changing while saving to other pages, 15:16

  • @faisalrahmamavathi7226
    @faisalrahmamavathi72265 ай бұрын

    Readymade garments എങ്ങനെ ഇതിൽ ചെയാം size colour patern okk വേണമല്ലോ

  • @easwaramangalam1615
    @easwaramangalam16152 жыл бұрын

    🙏🏻 സേവ് ചെയുന്നത് one by one ayit varan entha ചെയ്യേണ്ടത്. അത് എറർ ആകുന്നു plz hlp

  • @sajukichu
    @sajukichu2 күн бұрын

    ... Great Work .... എങ്ങനെ ആണ് പർച്ചേസ് ചെയ്യുന്ന ടാറ്റ സ്റ്റോക്ക് മാസ്റ്ററിലേക്കു ഫീഡ് ചെയുന്നത് ,

  • @92274465
    @922744652 жыл бұрын

    Supper 👌👌

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    ❤️

  • @haneefavp1092
    @haneefavp1092 Жыл бұрын

    Good class👍👍 റൈറ്റ് ബട്ടൻ press ചെയ്യുമ്പോൾ assain macro കാണുന്നില്ല... എന്താ പരിഹാരം sir

  • @richu_rich
    @richu_rich10 ай бұрын

    എന്റെ ഷോപ്പിൽ നടക്കുന്ന sales, stock വേറെ എവിടെയെങ്കിലും ഇരുന്ന് കാണുവാനും മാനേജ് ചെയ്യുവാനും എന്ത് ചെയ്യണം?

  • @donbosco5997
    @donbosco59973 ай бұрын

    Hai boss... Njan try cheythu but (cannot run the macro in the workbook. the macro may not be available in this workbook or all macros may be disabled) engane kanikkunnu any solution for this

  • @avinashrt4158
    @avinashrt41582 жыл бұрын

    I'm getting an error " Run time error 1004' after recording macros

  • @aachitk6591
    @aachitk659110 ай бұрын

    Google sheetil cheyyan patooo plss am facing big issue in my own company its small company but accounting clear aaavunilla

  • @kaleshkumar2448
    @kaleshkumar24488 ай бұрын

    Hi date picker cheriya complaint

  • @jayaramsudhakaran9107
    @jayaramsudhakaran9107 Жыл бұрын

    Hi good morning, may i get this software link to download. Thanks

  • @GokulNath-yd5yx
    @GokulNath-yd5yx3 ай бұрын

    Hi sir dropdown list engine search cheyth item edukam plse sir help me

  • @sanalvj6944
    @sanalvj69442 жыл бұрын

    Very informative and good piece of work! A humble suggestion, Can we do something to stop bank entry, what I mean is ‘if the entry cells are blank and we clicking on the macro assigned buttons blank cells being saved’

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Great suggestion brother!👍😊

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Great suggestion bro😊 Will definitely taken into consideration👍

  • @masoodsh4488
    @masoodsh4488Күн бұрын

    Save cheyydh close aki, veendum open akumbo macro option disable akunnu, reason??

  • @geethusajumon7924
    @geethusajumon79247 ай бұрын

    Good class Sir Purchase oru entry കൊടുത്തു കഴിഞ്ഞിട്ട് അടുത്ത Purchase കൊടുക്കുമ്പോൾ ആദ്യം കൊടുത്ത purchase കാണുന്നില്ല plz help Sir

  • @user-ii6ex1vu4q
    @user-ii6ex1vu4q Жыл бұрын

    Bro njaan purchase enter cheyyumbol same row il thanne entry varunnu

  • @nikeshcheruthazham3665
    @nikeshcheruthazham3665Ай бұрын

    Work cheyth excel close cheyth veendum open cheyyumbol macros onnum work akunnillallo. Macro onnum kanunnilla

  • @vinods2655
    @vinods26552 жыл бұрын

    Thank you brother for this tutorial. Could you please tell me how we can block blank data entry?

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Hey bro, Just select the respective range - Data validation- custom - Apply Function =Isblank()

  • @user-xc7cg8zr4c
    @user-xc7cg8zr4c8 ай бұрын

    hollo can you build a program like this for my shop??? i will pay .

  • @surajith28
    @surajith282 жыл бұрын

    Nice one👍🏾

  • @rows_columns

    @rows_columns

    2 жыл бұрын

    Thanks Bro😊

  • @mahi632001

    @mahi632001

    2 жыл бұрын

    Oru copy kittumo

  • @anuanualappy452
    @anuanualappy452 Жыл бұрын

    👍👍👍sprr bro ethile use cheyitha formula sent cheyi 🙏

  • @user-ej3rm8mo5l
    @user-ej3rm8mo5l Жыл бұрын

    Ith mobile exelil ചെയ്യാൻ പറ്റുമോ?

  • @unnikrishnan.
    @unnikrishnan.4 ай бұрын

    Whiile doing in the same way as you did, debug shows. I am copying my result in vba. Please give me direction for correction. Error is : Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _ :=True

  • @Afsalottakomban
    @Afsalottakomban2 ай бұрын

    Full download cheyyan pattumo

  • @affansworld3561
    @affansworld3561 Жыл бұрын

    👍👍

  • @ajeshkumar6185
    @ajeshkumar61852 жыл бұрын

    Hi.. Bro... ഞാൻ നിങ്ങളുടെ ഈ വീഡിയോ കണ്ടിരുന്നു... എന്നിട്ട് ഞാൻ അതേ പോലെ ചെയ്യാൻ നോക്കി... പക്ഷെ value കിട്ടുന്നില്ല..... Companyil വർക്ക്‌ ചെയ്യാൻ ആണ്......1500 ഐറ്റംസ് ഉണ്ട്..... So.എനിക്ക് ഇത് പോലെ ഒരു ഷീറ്റ് ഉണ്ടാക്കി share ചെയ്ത് തരാൻ കഴിയുമോ?

  • @himagroupexport9563
    @himagroupexport9563 Жыл бұрын

    Download link vidamo exel purchase sheet

  • @sparkinverter48
    @sparkinverter48 Жыл бұрын

    ഹായ് എനിക്ക് ഒരു മൊബൈലിൽ സ്റ്റോക് മാനേജ്മെന്റ് എങ്ങിനെ ചെയ്യാം എന്ന് parayamo

  • @shebzzvideo6334
    @shebzzvideo6334 Жыл бұрын

    Template onnu descriptionil add cheyyamo

  • @shibinbabu9809
    @shibinbabu9809 Жыл бұрын

    🔥🔥🔥

  • @rows_columns

    @rows_columns

    Жыл бұрын

    Thank you, I am happy to hear you feel that way!

  • @hmk60
    @hmk604 ай бұрын

    ഇതേ സംഭവം google ഷീറ്റിൽ ചെയ്യാൻ പറ്റുമോ

  • @shebzzvideo6334
    @shebzzvideo6334 Жыл бұрын

    Template please.. Its much impressive

  • @irshadmanikkoth2769
    @irshadmanikkoth27698 күн бұрын

    ഇതില് amount കൂടി add ചെയ്തു ചെയ്യാൻ പറ്റുമോ