Stock [ Inventory ] Management in Excel - Stock Maintain in Excel ( Hindi ) - Stock Register
Vložit
- čas přidán 14. 02. 2021
- 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.com/stock-inve...
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
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)
czcams.com/video/vN9UtZYyfRw/video.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
This is what I looking for since long time... Thanks for the problems solved
The best teachers teach from the heart. Thank you for all that you do!
Absolutely great explanation! Even though do not speak/understand your language, was able to do this just by watching. Clear and well.
No words to describe your talent. Simply you are a genius.
Sir, what a strong memory. Ek daam jhakaas.
👌❤️🙏
It's really helpful for the small industries. Thank you so much for sharing this wonderful inventory stock software making process. Thank you again 🙏
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.
This is excellent work. Keep it up. Looking forward to more such videos.
This is really awesome. I can't explain how much I enjoyed this video tutorials. Thanks for doing your excellent explaination.
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.
very important and your demonstration make it easy!!
Great Lesson ..
Just request your help for auto matic stock control for an offset Printing Press🙏👍
*Appreciated Thanks, Not just Best Teacher,... Valued Teaching Experience*
Sir, very nicely explained by you, even a fresher in Excel will become a champ with some practice
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)
czcams.com/video/vN9UtZYyfRw/video.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.
Welldon sir jee .... Super....God Bless you.....Shabir -Dubai...
Thank you for detailed and nice explanation. You teach in very easy ways.
A brilliant way to describe it, Hats off, Deepak ji.
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 chapter is really awesome. Any one can learn easily how to make Macro Enabled Work Book in Excel sheet through your unique way of presentation technic and vast knowledge in Excel indeed. Thank you very much Deepak Sir
In stock , every time I apply advance filter, it shows "extract range has a missing or invalid field name". Please help me out
Inventory Management Fully Automated || Warehouse & SME stock Management (Urdu/Hindi)
czcams.com/video/vN9UtZYyfRw/video.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
Inventory Management Fully Automated || Warehouse & SME stock Management (Urdu/Hindi)
czcams.com/video/vN9UtZYyfRw/video.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
Super se bhi uper Sir... Unbelievable solution.. You made an inventory software out of excel.
Great knowledge... Hats off 👌👌👏👏👏 keep it up 😊
thanks big bro.😊your explanationis IMPECABLE and WORD PERFECT.
you are great bro
Love from Pakistan
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.
Very nice sir Sab acche trha Se smjaya Aapne thankuu
I highly appreciate your knowledge of Excel. Please note one thing. The seller will be purchasing items from various suppliers,/manufacturers, so we cannot maintain a serial number for the billing of any particular item. We need to enter the bill number and the supplier's name from whom we have purchased. So there is no relevance in maintaining a sequential number for the purchase of a particular item say Mouse in your illustration because there are Mouse sold from several brands and also the rate of each brand would be different. HP may cost you Rs. 200/- and another top brand may cost you Rs. 250/-. So create a Database example based on various brands, Item codes, that would give us an average price of each item and then how to fix a sale price for it adding the profit @ a particular %. Further, a trading unit can maintain the serial number of the invoice raised for sales and your idea of getting the last sales invoice number is correct. Please modify your tutorial to include the following; Make a separate form for Purchase Entry, and a separate one for sales entry the stock should sort on the basis of brand and item code and give an average rate to fix a sale price after fixing the percentage of profit for it. Thank you
Excellent explanation. Hats off to you sir, for sharing your knowledge and helping many of us learn excel. Our best wishes with you and keep up the good work.
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 CZcams tutorial videos about trading I am still making losses, please I seek for a better website.
Great, & thanks as well,
when u share something precious for public good, it makes you precious too... ❤️
Sir you are absolute. Your sheets really help me a lot. Thank you so much.
BRILLIANT
Sach me sir bhot jyada dimak lagaya h sir bhot.. sab se jyada "stock not available" o my god.. 🥰🥰
Very simply explained. Good Knowledge.
Absolutely great. This is what I was find.
Please show how to manage monthly sale and purchase in this format
Please make a tutorial of the stock Register. I am sending you a picture of the stock Register please.
Great sir ...heads off...bhut bdia ..speechless
Hlo sir
Apke video Bhot achi ha
Or Bhot kuch Sakhna ko mlta ha
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 😂
Bhaiya, Bahut badiya. Thanks.
Sir this stock inventory video is very nice your explanation is to good it's amazing....thank you
sir how to enter more than one item in a single purchase?
Sir automatic balance sheet ka formula बताइये . Opening, closing balance automatic next years me आये
Un unbelievable, Excellent experience. Amazing, thanks
Super knowledge sir
I am really impressed and also learned from your this video
Thank u so much
Generally many items comes in a bill how to record 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
Excellent, awesome and very helpful bro. Thanks for this tricky video. God bless you.
Unbelievable Boss tussi Great ho.
Hello Sir, your software is absolutely amazing but im facing an issue while making it. In the advance filter time after doing everything at the end there is an error message popping up which says " The extract range has missing or invalid field name". Sir could you please help me out with this? I am not being able to complete my software because of this error.
I ve got the same thing
Remove the filters from purchase and sales sheet
I have got the same error pls give any solution
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
a VERy GOOD USE OF ms EXCEL Mainly for retail shop......or small enterprise
Thank You Respected Sir 🙏,
From my present position, it's very helpful for my work venue.
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
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 🙄
NICE WORK.ITS REALLY VERY HELPFUL.
EKDAM SAHI KNOWLEDGE BOSS
hey bro, I can't Download Stock Sheet .please helps
Whtsapp number dijiye stock wali sheet send kar du
Profit and loss v rhta to or batter hota❤️
sab tere ko free me denge bhai .....................
Bhut Shandar sir ❤
So helpful. Thank you
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
The extract range has a missing or illegal filed name. Error ? How to resolve.?
Pls select all range in advanced filter with heading row
I did everything but not resolved kindly help me out
@@DeepakEduWorld contact no.plz
@@fwmpc1859 bhai aapne stock wali sheet ki item ki heading same hona chahiye purchase wali sheet ki item ki heading se , tb ho jayega
@@DeepakEduWorld Can you please elaborate on this part further, I keep doing it but not working for me.
Awesome. Excellent. God bless you brother.
Sir it's very useful for stock maintenance in our store. Thank you 🙏
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
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👍
Bhai aap ka excel knowledge kamal ha
Thank you so much sir
You have done great job 👍
It's very helpful dear, thanks
It was really helpful
Nice, mind blowing video.
Superb vdo bro
THANKS FOR ULOAD Stock & Inventory Management In Excel Template ❤❤❤
Bhot Shandar vedio hai Bhai well done
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
Really very useful and Good knowledge
Very Good information. Thanks a lot
Very informative sir❤
Great learning 👍
Very nice class/teach
Excellent sir thank you so much
Superb and very well explained
Thank you sir your video help me a lot
As always perfect✌👍
Thank you so much helpful
Thank you Deepak
thank you it was great
Thank you Brother 🙏🏻
THNX THIS WILL HELP ME
this very nice tutorial platform i liked your channel
Just awesome...
Thank you so much sir you are excellent 😍😍
Thank you for helping Sir
Bahut mast 😊 thanks a a lot . You are good teacher .
It helped me so much
Thanks a lot
keep it up
Good work
Thanks bro format ky lya
Thank You Brother