Excel Template for Stock Management - Malayalam Tutorial

ഒരു സ്ഥാപനത്തിലെ സ്റ്റോക്ക് മാനേജ് ചെയ്യാൻ സഹായകമാകുന്ന ഒരു എക്സൽ ടെംപ്ലേറ്റ് എങ്ങിനെ നിർമിക്കാമെന്നാണ് ഈ വിഡിയോയിൽ വിശദീകരിക്കുന്നത്.
How to create a dynamic Excel Template for Stock management and Inventory management is explained in this video.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel‪@AjayAnandXLnCAD‬for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-mi...
Follow this link to download the Excel template explained in this video.
xlncad-my.sharepoint.com/:x:/...
#ExcelMalayalam #stockmanagement #MalayalamTutorial

[@sujathalita1508]

I made it stock management report today after your video saw it, its very helpful to me to control our raw materials, Thanks 😊

[@TheNiyas4000]

ഒരുപാട് ഐറ്റം ഉണ്ടാവുമ്പോൾ എങ്ങനെ പർചേസിൽ നിന്ന് സെലക്റ്റ് ചെയ്യും

[@ramachandrankoovakkatt8152]

VERY SIMPLE AND VERY UNDERSTANDABLE
GREAT WORK

[@XLnCADMalayalam]

Thank you

[@Faazthetruthseeker]

Simply explained..very good job..

[@JithinRTrivandrum]

That's new info , broadly explained the use of tables

[@XLnCADMalayalam]

Glad to hear that.

[@cryptoking1446]

Ithilum mikacha reedhiyil class edkahn parayaruth....athrak clear aayitt information share cheythu.

[@XLnCADMalayalam]

Thank you :)

[@ismailpc]

Very good video.. Nice n simple explanation. 👍🏻👍🏻🌹 Informative... Keep doing

[@XLnCADMalayalam]

Thank you :)

[@joysgz]

Very nice and simple presentation, all the best

[@kiranpaulalex6464]

Thank you so much brother, much helpfull..!

[@akhiltnath3826]

It is really good informative video.. Thank you very much sir... I am planning to start an optical shop. This stock management using excel is useful for me. Can you please tell me how to use excel to manage total sales vales and profits?

[@shabilahamed9663]

This video was very helpful, Thank you very much.

[@XLnCADMalayalam]

My pleasure 😀

[@abduljaleel576]

This was very helpful for me ,thanks God bless

[@XLnCADMalayalam]

Glad it was helpful!

[@hafizabdusamadahsani7918]

Super നല്ല അവതരണം 👍 good voice

[@XLnCADMalayalam]

Thank you :)

[@younuspk2815]

Essential content.. 🤝🤝👏👏

[@vijayendrarao9006]

Good Proper clear explanation Thanks

[@XLnCADMalayalam]

Glad you liked it

[@wazzz6410]

Very useful video, simply explian.. Thank you somuch..

[@XLnCADMalayalam]

Glad it was helpful!

[@media7317]

വളരെ വളരെ ഉപകാരപ്രദം.
വളരെ നന്ദി സർ

[@XLnCADMalayalam]

You are welcome :)

[@SHANKIDARAN]

Very usefull.. Thank you 👍

[@bijithlalmalayil8886]

How can we apply FIFO method of inventory valuation in excel?

[@mylife-uncut105]

Thank u sir. Very informative

[@XLnCADMalayalam]

Most welcome

[@Storiesbyfasseeh]

100% useful sir. Thankyou👍🏻👍🏻

[@XLnCADMalayalam]

Welcome 👍

[@niyaasveecy]

Very good info
I was planning to do same sheet which help
Me lot
Thank you habeebi

[@XLnCADMalayalam]

My pleasure 😀

[@prajithkarumathil]

Thank you very much

[@sreejithmohankannanz]

wow...so useful, thank you sir :)

[@XLnCADMalayalam]

Glad to hear that :)

[@MrSmijoj]

Very Good Presentation and easy to understand.👌👍

[@XLnCADMalayalam]

😀

[@Learneasyforclass5]

Thank u, it is very useful video

[@mohandassmr1725]

Thanks sir , such a important information and great presentation. Go ahead sir . Hope you are doing well . 😊

[@XLnCADMalayalam]

Glad to hear that and Thank you :)
Yes, I am doing good. Hope you too✌️

[@vishnumk107]

Thank You Sir

[@sameehasalim1888]

Thank you..so much helpful..

