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 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,

[@Smalliemichelledance]

AHHHHH AMAZAING! This was SUPER helpful. Stopping and going my own pace while I figured it out. Bless you!!!

[@YadOnlinetrainingacademy]

Thank you so much

[@me-xk9uo]

What's the last formula for the reorder

[@YadOnlinetrainingacademy]

If stock item less than 10 or 20 then reorder otherwise not

[@0brycefury]

That was very easy to understand. but don't you have a discrepancy formula just in case?

[@PRIYANKASharma-uv8lx]

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

[@YadOnlinetrainingacademy]

Sure dear. Only you need Fast typing Speed with excel knowledge

[@mrcat1991]

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?

[@akanjiemecallister4780]

So did u use addition or subtraction for inventory, sales value and remaining stock and what's up with the yes and No

[@YadOnlinetrainingacademy]

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

[@patrickngaruiya9611]

This was helpful thank you.

[@YadOnlinetrainingacademy]

Glad it was helpful!

[@rizwanmohammad6106]

Is it working still ?

[@YadOnlinetrainingacademy]

Sure dear

[@lazarusWafula-bd2rs]

I want to join u

[@YadOnlinetrainingacademy]

Sure dear

[@jyotinagavade9776]

Readymade garments stock control (barcode ) maintain karneka solutions batao sir

[@rosh8176]

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?

[@YadOnlinetrainingacademy]

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.

[@rosh8176]

@@YadOnlinetrainingacademy could you please upload a video how it can be done.
Please

[@YadOnlinetrainingacademy]

@@rosh8176 sure dear soon i will upload video about that

[@rosh8176]

@@YadOnlinetrainingacademy thank you sooo much bro 🙏🙏🙏

[@YadOnlinetrainingacademy]

@@rosh8176 Most Welcome

[@ainsmas361]

lovely and simple, thank you!! Had to play at 1.5x speed though!! Thank you

[@YadOnlinetrainingacademy]

Most Welcome

[@internalinjectiontrulyhere770]

Dont do dat same thing as a ny square meeting was a garage sale.

[@sumitrakamble914]

Sir please clear Formula

[@lesliemgimba]

My prob. is on the use of computer esp.on MS Exel. Oh! My God!

[@YadOnlinetrainingacademy]

You will learn computer by using computer every day.

[@kkkmmm1389]

Sir really it's helping me

[@pachuau1690]

Thank you🫶🫶 more useful than my computer class🙆‍♀️

[@YadOnlinetrainingacademy]

You're welcome 😊

[@gracekamashaazi2501]

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

[@YadOnlinetrainingacademy]

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,

[@gracekamashaazi2501]

@@YadOnlinetrainingacademy ok...be blessed Sir

[@gracekamashaazi2501]

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?

[@YadOnlinetrainingacademy]

Thanks for your comment dear.
Inventory values mean purchase price that you bought from vendors

[@gracekamashaazi2501]

@@YadOnlinetrainingacademy ok....I get it now.
Thank you.

[@olivierngendahayo3116]

Hello Sir, this is very interesting, Much appreciated

[@YadOnlinetrainingacademy]

Thank you so much for your supporting

[@bhavneshparikh8283]

how can download this file

[@YadOnlinetrainingacademy]

From video description

[@bhavneshparikh8283]

@@YadOnlinetrainingacademy sorry but did not available any link to download this file

[@YadOnlinetrainingacademy]

@@bhavneshparikh8283 Will be available soon

[@ramgr6888]

Your video clarity is not good.if you change this,it may be useful to all

[@YadOnlinetrainingacademy]

Thanks for comment dear. Plz Select video format from the TH-cam video setting.

[@LifeisBeautifulforall]

Excellent and too the point method. Thanks for sharing

[@YadOnlinetrainingacademy]

Glad it was helpful!

[@bhawnarajpal2050]

VERY HELPFUL THANKS

[@YadOnlinetrainingacademy]

Most Welcome

[@marshaleemaitland2452]

This was a super helpful video. Rate 1000%

[@YadOnlinetrainingacademy]

Glad it was helpful!

[@dr.ta7feez-545]

dear yadonline, i have a question if you please Sir , when i order more inventory in different price what should i do ? thank you

[@YadOnlinetrainingacademy]

Thanks for comment dear. plz put more condition in if statement ok for same product.

