Discover the Best Kirana Store Bill Format for Product Management

Kirana store bill format for Product Management

Hello Guys Welcome Back to Another Video In today's video we will know that how we can maintain our stock inside excel sheet so first of all here we see how this set will do our work like here right now you can see Also on one hand stock in but stock out word and here is the balance stock so whatever stock will be our in, whatever it will be out inside the investment, it came inside the tweet and whatever the item balance will come here automatically Here you will find all the items inside the drop down, you just have to open the box and select the item, so if you maintain it by using the drop down, then this is the first thing of great use to you, then it is your writing again and again. not have another fault Chances are very low that is now working to see that seat work will be on how to seat the first that all the items you see something we have items in the balance like that he is now as stock inverter inside us In stock, enter today's date, enter item, pencil , and quantity in Android App that now pay here The balance of the cob is done, we have 102 stock out today also enter the date, put the item back, the pencil is put and the quantity is 22%, so whatever balance will be there, it is automatically updated, now take another item and see as I put in again today, so before that we take calculators and enter inside the top 152 and now the greater will have been 150 inside our balance now it out and put today's date still here I put a pencil instead of a calculator , inside the disease below it , we will see by putting the calculator, so like if we put anything inside the quantity, the balance that is it will come, now if I put the calculator, then it is not that if I am here If I enter the calculator, then only that account will be there, if I type the quarter anywhere inside Stark and Dorthy, who will do it even if I put it here, like I will not put it here, then look here who has accounted here now It is a matter of its working, how it snows, how will it work, how will it be made? Now you know that whatever you will be in your total item, you will write it here inside the balance top, maybe you have two items, 20 items, this is 50 items, they will look like this after writing all the items rough Now here we will convert it inside the drop down, first we will come here, inside the column containing this talk in word item, now after coming here, you will select the sales till where you want to put the drop down village and after that the data You will go inside the tap, here is the option Data Validation, click on it and here if you select the list, the source below will tell why I will click on OK after selecting the item, now here is your list which has been created, you problem will be before you can select paste within a year to copy the column on the other hand the crown that before now can selection from either side of the road I want us now that it is so that our balance topics that were shown So now why don't we put a for inside the duty column, so that after braking the equal adjacent bracket? Asking us how far of the range the ear has to show the total MP3 Yes, we have to show the total till now, after that we will press f4 so that it is fixed, apply a gentle criterion to tell what thing we need that we value of this particular thing If we want, here we want from the pen, then why will the pencil rise up, we will select again, after that we have to tell where we want the total of the even range, then they want it here, we will press f4 from back so that it becomes free Close the bracket If we give this, then for the total, now we have to do for outward - will continue the same formula after closing the bracket - will write the committee will put all the rackets, will tell the range from back, the range will now be ours and toad's item The garden is that by pressing f4, we will kill it again, we will tell the criteria, we will select the pencil located back, we will apply gentle, after that we have to tell the even range, so this time the coincidence is our quantity column by pressing f4 and will freeze it and This formula will close the bracket We will dry it till the bottom, so now our sheth is ready, then you make this set, use it daily, by setting this you will get the description center, if you want, you can also download this video from your mother, so how do you like this video? If the video is helpful for you, then definitely give a like to the video and if there is any question or any theft, then definitely comment below, we will see you in the next video, thanks for watching a MP3 Jhal