If you need to maintain inventory for your products and would like to use an Excel spreadsheet to do so, please watch this short video, in which I will create an inventory list table and inventory movement schedule. inventory.

These two spreadsheets can serve as the basis for your business to keep accurate inventory records, both in terms of value and quantity.

The finished model uses many Excel techniques such as drop-down lists, VLOOKUP commands, SUMIF commands and DATA VALIDATIONS, all of which are explained in detail.

As usual, you can request a copy of the completed model for you to study and practice. Just follow the instructions at the end of the video.

Here are the links to the different Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Thank you so much

Free Inventory Spreadsheet Template – https://www.MrSpreadsheet.com/products/free-inventory-spreadsheet-template

You can also visit our websites at the following address:

United States, Canada and World – https://www.MrSpreadSheet.com
UK and Europe – https://www.MrSpreadSheet.co.uk

Or our social networks:

FaceBook – https://www.facebook.com/MrSpreadSheets
Instagram – https://www.instagram.com/mrspreadsheet
Twitter – https://twitter.com/Mr_SpreadSheet

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.