Buy the Simple Sheets Inventory Management Template
https://www.simplesheets.co/a/2147525...
(all purchases help to support this channel thanks!)

Template featured in the video:
https://www.bluepecantraining.com/wp...

Demo file:
https://www.bluepecantraining.com/wp...

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.

This video will teach you the following:
1) How to create Excel tables and why they are useful especially for dynamic ranges
2) How to use data validation to create dropdowns
3) How to use the VLOOKUP function
4) How to use the SUMIF function

Table of Contents:

00:00 Intro
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