How to create Stock Inventory Management System for small business in excel

This video is about Data inventory Sheet for Stock management and this will be useful for small business or any type to store. Hyperlink, Micro Record Command Button (for data transfer in record sheet) and sumif formula used in this sheet. sumif formula is very helpful for stock calculation.

If you want to go shortly in following parts of this video CLICK on time.

4:36 – How to apply Hyperlink on Button Shape
8:16 – How to create Micro Record for Command Button
11:00 – How to apply sumif formula