Automated Invoice and Stock [ Inventory ] Management in Excel - Inventory Management in Excel
Automated invoice and stock [ inventory ] management in excel - Inventory Management in excel ( Hindi ) - Stock Register
In this video you will learn how to create Invoice and Inventory Management in excel. You can easily create Invoice Generator with stock and inventory management in Excel with auto save invoice in PDF File - If you need to create sales invoice and maintain stock [ inventory ] in excel then this Fully Automatic Inventory Management System with Fully Automatic GST Invoice will help you to manage sale, purchase and inventory of stock. You can use this format as Stock Register and Inventory Management Software in excel to maintain your automatic sale purchase stock report.
Download Training File : deepakeduworld.com/invoice-an...
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
#InvoiceInExcel
#InvoiceAndInvenory
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
Пікірлер: 1 000
This is indeed an amazing video, I was really looking for this invoice plus inventory management, though I am not fully familiar with the Hindi language but I managed to understand it. Superb work. Mihlar from Sri Lanka
Thank You! Was going to buy an expensive software for this But now with this i've saved alot...:D
You've helped me so much! Another tutorial of yours that I watched before worked like a charm! Now I have complete confidence this one's going to be of massive help too. Thanks!!
@inamsadaf9481
Жыл бұрын
sir, send me link this form
@muzmil124
Жыл бұрын
Deepak
@muzmil124
Жыл бұрын
Resource
Download Template deepakeduworld.com/invoice-and-inventory/
@zacky2728
2 жыл бұрын
Excel provide kr do bhai plz.. HSN me kya kiya h wo smjh nhi aa rha
@fahadrazakhan5409
9 күн бұрын
Hh
Excellent and easy explanation. Thank you
Just wow don’t have anything to say searching this video from 3 years and finally I found it from your Chanel
@muraly3523
2 жыл бұрын
@Ganesh Kumar I have posted a video. Will be useful kzread.info/dash/bejne/m4eAk5uAmarFg7g.html
Excellent Sir, Bahut kuch sikhne ko mila, Thank You.
Hi Sir You've helped me so much! Now I have complete confidence this one's going to be of massive help too. Thanks !!
Sir there is a problem when purchase price and selling price increases of the same product..please add some formulas to updates the latest price according to date.
Great Job, But you should make inventory management in excel with reports, like monthly report and annual report
@Mumer-dg7it
2 жыл бұрын
Help bhai plz help Bhai VBA ka code kaha se milhe ga Invoice template Invoice ko pdf me save karen kia liye
Your every classes are inspiration to me, very very useful, thank you so much sir.
Amazing Video, very good detail easy explanations with good examples. keep it up and keep going !!
You software template is excellent. I have started using it in my shop. I need the following amendments: 1. GST column should be in a same row as in subtotal. In the left most row there should be SubTotal, then GST and then Net Total (SubTotal+GST). 2. The Column width should adjusted to reduce the width of Invoice No, GST column will come in the row of SubTotal, this width must be used to increase the width of Item.
@muraly3523
2 жыл бұрын
I have created a video today.Perhaps this video will help you kzread.info/dash/bejne/m4eAk5uAmarFg7g.html
I'm Big fan of your works bro majja agaya
Sirji, bahot bahot Shukriya. Aapane Hamare liye invoice with inventory banaya.
Bhaiya app ka video se mujhe bohot help hoti ha, thank u.
SUPERB....SIR....BUT HOW TO ADD PURCHASE STOCK??? IS IT MANUAL?
Dear Sir , I Kindly request you to share this Sheet. I took a lot of time today but could not complete it well. Thank You
Your template is best one I have seen soo far! I rarely comment on anything, but you video has convinced me to right you a comment for helping me and many like me. Thanks a lot.
Thank you sir apke video dekh ke mene he banaya or aj ye muze apne dukan me bahut kam ara hai ❤️ thank you sir again
Sir, make some changes in this invoice. We have created a data validation list of hsn code. Make that list searchable dropdown list plz.
How can we manage monthly account statement record of individual customers
Great Job... Very Innovative well explained... all the information's were very clear... Thanks a lot... God Bless...
Bohat shukria bhai Deepak. Blkl sahi aur bohat mofeed kam kia ap ne. Lov from 🇵🇰
When we create invoice in sale tab rows are gapping. Kindly suggest.
How it works if same item has two different rates and how to update date also in sales sheet
Excellent Deepakji aapney kafi mehnet ki hey is video ko bananey ke liye.....thank you very much 😊
Thanq thanq so much deepak sir.....aapne meri billing wali problem solve kar diya is video ke madhyam se 🙏🙏🙏
Great work sir. How can we create Ledger from this invoice automatically.
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?
@marcusrobs9535
2 жыл бұрын
Anyone who has traded cryptocurrency is well aware of how the volatile the market can be
@marcusrobs9535
2 жыл бұрын
If you're not a day trader and don't wanna be hit by massive drops, diversification may be a good option for you
@charlottegomez5279
2 жыл бұрын
When discussing crypto diversification frequently asked question is whether diversification is even possible
@charlottegomez5279
2 жыл бұрын
Because the majority of stock market have some correlation to Bitcoin, they argue that investing in Bitcoin is not a true diversification strategy
@fredrickhoward1297
2 жыл бұрын
@PRlNCĖ D0NÑÊLL🔛 You just hit the point there bubby👍
Great and love to watch Thank You sit
I'm from Pakistan. You such an amazing topic for Accounts related work. Great Job 👍🏻
Excellent video but there is a problem. The macro "sale" selects the entire invoice table and copies it to "Sales" sheet, but when are only 1 or 2 items, then the BLANK rows are also copied. What is the solution?
@subhambasfore2222
Жыл бұрын
Sir did you find the solution? Please help me if you get the solution
@a-55bagulrohitarvind68
Жыл бұрын
You got any solution then please tell 🙏
@saminaarfan5546
Жыл бұрын
Same problem is with me
@usamarajpoot4860
Жыл бұрын
Same problem😟
@Niazi_Data_Analyst
9 ай бұрын
same problem I am facing. rows gap between first and 2nd invoice entries@@usamarajpoot4860
I downloaded your video and learning as a regular basis. I learned lot ofnin excel.
hello king, as usual, you give us a unique surprise, go ahead.
Sir ji =vlookup ke bad hsn nahi le raha hai
@niceeducom1584
3 жыл бұрын
Vlookup function me [hsn] nahi letha hai pls provide solution
@preparationwithrb567
3 жыл бұрын
Table format phle kr lo, tb lega
Serial number pr formula lg skta h =if(d16>1,1,"") Love from Pakistan 🇵🇰
@pulkitsankhala
3 жыл бұрын
Bhag bae
This invoice inventory video is really awesome.you have described it briefly thank you sir.
@MegaMindTech
2 жыл бұрын
Agree
Very useful and good knowledge given..👌👌
Can we do this in Google sheet
its a really valuable video.i have crated a perfect invoice and inventory...thank you soo much Mr Deepak...kasun from Sri lanka...
Bahot badhiya banaya sirji. Bahot bahot shukriya.
Thanks to you now i can manage my whole business very easily
THANKS VERY MUCH SIR. ITS REALLY HATS OFF TO YOU FOR THIS SUPER DUPER AUTOMATED INVOICE VIDEO ON EXCEL. I AM REALLY THANKFULL TO YOU FOR THIS VIDEO.
Very Amazing. Nice bro. 👍👍👍👍👍👍 Bhooot kamal ki video banai ha. Excellent 😍💕👍
Love your beautiful teaching experience ❤ 😍 💕 ♥ 💖
@ghulamullahkhan597
2 жыл бұрын
Sir deepak If we want to edit gst from 5% to any value how to change in the invoice.
Loved It. Can you please make a video of how to create the same sheet with all same features in Google Sheets?
This vedio is really helpful full..you teach this very simply
Thank you for a very informative video. From Pakistan 💐💐❤️
Your this video is very informative. Please guide how to keep subtotal of invoice location same if we add or delete row in invoice. While transferring this subtotal to other sheet it's location is changed if we add or delete row in invoice.
Thanks for your wonderful video. Please let me know how would I adjust the return product and correction in the saved invoice if require.
Sir your excel Knowledge is unbeatable
Wawo! just great, I made my own shop invoice easily and working properly thank u
Great knowledge bro....much appreciated 👍
Excellent sir 👍🙏
Bundle of THANKS to improve my skills
Kaam ki cheez hai 👍🏻
Bohat zabardast from pakistan great Deepak sir great
Sir, you are a very good teacher. Your method is very good. I suggest you create a WhatsApp group to send your lectures to.
Excellent guide for new generation
Bhaii aap ला javab ho.... Excellent explanation ❤️❤️❤️❤️❤️❤️❤️
I am from Bangladesh . I used to view your videos . These are worthy and have much learning materials. I request you to make video on "Ms.Access" advance for such accounting software or inventory management.
The best teacher in Utube❤️❤️❤️❤️❤️
@DeepakEduWorld
3 жыл бұрын
🤗🙂
@subhambasfore2222
Жыл бұрын
@@DeepakEduWorld sir when I enter the one entry it's take all the blank cell....please give me the solution how to remove blank cell in SALE macro ?
Tx, Dipak sir
thank u so much , deepak brother , u r knowledge is excellent....
great work bro.
Adding the invoice value in words will make this perfect. Kindly do that too...
@basweerrashid690
2 жыл бұрын
Why in words?
@muraly3523
2 жыл бұрын
My video will help you. If I have posted a video today. You watch and comment.
thanks bro thank you very much it was easy and clear explanation
Sir , Nice & Easy Explanation.
Serial number based purchase and sell will be very helpful.
Sir, you have done great job. You teach to make invoice and in this video there an add of vyapar app for invoice thas a great😁😁😁
Excellent work.....you Rock
Excellent Mind blowing
smart guideline technique , valuable video
Many many thanks. I'm from Bangladesh.
This is really an important and amazing video. Your explaining skills are great👏😍 Thank u so much
Hi I have a question regarding purchase & stock. For example we have a purchase of mouse with different quality and price, in purchase sheet, HSN code, price and quantity is different, but when we refresh in stock sheet, it shows the both hsn code but with total sum of purchase quantity in both hsn code. Looking forward your earliest reply on this. Thank you
Sir nice explanation 👍👍
U put so much effort... thanks so much
Great work sir
Wonderful ,👌👌👌🙏
Super bro vary good Fantastic video Lajwab
Thank you sir aap aisi wala video chahie hum lgoko very very happy and very very very thank you sir.
Thanks sir very helpful video
Informative video Thank you Sir
Awesome Brother It helps me a lot
Sir apka video achha hay bahut sikha hay
Sehat bos Q.. Terima kasih datanya
Zabardast hai bhai great yar 👍
I hope this message finds you well. I've been following your tutorials on creating macros for Excel. First and foremost, I want to express my gratitude for the valuable content you provide. Recently, I watched your video on creating a sale macro, and I successfully implemented it for scenarios where I sell multiple items in a single invoice. However, I've encountered an issue when entering only one item in the invoice. The macro doesn't seem to work properly in such cases. I would greatly appreciate it if you could provide guidance on resolving this issue. Your expertise has been instrumental in my learning journey, and any assistance you could offer on this matter would be immensely helpful. Thank you for your time and consideration.
Very informative
amazing method .your style is good
Bhaiya aapka video dekkar same chij maine google sheet me bana di thanks
@DeepakEduWorld
Жыл бұрын
Bahut badhiya yogesh g 😊 👍
@yogeshpareek6697
Жыл бұрын
@@DeepakEduWorld BHAIYA ISME MERA KUCH NAHI HAI SAB AAP SE SIKHA HAI AAP TO MERE GURU HO JAI HO GURU DEV
Superb work brother,Thanks ❤
Thanks for the share.
I'm very happy,,,, Thanks
Your a great ser.
Dear Deepak Sir you are amazing. All the videos are full of knowledge, adding a lots of value to my work. Sir, Facing a problem in "Inserting Copied Cells" in the desired Sheet, following step by step guide. While Clicking on "Insert Copied Cell", Popup is coming and asking "Shift Cell Right" or "Shift Cell Down?". When selecting one option and click "OK", an error message is coming, saying, "This won't work because it would move cells in a table on your worksheet". I tried many time and got tired now. Hoping, you will help me here and give me solution. Thank you very much.
@muraly3523
2 жыл бұрын
I have posted a video today. See the demo first, and watch to the end if interested kzread.info/dash/bejne/m4eAk5uAmarFg7g.html
@rahmatrezaali6839
Жыл бұрын
Did you get the answers
very weldone job Sir Love from Pakistan
bro i have a question. suppose i have 10 input spaces in my invoice but i need to input more products. as in, what do i do to increase more input places? basically i need flexible product input area. because i might need to input two products in an invoice once and might need to input 25 in the next.