Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet
Вставка
- Опубліковано 13 чер 2024
- Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet In Excel | Stock Management
Get his sheet: bit.ly/3MzrCev
Get a customized stock sheet: bit.ly/3nKiWrh
Check out previous stock control video: • Stock Control Sheet In...
You can support me on
1- Patreon bit.ly/433u4Q2
2- Buymeacoffee bit.ly/40IH6AR
Formulas already taught on my channel:
Vlookup: • How To Do VLOOKUP Exce...
If: • How To Use IF Function...
Sumif: • How To Use Sumif Formu...
0:00 Intro / Recap
0:50 Data Sheet (Sheet 1)
2:15 Format as table in Excel
3:30 Ins & Outs (Sheet 2)
4:40 Data Validation in Excel
8:52 If formula in Excel along with vlookup formula
12:45 Multiple If / Ifs formula
16:35 Master (Sheet 3)
19:00 Vlookup formula in Excel
21:17 Sumifs Formula in Excel
25:10 Inventory count + Inventory Valuation
26:20 Formatting and then Outro
Play Lists
Microsoft Excel for beginners: bit.ly/3UaDANe
Business Studies: bit.ly/3K8eie9
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/49UYJCD
Email: brainbehindbusiness@gmail.com
#Excel #ExcelTutorial #ExcelForBeginners
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/n.gif)
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/49UYJCD
Very helpful! Thank you very much!
Glad it was helpful!
it is hard it takes like week to understand I like it so much thank you
Glad it helped! Stay Connected for more content like this.
God bless you🙌 you're helping me alot 🙏 ❤️ 😊
Happy to help!
Thankyou ❤
Very nice vedio, i am learning alot in this video. Thanks
Stay connected for more amazing videos like this.
Subscribe and hit bell icon to stay updated
Say I have a price for one product that changes one day to the next, how do I go about entering this into the inventory sheet without messing up the profit from the same product sold at a different price the day before. Do I need to make a new sheet for price changes each time?
No, you don't need to create a whole new sheet just do a simple thing and add that as a different product let's say
You had "Venom Tee" at 20 cost and 30 Price then add a new product "Venom Tee V2" with the new price if you don't want to mess with anything in the past
I hope this is helpful @lukewooten8084 🙏
Which formula did you use for the date please, I'm interested 😢
Its =Today() to get date of current day
I have made a video on this ua-cam.com/users/shortsFcxt5xGogQs
@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.
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
Wow😮😮😊😊😊❤
Thank you
Please, how to maintain spare parts shop
You can add products and pricing as weight for small items and others as normal items
@@BrainBehindBusiness how many budget needed to start business
It depends on business like what, where and how you want to start. some businesses cost less and others cost way too much
@@BrainBehindBusiness will 8Lakh enough for normal
you need to check all your cost and expenses.
1- you must have a good location
2- then you should set a side atleast 6 months of rent apart (for example 20k rent then keep 120k separate for rent)
3- Try to find place to buy auto parts in good price (Cheap but good quality) for 4 lakhs
keep other money for buying goods later on.
This is a general overview further you can research in your city about it. I am not a proper advisor in this and dont know your location, situation, and experience
How to have customer information in this excel file where we insert only the customers names and sales during the time and excel calculate the left inventory the sales and profits
sales, inventory left and profit are already explained in this video, please watch complete video for that.
Customer option can be added but that would be more complex but will make that in future for you. Stay tuned
@@BrainBehindBusinessI'll subscribe if u upload that, lol
Okay then please wait till that video :P
Sir apanka clear bhabare assuni 😢
@mkdtapuyt2673 Sorry can you please write in English?