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