How to create simple IN and OUT Inventory System in Excel

INVENTORY UPDATE!
How to Create a Dynamic/Expandable IN & OUT INVENTORY in Excel

FREE EXCEL INVENTORY MANAGEMENT TEMPLATE (FREE DOWNLOAD)

[njinicrispus]

This is one of the simplest and most powerful inventory management system established on Ms Excel. Thumps up man

[robertharris]

The F4 key will let you cycle through absolute and relative ranges, instead of editing and adding the $ symbol. Also add another column so you can have both a cost price and a sales price.
That would allow you to calculate profit.
If you turn your code column into a named range, you can then create pull downs with data validation for the other tables.

[mamadoujallow]

Thanks alot Chris your tutorial was wonderful. With it I was able to develop a stock inventory for my lab which I believe would be very useful in maintaining our stock.
Thank you

[ragielyncasas]

Thank you for this tutorial. This is what exactly i am looking for. Simple but effective.

[tinydino]

you're a life saver! i was looking specifically for this.

[raqelle]

I can't tell you how thankful I am for this video! THANK YOU SOOOO MUCH. It helped me lots with a problem I had at work and this worked liked magic. :) Thanks!

[cindytrimblr]

Thank you thank you thank you for making this straight to the point and easy to understand! This inventory system is amazing I'm saving this video.

[valmendez]

thank you for the tutorial i hope i can use this to my present job as a warehouseman

[ahmadtamimi]

the best explanation ever..very simple n easy to understand..thank you for this efforts..

[uziensalino]

This is helpful. I learn alot. I hope you can upload a video for this inventory excel, on how to in and out the product with the use of barcode scanner thanks a lot. ❤😇

[nelsonayop]

Thanks man!These is so great you help me learned this thing in such an easy way...

[faustopf-.]

This help me a lot in my first Barcode System. I made it in just an hour with more features. Thanks a lots for this gem!!

[MostAwesomestChannel]

Thank you for this great video. One question/suggestion: to solve the identical names issue, refer to item codes instead of item description and you won't need to change or edit the item descriptions.

[klaygallo]

Maybe its too late for me but this really helps me a lot. Thank you for sharing your knowledge.

[faizanali]

Me: Thanks youtube for suggesting me a master piece ..thumps up dude..!!!!

[mr.movieclips]

Amazingly, I needed this workout today as I'm preparing a new shop inventory system

[SuperKris]

such an amazing video, real great of you to do this, can't wait to get mine started. I've literally searched the whole of youtube for something simple like this

[vikramsangtani]

well tell me if same item i have and when i entry the item there is difftrent size and colours in garms so how i do for the same also why is not showing balce money for the same stock

[patrishcasila]

Patrish Casila

I've learned about the vlookup today. It has been a great help because we have a research and watching this made it easy for us. I also learned the importance of the dollar sign, and other functions of the ms excel.

[muhammadsiddiqui]

is there a way to adjust stock level in this inventory automatically after making an invoice in excel?