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
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
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.
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
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
Thnku sir , actually mujhe puchna tha sir aap ek video bna do jisme kgs and GM's me stock aata h in and out hota h morning and evening ke hisab se wo sheet kese bnegi ....
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
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
Thanku sir very helpful video h....pr sir hr baar kaam krne ke baad sheeet save krni pdti h or is Karan kaaafi sheeet save ho jati ,..iska kya solution h ki hm ek hi sheet me baar baar kaaam kr sake plz reply me
Bhai if I reduce quantity from stock out it's not reducing in the balance stock ..same row it's happening ..diff row it's not working how to fix that ..pls help !!
Yes you can do so, When we create item list, we can add short name, digits as prefix (e.g IN-01 denotes 1st item, IN-02 denotes 2nd item and so on). When we type IN-01 it's show IN-01 item name,
Sir Aapne kafi achi balance sheet banayi hai lekin Jab Aur Saman purchase karenge to use balance sheet main kese update karenge. Per day sheet kese kare day by day. Please make video
@@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.
Watch latest video about stock management - ua-cam.com/video/sejct_QtmOs/v-deo.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
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
I really appreciate,
nice explain.
thank you 🙏
Thx❤
Thank you sir this video very helpful ❤️👏
Bhot sahi yrrrrr great knowledge
Only u are best youtube
excellent. Actually, I opened a small business and I really need this type calculations.Best wishes from Kapurthala, Punjab.🙏
Very useful sir , Thanks for the information
Bhàiii bht achhi vedio thi
Thank you so much I don't how can I I tell you these is very useful to me..
Good work Easy giddiness.🥰
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
Bahut achha laga sir
Bhout acha bataya hai bhai
Isme party ka nam ad kar sakte hai kya
SUPER BHAI
Use Full Video thank you Sir
Thank you it's help for me
according to name, how will you do it?
Jaise Alex John mickle ko kitni stationery items diya
thank you sir ek number 🎉😊
Finally found formula here.. thank you so much bro
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
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
Kya ismein closing balance aur opening balance jod sakte hain
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 agar mere pas 100 item hai maine sab par formula laga liya uske bad agar mujhe usme aur item jodna ho to
Which battons is pressed after "sumif" >then choosing the range?
Actually it's add real value brother
I did it very helpful sir, Thanks 👍
Sir drop down me 150 item ho to frist letar vais item aa sakta he ki 150 item aayega..
Videos is excellent but how will be add Opening stocks after closing of Month
Watch this video - ua-cam.com/video/sejct_QtmOs/v-deo.html
Thanks Sir, the video is very helpful.
I looking part number before goods name .. how i can picked both without repition
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
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
Ye in out hua agar mere pas opening stock hai to wo is sheet mai kaise ad kar sakte hai
Bhai bht zbrdst 👍👍
You tube यूट्यूब मे आकर कुछ नई करने चाहने वालों दोस्तों एक दूसरे को सपोर्ट करो
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.
जो सॉफ्टवेयर खरीदेंगे वह सॉफ्टवेयर है या यही है क्योंकि मुझे खरीदना है plz
Dear Sir , Nyc video and wonderful explain in this but kindly please let me know how to apply formula in (Microsoft office app) Mobile
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
Sir very good information but sir opning stock kase dala
The link you have given perfectly but I'm facing a problem with opening stock
Opening, received,despatched and balance ka stock batsiye
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
It actually helps full nice
Super bro❤
THANK YOU FOR YOUR VALUABLE VIDEO
HOW TO LINK THIS TO OUR INVOICE WHEN WE SALE OR PURCHASE STOCK CAN THIS SHEET AUTOMATICALLY UPDATE.
I want this month date, data sheet, sale data ,profit and loss data one product for tea powder PlZ help
I need course for my team is it possible
Sir or assan tarika batiya..hum to sirf Excel khol sakta hee ji...stock sheet.. important hee
great work
sir, kaun sa item kaun godam me hai ka pta kaise lagayenge.
Very helpful 👌
Sir, how to find excel sheet format..Ples..provide..
New video - ua-cam.com/video/eyX487HrXFE/v-deo.html
Iske discription box mein apko sheet ka link bhi mil jayega
Best teaching skills ….
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
Usefull knowledge
Thnku sir , actually mujhe puchna tha sir aap ek video bna do jisme kgs and GM's me stock aata h in and out hota h morning and evening ke hisab se wo sheet kese bnegi ....
Kg ko gms mei convert kigiye
Thank sir for making this type video
Every month we need to make new sheets r ww can use only one
You can use sheet for entire year
Agar hr din hmare pas 3-4 nye item aate ho to ise drop down me add kese krenge
Agar isme ek colam or aad kre to kya fir bhi aase hi work kre ga kya
Ji haa karega
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 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: ua-cam.com/play/PLTY9Qq888nq6Z5T9VPC-BkdQ_GK-u2qOS.html
Check our playlisy
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
Thanku sir very helpful video h....pr sir hr baar kaam krne ke baad sheeet save krni pdti h or is Karan kaaafi sheeet save ho jati ,..iska kya solution h ki hm ek hi sheet me baar baar kaaam kr sake plz reply me
Kon sa version use kar rahe ho excel ka, and sheet apne khud prepare ki hai?
Thank u Sir..✍️🤲
Bhai if I reduce quantity from stock out it's not reducing in the balance stock ..same row it's happening ..diff row it's not working how to fix that ..pls help !!
range sahi se select nahi ki hai,, range sahi se select kro tab sheet proper work karegi
Use full video
Nice very helpful
Aese hi e-will per ek video bana dena please sir
Sir school mai adm fee and hostel transport fees ya sub hai to iska exel mention keise kare please help sir
Watch this - ua-cam.com/video/L2ktErHgTsQ/v-deo.html
I have 250item zc but when i want to inward. It will difficult to find items, send me filter setting formula in this sheet, in inward
we can use filter formula for a single cell, not on entire sheet. I work on it and as soon as possible i will share the same.
Nice jankari
Very very good🎉
Sir ek colum ka balance stock nhi cnfirm ho rha hain
Cliyr btaya kro na sir formule ko apne se typ kr dete ho
Koun sa tayp use kiye pta hi nai chal pata confusion formula
Sir i need customized stock sheet. I am tea manufacturer. Pls help
Thank you for this vdo
Sir yadi balance me pahle se opening stock ho tab
Sir loss profit v ish me add kar dijiye or ek video banaiye please
Dear Sir, Is it possible to add 3 digit Search Criteria for the selection of items while entry of item in purchase as well in sale. Kindly reply.
Yes you can do so,
When we create item list, we can add short name, digits as prefix (e.g IN-01 denotes 1st item, IN-02 denotes 2nd item and so on). When we type IN-01 it's show IN-01 item name,
Sir formula ko age kaise badhayenge
Thank you sir😊😊
Sir Aapne kafi achi balance sheet banayi hai lekin Jab Aur Saman purchase karenge to use balance sheet main kese update karenge. Per day sheet kese kare day by day. Please make video
Please excel link dubiye.
very help ful video thanks sir
Sir size wise stock kaise maintain kre please is par ek video bnao
Agar 50 items ki row bni h to formula sirf 50 row tk hi working kr rha h
Sir place order bhi sath me bta dete to bahut achha hota
How to edit the drop down list sir?? plz help
Thank You Vinay. I will check it will feedback you
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 ua-cam.com/video/eyX487HrXFE/v-deo.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.
Sir ye tho serial wise hi Kam Karta hai data upar niche Ho jaaye to uski entry nahin kar pata