Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM Please make one like I mention Below: 1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return ) 2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
Plz help me with the formula for data extracted from the two drop down menus, if I have a purchase something from a vendor and there are 5 vendors in my list and there is a drop down list of items also so from the item dropdown list and from the vendor dropdownlist how can I extract information of one item and a particular vendor
Good Morning sir, Muje apne factory k production(sweet/namkeen) ka stock maintains karna hai. Humare pass software hai but ek manual data humare pass rhe day wise cross check k liye uske liye apka help chahiye.
Sir it is super very simple but every small business people can use this kind of excel report thank you so much One more pls tell me how enter invoice wise stock out report please help me
Sir inward range main first letter likhte hi stock select nahi jota plz tell me how to select in short cut because we have 1000 stock item it is very difficult to find by mouse click or scroll
Inward stock outward stock tatha balance stock ke sath ismein opening stock aur closing stock bhi dikhai de tatha rank number bhi mil jaaye to bahut achcha ho jaaye
as fresher in this should i go with storekeeper job .. any what topic r should in storekeeper job can u plz describe .. and for store keeper job what computer skill require as friesher in entry level can u sa it will be grt help for me ... thank u
Storekeeper has to deals with inward, outward of stock, availability of stock, also knowing which particular item was more demanded and which item not are not transact. Some companies have their own software for stock management however if company using any software you can use excel.
I make this excel sheet as u guided in video but facing some problem..in balance column first five six cells working with formula remaining not working... How I can solve this
Sr mujee helf chiye aapka ye shit mene aapne ye sit aapne Excel me khola hh mujee kuch problem aarhi h jha item add krte h net stook me oha pr all item add nhi ho rha h drop box me nhi aarha h Kya aap meri helf kr sakte h
@@Excel4Freshers bro aapke bat sahi hai lekin Jaise aapane pencil select kiya tha to pencil chahe Jahan likhoge turant mines ho ja raha hai lekin jab koi Anya chij likho jise banana hua to mines nahin ho raha hai vah jo uske samne jab likho tabhi mines ho raha hai
jaise maine bataya aapne formula jab lagaya tab apne range sahi se select nahi ki hai. Aapne jo formula lagaya aap mujhe uska Screenshot insta par bhejo mein apko waha corract karta hu.
agr 10 item h uska Maine aapke tarah bna liya sabkuch kr liya formula sb set kr diya 10 no tk agr baad me aur 20 ya 50 item aayega to kaise sare item aur formula set krenge
Watch latest video about stock management - ruclips.net/video/sejct_QtmOs/видео.html
Need ur help sir...
Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
0:42 0:43 0:44
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM
Please make one like I mention Below:
1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION
Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return )
2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
Aapka trika bhut acha hai smjhane ka bhut eazy way se samjate ho aap
कल मुझे इन्वेंटरी की सीट बनानी है और ये वीडियो मेरे लिए बहुत हेपलफुल होगी।। धन्यवाद ❤
Bhout acha bataya hai bhai
Bhot sahi yrrrrr great knowledge
Bhàiii bht achhi vedio thi
excellent. Actually, I opened a small business and I really need this type calculations.Best wishes from Kapurthala, Punjab.🙏
Thank you very much for your valuable information!
Thank you so much it really helps
Plz help me with the formula for data extracted from the two drop down menus, if I have a purchase something from a vendor and there are 5 vendors in my list and there is a drop down list of items also so from the item dropdown list and from the vendor dropdownlist how can I extract information of one item and a particular vendor
Only u are best youtube
I really appreciate,
nice explain.
thank you 🙏
Very useful sir , Thanks for the information
Thank you sir this video very helpful ❤️👏
Bahut achha laga sir
Use Full Video thank you Sir
Kya ismein closing balance aur opening balance jod sakte hain
Thx❤
Good work Easy giddiness.🥰
Finally found formula here.. thank you so much bro
Thank you so much I don't how can I I tell you these is very useful to me..
Bhai bht zbrdst 👍👍
SUPER BHAI
Isme party ka nam ad kar sakte hai kya
Actually it's add real value brother
according to name, how will you do it?
Jaise Alex John mickle ko kitni stationery items diya
THANK YOU FOR YOUR VALUABLE VIDEO
thank you sir ek number 🎉😊
Which battons is pressed after "sumif" >then choosing the range?
Thank you it's help for me
Usefull knowledge
Sir drop down me 150 item ho to frist letar vais item aa sakta he ki 150 item aayega..
I did it very helpful sir, Thanks 👍
great work
Sir one question agar koi new item aati hai toh usko list me add kese krenge jisko arrow ko click kr k shortcut me ajay
I looking part number before goods name .. how i can picked both without repition
Good Morning sir,
Muje apne factory k production(sweet/namkeen) ka stock maintains karna hai. Humare pass software hai but ek manual data humare pass rhe day wise cross check k liye uske liye apka help chahiye.
Sir it is super very simple but every small business people can use this kind of excel report thank you so much
One more pls tell me how enter invoice wise stock out report please help me
It actually helps full nice
Very helpful 👌
Best teaching skills ….
Thanks Sir, the video is very helpful.
Sir agar mere pas 100 item hai maine sab par formula laga liya uske bad agar mujhe usme aur item jodna ho to
Nice jankari
Ye in out hua agar mere pas opening stock hai to wo is sheet mai kaise ad kar sakte hai
Thank sir for making this type video
Sir inward range main first letter likhte hi stock select nahi jota plz tell me how to select in short cut because we have 1000 stock item it is very difficult to find by mouse click or scroll
Thank you so much bhai
Sir or assan tarika batiya..hum to sirf Excel khol sakta hee ji...stock sheet.. important hee
Sir ya to samaj aa gaya haa lakin iski jagha pa hamara pass agar outward ma 4 location ho to tab hamari sheet kasa banagi or calulation kasa hogi
Use full video
Asslam Alikum sir video is very nice and very helpful sir ak cheaz pochne hay ky balance stock alag sheet per a Sakta hay
Wa alaykumu s-salam, ji aap kar sakte jaise waha formula lagaya hai waise hi kisi dusri sheet par laga dijiye
@@Excel4Freshers thanks
Stock outward row me formula kese add karna hai
You tube यूट्यूब मे आकर कुछ नई करने चाहने वालों दोस्तों एक दूसरे को सपोर्ट करो
HOW TO LINK THIS TO OUR INVOICE WHEN WE SALE OR PURCHASE STOCK CAN THIS SHEET AUTOMATICALLY UPDATE.
Super bro❤
Thank u Sir..✍️🤲
Agar isme ek colam or aad kre to kya fir bhi aase hi work kre ga kya
Ji haa karega
Thank you sir😊😊
I want this month date, data sheet, sale data ,profit and loss data one product for tea powder PlZ help
Videos is excellent but how will be add Opening stocks after closing of Month
Watch this video - ruclips.net/video/sejct_QtmOs/видео.html
Opening, received,despatched and balance ka stock batsiye
Thank you 😊
bro I have 30 iteam 24 iteam automatically formula working after 25 row formula not working on your file pls help me how do fix
very help ful video thanks sir
Thank you for this vdo
Thanku sir ❤️
Inward stock outward stock tatha balance stock ke sath ismein opening stock aur closing stock bhi dikhai de tatha rank number bhi mil jaaye to bahut achcha ho jaaye
Sir excel ke andar possible nahi hai. Ek free software hai uske upar humne video banaya hai. Iss software main hum dekh sakte h
Thank you bro
Very very good🎉
Nice sir
Thanks
Sir loss profit v ish me add kar dijiye or ek video banaiye please
Every month we need to make new sheets r ww can use only one
You can use sheet for entire year
I'm watching the video at the moment
Very nice thank you
as fresher in this should i go with storekeeper job ..
any what topic r should in storekeeper job can u plz describe ..
and for store keeper job what computer skill require as friesher in entry level can u sa it will be grt help for me ...
thank u
Storekeeper has to deals with inward, outward of stock, availability of stock, also knowing which particular item was more demanded and which item not are not transact.
Some companies have their own software for stock management however if company using any software you can use excel.
Dear Sir , Nyc video and wonderful explain in this but kindly please let me know how to apply formula in (Microsoft office app) Mobile
Thanks bhai
The link you have given perfectly but I'm facing a problem with opening stock
Agar hr din hmare pas 3-4 nye item aate ho to ise drop down me add kese krenge
sir, kaun sa item kaun godam me hai ka pta kaise lagayenge.
Thankyou bhai
Sir school mai adm fee and hostel transport fees ya sub hai to iska exel mention keise kare please help sir
Watch this - ruclips.net/video/L2ktErHgTsQ/видео.html
Nice very helpful
Aese hi e-will per ek video bana dena please sir
thanks broo...
Sir is hi list mein profit or loss wala columns kase add karain gay aur ye kase work karain gay .plz reply me
Excel Format's and their Working: ruclips.net/p/PLTY9Qq888nq6Z5T9VPC-BkdQ_GK-u2qOS
Check our playlisy
Thank You Vinay. I will check it will feedback you
Thanks sir❤
I make this excel sheet as u guided in video but facing some problem..in balance column first five six cells working with formula remaining not working... How I can solve this
Copy that formula and paste it to all remaining columns where u r getting issue
Sr mujee helf chiye aapka ye shit mene aapne ye sit aapne Excel me khola hh mujee kuch problem aarhi h jha item add krte h net stook me oha pr all item add nhi ho rha h drop box me nhi aarha h
Kya aap meri helf kr sakte h
Sir place order bhi sath me bta dete to bahut achha hota
Hlw bro ye jo aapne btaya hai ki pencil khi bhi likhe ya calculator khi bhi likhe stock minus ho jayega lekin aisa ho nhi rha hai
Isme Jo jha likha hai uske samne vhi chiz likho tb minus ho rha hai
Apne formula sahi nahi lagaya hoga aap ye video dekho Karo step by step bataya hai ruclips.net/video/eyX487HrXFE/видео.html
@@Excel4Freshers bro aapke bat sahi hai lekin Jaise aapane pencil select kiya tha to pencil chahe Jahan likhoge turant mines ho ja raha hai lekin jab koi Anya chij likho jise banana hua to mines nahin ho raha hai vah jo uske samne jab likho tabhi mines ho raha hai
please reply
jaise maine bataya aapne formula jab lagaya tab apne range sahi se select nahi ki hai. Aapne jo formula lagaya aap mujhe uska Screenshot insta par bhejo mein apko waha corract karta hu.
I need course for my team is it possible
Opening stock kese incres kare bhai
Sir stock work ke tafsealin video baney ❤❤
जो सॉफ्टवेयर खरीदेंगे वह सॉफ्टवेयर है या यही है क्योंकि मुझे खरीदना है plz
Sir ek colum ka balance stock nhi cnfirm ho rha hain
Good
agr 10 item h uska Maine aapke tarah bna liya sabkuch kr liya formula sb set kr diya 10 no tk
agr baad me aur 20 ya 50 item aayega to kaise sare item aur formula set krenge
Thanks 👍❤sir