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

Free Inventory Spreadsheet Template - https://www.MrSpreadsheet.com/product...

You can also visit our websites at:

USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk

Or our Social channels:

FaceBook -   / mrspreadsheets  
Instagram -   / mrspreadsheet  
Twitter -   / mr_spreadsheet  

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