Can Excel be used for inventory management? - Excel Tips and Tricks - video Dailymotion

RobertBarone

Can Excel be used for inventory management? Yes. Here's how you can do it in a very crude way.   Here are the formulas outlined in the video.   In Stock  =FILTER(A3:A34,B3:B34>0)   Out Of Stock  =FILTER(A3:A34,B3:B34

Transcript

00:00Here's a very simple way to monitor your inventory dynamically in Excel like this.

00:04Let me show you how this is done. Let's start off with in stock. Select cell D3

00:08here. You're going to use a function called filter. The first argument on the

00:11filter would be the names of the inventory, comma. The second argument is

00:16a condition. You're going to highlight all the quantities and if the quantity is

00:20greater than zero, which means they have it in stock, you want to show the name.

00:23Close parenthesis and hit enter and this will give you the list of all items

00:28with quantity greater than zero. Now for out of stock, you're going to use the

00:31same formula filter. Open parenthesis, highlight all the item names in the

00:35inventory, comma, then followed by the condition of quantity being less than or

00:40equal to zero. This is just in case if you enter a negative number and close

00:44parenthesis and hit enter, it'll give you a list of all items that is out of stock or

00:48has a quantity of zero. Now if you start putting zeros in some of this, you can see

00:52that in stock, names will start to move over to out of stock and then out of stock

00:56will start to increase in size.

Can Excel be used for inventory management? - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended