In this video I demonstrate how to create an inventory management template in Microsoft Excel. The template includes four tables: Opening Stock, Stock In, Stock Out and Closing Stock.
5 FREE EXCEL TEMPLATES
Plus Get 30% off any Purchase in the Simple Sheets Catalogue!
Click here for the Simple Sheets Inventory Management System
(all purchases help to support this blog – thanks!)
Click here to download the template featured in the video (complete).
Click here to download the demo file featured in the video tutorial.
Video Table of Contents
Please use the time stamps below to navigate between the video chapters.
00:00 – Introduction
00:35 – Create Official Excel Tables
03:35 – Opening Stock Table
04:59 – Closing Stock Table Pt1
5 FREE EXCEL TEMPLATES
Plus Get 30% off any Purchase in the Simple Sheets Catalogue!
06:00 – Stock In Table
10:30 – Stock Out Table
12:27 – Closing Stock Table Pt2