Hi Guys Brain Behind Business is an educational channel where you will learn everything about business and all the subjects directly related to business. Subjects/Topics to be covered
- Business Studies - Basic Accounting - Financial Accounting - Cost Accounting - Online Earning - Microsoft Excel For Beginners - Google Sheets Course - Managerial Accounting - Strategic Decision Making - Investment Decision Making - Management & Relationship Management Theory - Advance Microsoft Excel With Financial Modeling And much much much more
You guys can support me by buying me a Coffee: www.buymeacoffee.com/brainbehindbiz
Favorite ko talaga mag explain Ang indian dahil sa tulad Kung slow is magical Kasi naintindihan ko ka agd since high school ni research ko talaga indian explanation kapag meron akong Hindi naintindihan sa subject ko❤❤❤ thank you po in God bless
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html
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
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
@Brain Behind Business thanks for this. Very helpful. One challenge for me though, the product list doesn't update in the ins&outs when i add new products to the list in data. Any tips to resolve this.
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html
Hopefully it will work for you otherwise you can check this updated stock control sheet ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html
can you create an Excel sheet that can categorize expenses to make profit and loss based on the rules that I put in . can I copy the date from the PDF file from the bank
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html
Thankyou it helps alot and please can you also make another video especially to give the formula of stock inventory. I like your video it really helps me.
@NathanPaul-fd9ny You are welcome and thank you for watching. I have already created an updated version of stock control sheet that would be more helpful. Please watch this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html