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.
(all purchases help to support this blog – thanks!)
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
06:00 – Stock In Table
10:30 – Stock Out Table
12:27 – Closing Stock Table Pt2