Create an Inventory Management Template in Excel with Formula | Free Template Download

[@sidikiekonneh6248]

I’m a freelancer this help me a lot especially with my small business owners who want to keep it simple Thanks

[@robertsmeansbusiness4018]

Simple and to the point. Great for small businesses. However, how can one inculcate the accounting concepts of FIFO, LIFO etc. in computing the closing stocks prices?

[@Jojosmith342]

Thumbs up as always for the BEST instructor Chester Tugwell for the clear and valuable tutorials. Thank you very much for all your lessons and great tips 👍

[@aaagwz]

Honestly, you are the best! You are very generous as well for sharing your template. Thank you!

[@abiodunogunseye3151]

U just made the inventory system easier and you earn a subscriber

[@convinth]

Superb tutorial! Clear, unhurried and concise.

[@nyaguthiiwangai]

I enjoyed every step of this. Thank you Chester

[@robotbobusa2479]

A big thanks to you for taking the time to make these videos on Microsoft Excel! Do you happen to have a video showing us how we might add a scanning ability to update our In and Out inventory? So that if I scan a custom Barcode, I have created it will add or remove stock from my Inventory Management and or the In and out sheet? Thanks in advance.

[@JohanneCaglianone]

Wow. I want to learn more from you. I am taking over Logistics/Inventory Control/Demand Planning for a small retail and e-commerce company that is just a mess. I have no experience and am learning data analytics using excel and tableau. I am trying to get his in a way as you hsve explained so I have at least a handy way to track inventory. Thank you. I am going to try this!

[@KarisaMc]

Wow, Thank you so much for this you have no idea on how happy I am. Your work is amazing. Much love from South Africa.

[@adnanabbasi9482]

A very useful video on stock management. However, it would be more of interest to the masses if it would address with weighted average pricing and variable purchased price each time along with the selling on different pricing and the profitability out of it. But, thanks again for the video.

[@ahsanw2136]

Great job men.I really appreciate your way of guidance.🥰😇🥰

[@dannaibnsaid2221]

Nice. I am so happy subscripe to the channel. Please how can we include fifo lifo and multiple shops to this inventory

[@noratun3613]

Thank you so much sir. I am running a small business and this is very helpful!

[@zanderhuynh7998]

I love it! Can you show us how to make another sheet for bill of material to make finish product!

[@IvanCortinas_ES]

Super tutorial. Thank you for the video and for the template! Excellent tutorial!

[@11acjr]

Just perfect instructions, thanks!

[@mohamedyusuf7111]

hi brother I used your invoice tutorial and created mine for my shop it worked well and was time-saving, and now I am following your inventory management system but the problem I'm facing is once I created my header and convert that into a table my paste link button is not shown, but outside the table in the same sheet is working what to do please help me out.

[@stimpys123]

I have been trying to do exactly this, brilliant

[@simbarashezhou2240]

This is wonderful.... thank you so much

[@wayneedmondson1065]

Nice one Chester! Using Excel Data Tables makes it very efficient. Thanks for sharing this example :)) Thumbs up!!

[@gokulbmw0604]

Hi sir, I need support for my scenario in excel sheet A2 cell value dynamically change as 1 or 0. I want to count total how many time 1 appear in cell A2. I need total number of counts value in B2 cell.

[@Mikabellaa]

Can this be set up so the vlookup looks up multiple tables at once?

[@tinashekamwenje4196]

Perfect, great learning experience

[@kailzaker1103]

I would like to know why the 'paste link' is not showing when pasting to a table.

[@Egyptian_Koppite]

Excellent work sir

[@davidtambunan9510]

super.... very simple

[@yongmingzhu8296]

Can i add barcode inside this sheet ?

[@SherAliKhanPK]

Wonderfull...

[@sergeyp6472]

Thanks! Simple and efficient!