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
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,
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?
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
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
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.
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 ?
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 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
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.
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
AHHHHH AMAZAING! This was SUPER helpful. Stopping and going my own pace while I figured it out. Bless you!!!
Thank you so much
Thank you🫶🫶 more useful than my computer class🙆♀️
You're welcome 😊
lovely and simple, thank you!! Had to play at 1.5x speed though!! Thank you
Most Welcome
This was a super helpful video. Rate 1000%
Glad it was helpful!
Excellent and too the point method. Thanks for sharing
Glad it was helpful!
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
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.
This is life saving truly❤️
Thank you so much
Nice
Very simple
Very on task
Thank you so much 😊
This was helpful thank you.
Glad it was helpful!
thank you heaps! this is exactly what i was looking for to record my day to day liquid use.
Glad that it was helpful
This really helped me....thank you
I'm so glad!
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
Hello Sir, this is very interesting, Much appreciated
Thank you so much for your supporting
God bless you. You made my day
Thank you so much and Glad that it was helpful for you
Sir its really helpful for me thank you very much
Most welcome
Thank you so much 💞💞💞
You're welcome 😊
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
Sure dear. Only you need Fast typing Speed with excel knowledge
you have made my life so easy! best regards
Glad I could help!
Sir really it's helping me
Amazing sir.outstanding and mindblowing
Thank you so much 😀
Very easy to understand. Thank you
Most Welcome
That was very easy to understand. but don't you have a discrepancy formula just in case?
Simplify and straight to the point
Thank you so much
I like this stock control list.
Thank you so much
VERY HELPFUL THANKS
Most Welcome
Really helpfull .. thank you very much Sir.
You are most welcome
thank u so much sir...ALLAH bless u
Most Welcome dear.
Thank you so much! it really helpful. God bless you !
You're welcome!
thats nice and easy ,good vid
Thank you so much
thanks for the help!
Happy to help!
Good work sir😃
Thank you so much dear.
Thank You 😍
You're welcome 😊
Bro this is awesome!!!!
Glad you enjoyed it
Thanks for this video. Its really helpful. and also its shorts video.
Most Welcome dear.
This is very usable and useful
Thank you sir!!
Most welcome!
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
It's really great, thanks
Thank you too!
Its wonderful
Thank you so much dear
Readymade garments stock control (barcode ) maintain karneka solutions batao sir
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
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.
Super love from india
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.
Wow awsome
Thanks for Awesome comments
Thank you very much sir
Most Welcome dear.
Thank you, Sir. This is very useful.
Most Welcome dear.
Thank You Sir
Most welcome
What's the last formula for the reorder
If stock item less than 10 or 20 then reorder otherwise not
I like this program
Thank you so much
thnx alot , i needed this alot
Glad it helped
Amazing 👏
Thank you so much
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?
Tnx..hitted u already
Thank you too
Woooooow thx alot
Most Welcome dear.
Thank You sooo much!
Most Welcome
Thank you so much
Most Welcome my dear.
Ye to simple hogya mery liye
Glad to Help you
Thanks
Most Welcome
What if we keep purchasing in alternative days and issues every now and then?
GOOD SIR
Thanks
AWESOME,,,,,
Thank you! Cheers!
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
Could we mention Expiration Date too?
Yes Sure you can if possible
thanks
Most Welcome.
زبردست
Glad to Help you dear.
My prob. is on the use of computer esp.on MS Exel. Oh! My God!
You will learn computer by using computer every day.
Is it working still ?
Sure dear
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.
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
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
I want to join u
Sure dear
Why no sound
Plz Follow this th-cam.com/video/am1eYlGaakg/w-d-xo.html
Phir isne new product kese add kren
thanks for comment. plz add another condition mention the product name and price.
@@YadOnlinetrainingacademy thank you
Sir please clear Formula
Dont do dat same thing as a ny square meeting was a garage sale.
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 TH-cam video setting.
A101
Awaj KO kya ho gya h
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 a lot
Most Welcome
Thanks
Most Welcome
Thanks
Most Welcome
Thanks
Welcome