[@XLnCADMalayalam]

Glad it was helpful!

[@prabhap.n6452]

Than you sir, Very useful information

[@XLnCADMalayalam]

You are welcome 😀

[@DoTechRescue]

Thankyou, for the video.

[@fasi6908]

Searchable Drop down list is possible in this table? Because if item list more than 500 or above it is difficult to select....?

[@mvmstudious9124]

അടിപൊളി 👍

[@sp7170]

Very good presentation. സംഖ്യകള്‍ align to its order ചെയ്യുന്നത് അല്ലെ കാണാന്‍ നല്ലത്? I don't mean to align to the right edge of the cell.

[@muneerr.m9746]

Thanks for valuable information....

[@XLnCADMalayalam]

So nice of you

[@poulo121]

Excellent.

[@e07_adinsdipu37]

Thank you sir it is a excellent information

[@XLnCADMalayalam]

My pleasure :)

[@Salamolakode]

Well done 👍

[@soniyastalin7334]

Very very helpful thnk u so much sir...

[@XLnCADMalayalam]

Most welcome😀

[@samrasayed8566]

Such a great info and also good presentation👍

[@prajeeshsk9528]

Can you share the link for download

[@nikhilaloor203]

Thanks❤

[@nishakv3670]

Thank you so much sir

[@mohammedumair8785]

Very nice presentation.... 👍👍👍

[@XLnCADMalayalam]

Thank you! Cheers!

[@jafarabdu3398]

Very very useful video, thanks sir

[@XLnCADMalayalam]

Glad to hear that 😀

[@jaleeljose1916]

Hello. How to excel by adding Actual Stock, Purchase Material, Used Material, Project‌ Material and Material List to manage the stock. Can you tell me something ..

[@martinmathewmm4681]

Good & very useful session

[@XLnCADMalayalam]

Thank you 😀

[@Shafidubai23]

Nice

[@akhiltnath3826]

Very informative

[@sureshsuresh-yi3fg]

Excellent

[@nishakv3670]

Thank you so much🙏

[@XLnCADMalayalam]

You're welcome 😊

[@AdhidevusWorld]

Usefull video

[@Saleeshdevayani]

THANK YOU VERY MUCH ....

[@samkp6941]

Very informative thanks ... subscribed your channal

[@sreekumariresreekumar8796]

how we can remove excel table property of an excel table, that means change to normal range table, pl explain

[@XLnCADMalayalam]

Either you can Right-click on the table > Table > Convert to Range
otherwise select the Table > go to Table Design tab > click on Convert to Range

[@jenumc]

Super informative video

[@escapetomiles]

Sir , Is there any way to create a Parent Product .....for eg. Mobile Phone is Parent Product and Battery, Charger, Phone Case, Memory Card (Those which comes along with the Mobile Phone) is sub Products.....as In if we sell one mobile phone.....other sub product must automatically reduce by one or two or three

[@XLnCADMalayalam]

It can be done, but you have go through the concept of Data Validation (Drop down lists).
I recommend to watch my videos (both Malayalam and English) on How to create Drop lists, How to create Dependent Drop lists, How to Create a Drop Down List that will hide used Items and How to create a Dynamic Dependent Drop Down List in Excel.
czcams.com/video/RUG0SET9i-Y/video.html
czcams.com/video/MdHRZEUVW4I/video.html

[@mohammadbasheer9185]

can I possible to this sale and purchase in different sheet with same formula?

[@diganful]

Thank you so much!

[@XLnCADMalayalam]

Glad it helped!😀

[@sreeprasad6555]

Sir ..is this suitable for food manufacturing store keepings??please reply me sir

[@habeebmoger362]

ഇതിൽ ഉദാഹരണത്തിന് ലാപ്ടോപിന്റെ ഡീറ്റെയിൽസ് മാത്രം എടുക്കുന്നത് എങ്ങനെ

[@XLnCADMalayalam]

Check my video on the FILTER tool in Excel

[@aslamvm4267]

Super worke

[@suneerambalaparamban6877]

Thank you...

[@XLnCADMalayalam]

My pleasure 😀

[@narayanankutty9493]

Thanks brother

[@vineethmc9007]

Very helpfull..✌️✌️

[@XLnCADMalayalam]

Glad it helped

[@abdullahvayalar]

excellent.....thanks

[@XLnCADMalayalam]

Glad you liked it!

[@abdulrazakmoosa2063]

