Відео

Thank you for watching, I have created an advance version of stock control sheet for that purpose, please check that on my channel

Happy to help, stay connected for more videos

Glad I could help

Glad it was helpful!

Thanks

Please use =IF( then select any cell. You can check video on my channel to learn about IF formula its very useful formula to learn

Thank you for your kind comments but to clarify I am not an indian. I am a Hindu guy from Pakistan

for that we have an advance version of stock control sheet which has more features than this one where you can add and sell stock as per your business ua-cam.com/video/-FGLhhifShQ/v-deo.html

All the best

Please check interactive stock control sheet on my channel, that will solve your issue

Thank you

Do you mean it should tell you the Day (Mon, Tue) from date?

What i mean is that I want to create a sheet that when I change the date it should display the new items every day

that is possible with Vlookup formula and we need to set things first like what you want excel to display when a particular date is selected

This 20 is an imaginary number it could be any number in your case. I just want excel to alert me when my stock levels are below 20 you can make it 5 or any other number

Thank you

Thanks, stay connected

Thanks, stay connected

Okay sir g kaise pura right nahe tha?

Glad it was helpful!

Yes, I can help you with that but it will be a paid task for sure. www.buymeacoffee.com/brainbehindbiz/extras You can book zoom consultation from here or directly an interactive calculator sheet

20 is just an imaginary number, you can keep it 10 or 100 whatever you like. Its just a buffer stock level at which you want warning that stocks are low

Sir took 20 as the minimum number to place an order for restock of the products👍🏻

Exactly @Saitama647

Glad it was helpful!

Sir visible to hai

Thanks for the sub!

It should update, may be you have not properly followed the video. You can also download my version of the file from description and it should work

@@BrainBehindBusiness thank you. I figured it out. It had to do with validation of the data.

Okay great. Stay connected

I am trying to create a furniture inventory sheet, and I want to ask you what kind of formula can I use if I want the value I place in (for example) column A(inventory In) to add to column C(current inventory), and the value that I put in column B (inventory out) to subtract from column C. Is there a way that you can suggest I can accomplish this?

Hi @Dwalk416, Please watch this whole video again you need to add products in product sheet and then ins and outs in different sheet. If you want a paid consultation then we can book it from the description of the video

Yes, I can make but that would be complicated to mange inventory and debtors at the same time, you should use two separate sheets one for inventory other for debtors.

Hi Tracey, I can make a customized excel sheet for you but that would be a separate paid task. @traceychivers1988 My Services: www.buymeacoffee.com/brainbehindbiz/commissions Sheets and discussion: www.buymeacoffee.com/brainbehindbiz/extras

You are welcome, you can download this sheet from here www.buymeacoffee.com/brainbehindbiz/e/74865 and I have also created and advance version of stock control sheet which has more features than this one. ua-cam.com/video/-FGLhhifShQ/v-deo.html

Hopefully it will work for you otherwise you can check this updated stock control sheet ua-cam.com/video/-FGLhhifShQ/v-deo.html

I think this video will solve your problem, just add products such as X shoes with different sizes and Y with different sizes like this. ua-cam.com/video/-FGLhhifShQ/v-deo.html

I think this video will solve your problem, just add products such as X shoes with different sizes and Y with different sizes like this. ua-cam.com/video/-FGLhhifShQ/v-deo.html

You are welcome 😊, Please do visit other videos on my channel specially advance stock control sheet

You are most welcome, stay connected for more amazing videos like this

what do you thing now

Thank you! Cheers!

You can also use google sheets if you want online version unlike excel

Its an online platform, you can get he link in the description

Glad to hear that. Stay connected for more amazing videos like this

Thank you

You're welcome

Thank you and stay connected for more amazing videos like this

You mean profit and loss for your business? yes you can take dates from PDF files as well

@@BrainBehindBusiness can we create rules in Excel similar to QuickBooks to categorize the expenses based on the rules that we input?

Yes, we can but that will be a complex project and that would be for business right?

Thanks and welcome

No thats not possible with excel alone

Inventory value is Qty in hand X Unit Price I have used "Product" formula but you can multiply Qty in hand with Unit Price.

Inventory value is Qty in hand X Unit Price I have used "Product" formula but you can multiply Qty in hand with Unit Price.

Inventory value is Qty in hand X Unit Price I have used "Product" formula but you can multiply Qty in hand with Unit Price.

It will work in the same way just figures will be different. Please re watch the video and you will know that you can add all figures as your own

Thank you

which formula you want to learn about? please re-watch the video everything is explained well in this

You can make another copy for other year or if you want advance features in stock control sheet then please check this updated stock control sheet ua-cam.com/video/-FGLhhifShQ/v-deo.html

thanks so much for your response but I still didn't get it @@BrainBehindBusiness

Have you checked new video which I shared?