How to keep Inventory using an Excel Spreadsheet - [create your own Template]

If you need to keep an Inventory for your products and would like to use an Excel spreadsheet to do this, then please watch this short video, where, I will create an Inventory List table and an Inventory Movements schedule.

These two spreadsheets can form the basis for your business to keep accurate Inventory records both in terms of Value and Quantity.

The finished template uses many Excel techniques such as Drop Down boxes, VLOOKUP commands, SUMIF commands and DATA VALIDATIONS all of which are explained in detail.

As usual you can request a copy of the finished template for you to study and practice on. Just follow the instructions at the end of the video.

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

You can also visit our websites at:

Or our Social channels:

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting

[abdullahiabiodun]

This has been very helpful to me especially at this time while I was given a task to do the inventory valuation for the month in my office with insufficient training. I would love to learn more from your videos. And I must say that I love your tone of explanations and the manner with which you lay things out. Thanks.

[stewartwilkinsonsnr]

Wow such a Great Excel Channel, I’m 73 (in age only) keep my brain active by learning new things. So started on Excel and having found this channel look forward to learning with someone who for me cares about teaching with a clear voice. Now better get started. 👍👏 16/09/2021 Just installed Excel 2019 👍

[louisawelsh]

You are fantastic, Perfect speed, clear, top of your game from my perspective with western ears - love the accent, reminds me of the butler on Downton Abbey. Thank you so much!

[shawnharmon]

Some of our fulfillment partners are not doing a good job on inventory balances so this is an excellent stand alone for our accounting department to make sure we don't run out of product.

[lisajohns]

This is beyond helpful for any seller who has to maintain their inventory. Thank you so much for taking the time to make such an informative video and basically showing us how to create our own templates step-by-step. If they're still available, would you kindly send me the link for the download of your templates for these spreadsheets, so that I have some kind of reference (or unable to ) while working on my own templates? Thanks again for your time and effort.

[sk]

This has helped keep my drug business efficient 😅 thank you loads

[amadougitteh]

thank you CFI, my excel knowledge is always improving thanks to you, Mr Spreadsheet.

[AngelMartinez-lfsp]

This is excellent and exactly what I needed to keep track of my inventory for my small business.

[tanyastaten]

I would like a copy of the spreadsheet. Your style is quite unique and such that it encourages me.

[foodpantry]

Loved the simplicity. Also enjoyable to watch. Would love to get a copy of the spreadseet.

[phoebedavis]

Really enjoyed this tutorial! Easy to follow and implement! I have Someka's stock and inventory tool for google sheets and it's really well designed and easy to use but it's good to know how to create this kind of templates from scratch! Thanks:)

[shahzadshah]

with the help of this video people, you can not imagine what I got... I was searching for my problem for one month but did not found any clue on youtube I talked with software-provided people but they asking to charge too much... by the grace of Allah Kareem I found this video and it helps me and solve my problem... I m really thank full to Mr. Spreadsheet team that they answered me on my E-mail however they straightforward denied me to solve my problem on my spoken word.. but with little knowledge of formulas editing through watching your video, I reach my achievement... thank you so much

[kwasidzah]

Great stuff! I like the way you combined several different formulas and functions to come up with such a useful template. Thank you. I have one question though. How do you factor in a situation where the costs of your products keep changing very often? Is there a way to build in a means of updating your template without having to create a new template each time costs change or having the new costs change past transactions?

[billohearn]

Thank you for the excellent demonstration of how Excel can be used to create an inventory control system. I'd love to receive a copy of the spreadsheet.

[nozisikhonde]

The best Excel tutorial! So easy to follow and concise. Thank you! Now for a sales template please.

[fosternkansahboye]

Thank you very much, I really love this. Thanks once again for the knowledge shared, really appreciate.

[cbalian]

Amazing content. I'm a huge Excel geek and it never ceases to amaze me at it's capabilities. Where to go to download or look up this and other templates?

[joclare]

Excellent. This has really helped me in my new business. I've started so many spreadsheets trying to sort inventory but I only needed one....this one! Thank you :-)

[stewartwilkinsonsnr]

Wow just created a spreadsheet to monitor our Medicines, using the same layout as the Inventory Spreadsheet. Thanks again Mr SpreadSheets 👍

[thebigbacon]

AWESOME!!, just created an inventory management spreadsheet for my warehouse. Thank you, this was very easy to follow.