How to Create Stock Control List in Ms excel 2019 || Inventory Management in Ms Excel
Вставка
- Опубліковано 6 лют 2019
- 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 Erro...
===========================================================================
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,
AHHHHH AMAZAING! This was SUPER helpful. Stopping and going my own pace while I figured it out. Bless you!!!
Thank you so much
Sir really it's helping me
I like this program
Thank you so much
This is very usable and useful
Thank you so much! it really helpful. God bless you !
You're welcome!
lovely and simple, thank you!! Had to play at 1.5x speed though!! Thank you
Most Welcome
thank you heaps! this is exactly what i was looking for to record my day to day liquid use.
Glad that it was helpful
you have made my life so easy! best regards
Glad I could help!
Thank you, Sir. This is very useful.
Most Welcome dear.
Thank You 😍
You're welcome 😊
Super love from india
Thank You Sir
Most welcome
Simplify and straight to the point
Thank you so much
This was helpful thank you.
Glad it was helpful!
That was very easy to understand. but don't you have a discrepancy formula just in case?
Thank you🫶🫶 more useful than my computer class🙆♀️
You're welcome 😊
This was a super helpful video. Rate 1000%
Glad it was helpful!
Really helpfull .. thank you very much Sir.
You are most welcome
excel was a big rule to any businesses i am dealing with it everyday for couple of years now so i am sharing my skills to help others
need help
want 1 file for stock maintain and material going 4 shop's on daily basis. want one file but date vise and end of the month each shop report as per daily material issued.
have open stock qty and product name just need file with formula
@@munawarzareef7169 maybe you can reach me and make it a bit clear sir
please give me Whsatpp number or mail address
@@munawarzareef7169 workhard0205@gmail.com
drop more details
Thank you. This is so good and very very helpful. I cannot grade it well enough. It's short, no time wasting and well informative, which makes it even more brilliant. No doubt, you've done a great job here. I've even subscribed to your page. God bless
Glad it was helpful! and Most Welcome my dear.
Nice
Very simple
Very on task
Thank you so much 😊
thank u so much sir...ALLAH bless u
Most Welcome dear.
Excellent and too the point method. Thanks for sharing
Glad it was helpful!
Hello Sir, this is very interesting, Much appreciated
Thank you so much for your supporting
This is life saving truly❤️
Thank you so much
thnx alot , i needed this alot
Glad it helped
Thanks for this video. Its really helpful. and also its shorts video.
Most Welcome dear.
Amazing sir.outstanding and mindblowing
Thank you so much 😀
Sir its really helpful for me thank you very much
Most welcome
This really helped me....thank you
I'm so glad!
Very easy to understand. Thank you
God bless you. You made my day
Thank you so much and Glad that it was helpful for you
It's really great, thanks
VERY HELPFUL THANKS
Most Welcome
Thank you very much sir
Most Welcome dear.
Thank you so much
Most Welcome my dear.
Thank You sooo much!
Most Welcome
Bro this is awesome!!!!
Glad you enjoyed it
thanks for the help!
Happy to help!
Thanks
Most Welcome
Amazing 👏
Thank you so much
Thank you so much 💞💞💞
You're welcome 😊
Woooooow thx alot
Most Welcome dear.
Tnx..hitted u already
Thank you too
Thanks a lot
Most Welcome
Thank you sir!!
Most welcome!
Wow awsome
Thanks for Awesome comments
Its wonderful
Thank you so much dear
thats nice and easy ,good vid
Readymade garments stock control (barcode ) maintain karneka solutions batao sir
thanks
Most Welcome.
The qty in hand didnt reduce when some choclate was sold. How would you go about having it fluctuate with incomming stock and reduce with sales?
GOOD SIR
Thanks
Very simple method and I am happy to see, but if you remove the yellow round from cursor is will give clear idea in where you clicking!
Thank you so much dear and thanks for your nice suggestion
Ye to simple hogya mery liye
Glad to Help you
What's the last formula for the reorder
If stock item less than 10 or 20 then reorder otherwise not
What if we keep purchasing in alternative days and issues every now and then?
زبردست
Glad to Help you dear.
Good work sir😃
Thank you so much dear.
Dear want to ask can we do all these when we have our inventory on separate sheet than sales sheet ?
Yes sure you can do it on separate sheet.
So did u use addition or subtraction for inventory, sales value and remaining stock and what's up with the yes and No
Yes means when stock is less than the required one then you can reorder the stock, No means when inventory or greater than the required one stock, Yes No or signals to reorder or not
A101
dear yadonline, i have a question if you please Sir , when i order more inventory in different price what should i do ? thank you
Thanks for comment dear. plz put more condition in if statement ok for same product.
AWESOME,,,,,
Thank you! Cheers!
How donget Sales value? Plsss
Thanks for comment dear. i put the dummy data when you creating stock control list then you have a complete record of Purchase and sales then you can create your Stock control list in excel easily.
Can a 45 years old person also get a entry level job after learning advance excel no experience IT Background. Please suggest. Your teaching is helpful. Thanks
very useful , but i have a little concern, i want to include expiring date into the database, so that i will be able know which product is near expiring . how do i go about it please ?
Plz mention purchase date and expiry date and use if function to find out the expiry product
Put expiry date in the front of each product then by using conditional formatting highlight those product which is expire so you can easily find out the expiry product ok.
@@YadOnlinetrainingacademy with all due respect. can you demonstrate it for me? am not really good at excel .
@@iykeagyapong6195 Dear I will upload video about that how to find Expiry Product in Inventory list ok, verbally I can say that if the Expiry date of your product is less than or equal to current date of the system then it will be expired otherwise not. =if(select date
Could we mention Expiration Date too?
Yes Sure you can if possible
Sir please clear Formula
How to edit after issue a material
Every time searth the material and edit???
thank you so much dear. Plz Reference your product from other sheet then you can easy edit your product and extend it
@@YadOnlinetrainingacademy am not a professional and make a small video sir
Am a storekeeper but we want to buy a system
How to make please
Thank you so much.
I have a question, if u buy more new stock, do u add on that same sheet or you open a new one? Thank u
Thanks for comment dear. if you Buy new stock you can only change the quantity in hand figure on the same page, Also you can refer from another sheet if you want,
@@YadOnlinetrainingacademy ok...be blessed Sir
Another question, what is the use of inventory value...why do we calculate it? What does it mean in simple terms? How does it help us while monitoring our business?
Thanks for your comment dear.
Inventory values mean purchase price that you bought from vendors
@@YadOnlinetrainingacademy ok....I get it now.
Thank you.
My prob. is on the use of computer esp.on MS Exel. Oh! My God!
You will learn computer by using computer every day.
Dont do dat same thing as a ny square meeting was a garage sale.
Why no sound
Plz Follow this ua-cam.com/video/am1eYlGaakg/v-deo.html
Sir , how to update the cell value when adding new products to the inventory and update the available balance.
For example
Here I have only 3 bottles as available.
Tomorrow i'm goings to buy 5 bottles.
For tomorrow stock will be 8 bottles. (3+5=8)
And again next week i'm going to buy 10 bottles and stock will be 18 bottles.
(8+10)
Which formula or function can i use for this?
Thanks for comment dear plz you need to add product on other sheet this will be only product sheet and give reference in this sheet only then this will be automatically updated and you will only update the product sheet.
@@YadOnlinetrainingacademy could you please upload a video how it can be done.
Please
@@rosh8176 sure dear soon i will upload video about that
@@YadOnlinetrainingacademy thank you sooo much bro 🙏🙏🙏
@@rosh8176 Most Welcome
Is it working still ?
Sure dear
Awaj KO kya ho gya h
sir ya jo last pa ap ny recorder stock less than 50 rahka h to to sir her oroduct ma same rahy gi ya change ho gi
please guide me sir
Thanks for comment dear. plz you can can change it or make it same for every product.
@@YadOnlinetrainingacademy sir hum same kasy rahk sakty h jub kyher product ki vaklue different h us hisab sy hi Recoder inventry ho gi
Phir isne new product kese add kren
thanks for comment. plz add another condition mention the product name and price.
@@YadOnlinetrainingacademy thank you
how can download this file
From video description
@@YadOnlinetrainingacademy sorry but did not available any link to download this file
@@bhavneshparikh8283 Will be available soon
Your video clarity is not good.if you change this,it may be useful to all
Thanks for comment dear. Plz Select video format from the UA-cam video setting.
hello sir im looking for inventry system can u help me plz u got any contact details
wht type u need
maybe can try to do it
Vai kotha bolte na parle video koiren na pz
Āmāra priẏa kathā balabē
Thanks
Most Welcome
Thanks
Most Welcome
Thanks
Welcome