Buy the Simple Sheets Inventory Management Template
www.simplesheets.co/a/2147525...
(all purchases help to support this channel - thanks!)
Template featured in the video:
www.bluepecantraining.com/wp-...
Demo file:
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
------------------------
Негізгі бет Тәжірибелік нұсқаулар және стиль Create an Inventory Management Template in Excel with Formula | Free Template Download
Пікірлер: 30