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.

Видео How to keep Inventory using an Excel Spreadsheet - [create your own Template] канала Mr.SpreadSheet