Stock [ Inventory ] Management in Excel - Stock Maintain in Excel ( Hindi ) - Stock Register
ฝัง
- เผยแพร่เมื่อ 16 ต.ค. 2024
- Stock [ Inventory ] Management in Excel - Stock Maintain in Excel ( Hindi ) - Stock Register In this video you will learn how to manage stock in excel with inventory management - If you need to maintain stock in excel then this Fully Automatic Stock register will help you to manage sale, purchase and inventory of stock. You can use this as Stock register format in excel to maintain your automatic stock report.
Download Stock Sheet : deepakeduworld...
MS Word Home to View Complete Tutorial : • Microsoft Word A to Z ...
MS Power Point Home to View Complete Tutorial : • MS Power Point Tutoria...
My New Channel : bit.ly/3qFrbl5
Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
Vlookup Complete Tutorial : bit.ly/2K0C1Sb
#StockRegister
#StockManagement
#InventoryManagement
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Thanks for watching #deepakeduworld
Your Excel knowledge is unbelievable dear brother you rock your every trick video and your way to teach is excellent and can't describe with words . Awesome and brilliant way . God bless you dear ❤️❤️
🤗🤗🤗
Awesome video bhai👍👍👍
@@DeepakEduWorld please answer my questions too
Bhai Aap nay jawab nahi diya
@@Vinu9484 h
Super se bhi uper Sir... Unbelievable solution.. You made an inventory software out of excel.
Great knowledge... Hats off 👌👌👏👏👏 keep it up 😊
I am from Pakistan first time i watch a channel which is quite superb for good learning , lots of love sir
Your knowledge is excellent. Sir I want to know that if my sale quantity is more than purchase quantity, then it should not allow the entry. For this what formula I have to apply in sale quantity.
No words to describe your talent. Simply you are a genius.
This is PURE value. So much respect to you! Eduction without cost is the highest of all possible gifts. Thank you!!
In stock, every time i aplly advance filter , it shows "extract range has a missing or invalid field name". I have tried everything, Please help me out
Inventory Management Fully Automated || Warehouse & SME stock Management (Urdu/Hindi)
th-cam.com/video/vN9UtZYyfRw/w-d-xo.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
Same here
Dear Deepak Sahab i created my stock register according to your step by step instructions with some new changes and found working properly.Thanks a lot sir.It is really very help full
for me.Thanks once again.
mujhe ek problum face krni par rhi hy is me jab stock par advance use kr rha ho to wo stock nhi show kr rha
@@pakistannews1065 آپ اپنا مسلہ مکمل طور پر بتائیے تاکہ پھر کوشش کی جائئے
Nice Deepak
Ek invoice me agar 1 se jyada item ho to uski entry kaise karenge.
Please is topic par zaroor video upload Karen.
Haa pls batao
This is what I looking for since long time... Thanks for the problems solved
Sir can you please suggest me a better way to maintain my stock
Hello sir....I followed every step very carefully and made a wonderful maintenance sheet...I am really happy and very very thankful to you sir....your teaching skills are so amazing and good knowledge of the subject...thank you so much again for this kind of awesome videos...
🤗🤗🤗🤗🤗🤗
Bhai mujhe mail kar do... Mere se error a rahe... Bani hui
How do you save the software. I complete the software but when I try to save the software it doesn't save. After closing the worksheet it doesn't work. What should I do now.
Inventory Management Fully Automated || Warehouse & SME stock Management (Urdu/Hindi)
th-cam.com/video/vN9UtZYyfRw/w-d-xo.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
@@prashantyadav6814 aghr bhai tumhy mili ha tu mujhy bhi kar doo
mere pass bhi error aa raha ha.
Starting early is the best way of getting ahead to build wealth, investing remains a priority. The stock market has plenty of opportunities to earn a decent payouts, with the right skills and proper understanding of how the market works.
Venturing into the bitcoin without an adequate orientation with a professional broker for accurate signals, you might lose all your hard-earned money
Binary trading is a good and reliable way of building wealth which also create opportunities for crypto Believers.
You see in trading cryptocurrency, one requires more than just a primary knowledge of crypto. It is best to trade with an expert to avoid unnecessary losses. It's advisable to have a professional trader/broker who is an expert in the field to help you manage your account.
I'm into Real Estate, but I took the decision to invest in the Crypto market and I have been getting good returns on my investments. The market is also an effective way to grow wealth.
After watching several TH-cam tutorial videos about trading I am still making losses, please I seek for a better website.
Sir this stock inventory video is very nice your explanation is to good it's amazing....thank you
Sir, what a strong memory. Ek daam jhakaas.
👌❤️🙏
Sach me sir bhot jyada dimak lagaya h sir bhot.. sab se jyada "stock not available" o my god.. 🥰🥰
Super knowledge sir
I am really impressed and also learned from your this video
Thank u so much
very important and your demonstration make it easy!!
Boss, this is great. We want more from you such as inventory ABC classification. keep it up. It was enjoyable, quick and short cut. Thank you.
Thank You Respected Sir 🙏,
From my present position, it's very helpful for my work venue.
Sir but ek sales k bill me 2 ya 2 se jyada items b to sale kr skte hna wo kse ho payega sir isme..
Any reply please?
Tally prime 😂
Even if I don’t know the language, I understood the tutorial. Thank you for sharing us your skill. If you have the English version, please share us. It very useful.
Is it a good idea to have a stock broker in Uk?
Great Lesson ..
Just request your help for auto matic stock control for an offset Printing Press🙏👍
Stock list (The extract range has a missing or illegal field name ) problem hai item stock nahi ho raha hai
Same problem
the extract range ...aur stock ma jaha copy karn ha un dono coloumn ki heading same honi chahiye tabhi advance filter aplly hga
@@ALI-mb2zu bhai kaise hoga nhi ho pa rha
I think you move your column to another cell or did changed something
The extract range has a missing or illegal filed name
Ye problem aa rahi hai baar baar
Absolutely great. This is what I was find.
Please show how to manage monthly sale and purchase in this format
Hello, Deepak, video is nice, but at 22:30, I am getting an error that says "The extract range has a missing or invalid field name", I have cross-checked everything on the purchase sheet, and everything seems quite fine, can you please let me know how to fix that?
Thanks in advance.
yes mee too
Same
Koi solution Mila
Koi solution mila
Same situation 🙄
bayya i'm in hyderabad i followed every videos its very usefully to us thanks bayya , its no words to say thanks mera dosthe deepak vande matram, bayya ji
A BIG thank you for the wonderful video on stock inventory systems development. I have been looking for one such as this. This is very useful. However, the "sale entry" accepts items which are unavailable in the purchase list. Under such circumstances, the "stock' table does not show the items entered in the "sales entry" table which were not recorded in the "purchase" table. Hoping to see any options to deal with such case.
Yours sincerely
Dear sir same problem stock table dose not show the items entered in the sale and purchase entry table which not records in the purchase table please suggest me
There can be a logical condition applied here. Wherein no new items can be entered in sales entry. Let's see. Il play around and find it.
While making stock sheet...how are u removing filters from item, P qty, and S qty...
When I am making it , it's not getting through..pls help
Not working
Hi, Deepak Can you help me with one Excel format with Automated Stock Inventory and Sales Invoice
this is good but not easy... make product add by name rate qty and stock show up by category and the same as sale sheet when we sell product then reduce item from stock and sale rate show with profit... i have make my own sheet large num of product.. sale invoice , dues & proft loss but i learn from this video how to make automatically product added.. thanks
sir how to enter more than one item in a single purchase?
a VERy GOOD USE OF ms EXCEL Mainly for retail shop......or small enterprise
No doubt it's helpful, but when we have to sell multiple products to a single customer we have to enter details twice and also recorded in two different rows in which it's difficult to calculate total amount of bill in a single row. Looking for your best solution . Thanks in advance.
yes, your point is legitimate.
Yes it is a valuable question. Please sir make another video about it with profit and loss
Please make a tutorial of the stock Register. I am sending you a picture of the stock Register please.
excellent video.... true handheld video. thank you very much... radha radha....
Radhe radhe
BRILLIANT
Generally many items comes in a bill how to record it.
Un unbelievable, Excellent experience. Amazing, thanks
Profit and loss v rhta to or batter hota❤️
sab tere ko free me denge bhai .....................
The extract range has a missing or illegal field name.
Sir ye error aa rha hai.
sir mera v
sir nhi hi raha hai
Mera b same error a rha kindly do something
bhaiya tm hara heading or criteria .check kar na ho jayega. mera ho gaya abhi
I also missing
Superbbb 🙏🙏🙏
Sir kuch query rahegi to plz contact kaise kare
Sometimes I really wondered how people make this huge profits investing on the stock market online, I agreed with you investing and earning is a legitimate way to gain financial freedom, but how is it done?
Anyone who has traded cryptocurrency is well aware of how the volatile the market can be
If you're not a day trader and don't wanna be hit by massive drops, diversification may be a good option for you
When discussing crypto diversification frequently asked question is whether diversification is even possible
Because the majority of stock market have some correlation to Bitcoin, they argue that investing in Bitcoin is not a true diversification strategy
@PRlNCĖ D0NÑÊLL🔛 You just hit the point there bubby👍
Hlo sir
Apke video Bhot achi ha
Or Bhot kuch Sakhna ko mlta ha
Sir video is vary vary nice super
But is main Day wise summary add ho Jaye to best rahega
Jaise opening stoc Qty and amount,sell Qty and Amount,and bal Qty and
Thank you for detailed and nice explanation. You teach in very easy ways.
Great sir ...heads off...bhut bdia ..speechless
Excellent, awesome and very helpful bro. Thanks for this tricky video. God bless you.
You are awesome bhai, tumhara waja se mujhe kuch naya sikne mila or ye mere kam v ayega... Thank you🙏 Dil se vai
Bhai aapka video mere liye bohot useful Raha
Bas ek chiz batadijiye yaha se profit/loss kaise nikale
Best explaining so far on youtube
Please also show sale purchase accounting and totals and difference and profit loss etc
thanks big bro.😊your explanationis IMPECABLE and WORD PERFECT.
your inventory management Excel with macros is awesome and superb, but I can't use as we have different types of inventory, please advise me for customisation.
*Appreciated Thanks, Not just Best Teacher,... Valued Teaching Experience*
hi Deepak how are you, thank you for your giving us the best knowledge I am from Pakistan, and I have a problem, there are a lot of videos for stock inventory, but I never find Stock inventory for manufacturing units, From raw materials to finish Goods, For example, I have 3 employees I am giving them raw material and they are giving me finish product how can we deduct raw material by finish goods when they give it back, and how to maintain my stock inventory left with my employee and in my warehouse hope you will resolve my issue i am much needed this time
But apke iss channel se mujhe bohot hi accha hua
Lovely. लॉजिक, ऑप्शंस, फॉर्मूले, स्टेप्स शुरू करते समय बैकग्राउंड बताओ और धीरे धीरे आगे बढ़ो। I learnt a lot 😀😀
Very nice sir Sab acche trha Se smjaya Aapne thankuu
You are a good teacher bro.
Such A Brilliant Teaching
Sir you are absolute. Your sheets really help me a lot. Thank you so much.
NICE WORK.ITS REALLY VERY HELPFUL.
Good job i don’t know Hindi but I understand you r teaching knowledge 🎊 🎉👏👏👏
Bhai aap ka excel knowledge kamal ha
THANKS FOR ULOAD Stock & Inventory Management In Excel Template ❤❤❤
Very Good information. Thanks a lot
Awesome. Excellent. God bless you brother.
A brilliant way to describe it, Hats off, Deepak ji.
Great, & thanks as well,
when u share something precious for public good, it makes you precious too... ❤️
Thanks for this great video i was able to create & customize stock management according to my needs but still facing issue in last billed. I want program to show the last entry date in purchase and sale option....what i do?
Thank you so much... practically done successfully
Thanks a lot
👍
hello we talked?
Sir it's very useful for stock maintenance in our store. Thank you 🙏
Bhai u r excellent
Apka video mere bohut kam aya
Mere dukan ke liye ek stock n sales sheet banana tha
Up agar help kor dete to bahut upkar hota
Apke sath communicate kyase kare
Sir, very nicely explained by you, even a fresher in Excel will become a champ with some practice
It's amazing but one thing I have seen and that thing is that when put an entry of sale of an items that you haven't purchased before, it works and that items stock should be shown as negative in stock sheet but actually in stock there is nothing show up
I think this one thing that you should improve in this sheet
Thanks
Really very useful and Good knowledge
Sir i have a curtain shop please guide me to maintain stock, i sell curtain and cloths both.
(a)Gate curtain made 2.5m
(b)windows curtain made 1.5m
Suppose that:-
1. Cloths is 50Meters
2. 5pic of gate curtain sellout.
3. 3pic of window curtains sellout .
4. 5meters cloths is sellout.
5. 2 pic gate curtain is return.
1 - What is rest stock ?
2 - how much profit ?
Pease make a video on this how to create sheen on this table.
Very simply explained. Good Knowledge.
Sir aap bahut achchha vedio dalte hai youtube per..
Bahut mast 😊 thanks a a lot . You are good teacher .
My boss impress by me only for you thankyou so much sir
Hi
Sir you are great. Its verry help full.
I watched this video of yours. It was very important for my store. If possible, can you send me a link. The initial balance is added to the purchases and the balance is deducted from the issuances. Thank you very much for an excel video. I am sri lankan kenek i am saman
deepak bhai i'm from andhrapradesh i have been watching your videos for 1 month
the information you have given is awesome
however, I have a doubt currently I'm using Excel Windows 2007 version so does this advanced version work on my computer or not please let me know
Thanks excellent sir
Itna to kisi institute m bhi nhi sikhate h bhai great Work 👍 Thank You Brother
SUPER AWESOME CAN YOU PLEASE TELL HOW TO CREATE ANOTHER PAGE IN THIS WORKBOOK WHICH SHOWS STOCK OF AVAILABLE ITEMS ONLY ?
Sir, Thankyou very much to make me understand the use of VLOOKUP. Further, I had prepared same excel like you taught and added a coloumn "Unit" . How can i pull the text of unit automatically in Stock sheet corresponding to item in Item coloumn.
King of Excel user 🙏🙏
Very useful way of teaching
It helped me so much
Thanks a lot
keep it up
Good work
Very useful video sir
Aap ke clothes shop ke liye video banao jisme
1 sale
2 parches
3 stock
4 gst
5 margin
6 profit
7 item code
8 date
In sabhi ka option ho
gajab brother gajab
Nice Video Sir...explained very well. I have a question, the formula what we have apply on column E which says if the sales qty is more than available stock it's says "Stock Not Available" but for new item which is not at all available in available stock for that it's not alerting insted it's simply taking as a sales..could you plz advise how to add the formula which says if new items is selling it should alert the same way how it alerts if we sell more qty. Thanks and God Bless you.
Aapki Teaching Skill Acchi hai Sir...
आदरणीय दिपक सर, मैने आपका विडियो देखा, देख कर बहुत अच्छा लगा। इस विडियो मे बहुत सारी ज्ञान की बातो का विवरण दिया गया हैं जो की एक नौ सुखिये के लिये बहुत ही अधिक उपयोगी हैं। आदरणीय दिपक सर, मेरा आप से नम्र निवेदन हैं कि आप इसमें क्र्य - वापसी(purchase return) and Sales return (विक्रय वापसी), बिल तैयार करना तथा इसकि प्रिन्टिन्ग आदि को कैसे कर सकते हैं, यदि आप इन बातो का विवरण देते है ,तो मुझे बहुत ही अथिक खुशी होगी तथा मै आपका बहुत-बहुत आभारी रहुँगा। आपकी प्रतीक्रिया के इंतजार मे। मनोज कुमार नागले।
Thank you so much manoj ji.. mere video aapke kaam aate hain ye jaan ke bahut accha lagta hai or bahut sara motivation milta hai aur acche videos banane ke liye… is video ka 1 or new version jaldi aayega bas thoda sa intzar karen aap 😊
सर,मै चाहता हुँ कि आप इसमे purchase and Slaes कि bulk में entry कैसे करे इस बात का विवरण भी जोडो@@DeepakEduWorld
Fabulous and wonderful video.
Excellent performance 🎉🎉🎉🎉
Very helpful in my job sir ❤