👉How to create an inventory or stock control system in Excel? 🎯Easy with one function🚩
Every business that offers the exchange of merchandise or products must have inventory control.
Whether it's simple or very advanced, it's necessary to perform analyses and keep track of existing products.
In this video, I'll show you how to create this sheet in the simplest and most detailed way using the SUMIFS function, basic subtraction operations, and a drop-down list.
00:00 Introduction - 👉How to create an inventory control or stock control sheet in Excel?
00:13 Starting the first sheet - Summary
01:05 Creating the Transaction Sheet
02:15 Data Validation
03:50 Entering formulas and functions in the Summary Sheet
05:20 Final Operation
Important: Record all transactions made with your product.
This sheet is useful for getting started. You can continue using it once you have more than 12 products, but if your business is growing, it's also necessary to grow in organization and order.
--------------------------------------------------------------------------------------------------
Subscribe to the channel.
E-mail. [email protected]
Facebook page. / eltioexcel.cl
Web page . www.eltioexcel.com
Instagram @ElTioexcel