In this video, we will be showing you how to effectively manage your inventory using Microsoft Excel. We will create a mini but powerful #Inventory #management system in #Excel, specially we will discuss how you can use current or last purchase rate for your stock and profit valuation. The benefit of this method is to valuate your stock as per market value. We you will Excel Lookup, sumif , vlookup and other useful logics to achieve our desired goal. You will also learn how to lookup last value on be base of selected criteria.
Thanks for Watching , please don’t forget to subscribe our channel and like the video for useful upcoming videos. Thanks again !