Тёмный

simple inventory and warehouse management in excel 

Nader Bahri
Подписаться 835
Просмотров 161 тыс.
50% 1

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

Опубликовано:

 

4 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 52   
@debSilbert
@debSilbert Год назад
so happy to have someone move along quickly so we don't fall asleep!
@k.3036
@k.3036 2 года назад
Thank you soooo much! you've just saved my life. i want the advanced one too.
@mdsafayetislam2924
@mdsafayetislam2924 Год назад
Absolutely amazing wonderful
@christineanney.macaraeg2287
@christineanney.macaraeg2287 6 месяцев назад
Thank you very much! Very helpful. Excellent. more tuitorial please!
@marquisebartley9701
@marquisebartley9701 3 года назад
For future reference can you caption the video with shortcuts youre using as well as move a bit slower when entering the formulas
@sysamkhas8063
@sysamkhas8063 2 года назад
Brillant! definitely love to have the advanced program training. thank you
@jadadocs8844
@jadadocs8844 3 года назад
Hello, great tutorial. I need so help as well. It might be an easy question, but it got me searching for
@muhammedasifali7433
@muhammedasifali7433 6 месяцев назад
Excellent, very useful
@nickb.829
@nickb.829 2 года назад
This was great 👏
@ShumukhTechbd
@ShumukhTechbd 3 года назад
good job
@Alnasrlina
@Alnasrlina 2 года назад
Very nice Nader, now can you please do another video if you have multiple warehouse locations and want to track the expiry date
@marianunabia6294
@marianunabia6294 Год назад
Great video! Thank you! Can you also make a video where it includes the price and can tally to customers especially repetitive customers
@jm2224
@jm2224 3 года назад
Hi Nader, Thank you for your video, Can you share the link of the same excel file?
@annettewikstrom6350
@annettewikstrom6350 2 года назад
Thank you for the video, very good for learning
@Floresnegras68
@Floresnegras68 2 года назад
Hello, did the formula work for you? For the Sum of in i am still getting '0"
@zawmin677
@zawmin677 Год назад
Than You!
@Floresnegras68
@Floresnegras68 2 года назад
@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??
@rhensoudiego4910
@rhensoudiego4910 3 года назад
Hello mate where can I download your template for warehouse inventory management thanks..
@abrahamterefe
@abrahamterefe Год назад
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?
@mustafareza2480
@mustafareza2480 9 месяцев назад
Excellent programming video! Thanks for sharing. How may I request for the advance level program video and spreadsheet formulas from you sir?
@amandubey2014
@amandubey2014 Год назад
Nyc
@robwatt2290
@robwatt2290 Год назад
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.
@theresadickson3632
@theresadickson3632 2 года назад
Thanks so much for this. Am a new warehouse manager, please how do I get this excel sheet?
@amilaperera841
@amilaperera841 Год назад
If the same code added twice in InOut sheet , Remaining sheet show both lines and final quantity is double. ?
@abrahamterefe
@abrahamterefe Год назад
Yes. I was looking for a solution for that but I couldn't find one. Anything you come up with as a solution pls?
@amandubey2014
@amandubey2014 Год назад
Good
@maurygarcia
@maurygarcia 2 года назад
is there a way i can call inventory by date? meaning , is there a way i can create reports ?
@nobertmarevanhema497
@nobertmarevanhema497 Год назад
Very Good... I think you need to slow down a bit
@rameezalaam007
@rameezalaam007 2 года назад
Please make video on Advance program training. continue to upload videos Please Please Please
@abushamirtablan2151
@abushamirtablan2151 3 года назад
Hi mate can you please send us the link of this file? it's really a big help mate... GOD BLESS
@xrainblake5525
@xrainblake5525 2 года назад
Nice! I will try this. How many products can I add? Is it difficult to search if I add more than 100 products?
@omoboyowaolayiwola1170
@omoboyowaolayiwola1170 Месяц назад
More than 4000
@VictorMendozaMagallanes299
@VictorMendozaMagallanes299 Год назад
Brother thank a lot and how can I download the template, please
@panajotcollaku4268
@panajotcollaku4268 3 года назад
Hello can u send me link of same excel
@sanchee1737
@sanchee1737 10 дней назад
im stuck at 6:04, my excel say too man argument, please help
@Mohamed.musthafa
@Mohamed.musthafa 2 года назад
want download the sheet
@mubangakaoma4867
@mubangakaoma4867 3 года назад
Share your sheet
@bobcuenco3421
@bobcuenco3421 Год назад
You explained very fast
@parveetly
@parveetly Год назад
Only u can understand that...show slowly bro
@ginocompuesto4206
@ginocompuesto4206 3 года назад
Share your sheet mate thanks
@leafararbal7540
@leafararbal7540 2 года назад
if you want an inventory application for warehousing i can make it for you in ms access
@mahirexpress2046
@mahirexpress2046 3 года назад
Please contract
@ochiengodoyo2921
@ochiengodoyo2921 7 месяцев назад
Poor camera
@thomasnartey6043
@thomasnartey6043 Год назад
The teacher doesn't teach well. Poor teaching. Doing everything by himself without considering other people watching. Very poor. Do not understand anything
@sidaliyou7412
@sidaliyou7412 2 года назад
Bro work on your english, speak slowly
@turetskiy_shpion_44
@turetskiy_shpion_44 2 года назад
He already speaks slowly, and it is pretty understandable.
@AlisaChagnon123
@AlisaChagnon123 2 года назад
@@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!
@turetskiy_shpion_44
@turetskiy_shpion_44 2 года назад
@@AlisaChagnon123 Alt+A+V+V is the short cut for the Data Validation section
@donavengeorge6311
@donavengeorge6311 Год назад
very bad quality of video
@mustafareza2480
@mustafareza2480 9 месяцев назад
don't watch again, you have your liberty!
Далее
Grand Final | IEM Dallas 2024 | КРИВОЙ ЭФИР
6:53:16
Excel : How to create a simple warehouse management
8:10
Creating Easy Data Entry Forms in Excel
9:52
Просмотров 2,9 млн
STOCK INVENTORY MANAGEMENT SYSTEM with Google Sheets
21:36
Inventory Management using Excel for free | NETVN
10:32
How To Label Your Warehouse Bin Locations
6:03
Просмотров 115 тыс.
Google Sheets - Inventory Management System Template
34:14