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
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
2 жыл бұрын
Pleasure is mine😊 definitely I will👍👍👍
@jithuvdinesan92
6 ай бұрын
E file kittan vella vazi undo bro? Excel sheet.🥹@@rows_columns
എനിക്ക് അറിയുന്ന അറിവ് ഒന്നും അല്ല ഇനിയും 10000 മടങ്ങു പഠിക്കാൻ ഉണ്ട് എന്ന് എന്നെ മനസ്സിലാക്കിപ്പിച്ച വീഡിയോ 👍👍👍👍
@rows_columns
Жыл бұрын
🙏❤️
@adminorange9520
5 ай бұрын
😀
Informative & cool presentation. Very good subject matter expertise combined with excellent teaching skills .
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
Amazing good effort , keep it up
ഒരുപാട് excel Tutorial കണ്ടിട്ടുണ്ട്... ഇത് വേറെ ലെവൽ💥
@rows_columns
Жыл бұрын
😊🙌
Excellent. You have covered a lot within a short period.
@rows_columns
2 жыл бұрын
😊
Explained in detail. You are blessed with excellent teaching skill. 👏
@rows_columns
2 жыл бұрын
Thanks a ton Shameer Bro😊
Thank You Bro really useful god Bless you and your family
Thank you very much❤
Very informative and excellent presenatation. നിങ്ങളുടെ എല്ലാ ക്ളാസ്സുകളും മിസ്സാവാതെ കാണാറുണ്ട്. Excel ഇത്രയും എളുപ്പമാണെന്ന് നിങ്ങളുടെ വീഡിയോ കണ്ടതിന് ശേഷമാണ് മനസ്സിലായത്. ഇനിയും പുതിയ പുതിയ ടെക്നിക്കുകളും വീഡിയോകളും പ്രതീക്ഷിക്കുന്നു. നിങ്ങളുടെ ക്ളാസ്സുകൾ മലയാളത്തിൽ മാത്രം ഒതുങ്ങിപ്പോകരുത്. ലോകം മുഴുവൻ കാണാൻ വേണ്ടി English tutorial കൂടി ചെയ്ത് കൂടെ ....
Fantastic job bro thank you very much ❤️❤️
@rows_columns
2 жыл бұрын
😊👍
Well Explained ,Thank you sir...
@rows_columns
2 жыл бұрын
👍
Great job bro ❤
My brother, thankyou very much, it's awesome,🌹
@rows_columns
2 жыл бұрын
😊
Thanks
Good explanation and very useful for startups. Keep doing.
@rows_columns
Жыл бұрын
Thanks bro😊
Thanks Sir orupadu usefull ayirunnu ready vedio
@rows_columns
7 ай бұрын
Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊
you deserve appreciation😍
@rows_columns
2 жыл бұрын
Thanks for ur recognition😊🤝
Bro your tricks are really helpful🔥🔥
@rows_columns
2 жыл бұрын
Thanks Man😍
Very helpful and well explained.... 👌👌👌
@rows_columns
2 жыл бұрын
Thanks a ton😊👍
Well done 👍 bro, appreciate you
@rows_columns
2 жыл бұрын
😊
Super 👌🏻 Thanks....
@rows_columns
2 жыл бұрын
😻
Excellent💯😍😍😍
Very useful ...thank you for this....
@rows_columns
2 жыл бұрын
Thank you bro😊
Brilliant ❤
Excellent bro
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
Sir, super, its very helpful, can u make an edit option on this software for purchase and sale?
വളരെ ഉപകാരപ്രദമായ ഒരു വീഡിയോ ആണിത്, thax. ഇതിൽ invoicing/billing കൂട്ടി യോജിപ്പിച്ചു കൂടെ, കസ്റ്റമറുടെ ഡീറ്റെയിൽസ് അടക്കം ?
Good work keep it up thanks a lot sir for sharing ur knowledge. Really appreciated.
@rows_columns
2 жыл бұрын
Pleasure is mine dear😊
@ajmalpibrahim2909
2 жыл бұрын
Please send mobile No
Good work and effort, sir ith namuk multi systemil (eg:pc 1,pc2,pc3) control cheyyan pattumo
Superb...
Great work thanks
@rows_columns
2 жыл бұрын
Most welcome😊
Thank you sir
Alfan bhai... Very Awsome..👌👌👍👍
@rows_columns
2 жыл бұрын
Thanks Prasanth Bhai😊
Wow super Mr Alfan❤️❤️❤️👌👌👌
@rows_columns
2 жыл бұрын
Thanks Bro😍
nice video brother ❤️ I have a doubt Pivotal data rang lekk data add cheyyunathinausharicch pivot able auto update aavuoo Atho refresh adikendi verumo
Excellent video..Very useful..Could you please share the template
Bro vere level aan👏🏻
@rows_columns
2 жыл бұрын
Thanks Man🥰
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.
Thank you for video. But I am facing an issue that my macro is being overwritten over the previous line.
Enikkoru stationary shop und.. Athile salum, purchasing add cheyyan hlp cheyyamo
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
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
Very good presentation 👍
@rows_columns
2 жыл бұрын
Thanks Bro
Hai bro, Oru doubt eppol oru purchase entry add cheyythu athinushesham bill number mathram enter cheyythu aa purchase details recall cheyyan pattumo
Very good explanation ❤
@rows_columns
4 ай бұрын
Glad you think so!
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
Can you give a detailed tutorial of 'school/college management system' including fee details?
Same time above one items engne purchase and sales cheyyan kayiyum pls explain
Multiple batch,multple products, multiple customer, multiple purchase party okke ulla inventory ledger excel il cheyyunnath enganeyan?
Tnk you sir
What if when purchasing Multiple Items in single invoice. How can be entered.
Ee systethil multi item sale engane cheyyam ennu paranju tharavo
Sir.. Ithile sale kodukumbo stock kurayunath shop and store eathilanne kuranu poondathe enne kodukan pattumboo
Sir macro recordinginu shesham copy chyithitt purchasil paste special adicheppo date inu pakaram 45677 ingene numbersaan verunned endha chyyended ...adhvereyulled ellm crrctaayitt poonnundaayirunnu
Couldn't do copy and paste in choose product space in dashboard...is it any chance
How to add more than one products in a particular firm
ee video yude 11minut 20 seconds muthal parayunna data validation cheyyaan nokiyitt pattunnilla .stock master worksheetil click cheyyaan pattunnilla athonnu pranju tharumo
Bro stock list oru new item add cheyynmnkil ath automatically dashboard search cheyyumbol varumo ? Plz reply
Great content. Bro , നമുക്ക് dropdown പകുതി അടിക്കുമ്പോളെക്ക് അതല്ലെങ്കിൽ dropdown ൽ search എങ്ങനെ ചെയ്യാം എന്ന് വിശദീകരിക്കാമോ?
how to select dropdown list short cut key,
Hiii When i execute the macro for print pdf I'm getting error code "Run time error 1004"
Customer wise item ledger undakkan pattumo
Billing um koode ulla software undo inbuild. Please reply
Sir, date is automaticaly changing while saving to other pages, 15:16
Readymade garments എങ്ങനെ ഇതിൽ ചെയാം size colour patern okk വേണമല്ലോ
🙏🏻 സേവ് ചെയുന്നത് one by one ayit varan entha ചെയ്യേണ്ടത്. അത് എറർ ആകുന്നു plz hlp
... Great Work .... എങ്ങനെ ആണ് പർച്ചേസ് ചെയ്യുന്ന ടാറ്റ സ്റ്റോക്ക് മാസ്റ്ററിലേക്കു ഫീഡ് ചെയുന്നത് ,
Supper 👌👌
@rows_columns
2 жыл бұрын
❤️
Good class👍👍 റൈറ്റ് ബട്ടൻ press ചെയ്യുമ്പോൾ assain macro കാണുന്നില്ല... എന്താ പരിഹാരം sir
എന്റെ ഷോപ്പിൽ നടക്കുന്ന sales, stock വേറെ എവിടെയെങ്കിലും ഇരുന്ന് കാണുവാനും മാനേജ് ചെയ്യുവാനും എന്ത് ചെയ്യണം?
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
I'm getting an error " Run time error 1004' after recording macros
Google sheetil cheyyan patooo plss am facing big issue in my own company its small company but accounting clear aaavunilla
Hi date picker cheriya complaint
Hi good morning, may i get this software link to download. Thanks
Hi sir dropdown list engine search cheyth item edukam plse sir help me
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
2 жыл бұрын
Great suggestion brother!👍😊
@rows_columns
2 жыл бұрын
Great suggestion bro😊 Will definitely taken into consideration👍
Save cheyydh close aki, veendum open akumbo macro option disable akunnu, reason??
Good class Sir Purchase oru entry കൊടുത്തു കഴിഞ്ഞിട്ട് അടുത്ത Purchase കൊടുക്കുമ്പോൾ ആദ്യം കൊടുത്ത purchase കാണുന്നില്ല plz help Sir
Bro njaan purchase enter cheyyumbol same row il thanne entry varunnu
Work cheyth excel close cheyth veendum open cheyyumbol macros onnum work akunnillallo. Macro onnum kanunnilla
Thank you brother for this tutorial. Could you please tell me how we can block blank data entry?
@rows_columns
2 жыл бұрын
Hey bro, Just select the respective range - Data validation- custom - Apply Function =Isblank()
hollo can you build a program like this for my shop??? i will pay .
Nice one👍🏾
@rows_columns
2 жыл бұрын
Thanks Bro😊
@mahi632001
2 жыл бұрын
Oru copy kittumo
👍👍👍sprr bro ethile use cheyitha formula sent cheyi 🙏
Ith mobile exelil ചെയ്യാൻ പറ്റുമോ?
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
Full download cheyyan pattumo
👍👍
Hi.. Bro... ഞാൻ നിങ്ങളുടെ ഈ വീഡിയോ കണ്ടിരുന്നു... എന്നിട്ട് ഞാൻ അതേ പോലെ ചെയ്യാൻ നോക്കി... പക്ഷെ value കിട്ടുന്നില്ല..... Companyil വർക്ക് ചെയ്യാൻ ആണ്......1500 ഐറ്റംസ് ഉണ്ട്..... So.എനിക്ക് ഇത് പോലെ ഒരു ഷീറ്റ് ഉണ്ടാക്കി share ചെയ്ത് തരാൻ കഴിയുമോ?
Download link vidamo exel purchase sheet
ഹായ് എനിക്ക് ഒരു മൊബൈലിൽ സ്റ്റോക് മാനേജ്മെന്റ് എങ്ങിനെ ചെയ്യാം എന്ന് parayamo
Template onnu descriptionil add cheyyamo
🔥🔥🔥
@rows_columns
Жыл бұрын
Thank you, I am happy to hear you feel that way!
ഇതേ സംഭവം google ഷീറ്റിൽ ചെയ്യാൻ പറ്റുമോ
Template please.. Its much impressive
ഇതില് amount കൂടി add ചെയ്തു ചെയ്യാൻ പറ്റുമോ