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 ❤️❤️
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
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...
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.
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.
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.
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.
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.
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
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.
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
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?
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
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
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
This tutorial is very fruitful forever
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)
ua-cam.com/video/vN9UtZYyfRw/v-deo.html
#excel #exceltips #exceltricks #excelformulas #exceltutorial #excellent #excelskills #excelbasico #exceltraining #exceldashboards #excelshortcuts #exceldataentry #excelonline
#invoice #invoicebooks
Same here
Same here bro..what we can do now@@rajendrasinghrathore3704
Same here
Itna to kisi institute m bhi nhi sikhate h bhai great Work 👍 Thank You Brother
Sir, what a strong memory. Ek daam jhakaas.
👌❤️🙏
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
But apke iss channel se mujhe bohot hi accha hua
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)
ua-cam.com/video/vN9UtZYyfRw/v-deo.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.
This is what I looking for since long time... Thanks for the problems solved
Un unbelievable, Excellent experience. Amazing, thanks
very important and your demonstration make it easy!!
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 UA-cam tutorial videos about trading I am still making losses, please I seek for a better website.
Great sir ...heads off...bhut bdia ..speechless
Sach me sir bhot jyada dimak lagaya h sir bhot.. sab se jyada "stock not available" o my god.. 🥰🥰
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 😂
excellent video.... true handheld video. thank you very much... radha radha....
Radhe radhe
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.
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.
Hlo sir
Apke video Bhot achi ha
Or Bhot kuch Sakhna ko mlta ha
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
Please show how to manage monthly sale and purchase in this format
Lovely. लॉजिक, ऑप्शंस, फॉर्मूले, स्टेप्स शुरू करते समय बैकग्राउंड बताओ और धीरे धीरे आगे बढ़ो। I learnt a lot 😀😀
Great Lesson ..
Just request your help for auto matic stock control for an offset Printing Press🙏👍
BRILLIANT
Bhai aap ka excel knowledge kamal ha
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 🙄
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.
Such A Brilliant Teaching
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
sir how to enter more than one item in a single purchase?
Absolutely great. This is what I was find.
Ye sheet ban Jane ke baad file save kaise kare Sir ji
Koi reply nhy
Good question
Save as option click
Save karne k time option aata with macro wala option select krke save kr de
F12 save as macro sheet
Please make a tutorial of the stock Register. I am sending you a picture of the stock Register please.
Aapki Teaching Skill Acchi hai Sir...
Generally many items comes in a bill how to record it.
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
Super knowledge sir
I am really impressed and also learned from your this video
Thank u so much
Profit and loss v rhta to or batter hota❤️
sab tere ko free me denge bhai .....................
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
Very nice sir Sab acche trha Se smjaya Aapne thankuu
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
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👍
Sir .. Great ..
Thanks for uploading such a valuable vid ..
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 VERy GOOD USE OF ms EXCEL Mainly for retail shop......or small enterprise
You are awesome bhai, tumhara waja se mujhe kuch naya sikne mila or ye mere kam v ayega... Thank you🙏 Dil se vai
Sir aap bahut achchha vedio dalte hai youtube per..
*Appreciated Thanks, Not just Best Teacher,... Valued Teaching Experience*
King of Excel user 🙏🙏
You are a good teacher bro.
Awesome. Excellent. God bless you brother.
It is very informative i like it so much and learn many more about excel.
Really very useful and Good knowledge
A brilliant way to describe it, Hats off, Deepak ji.
Sir, Very Informative and Helpful. Thanks.❤.
Very Good information. Thanks a lot
Excellent performance 🎉🎉🎉🎉
Very simply explained. Good Knowledge.
Thank you for detailed and nice explanation. You teach in very easy ways.
Bhot Shandar vedio hai Bhai well done
NICE WORK.ITS REALLY VERY HELPFUL.
Fabulous and wonderful video.
My boss impress by me only for you thankyou so much sir
Thanks for Sharing your knowledge,
Bahut mast 😊 thanks a a lot . You are good teacher .
Thank You Respected Sir 🙏,
From my present position, it's very helpful for my work venue.
Sir you are absolute. Your sheets really help me a lot. Thank you so much.
thanks big bro.😊your explanationis IMPECABLE and WORD PERFECT.
Excellent, awesome and very helpful bro. Thanks for this tricky video. God bless you.
BAHUT ACCHI SHEET BANAI HAI AAP NE BUS EK CHEEZ NAHI BANAI AAP NE TOTAL AMOUNT KA
WO KESE BANEGI MERE SAMAJH ME NHI AA RHA HE PRODUCT MARGIN KESE NIKLEGA
Sir, very nicely explained by you, even a fresher in Excel will become a champ with some practice
Unbelievable Boss tussi Great ho.
Great ❤❤❤
Bhut Shandar sir ❤
Very useful way of teaching
Bhaiya, Bahut badiya. Thanks.
Great learning 👍
gajab brother gajab
Very nice class/teach
Very informative sir❤
Sach btaun to meri job se ishi ki wjh se pakki hui hai thanku sir ji..... Km se km 5 baar repeated dekha h mene
Bhai aapka video mere liye bohot useful Raha
Bas ek chiz batadijiye yaha se profit/loss kaise nikale
Superbbb 🙏🙏🙏
Sir kuch query rahegi to plz contact kaise kare
Bht alaw love from Pakistan ❤❤
Amazing ! Love From Pakistan
You are the Master
Wow superb dear bro...
Bahut badiya
THNX THIS WILL HELP ME
Superb and very well explained
Superb ❤👌👍
Sach me Sir ye to kafi useful hai
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 👌👌
Superrrrr👌👌👌👌👌👌👌👌👌
Best explaining so far on youtube
Please also show sale purchase accounting and totals and difference and profit loss etc
I like your teaching style so much❤