Inventory Management | Excel Inventory Management (Super Easy)
HTML-код
- Опубликовано: 27 сен 2019
- #InventoryManagement #Excel #InventoryManagementSystem #ExcelInventoryTemplate
In this video, you will learn how to create an inventory management system in Excel. Inventory Management through this inventory management template Excel is very easy. It is very easy and quick to setup.
This warehouse management software will help you to keep record of inventory i.e. opening stock, purchases, sales, and closing stock. Inventory control will not be difficult any more.
Here is the link of Fully Automate FIFO Inventory Valuation Method.
MS Excel - FIFO inventory Valuation Method in Excel (Fully Automated) Tutorial
• MS Excel - FIFO invent...
MS Excel - FIFO inventory Valuation Method in Excel (Fully Automated) Tutorial Part-2
• MS Excel - FIFO invent...
MS Excel - LIFO inventory Method (Fully Automated) Tutorial
• MS Excel - LIFO invent...
I will always appreciate a teacher who knows how to brake it down and clarify. I did have trouble with the low volume but I'm glad I found you.
Thanks a lot, i am an engineering professional and my boss wanted me to keep track of supplies, i searched numerous videos but i made excel sheet from scratch watching your video because of your clear instructions. Thank you so much for the video. I really appreciate your work brother. :)
This tutorial is exactly what I've been looking for, thank you so much for taking the time to make it and explain it. I now need to give it a go.
I been using excel for many years and now I now upon watching this video I already use it and Its really great and easy to use ... Many things to you
Learned so much!! Been wanting to learn Vlookup formulas for a while now, and your tutorial made it super easy to understand. Will definitely try to implement with my inventory logs. Thank you!!
Struggled 3 years at college & 4 years at Uni due to unprecise teaching from Professors.
Luckily, RUclips Indian sensei saved my life.
Once I graduated, I thought that was over.
But again, I was wrong.
They will be helping us forever. Never ending process :'D
I've watched lots of videos on this subject but non explained it better as you did. Thank you very much.
This is the breakthrough for me
To the point, useful, easy to follow. Exactly what I needed to manage my inventory. Thank you!
exactly what i was looking for! Easy and precise. Perfect!! Thank you for making this video ❤️
After searching the whole net finally found what I wanted 🤩thank y so much
I am looking for a video like this, inventory details maintain just 01 sheets. After watching this video I have been a subscriber to your channel and also press the like button this video. Thanks a lot again.
this was very helpful and easy to follow. you broke it down into bite sized bits instead of cramming the info at your audience :)
Thank you so Much Sir for sharing your valuable knowledge and experience. This video is way simple and easy to understand and implement an inventory management system for a small business. It really helped a lot. Best video so far. Keep up the Great Work. Appreciate it.
Great teacher. I'm using this for my business.
Learned a lot, great info! is there a way to combine several part numbers and quantities under one primary kit number to change inventory levels from sales/stock out?
Hi I have prepared a chart in the same you have explained but I would like to add date of expiry and also set alerts for the near expiry goods, so is there any option to do so
This is quite informative! Thank you! Simple and to the point. You are teaching it and not just presenting it. Keep up the good work!
Thanks
What an awesome video. Honestly one of the most well explained video tutorials I've watched. Thank you
Thank you so much! I learned so much and I'm sure this inventory will serve my business for years :))
magnificent my friend..
Really helpful! Thanks!!!! Salute from Philippines!!
Thanks for the knowledge, WHAT A DELICIOUS CONTENT !!, this content is really cool. the explanation is easy to understand.
Very simple and very useful. Thanks man!
Thank you very much. This is what I'm looking for!
Simply Great, Awesome !
Thanks
Thanks for the video. It is very easy to understand and also very helpful. I refer to it often
You are great.super easy way to teach.
Stay Blessed Bro
Hello,
Thank you for the video. It was 100% understandable. It is really acknowledged that you understand the needs of the analytics in the warehouse management system. Just as a perspective of costs, technology upgrades, and inflation, how could you summarize old stocks and new stock together, i.e. price changes every 6 months for some products and the sum of their actual prices? This is something I am really interested in as I deal with a big quantity of materials and also with a considerable time span from 0 to 2 years. I would love to hear from you. Thank You!
Shah sahb ap UAE mn wearhouse mn kam krty hn plz help me
Wow. Just amazing. I was looking for this, will save so much trouble for me. Thank you boss!
Very good tutorial, really every step guided in very good manner
Excellent
U solved my problem. Thanx
Thanks for video, it was very clear and perfect class
Nice video.. Good enough Information.
Would love to see a video on creating an excel sheet which will hav all details for managing a small company..
Like sales data, purchase data, stock in and out, payment received, ledger kinda report, cash inflow and outflow..
Currently i am working on one such sheet but progress is slow as am not an expert..
This is just what I have been searching for. Is it possible to download the template itself please?
Hi, would like to ask help,..☹ how to add 2 look up values from different table set???
Thanks so much for this great work
you have help me with employment
I had always needed this to complete my jobs
thanks so much sir for this amazing effort
Can you please make something about space allocation for articles. If that's possible we can definitely make this useful.
Thank you very much. Very helpful and simple to understand.
Thank you very much for the video
Very clear to understand and precise.
its so easy to follow.nice tutorial👏🏻👏🏻👏🏻
Thanks to the teacher, he explained is so well. Do you have any website?
Excellent work Bro ! You saved me buying costly inventory systems...thank you :-)
Thanks a lot! This save me a lot of labour time key in data manually! 🤩
Wow this is great sit
love your way of explaining
Thanks
Nice this is exactly what I was looking for
Thanks.. I found the best Inventory management sheet as i want !! Thanks a lot
Great course. If you decide to add a new row to your initial "stock" say item #11, how can you make the new row to become a part of your "stock" table?
I would recommend formatting the cells as a "Table" in the styles group on the "Home" tab first before doing any formulas or creating other tables. This should automatically recognize any added rows as being a part of the table and **should** adjust data in the others as well. Curious to know if this works for you!
Very useful and great explanations.
It is a very valuable Video, thanks for making it, one thing what if there is a price difference in opening stock and purchases?
I have a question if I don't want opening stock table, just need purchase, sales and stock how can I joint the tables?
Thanks
thanks alot brother..it was so helpful:)
💯 accurate thanks so much 🙂
This was amazing!! I learned so much. Thank you!!
wao amazing
Excellent
Thank you very good explanation ❤
Really superb, great 👍
Thank you so much for this!!
Thank you very much. This is really helpful.
Amazing tutorial....Helped me lot.. :) Thanks for sharing
Very helpful for my small business. Thanks for sharing!
Is there a way where I can monitor the in, out, stock, re-stock and stock value all at the same time on daily basis?
Or is there a way that the sumifs function can be set on daily basis?
yes u can use sumifs with current date criteria
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
Thank you so much for sharing this valuable video 🙏🙏🙏
Amazing and truly helpful for my inventory. Thank you so much sir for sharing this video.
Apne Jo formulas use liye last like M5 N5 ACS etc plz us pr koi video BNA dijiye
This is exactly what I was looking for, a crisp concise video on small inventory maintenance. Thanks. I have just subscribed to your channel.
Kem cho Kaki?
I LOVE YOU! Thanks so much for this tutorial
The better way is that the data storage should be another Excel file. Database excel file and operation excel file are separated. if so, you can prevent that if your "operation excel file" is damaged, your data is still in somewhere safely.
Thank you!
THANK YOU IT IS VERY HELPFUL CLEAR
Hello, what if the stock purchases for the 2nd time is higher or lower in price ? What is the efficient way to calculate Total stock value ?
I made an inventory sheet based on this one. Thank you very much!.. Just one thing, Is there a way to restrict the input in stock out / sales if the current inventory is not sufficient?
You can use simply a "IF" function saying the sales should not cross the inventory limit. So that you may know when the purchases become insufficient for the inventory.
@@PraveenKumar-jp4sl would be a big help if you can give me a formula basing on your sheet shown in the video so I can pattern it to my sheet. cant seem to find the correct formula. Hoping you can help me out. Thanks so much!
A very good teacher
good job dear you deserve more views
you save my timee, thank you so much for uploading this video!!
Well done! Thank you.
Thank you! I learned from seeing your video.
Very helpful, thank you! Subscribed
do yyou have a copy or demo file that i can play and use if it fits my needs.
This is Genius. Thankyou
Thanks....it was realistic to implement this in working environment
Thanks for valuable explanation.
Woww... wonderful and valuable information..🙏🙏
very nice! I like it!
Thank you very much it was very useful, i have found it at the right time, thanks
How to delete or stenth the range of selected table in purchase ,sales or stock table.
Hi, Thank you for sharing your knowledge. If I want to add on more Item Code, how to change the formats again?
This is amazing. Can u help me setup a inventory system?
The way you guide very fine, but the thing is how we can update Current stock auto.?? or we have to copy Item and Unit price..???
Thank you for this, Mr. It is very helpful
After make this how we can add more product in this sheet please explain.
I am facing a problem in the last range of closing stock the sum of sale is showing 0
Thank you so much for this knowledgeable video!
Hey Very good video but audio was not good to hear with speakers use headphone and one more thing if we dont have opening stock than we can also use vlookup function in the current stock status tab to automatically add item name unit price etc
thanks, ver informative 👍
I’m watching your videos with great enthusiasm. Could you please help to set-up an inventory system for restaurants? Presently we have 13 outlets and there more to come. We have one central point of buying and we transport our goods once delivered to our commissary place to our outlets - Would be glad to hear from you
How do I calculate profit or loss from this data ?? Please help me. Thanks in advance.