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 drop-downs
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
------------------------