[@iykeagyapong6195]

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 ?

[@YadOnlinetrainingacademy]

Plz mention purchase date and expiry date and use if function to find out the expiry product

[@YadOnlinetrainingacademy]

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.

[@iykeagyapong6195]

@@YadOnlinetrainingacademy with all due respect. can you demonstrate it for me? am not really good at excel .

[@YadOnlinetrainingacademy]

@@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

[@musasamaifarmah6618]

I like this stock control list.

[@YadOnlinetrainingacademy]

Thank you so much

[@samae475]

Tnx..hitted u already

[@YadOnlinetrainingacademy]

Thank you too

[@rasheedonisade1648]

Thanks

[@YadOnlinetrainingacademy]

Most Welcome

[@Tunogkalyeah]

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

[@munawarzareef7169]

need help

[@munawarzareef7169]

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

[@Tunogkalyeah]

@@munawarzareef7169 maybe you can reach me and make it a bit clear sir

[@munawarzareef7169]

please give me Whsatpp number or mail address

[@Tunogkalyeah]

@@munawarzareef7169 [e-mail]
drop more details

[@MarthaAustin-n5y]

I like this program

[@YadOnlinetrainingacademy]

Thank you so much

[@aestheticclub3989]

Awaj KO kya ho gya h

[@ajiboyebeatriceolutoun691]

This really helped me....thank you

[@YadOnlinetrainingacademy]

I'm so glad!

[@maziochendu5258]

Nice
Very simple
Very on task

[@YadOnlinetrainingacademy]

Thank you so much 😊

[@dilawarabbasi4524]

Sir its really helpful for me thank you very much

[@YadOnlinetrainingacademy]

Most welcome

[@khurshidraahi9698]

Thank you so much 💞💞💞

[@YadOnlinetrainingacademy]

You're welcome 😊

[@fidda6641]

thanks for the help!

[@YadOnlinetrainingacademy]

Happy to help!

[@sathishkumarsambath3500]

How to edit after issue a material
Every time searth the material and edit???

[@YadOnlinetrainingacademy]

thank you so much dear. Plz Reference your product from other sheet then you can easy edit your product and extend it

[@sathishkumarsambath3500]

@@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

[@mdubyda593]

Vai kotha bolte na parle video koiren na pz

[@YadOnlinetrainingacademy]

Āmāra priẏa kathā balabē

[@shaikh763]

Wow awsome

[@YadOnlinetrainingacademy]

Thanks for Awesome comments

[@rheapeter9709]

Thank you sir!!

[@YadOnlinetrainingacademy]

Most welcome!

[@kirankamble2288]

Thank You Sir

[@YadOnlinetrainingacademy]

Most welcome

[@menghouv]

Could we mention Expiration Date too?

[@YadOnlinetrainingacademy]

Yes Sure you can if possible

[@miyagi2221]

thats nice and easy ,good vid

[@YadOnlinetrainingacademy]

Thank you so much

[@walkwithlenin3798]

What if we keep purchasing in alternative days and issues every now and then?

[@technicianbabu-CP]

Thank You 😍

[@YadOnlinetrainingacademy]

You're welcome 😊

[@mohamedbashir1270]

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!

[@YadOnlinetrainingacademy]

Thank you so much dear and thanks for your nice suggestion

[@semititudrau852]

Really helpfull .. thank you very much Sir.

[@YadOnlinetrainingacademy]

You are most welcome

[@freezone2030]

Why no sound

[@YadOnlinetrainingacademy]

Plz Follow this th-cam.com/video/am1eYlGaakg/w-d-xo.html

[@kudzaingozo-chapata8079]

This is very usable and useful

[@moazzamali8653]

Its wonderful

[@YadOnlinetrainingacademy]

Thank you so much dear

[@mcmxcau]

thank you heaps! this is exactly what i was looking for to record my day to day liquid use.

[@YadOnlinetrainingacademy]

Glad that it was helpful

[@lizusmitadas5577]

This is life saving truly❤️

[@YadOnlinetrainingacademy]

Thank you so much

[@rizwanullah8721]

Dear want to ask can we do all these when we have our inventory on separate sheet than sales sheet ?

[@YadOnlinetrainingacademy]

Yes sure you can do it on separate sheet.

[@rizwanaslam874]

thank u so much sir...ALLAH bless u

[@YadOnlinetrainingacademy]

