Simply explained..very good job..

Thank you so much brother, much helpfull..!

VERY SIMPLE AND VERY UNDERSTANDABLE GREAT WORK

@XLnCADMalayalam

3 жыл бұрын

Thank you

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

Very usefull.. Thank you 👍

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

@TheNiyas4000

4 ай бұрын

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

Essential content.. 🤝🤝👏👏

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

@XLnCADMalayalam

3 жыл бұрын

Glad to hear that.

Thankyou, for the video.

Thank u, it is very useful video

Very nice and simple presentation, all the best

This video was very helpful, Thank you very much.

@XLnCADMalayalam

Жыл бұрын

My pleasure 😀

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

@XLnCADMalayalam

3 жыл бұрын

Glad it was helpful!

Thank u sir. Very informative

@XLnCADMalayalam

3 жыл бұрын

Most welcome

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

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

Thank you very much

Excellent.

This was very helpful for me ,thanks God bless

@XLnCADMalayalam

Жыл бұрын

Glad it was helpful!

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

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

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 ..

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

Good Proper clear explanation Thanks

@XLnCADMalayalam

3 жыл бұрын

Glad you liked it

അടിപൊളി 👍

Thank you so much sir

Thank You Sir

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?

Well done 👍

Usefull video

100% useful sir. Thankyou👍🏻👍🏻

@XLnCADMalayalam

2 жыл бұрын

Welcome 👍

THANK YOU VERY MUCH ....

Thank you..so much helpful..

@XLnCADMalayalam

3 жыл бұрын

Glad it was helpful!

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

@XLnCADMalayalam

3 жыл бұрын

Glad to hear that :)

Very informative

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

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

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

Super informative video

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

@XLnCADMalayalam

2 жыл бұрын

You are welcome :)

Very informative thanks ... subscribed your channal

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

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Thanks for valuable information....

@XLnCADMalayalam

2 жыл бұрын

So nice of you

Thank you so much!

@XLnCADMalayalam

2 жыл бұрын

Glad it helped!😀

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

Than you sir, Very useful information

@XLnCADMalayalam

7 ай бұрын

You are welcome 😀

Very very helpful thnk u so much sir...

@XLnCADMalayalam

10 ай бұрын

Most welcome😀

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

@XLnCADMalayalam

Жыл бұрын

My pleasure 😀

Thank you sir it is a excellent information

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

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

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Thank you so much🙏

@XLnCADMalayalam

9 ай бұрын

You're welcome 😊

Oru interior work nadathunna oralk upayogikkunna reethiyil ithay polulla orennam kanikkan pattumo

Super sir

Very very useful video, thanks sir

@XLnCADMalayalam

Жыл бұрын

Glad to hear that 😀

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.

Thanks brother

Excellent

Thanks❤

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

Large number of stock items undenkil engane drop down list il ninnu items easy aay select cheyyam

Very Good Presentation and easy to understand.👌👍

@XLnCADMalayalam

10 ай бұрын

😀

excellent.....thanks

@XLnCADMalayalam

3 жыл бұрын

Glad you liked it!

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

@XLnCADMalayalam

3 жыл бұрын

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

Thanks alot....

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

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

@XLnCADMalayalam

3 жыл бұрын

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

Super worke

Total Qty total cheyyaan options undoo?? Items enter cheyyumbool sum cell down aavum veenam

Thanks ....

Thank you so much 💓

@XLnCADMalayalam

2 жыл бұрын

You're welcome 😊

very good, thanks

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

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

3 жыл бұрын

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. kzread.info/dash/bejne/hIl7krV-hJzPXbw.html kzread.info/dash/bejne/f5h8tLx-hbm9ZKw.html

Good & very useful session

@XLnCADMalayalam

Жыл бұрын

Thank you 😀

Nice

Thank you...

@XLnCADMalayalam

Жыл бұрын

My pleasure 😀

Such a great info and also good presentation👍

@prajeeshsk9528

Жыл бұрын

Can you share the link for download

EXCELLENT..

@XLnCADMalayalam

3 жыл бұрын

Thanks for listening

Very nice presentation.... 👍👍👍

@XLnCADMalayalam

2 жыл бұрын

Thank you! Cheers!

Sir ethil last low stok varunna formula onnu parayi. Ethil parayunna les than manasilakunnilla

@firosalsalam

3 жыл бұрын

=IF(select your stock first column < 25, "low stock", " ") enter

Very helpfull..✌️✌️

@XLnCADMalayalam

3 жыл бұрын

Glad it helped

Thanks a lot

@XLnCADMalayalam

2 жыл бұрын

Most welcome

Thenks sir 😍

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

I can't thank you enough

how to make pivot table in excel file

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

@XLnCADMalayalam

3 жыл бұрын

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

Opening stock engane add cheyyum

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

@XLnCADMalayalam

3 ай бұрын

Check my video on the FILTER tool in Excel

Thank you sir🥰🥰

@XLnCADMalayalam

2 жыл бұрын

My pleasure 😀

Great info

@XLnCADMalayalam

3 жыл бұрын

Glad you think so!

More than 200 product undenkil athengane search cheyum ? Athukude paranju tharavo?

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

@XLnCADMalayalam

Жыл бұрын

You should use SUMIFS function in that case.

Thank you

@XLnCADMalayalam

3 жыл бұрын

You're welcome

How to get down arrow Data in Malayalam... Pls

Thank you sir

@XLnCADMalayalam

3 жыл бұрын

So nice of you

How to record purchase return & sale Return

Pls upload the link to download the excel sheet for study purpose

Sir Ethil Customers inte name add cheyyan enthu cheyyanam ? Oru customer oru month il enthokke items purchase and sale cheythu ennukoodi add cheyyan help cheyyamo ?

@XLnCADMalayalam

2 жыл бұрын

Go through the Basic Excel Tutorials (especially Excel Tables) and you will able to modify the template for your requirement.

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

@XLnCADMalayalam

2 жыл бұрын

Yes, definitely

Thank you. diffrent പ്രൈസ് ന്ന് purchas ചെയ്യുന്നത് എങ്ങിനെ ?

But its superb and simple 🙏