Ye Software bahut hi Acha Banaya gaya Bina kisi auto Function ko use kiye bina.. V lookup aur Piotable ka Istemal kar kar... Bahut acha Laga ye vala Vedio Ku6 aur new tarika se inventory software banane ka Sikhne ko mila.. Par aap ka Jo pahele Vala Inventory software banane ka Tarika Bataye the woh muje Bahut hi achha laga tha.. Pura Software auto system se banaya Gaya tha... Aur Us me To Vlookup aur Auto Item nikal na aur Advance Filter use karna aur Last me Meceo wala system. Us me Banaya Gaya Jo aap ka Inventory program Bahut acha laga tha.. Is me kahi bhi Mecro ka use nahi kiya gaya aur asan Tarika se banaya hai aur samjaya Bahut acha laga Ye bhi Ku6 naya sikhne ko mila....❤❤❤ Thank You Deepak Ji... Nice Vedio and Very good Understanding for all function....❤❤❤❤
@DeepakEduWorld Q na Ho Aap itna Mehnat kar k Ku6 na Ku6 new Shikha Jate hai.. Khusi to hogi na... Hame... Itna to ham Ms Office ka Class me jaa kar sikhte to Sikhne ko Nahi milta utna aap ka Vedio me Ku6 new Sikhne me Mil jata hai...
You do this very good work, you used to give practice file along with the video, people do not give to download the practice file on UA-cam, please give the link, you do this very good work. And you are also a very good teacher in the world. ❤❤❤❤❤❤❤
Nice one bro, very simply explained and i found this as base for any type of dashboard in excel, rest is what you want to see and formula and pivot to bring it.
दीपक जी आपने एक बार फिर उम्मदा और बहुत लाभकारी जानकारी दी है ,आपका आभार . अगर Goods वापस देना हो कंपनी को तो वो कहाँ एड करेंगे और साथ ही goods कस्टमर ले गया उसने यूज कर वापस लौटाया या फिर दुकान में यूज किया या दुकान में ख़राब हो गया तो इन सब सामान को कैसे इन्वेन्ट्री में कैसे डालेंगे
Sir Gr8 video I watch it for almost 2 hrs and managed to complete. My request is to add invoice to the inventory system, I have seen you 2yrs old video about invoice If you do a add on on this invoice that will be gr8
Yes it's fantastic...it gives great motivation while creating this type of dashboard. Can I make the same type of dashboard on Google sheet or any other way to make it live for muti users.
Nice work to understand basics but there are few limitations to this workbook. 1- What about costs if we are purchasing at different rates as rate changes is pretty normal in subcontinent. 2- Purchasing same items from multiple vendors. 3- what if we want to manage inventory rates at lifo system.
It would be really appreciated if you make an updated version of this workbook considering the given information. I know it would make formulas a little complex but that's the part of learning and we really appreciate your efforts for this. Love from Pakistan.
*Dosto kaisa laga ye project ?* Is trah ke projects me seekhne ke liye bahut kuch hota hai.. time nikal ke video poora jarur dekh lena and aap template video description se download kar saktey ho… 🔥🔥
Sir mera ek question hai ki month end hotehi pura month ka record every month ka all total amount k sath single sheet me mile or save hote hi pura project record clear ho jaye or new month new record ke sath ho.
Valuestapm ki zarurat is liye hai qk 1 product 50 ka cost hua sales me vlookup se automatically 50 k hisab se profit ban gaya lekin same product 60 ka cost hony per pichli entries ka cost b barh jaye ga is ka koi solution bata den please aur agr mumkin ho to google sheets me bata den
Good course! One issue though! Coat and selling pieces changes as time goes on! But this software won’t do that, because it will always bring the set cost and selling price! And if we change in future it will change the past data as well! Do someone has a solution?
I'm from Bangladesh. I'm a regular student of you. I have a big request to you, that this create a Accounting Software In MS Excel. Please Sir. Thank You So Much.
@@DeepakEduWorld I'll be so happy if you do this for us. because everyday we need to work for our business. if you make an fully automated accounting software with dashboard for us, then we'll be so benefited by you. Thank You So Much Sir.
Thank you for this great project. i have tried this by watching full video , everything work properly but unfortunetly i an facing a problem in sales sheet, i cant select same customer for multiple sales, i mean if i write same customer id for multiple time its not showing customer name, rest is perfect,thank you, if possible please help me to solve this..
Sir aapne ajtak excel power Query topic par video nehi banaya hai. Ek power excel Query ka use sikha dijiye.. and complete excel for data analysit aise ek complete videos banaye.
I'm working on Requisition data, PO data , receipt data & balance stock in Store.. liked with each other.... If you have better dashboard linked with each other...pl share with us
Great work dear. Please upload fully automatic working file video of School Management of STUDENTS ... it will included..... 1) Name 2)F. Name 3) Gender 4) Class 5)admission date 6) admission fee 7) Annual fee 8) Exam Fee 9) ID card fee 10) Tuition fee per month 11) Errors 12) Total amount received 13) receivable amount etc
Good Morning Sir How are you but i am trying lean to it software but there are feeling ahead trouble. in 10 version excel i am not finding icon in there illustrutioin.
AoA sir thank you so much replying me of my approaching Message but how did i am search the file of training file if can you Provide me your Whatsapp number.
Ye Software bahut hi Acha Banaya gaya Bina kisi auto Function ko use kiye bina..
V lookup aur Piotable ka Istemal kar kar...
Bahut acha Laga ye vala Vedio Ku6 aur new tarika se inventory software banane ka Sikhne ko mila..
Par aap ka Jo pahele Vala Inventory software banane ka Tarika Bataye the woh muje Bahut hi achha laga tha..
Pura Software auto system se banaya Gaya tha... Aur Us me To Vlookup aur Auto Item nikal na aur Advance Filter use karna aur Last me Meceo wala system. Us me Banaya Gaya Jo aap ka Inventory program Bahut acha laga tha..
Is me kahi bhi Mecro ka use nahi kiya gaya aur asan Tarika se banaya hai aur samjaya
Bahut acha laga Ye bhi Ku6 naya sikhne ko mila....❤❤❤
Thank You Deepak Ji... Nice Vedio and Very good Understanding for all function....❤❤❤❤
🙏 glad you like it
@DeepakEduWorld Q na Ho Aap itna Mehnat kar k Ku6 na Ku6 new Shikha Jate hai.. Khusi to hogi na... Hame...
Itna to ham Ms Office ka Class me jaa kar sikhte to Sikhne ko Nahi milta utna aap ka Vedio me Ku6 new Sikhne me Mil jata hai...
Excellent teaching! Dil khush hogaya.
Thank you Sir from Pakistan ❤ very good Explanation ❤
Boht Super Sir
Boht acha samjhaya aur Template dy kar Boht Aasani ki ALLAH pak aapko aur tarqi aur ilm dy
Rashid Ali from Pakistan
You do this very good work, you used to give practice file along with the video, people do not give to download the practice file on UA-cam, please give the link, you do this very good work. And you are also a very good teacher in the world. ❤❤❤❤❤❤❤
Thanks! You can download the practice file from the link in the description box. 😊
you are genius sir Thanks for the nice presentation
Wonderful sir very helpful video. Looking like automated website.
Explanation is nice sir
Very Helpfull and super easy to understand.
Dear Sir,
Thank you ! Worthy you delivered a good learning opportunity.
Thanks
sir u r the best teacher in the world, thanks
i have learned word and excel from you, and the way you describe things amazing
MashALLAH Very Helpfull Video And Also V Formula Knowlage
Mast !!!👌Thank you for teaching.
بہت بہت اچھا سر جی ہم آپ کے حوصلہ افزائی کرتے ہیں
very good and very simple way to teach the thing , thank you
Nice one bro, very simply explained and i found this as base for any type of dashboard in excel, rest is what you want to see and formula and pivot to bring it.
दीपक जी आपने एक बार फिर उम्मदा और बहुत लाभकारी जानकारी दी है ,आपका आभार . अगर Goods वापस देना हो कंपनी को तो वो कहाँ एड करेंगे और साथ ही goods कस्टमर ले गया उसने यूज कर वापस लौटाया या फिर दुकान में यूज किया या दुकान में ख़राब हो गया तो इन सब सामान को कैसे इन्वेन्ट्री में कैसे डालेंगे
YOUR WORK IS REAILLY GREAT, ITS REAILLY USEFULL TO MY BUSINESS. I REAILLY APPRICIATE YOU
THANKS GOD, MANY BLESSINGS TO U AND TO YOUR USEFUL WORK
Thanks and welcome 🙏
Sir
Gr8 video I watch it for almost 2 hrs and managed to complete.
My request is to add invoice to the inventory system,
I have seen you 2yrs old video about invoice
If you do a add on on this invoice that will be gr8
I will try to add a section on invoices to this project shortly. 😊
Zabardast
Very helpful video for excel users thanks❤
Very nice easy simple way to explain great work
Awesome boss👌
Thanks for sharing
Very helpful video, Thanks Sir.
Very helpful video, Thanks
Thanks sir , Really your all are very useful and nice.
Dear sir please complete school management system banaiye.
❤❤
بہت بہت اچھا ہم آپ کے حوصلہ افزائی کرتے ہیں
Telecom Franchise k leay Aik banao na.....Load order + Load Recived ka banaw
Very helpful and informative video. ❤ Sir aik vehicles management ka software bhi banao thank you sir❤❤❤❤
Great effort hatts off my bro.
Super video sir
Sir bahut achha banaye hai, please ek video advanced chart in inventory management
Nice presentation🌹
Yes it's fantastic...it gives great motivation while creating this type of dashboard. Can I make the same type of dashboard on Google sheet or any other way to make it live for muti users.
bhai sale ke sath sath isi mai invoice dhal ke dikha do plz 😢 plzzz
Great video
Very underrated channel
Yes sir very usefull video
bhai please sale ke sath sath isi mai invoice bhi dhal dete 😢 plzz
Hello sir. Sir please isi trha ka dashboard complete school management pr b bnao please
Nice work to understand basics but there are few limitations to this workbook.
1- What about costs if we are purchasing at different rates as rate changes is pretty normal in subcontinent.
2- Purchasing same items from multiple vendors.
3- what if we want to manage inventory rates at lifo system.
It would be really appreciated if you make an updated version of this workbook considering the given information.
I know it would make formulas a little complex but that's the part of learning and we really appreciate your efforts for this.
Love from Pakistan.
Sure, I’ll make updated version of this project and publish shortly ✅😊
Hello Deepak ji mughe apne small bussines ke liye aise hi ek software bnwana h kya ap bna skte ho
GST calculate sheet hota to aur v accha hota .. possible hoga to plz ek video bana dijiye ga..plz
Superb
Pls how to make sale print
Thank you very much
very good
thanks
Very interested bro
Sir wonderful video,
sir is ke sath customer ki bill print ki option diya ja saktehe kiya
La Jawaab Ho ji Aap
बहुत मेहनत करी है जी आपने, धन्यवाद
Sir ye aapka excel konsa hai mere pc main Window 10 & Excel 2016 hai work krega ye kya Table
Bilkul work karega.. try it
Waah sir
THANKS VERY INFORMATIVE PLEASE MAKE ANY WAREHOUSE MANAGEMENT VIDEO I AM WORKING IN WAREHOUSE to maintain stocks issuance and receiving
Nicely explained.
Sir, what are your views on Power BI. Can all this be done with Power BI.
Nice Sir Can you make Opening Stock adjustments in this Inventory Management.
Isi tarah k project me school management software please sir
very nice
Thanks u Sir
*Dosto kaisa laga ye project ?*
Is trah ke projects me seekhne ke liye bahut kuch hota hai.. time nikal ke video poora jarur dekh lena and aap template video description se download kar saktey ho… 🔥🔥
Sir apne sheet ko hide kese Kiya hai Thora batayiye
Sir software ka nam kya hai please tell me
Ye excel me bana hai ya kisi aur software me
Sir Advance Excel seekhna aap se hai please sir suggest me
Data Analysis kaise karte hai kya hota hai all 😢
Sir mera ek question hai ki month end hotehi pura month ka record every month ka all total amount k sath single sheet me mile or save hote hi pura project record clear ho jaye or new month new record ke sath ho.
I will publish updated version of this project shortly ✅
❤❤❤
Deepak Sir ap ne Timestamp ka video banaya hai mene dekha hai kya value stamp kisi fuction se possible ho sakta hai code k bina
Valuestapm ki zarurat is liye hai qk 1 product 50 ka cost hua sales me vlookup se automatically 50 k hisab se profit ban gaya lekin same product 60 ka cost hony per pichli entries ka cost b barh jaye ga is ka koi solution bata den please aur agr mumkin ho to google sheets me bata den
Good course! One issue though! Coat and selling pieces changes as time goes on! But this software won’t do that, because it will always bring the set cost and selling price! And if we change in future it will change the past data as well! Do someone has a solution?
Can you make with this pos system in this.
Customer and product id se name se entry accha hota
You can easily customise this as per your needs..
I'm from Bangladesh. I'm a regular student of you. I have a big request to you, that this create a Accounting Software In MS Excel. Please Sir. Thank You So Much.
Thanks for your request! I'll definitely keep it in mind for future videos. 🙏
@@DeepakEduWorld I'll be so happy if you do this for us. because everyday we need to work for our business. if you make an fully automated accounting software with dashboard for us, then we'll be so benefited by you. Thank You So Much Sir.
اگر آپ سکول و کالج یونیفارم سٹور کا ڈیش بورڈ بنانا سکھائیں تو اچھا رہے گا۔
Nice sir ji
Thankyou sir
Hello sir workshop/garage inventory mAnagement system pe excel sheet bhi bna sikha dijiye..
Thank you for this great project. i have tried this by watching full video , everything work properly but unfortunetly i an facing a problem in sales sheet, i cant select same customer for multiple sales, i mean if i write same customer id for multiple time its not showing customer name, rest is perfect,thank you, if possible please help me to solve this..
great
Sir aapne ajtak excel power Query topic par video nehi banaya hai. Ek power excel Query ka use sikha dijiye.. and complete excel for data analysit aise ek complete videos banaye.
Bhai hardware plywood ke liye ek inventory software bnao usme catogry wise product hote h ek hi hsn ke 50 product hote h. To usko kaise manage kre
Nice
I'm working on Requisition data, PO data , receipt data & balance stock in Store.. liked with each other....
If you have better dashboard linked with each other...pl share with us
Very very useful video
Great work dear. Please upload fully automatic working file video of School Management of STUDENTS ... it will included..... 1) Name 2)F. Name 3) Gender 4) Class 5)admission date 6) admission fee 7) Annual fee 8) Exam Fee 9) ID card fee 10) Tuition fee per month 11) Errors 12) Total amount received 13) receivable amount etc
Good Morning Sir How are you but i am trying lean to it software but there are feeling ahead trouble. in 10 version excel i am not finding icon in there illustrutioin.
Very good evening g.. i am fine and hope you r also well.. you can copy icons from training file or you can also search these icons in google also
AoA sir thank you so much replying me of my approaching Message but how did i am search the file of training file if can you Provide me your Whatsapp number.
GOOD
IT company assets management sheet how to create please make video on this topics
Sir, day book se sale purchase expenses kaise shift kare on another sheet in excel? Ye sab banaya aap ka video dekhkar but shifting issue aa raha hai,
Sir excel ke all tabs ka details video kab aayega 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉
How to handle if buy and sell price change...e.g buy 30@300 and then again buy 50@310
SIR AGAR RECHARGE AND SERVICES KA BUSINESS HO TAB ENTRY KAISEY HOGI
PLZ MAKE VIDEO ON IT
Can google sheet do this 😢?????
sir g xlookup formula multiple sheets par kase lage wo sekna hai ji
Sir, there is a problem in this template. When ever we scroll-down the sheet for more entries, the navigation menu at left scrolls up. Any solution?
Sir Agar is ko Alag sy Software my convert karna ho tu?
Good
Muje manufacture ke liye aapki help chahiye aap ke charges bataye
please make a full tutorial of ms Acess
Sir, after copy & paste to next sheet Inventory management system embulom is not pasting
Aur ek product multiple vendors se liya hai toh kya karenge sir
Sir .notification formula kam nahi karta hi😮😮😮 baki sub ok hi
Dhyan se formula dekho.. step by step apply kro ho jayega
Complete Excel tutorial kab aayega
Excel ke kaunse version Mai ye bana sakte hai?
Excel 2007 version Mai filter function nahi hai
Google sheet mei ban sakta hai kya
Same Question 😂? ❓❓❓
what about if one hsn code has many items, how to record that
I want entry data always in first row. So Sir pls make video for this vba code