How to Create Stock Control List in Ms excel 2019 || Inventory Management in Ms Excel

Aug 14, 2023

How to Create Stock Control List in Ms excel 2019 || Inventory Management in Ms Excel

Hi Viewers in this tutorial you will learn how to create stock control list or Inventory Management System in Ms excel 2019 step by step.
Subscribe my channel for more professional tutorials.
   / yadonlinetrainingacademy
===========================================================================
Complete Excel Course videos
   • Five Common Excel Errors and how to f…
===========================================================================
Stock control list formulas / Inventory Management system formulas
inventory values
=product(qty*unitprice)
sales value
=product(soldqty * Unitprice)

Reorder status
=if(stock less than 5o,“Yes”,No”)
=======================================================================
For More Professional Videos Plz follow the link given bellow.
   / yadonlinetrainingacademy
=======================================================================

#stockcontrollistinexcel, #howtocreatestocklist, #inventorymanagementinexcel, #stocklisttemplates, #inventorymanagement, #inventorymanagmentsysteminexcel, #inventoryexcel, #excelinventorymanagment,

Content

9.695 -> Viewers in this video I will show you How to create stock control list in Ms excel

13.832 -> Like this one

17.267 -> Create new blank sheet by clicking on plus symbol

32.369 -> Type here heading that is Stock control list for grocery shop

49.824 -> Change the row height from format option

56.901 -> align contents center

59.066 -> and select background color for this row

69 -> apply style on text that is bold and change the font size

84.117 -> Select area bellow the heading and apply background color

91.984 -> text color will be white

93.795 -> and change the row height

100.215 -> Apply border

106.253 -> Type heading for column first one will be product name

111.323 -> Then Unit Price

114.553 -> third one will be Quantity in hand

120.538 -> 4th one will be sold quantity

127.522 -> 5th one will be Inventory Value

131.348 -> 6th one will be Sales value

138 -> 7th one will be Remaining stock

145.079 -> and the last one column will be Reorder status

152.646 -> Select column and change width of column

158.707 -> Align text center

162.729 -> Select style bold and change the font size

171.803 -> Select area and create border for that area

178.122 -> change row height

181.324 -> align contents center for this area

186.613 -> Now type product name one by one

197.549 -> After that mention the Unit Price for all these products

204.139 -> Now mention the Quantity in hand

208.885 -> Also mention the quantity that is sold out

215.374 -> Now we calculate Inventory value by using formula

221.945 -> unite price multiplied by Qty in hand

227.681 -> copy the formula for remaining one product

235.4 -> Here we calculate sales value

241.173 -> Sales value multiplied by sold quantity

247.034 -> Copy the formula for the other rows

251.5 -> Now we will find the remaining stock

254.758 -> That is quantity in hand minus sold quantity

259.75 -> Copy formula for the remaining on rows

265.611 -> Here we will find the reorder status by formula

268.55 -> that is if the remaining stock less than or equal to 50 then reorder for product otherwise not

281.212 -> For reorder type yes option and No for not

288.783 -> then copy the formula

297.643 -> if you change the sold quantity you will see the effect of remaining stock

305.017 -> Thanks for watching this video plz like and subscribe the channel

Source: https://www.youtube.com/watch?v=tT1LHcBpAcc