Stock Management in Excel (Malayalam) || വെറും 15 മിനിറ്റ് കൊണ്ട് പഠിക്കാം!
Vložit
- čas přidán 28. 04. 2020
- In this video, you will learn how to create an Stock management system in Excel (Malayalam).
It is very simple and quick to setup by using simple functions and formulas. This warehouse management software will help you to keep record of inventory like Net stock, purchases, sales, closing stock, Reorder Alert etc with dashboards for quick analysis. So Inventory control will not be difficult any more. So, Spreadsheets are the simplest way to manage your inventory.
So, to reduce the errors and increase efficiency, you can start to control your inventory with the help of an excel. It is a cheap and capable tool to manage your stocks.
Excel is recommended to small scale businesses, particularly the ones who have just started up their business journey. Though it has its limitations, it’s still better than using pen and paper and log sheets.
#StockManagementSystemInExcel #SkillsToSucceedByAlFan #ExcelMalayalam
++++++++++++++++++++++
Download file used in the video: drive.google.com/drive/folder...
This excel in Malayalam tutorial video will help you to become a Microsoft excel expert in 2022?
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, 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 malayalam 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 2022 on youtube, 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.
Other Videos You Might Like:
10 Magical Time Saving Tips & Tricks To Make You Excel Expert : • 10 Magical Tricks in M...
Learn Basic VLOOKUP Function in 5 Minutes : • Learn Basic VLOOKUP in...
How to Use SUBTOTAL Function in MS Excel : • How to Use SUBTOTAL Fu...
5 Easy Method to Find & Remove Duplicate Data in Excel : • Find & Remove Duplicat...
How to Create a Pivot Table in Excel : • Learn Pivot Table in 1...
Excel IF Function | IF, SUMIF, COUNTIF, NESTED IF : • IF, SUMIF, COUNTIF, NE...
12 Functions in 12 Minutes || Excel Text Functions : • Data Cleaning Function...
MIND-BLOWING Excel Trick | Auto Advanced Filter - • How do I use advanced ...
Difference Between VLOOKUP vs HLOOKUP - • What is VLOOKUP vs HLO...
How to Insert Blank Rows & Columns After Every Data in Excel : • How to Insert Blank Ro...
Let’s connect on social:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan
Kure naalaayi oru malayalam excel tips kittiyirunnengil ennu vichaarikkunnu. Thanks
Hope this video will help you🙂 - czcams.com/video/5qZAIsdMFjI/video.html
😊@@rows_columns
ഈ ചാനൽ സബ്സ്ക്രൈബ് ചെയ്തവർക്ക് എൻ്റെ വാക്കുകൾ ഉപകാരപെടുകയാണെങ്കിൽ വായിക്കുക, വിദ്യാർത്ഥികൾക്കും പ്രൊഫഷനുകൾക്കും പെട്ടെന്ന് മനസിലാകുന്ന തരത്തിൽ വളരെ ലളിതകരമായ രീതിയിലാണ് അൽഫാൻ ഓരോ കാര്യങ്ങളും അവതരിപ്പിചിരിക്കുന്നത്. ഓരോ ഫങ്ക്ഷൻസും ഫോർമുലകളും എങ്ങനെയാണ് ഉപയോഗിക്കേണ്ടത് അത് പോലെ അതിൻറെ റിസൾട്ട് എങ്ങനെയാണ് ലഭിക്കുന്നത് എന്നൊക്കെ വളരെ ക്ലാരിറ്റിയോടു കൂടിയാണ് പറഞ്ഞു തരുന്നത്.എന്തായാലും എക്സെലിന്റെ ഉപയോഗം ഉള്ളവർ ഈ വീഡിയോസ് ഒക്കെ ഒരു പ്രാവശ്യം കാണുന്നത് നന്നായിരിക്കും.
Good job dear, opening stock, purchase return, sales return എന്നിവ കൂടി ഉൾപ്പെടുത്തിയാൽ കൂടുതൽ നന്നായിരിക്കും.
That's good
Simply described... thanks for your mail with templates
😇
Excellent topic. Very useful
If you covert table to an excel table, the table will become dynamic and then we will not have to copy formula
👍
Hi Alfan,Is there any possibility to count the total number of qty for an year for a particular part number and also any ways to count all the parts starting with FP----- & sp-----.Balance code after fp varies , but i need to count all the parts if it starts with FP.Please reply
Hi Bro,
The video is very helpful one, can you please tell me that if i have more than 30 products and the customer buying one - one product each from the all. I have tried your same method but it is getting a long sheet and also not easy to manage also. please advise
Ithil vat , price , including cheyithu kanichu tharamo grocery stock
👍👍👍nalla avatharanam
Thank you very much for uploading such a great tutorials, can you pls explain how to change the cell colour (red) automatically when the stock alert cells turn to "OUT OF STOCK"
Thanks for watching video🙂 Regarding your query ; I have applied conditional formatting over there, same I have explained in detailed under below video (link provided)
czcams.com/video/zQqF6nHB7qs/video.html
@@rows_columns Thanks mate
Can you share your Mobile number please to discus something about my business, need your help. or whatsApp me on 8078332475
How to retrieve whole (before openig) file protection Password in Exl, if forgot P/word?
Hi, how we can add to purchase list, if I purchase a product not in the stock list??? Please help... I mean, can we automatically update the stock item data by adding items to purchase list???
Very intersting subject. If you are incorporate opening balance of qty in Inventory system, it will be more beautiful. Your all video is are informative. Thank you so much.
Sure I will👍😊
New prodact the salaction new do
Hi Alfan , in this case products are up to “G “ , how to add a new item in the formula after couple of transactions
You can add up the line items for respective new products and after that same included it under 'drop down list'.. Once its done you can drag down the formula under Colum 'K' (Stock)
@@rows_columns can we make it table for automatic updation?
Very helpful presentation 👍👍
Items list poyittallaathe namuk ha coloums il txt cheith add cheyyaaan pato??
Eg : 1000 items undenkhil list il poitt item select cheyyal budhimutt alle?
how to add a new product in this system..?
U can add manually and same included it under drop down list by editing the range😊
Very good but set cheitha era finish ayal coloms add cheyyan enth cheyyum
Thanks a lot... its very helpful
Did well. Thank you very much
Tnx Brother :)
Very useful goahead bro
Thank you somuch for your video’s broii..It’s Really helpful 🙏🏻🙏🏻
Thanks Adish bro😊
Stock alertil 3 ennam kodukkan kazhiyille if 0= out of stock, less than 10 low stock, higher than 10 in stock paranju tharamo
Super bro.. Ningalude presentaion super.. Mansilakkunnund.. Nallavannamm👍
Hi
കണ്ടതിൽ വെച്ച് വളരെ നല്ല വീഡിയോ
നല്ല അവതരണം
എളുപ്പത്തിൽ ചെയ്യാൻ താങ്കളുടെ വീഡിയോ
മൂലം സാധിച്ചു
അഭിനന്ദനങ്ങൾ
Thank you, I am happy to hear you feel that way!
Really great and good explanations so helpful for Xl fraternity good way of helping all let you grow day by day
Thank a ton😊
Very Good Presentation..thanks
Good simple videos Alfan👍👍
🙏😊
ഞാൻ accountant ആയി work ചെയ്യുന്ന വ്യക്തിയാണ് ... നിലവിൽ ഞാൻ ഒരുപാട് excel work-കൾ ചെയ്യാറുണ്ട്..താങ്കളുടെ ഓരോ വീഡിയോസും വളരെയേറെ ഉപകാരപ്രദമാവുന്നുണ്ട്....
Tnx a ton Brother :)
Work sheet complete kazhinjal veendum add cheyyan enth cheyyanam
Hope u r fine by the grace the almighty, if i want add 2 more products in the sheet how can it,
Useful video aayirunnu tnqq bhai
Most welcome brother😊
It's super Tips bro ....thank you very much ....
Welcome bro👍😊
Good presentation.. Thanks dear
😊
Excellent n great go ahead
♥️
Excellent presentation 👏👏👌👌.... Very useful
Thank you, I am happy to hear you feel that way!
Your classes helping me a lot in my work...
Glad to know that😇
Really worth with good and simple explanations
Product name & size difference ulla 2 columns engane anu set cheyendathu
The most informative video
:)
purchase report,sales report ഒക്കെ വേറെ വേറെ ഷീറ്റിൽ കാണാൻ ഉള്ള വീഡിയോ ചെയ്യുമോ?. like monthly report,year report please submit
Hai sir,
നിങ്ങളുടെ വീഡിയോ എന്നെ പോലെയുള്ള ഒരുപാട് ആളുകൾക് നല്ലപോലെ എക്സലിനെ മനസ്സിലാക്കി പഠിക്കാൻ പറ്റുന്നുണ്ട്, ഇങ്ങനെ ഒരു വീഡിയോ ചെയ്തതിനു ഒരുപാട് നന്ദി... 👌👏👍
Thank you
Thank you, I am happy to hear you feel that way!
Very helpful CZcams channel 👍
😊
Njan ee formula apply cheythu 1 year ayi perfect ayirunnu,ippo complete cellil apply akunilla, chila cell purchase ans sale count akunilla . same formula copy cheythu koduthittum chila cellilil perfect akunilla.onnu reply edamo
നല്ല അവതരണം👍💐
Tnx Brother😊
Hy bro,
Need spare parts stock inventory with price, how to add price list in this table.
Sure Bro... Will figure out :)
Very useful class 💯
Glad you think so!
how to create VBA code automatically transfer data other sheet inside excel table? please can you help
Will show it in separate video.. Thanks for your suggestion :)
Super. Very useful
😊
very useful video really appreciate your effort....
Thank you, I am happy to hear you feel that way!
Date wise data updation nghne set cheyum
Really owsome.Ithu pole payroll records maintain cheyyan engane anenu kaniko.njan cheythu nokkuvanu.
Sure👍😊 will upload it soon..
Thank you...❤️
🥰
Your classes so good and easy to understand
😇
@@rows_columns 😎
*Thank you very much*
☺️
Nice presentation 🤝👌👌👌
Thank you! Cheers!🙌
Thank you sir....
❤️🙏
Ithil oru puthiya item list cheyyanamegil formula full mattano
Superb
kidu thanks alot
Thanks for your feedback and I'm glad it helped 😊
You can download file used in the video : www.rowscolumns.com/free-excel-templates
My laptop keyboard F4 key is not working for this formula what to do ? Pls suggest a solution
Press Fn + F4😊
If opening stock is there then what is the procedure to be followed
Hi Bro
How can I implement above inventory management in Rental business, pls advise
We can bro.. but using different function along with existing formulas which i shows here... will plan & upload it👍😊
Skills to Succeed by AlFan many thanks Bro, await for same
Very useful videos. 😍😍😍
Thanks a lot 😊
താങ്കളുടെ വീഡിയോ വളരെ നല്ല നിലവാരം പുലർത്തുന്നു വളരെ പെട്ടെന്ന് മനസ്സിലാകുന്നുണ്ട് നന്ദി ഒരു സംശയം ഉണ്ടായിരുന്നു ഗൂഗിൾ ഡ്രൈവിൽ വർക്ക് ചെയ്യുന്നത് ഗൂഗിൾ ഷീറ്റിൽ ചെയ്യാൻ പറ്റുമോ.
how can we change out and in stock font colour
ബ്രോ medicine ഇപ്പോൾ ഉള്ള സ്റ്റോക്ക് il നിന്നും indent വരുമ്പോൾ balance stock കൂടുന്നു, expiry or sell വരുമ്പോൾ കുറയുന്നു അങ്ങനെ ഒരു balance amount കിട്ടും...
പക്ഷെ enikku opd sheetil balance കാണിക്കണം. Opd used akunnathu main stockil kurayanam... Next വീണ്ടും same medicines opd used akumbol opening stock nerathe kuranjathil ninnum varanam.
you are amazing
😊
This excel video helpful for Trading firm only, please upload a video for manufacturing firm
Sure Bejoy😊 Thanks for your suggestion
Thanks Sir
Alfan Rishaf here,vidoes are good keep going.
Do one more video wfor the same (sms) with opening stock plus qty &price and if there is huge product list like 2000 items how we tackle with drop down list etc.
Sure... I will be uploading the separate video for the firm who keep large no of stocks by giving option like searchable drop drown list or Searchable box via VBA. Anyways tnx for your feedback😊
Thanks ebdurahma
Restaurant inventory engane maintain cheyyam
Super Bro Very Good
Thank you so much
Second product purchase cheyyumbol net stockil varunnillallo..any mistake
Ithil abcd order il purchase cheithal matrame net stoçk report lek varunnullu ath enda
Didn't get your question bro!
superb bro
Tnx Man😊
E format aneshichu nadakuvayirunu appozhanu sirnte topic kandathu Thank you
Tnx Bro😊
Hii..
Just now got a call from Alfan by sharing my number in the comment box.
What a quick response. Really hats off you dear.
Really looking forward to solve all the accounts related issues with help of this gentleman.
Thank you.
😊🤝
കുറെ item ullappo formula copy ചെയ്യാൻ ഓപ്ഷൻ ഉണ്ടോ
Product nte different category engane list cheyyum
Thanks sir .. thanks for send file❤️❤️❤️
🤝😊
Brother can share the file
eniykkum koodi share cheyyamo
Good dear
Thanks dear😊
How can add colour in condition. Eg red for out of stock
Through conditional formatting - will show it in separate vid..
opening stock indel sum if function vach closing stock find cheyyan pato?
Yes👍
Sir
ഈ ഷീറ്റ് എങ്ങെനെ create ചെയാം എന്ന് കൂടി പറയാമോ.please this same function
Sir.... F4 അടിക്കുമ്പോൾ close ആകുന്നില്ലല്ലോ
Very usefull ❤️
Thank you😊
😊
How can we do, if we purchase and sale more than 1 product in one day
First of all thanks for watching video😊
Yes, we can pass the entry by putting same transactions (Sales & Purchase) date in different cells (Row wise) by selecting respective products.. It works👍
Thank you sir it was very useful...I will try to do it in excel..
😊👍
thanks
Thanks for your feedback and I'm glad it helped 😊
You can download file used in the video : www.rowscolumns.com/free-excel-templates
ഇതിൽ sales and purchase ൽ price add ചെയ്തു കാണിക്കുമോ. For example, product A 20pcs *100RS =2000
Am planning to upload (near future) similar system by including sales, Purchase, Invoice, LPO, day book.. (kind of small accounting solution). Thanks for the suggestion😊
can do a video about how to create a form & highlights
Sure Bro👍😊
Good
Daily stock maintain ചെയ്യുന്നതിനുള്ള idea ഉണ്ടോ
നമ്മളുടെ ഒരു പ്രൊഡക്ട് തീർന്നു പോയി എന്ന് കരുതുക സെയിലിൽ നമ്മൾ തൊട്ടടുത്ത പ്രൊഡക്ടിന് പകരം അബദ്ധത്തിൽ തീർന്നു പോയ പ്രൊഡക്ട് ക്ലിക്കായി പോയാൽ സ്റ്റോക്കിൽ മൈനസിൽ കാണിക്കുന്നു ഇതിൽ നിന്നും എങ്ങനെ രക്ഷപ്പെടാം എന്ന് പറയാമോ
I have downloaded your template, A,B,C matti namude product name kodukkan enth cheynm?
Remove data validation and create your own list. Pls check the below video
czcams.com/video/CSGVA-wfDCs/video.html
Can i get this excel dashboard
God job bro
Tnx Bro😊
Stock കൂടുതൽ കിടക്കുന്നു. Presently അത്രയും ഇല്ല. അപ്പോൾ എന്തു ചെയ്യും .
Stock valu koodi ulpeduthi oru columns undengil useful aayirunnu
Pls refer this😊:
czcams.com/video/zQqF6nHB7qs/video.html