very informative presentation. Please clear my doubt, Can you show how to enter data for serial No.I tried but wrong answer

[@XLnCADMalayalam]

You can download the file from the link given in the description of the video.

[@dhanesha5815]

Very good your voice is so beautiful

[@XLnCADMalayalam]

Thank you.

[@indianlovely4779]

Thanks a lot

[@XLnCADMalayalam]

Most welcome

[@manojsivan9405]

EXCELLENT..

[@XLnCADMalayalam]

Thanks for listening

[@hariprasadth7901]

Thanks

[@sarathsoman7393]

സൂപ്പർ

[@XLnCADMalayalam]

Thank you :)

[@jafarabdu3398]

very good, thanks

[@XLnCADMalayalam]

My pleasure :)

[@ajeeshuthaman8060]

Thank you

[@XLnCADMalayalam]

You're welcome

[@mohsinarakkal8668]

Thank you so much 💓

[@XLnCADMalayalam]

You're welcome 😊

[@abhilashh1077]

How to carry forward the stock to another worksheet if we are using diff sheets for each month?....tks

[@XLnCADMalayalam]

Please ask this question on 'Quora' and tag me.

[@theresaangel2340]

Thanks ....

[@dharsanam]

HI...Gud presentation...when I try for automatic sl no...i got always 1..1...1.. like this , ..dont get 1..2..3 like this. why this happen, pls answer.

[@JP-gv3hs]

Great info

[@XLnCADMalayalam]

Glad you think so!

[@soumeshcp1039]

Thanks alot....

[@thevasseri71]

ഇതിൽ purchasum salesum കൂടാതെ ഞമ്മൾ തന്നെ ചില ഐറ്റംസ് consume ചെയ്യുകയാണെങ്കിൽ ടോട്ടൽ എന്ന കോളത്തിൽ equation എങ്ങനെ വരുന്നു എന്ന് കൂടി വരുന്ന എപ്പിസോഡിൽ വിവരിക്കുമെന്ന് പ്രതീക്ഷിക്കുന്നു

[@kannankakkad]

Super sir

[@muhammedrasil6886]

Thenks sir 😍

[@XLnCADMalayalam]

My pleasure :)

[@abhijithk.r7257]

Thank you sir🥰🥰

[@XLnCADMalayalam]

My pleasure 😀

[@eazylearn5943]

Good useful 👍👍

[@XLnCADMalayalam]

Glad you think so!

[@anukuttantr2336]

Thank you sir

[@XLnCADMalayalam]

So nice of you

[@jacobantony5]

Very good class sir

[@XLnCADMalayalam]

Glad to hear that and Thank you :)

[@sharonthomas2012]

I can't thank you enough

[@dileepkumarj2388]

We have 3000+ items with codification. item name, parts number, uom , qty. etc. Need to fill as one record (the commmon details of an item) if we type any code in one colum.

[@XLnCADMalayalam]

Use VLOOKUP function.

[@ashmifamily3694]

This possible to make 3sheet ?, purchase, sale and stock

[@niyasahamed1047]

sir oru production companiyile stock manage ment work sheet engane create cheyya

[@subrukodur9819]

Good, can we check the quantity availability on the base of date?

[@XLnCADMalayalam]

You should use SUMIFS function in that case.

[@ajthanzeerabdulla4120]

Thanks Mr ajay anand

[@XLnCADMalayalam]

My pleasure :)

[@krishnakrishna-ru7vh]

But its superb and simple 🙏

[@hakkeemvp3968]

Very good information

[@XLnCADMalayalam]

Glad to hear that :)

[@jagsideas3383]

Good Info
Can I add customer name and multiple item with this sale colum and similary purchase colum with vendor name

[@XLnCADMalayalam]

Yes, definitely

[@vidyakrishnan9304]

Hi sir I am getting an error : the macro may not be available in this workbook or all the macros may be disabled.. kindly help

[@shanavasshany93]

Sir the how to use alternative units in Excel i am at beginning of my work

[@satheeshvk8143]

Good tutorial

[@XLnCADMalayalam]

Glad you think so!

[@eazylearn5943]

Idakk serial number automatically add aavnilla apol stock puthiyath cheerkkumpol shariyavnilla what is the problem?please reply

[@mpjairaj]

Very useful video.👍🏽.
Is it possible to get low alert as a message in the mobile ?

[@XLnCADMalayalam]

Excel doesn't has an in built option for this purpose. But I think this is possible with Power Automation.