simple inventory and warehouse management in excel
Вставка
- Опубліковано 21 лип 2024
- There are three simple steps you can take to create a warehouse software in Excel.
Using VLOOKUP and Sumifs
If you need more advanced training or a program, just follow us and write in the comments
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/tr.png)
so happy to have someone move along quickly so we don't fall asleep!
Thank you soooo much! you've just saved my life. i want the advanced one too.
Absolutely amazing wonderful
Brillant! definitely love to have the advanced program training. thank you
Thank you very much! Very helpful. Excellent. more tuitorial please!
Hello, great tutorial. I need so help as well. It might be an easy question, but it got me searching for
For future reference can you caption the video with shortcuts youre using as well as move a bit slower when entering the formulas
Great video! Thank you! Can you also make a video where it includes the price and can tally to customers especially repetitive customers
Excellent, very useful
Very nice Nader, now can you please do another video if you have multiple warehouse locations and want to track the expiry date
This was great 👏
It is a good template.
Thank you. But one problem is...
When I add same item on output twice or multiple times (once IN and other times OUT), the quality on "Remain" sheet will automatically lookup the value of Quantity on "Main" sheet just keeping the sequence only even if the items are not same.
Any solution for this?
@Nader Bahri For the "Sum of In" portion, I am still retrieving 0, even though my sheet has 10 products that came in.Can you Help??
Hello mate where can I download your template for warehouse inventory management thanks..
Hi Nader, Thank you for your video, Can you share the link of the same excel file?
is there a way i can call inventory by date? meaning , is there a way i can create reports ?
Excellent programming video! Thanks for sharing. How may I request for the advance level program video and spreadsheet formulas from you sir?
Hi, Great video’s I would like help how to solve a problem, how to assign, tables, ranges, Vlookup etc.
Eg: What lures are best to catch different fish.
Select type of fish from dropdown list. Eg: Cod, Trout, Bream
Select lure type from dropdown list. Eg: Spinnerbait, Soft plastic, Hardbody
Have a list of Lure Brands for each type of fish.
By selecting fish type Eg: Cod, Lure Type Eg: Spinnerbait, Would bring up the list of spinnerbait brands for Cod in the third column.
Thank you for the video, very good for learning
Hello, did the formula work for you? For the Sum of in i am still getting '0"
Thanks so much for this. Am a new warehouse manager, please how do I get this excel sheet?
Hi mate can you please send us the link of this file? it's really a big help mate... GOD BLESS
good job
Very Good... I think you need to slow down a bit
If the same code added twice in InOut sheet , Remaining sheet show both lines and final quantity is double. ?
Yes. I was looking for a solution for that but I couldn't find one.
Anything you come up with as a solution pls?
Hello can u send me link of same excel
Please make video on Advance program training. continue to upload videos Please Please Please
im stuck at 6:04, my excel say too man argument, please help
Than You!
Brother thank a lot and how can I download the template, please
Nyc
want download the sheet
Good
Nice! I will try this. How many products can I add? Is it difficult to search if I add more than 100 products?
More than 4000
Share your sheet
Share your sheet mate thanks
if you want an inventory application for warehousing i can make it for you in ms access
Please contract
Only u can understand that...show slowly bro
You explained very fast
Poor camera
The teacher doesn't teach well. Poor teaching. Doing everything by himself without considering other people watching. Very poor. Do not understand anything
Bro work on your english, speak slowly
He already speaks slowly, and it is pretty understandable.
@@turetskiy_shpion_44 Do you know what he says at :58? It sounds like "Alt A, V V", but that's not working for me. Any help is appreciated. Thanks!
@@AlisaChagnon123 Alt+A+V+V is the short cut for the Data Validation section
very bad quality of video
don't watch again, you have your liberty!