Most Welcome dear.

[@kkkmmm1389]

Super love from india

[@nduggajoseph5371]

Woooooow thx alot

[@YadOnlinetrainingacademy]

Most Welcome dear.

[@kanizfatema3236]

Thanks for this video. Its really helpful. and also its shorts video.

[@YadOnlinetrainingacademy]

Most Welcome dear.

[@nbtechzone]

Thanks

[@YadOnlinetrainingacademy]

Welcome

[@dhonepanganiban9239]

Good work sir😃

[@YadOnlinetrainingacademy]

Thank you so much dear.

[@ndukajijane5158]

Thanks a lot

[@YadOnlinetrainingacademy]

Most Welcome

[@gullomarketing]

GOOD SIR

[@YadOnlinetrainingacademy]

Thanks

[@kavyabharathesh2903]

Thank you very much sir

[@YadOnlinetrainingacademy]

Most Welcome dear.

[@sujithkrishnau]

A101

[@nurulmohd844]

Thank you so much! it really helpful. God bless you !

[@YadOnlinetrainingacademy]

You're welcome!

[@khuzaimahr1477]

Bro this is awesome!!!!

[@YadOnlinetrainingacademy]

Glad you enjoyed it

[@vasudevan5657]

Amazing sir.outstanding and mindblowing

[@YadOnlinetrainingacademy]

Thank you so much 😀

[@sachinlama6112]

It's really great, thanks

[@YadOnlinetrainingacademy]

Thank you too!

[@malonegonzales9737]

How donget Sales value? Plsss

[@YadOnlinetrainingacademy]

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.

[@ramgr6888]

Thanks

[@YadOnlinetrainingacademy]

Most Welcome

[@asrafulcngkhyrul6742]

thanks

[@YadOnlinetrainingacademy]

Most Welcome.

[@khurrammansoor5984]

Thanks

[@YadOnlinetrainingacademy]

Most Welcome

[@aligulsher3597]

Phir isne new product kese add kren

[@YadOnlinetrainingacademy]

thanks for comment. plz add another condition mention the product name and price.

[@aligulsher3597]

@@YadOnlinetrainingacademy thank you

[@tanyakamvumbi722]

Thank you so much

[@YadOnlinetrainingacademy]

Most Welcome my dear.

[@TheHoshmanddeeba]

you have made my life so easy! best regards

[@YadOnlinetrainingacademy]

Glad I could help!

[@ghulamishaq2683]

زبردست

[@YadOnlinetrainingacademy]

Glad to Help you dear.

[@ghulamishaq2683]

Ye to simple hogya mery liye

[@YadOnlinetrainingacademy]

Glad to Help you

[@Prado120Vx]

thnx alot , i needed this alot

[@YadOnlinetrainingacademy]

Glad it helped

[@lenaarc]

Thank You sooo much!

[@YadOnlinetrainingacademy]

Most Welcome

[@diamondsparta9423]

Amazing 👏

[@YadOnlinetrainingacademy]

Thank you so much

[@George-vy8fp]

Thank you, Sir. This is very useful.

[@YadOnlinetrainingacademy]

Most Welcome dear.

[@theresadickson3632]

God bless you. You made my day

[@YadOnlinetrainingacademy]

Thank you so much and Glad that it was helpful for you

[@smartsalome1676]

Very easy to understand. Thank you

[@YadOnlinetrainingacademy]

Most Welcome

[@emmanuelthomas6083]

Simplify and straight to the point

[@YadOnlinetrainingacademy]

Thank you so much

[@zeenarafi]

AWESOME,,,,,

[@YadOnlinetrainingacademy]

Thank you! Cheers!

[@abcmotorhouse1834]

hello sir im looking for inventry system can u help me plz u got any contact details

[@munawarzareef7169]

wht type u need

[@Tunogkalyeah]

maybe can try to do it

[@gullomarketing]

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

[@YadOnlinetrainingacademy]

Thanks for comment dear. plz you can can change it or make it same for every product.

[@gullomarketing]

@@YadOnlinetrainingacademy sir hum same kasy rahk sakty h jub kyher product ki vaklue different h us hisab sy hi Recoder inventry ho gi

[@cockcrowsunrisecockcrowsun8887]

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

[@YadOnlinetrainingacademy]

Glad it was helpful! and Most Welcome my dear.