Skip to content
Home ยป Create an Inventory Management Template in Excel with Formula | Free Template Download

Create an Inventory Management Template in Excel with Formula | Free Template Download

     

    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.

    Click here to download the featured template (complete).

    Click here to download the demo file used 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

    06:00 – Stock In Table

    10:30 – Stock Out Table

    12:27 – Closing Stock Table Pt2