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
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. :)
i think this is perfect to keep tracking for current inventory , but how you keep track if the current stock is tali? inventory head tell their labor to count it everyday right and tali it ?
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!!
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.
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.
Thanks for your video, it helps me a lot. I watched your video and made a report. Now I want to add some new products, but I do not understand how to do.
Hi dr. Thanks for your vedio. But i have a just problem . If purchase price was different by same item. I don't understand that how i adjust it .please help.
First thank you so much for this video. Second I have a question, if we want to change the Price of units on opening stock it doesn't change automatically on current status stock Units price. So how to make it automatically that if we change the price on units on opening stock it change on current status stock??
Hi Farhad, thanks for your question. Please note that a new tutorial is coming this week with inventory management system that will incorporate updated price changes of stock items. Please stay tuned. 😇
This a greate video thank you so much. It helped me a lot. But i have one question if you can please answer it. Isn't the "opening stock" the same as the "purchases/stock in". Because bothe of them indicate the stocks on hand right.
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!
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
Thank You Soo Much, can you pls. Help me in maintaining inventory if sales is in kg sometimes and sometimes in square feet and the purchase is in Kg only
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
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!
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!
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?
Hi, thank you for the details. Sir how can we make a printed document of all items for a particular month. For example no. of an item bought and sold in a month and the amount. Thank you
Ηello sir there is any way to add any kind of ability like barcode reader in order to automatically read the products from an invoice (and automatically adding them on the excel app? ?
If you want to learn Excel in Hindi or Urdu language please hit the below link to Subscribe and learn Excel in Hindi / Urdu 😊 youtube.com/@MegaMindTech?sub_confirmation=1
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..
Well done, but i think there is two points uncovered #1 price of purchasing not the same as selling #2 items have the same not allowed to add new items
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?
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/1.gif)
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 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.
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
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. :)
i think this is perfect to keep tracking for current inventory , but how you keep track if the current stock is tali?
inventory head tell their labor to count it everyday right and tali it ?
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
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
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.
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!!
After searching the whole net finally found what I wanted 🤩thank y so much
Wow. Just amazing. I was looking for this, will save so much trouble for me. Thank you boss!
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.
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 ❤️
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.
Thanks for your video, it helps me a lot. I watched your video and made a report. Now I want to add some new products, but I do not understand how to do.
Hi dr. Thanks for your vedio. But i have a just problem . If purchase price was different by same item. I don't understand that how i adjust it .please help.
Amazing and truly helpful for my inventory. Thank you so much sir for sharing this video.
Thanks so much for this great work
you have help me with employment
I had always needed this to complete my jobs
Very helpful for my small business. Thanks for sharing!
this was very helpful and easy to follow. you broke it down into bite sized bits instead of cramming the info at your audience :)
Thanks.. I found the best Inventory management sheet as i want !! Thanks a lot
First thank you so much for this video. Second I have a question, if we want to change the Price of units on opening stock it doesn't change automatically on current status stock Units price. So how to make it automatically that if we change the price on units on opening stock it change on current status stock??
Hi Farhad, thanks for your question. Please note that a new tutorial is coming this week with inventory management system that will incorporate updated price changes of stock items. Please stay tuned. 😇
This a greate video thank you so much. It helped me a lot. But i have one question if you can please answer it. Isn't the "opening stock" the same as the "purchases/stock in". Because bothe of them indicate the stocks on hand right.
Also the "price/unit" in "opening stock" is it the purchasing price or the selling price of the product
Thanks for the knowledge, WHAT A DELICIOUS CONTENT !!, this content is really cool. the explanation is easy to understand.
Thank you very much for the video
Very clear to understand and precise.
Really appreciate this lecture of inventory management on excel
GREAT CONTENT! Quick question and I hope your still answering questions for this, is this for daily update inventory?
Yes you can use it for daily update
@@MicrosoftOfficeTutorials ty for quick response, i'll be subscribing!!!
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!
Thanks for the video. It is very easy to understand and also very helpful. I refer to it often
Thank you very much. Very helpful and simple to understand.
What an awesome video. Honestly one of the most well explained video tutorials I've watched. Thank you
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
Thank you very much it was very useful, i have found it at the right time, thanks
thank you! great video, following step by step make my own tracking sheet. subscribed
Thanks....it was realistic to implement this in working environment
Thank you so much! I learned so much and I'm sure this inventory will serve my business for years :))
you save my timee, thank you so much for uploading this video!!
Are you able to set up and complete this same process without having item codes? Thank you for your help
Yes
So you would reference "item name" rather than "code" ?
Helpful video! I just have a question, what does closing stock mean?
Stock in hand at closing date
Great teacher. I'm using this for my business.
A very good teacher
Woww... wonderful and valuable information..🙏🙏
Thank You Soo Much, can you pls. Help me in maintaining inventory if sales is in kg sometimes and sometimes in square feet and the purchase is in Kg only
Very good tutorial, really every step guided in very good manner
This was amazing!! I learned so much. Thank you!!
I LOVE YOU! Thanks so much for this tutorial
its so easy to follow.nice tutorial👏🏻👏🏻👏🏻
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?
Thank you and more power to your channel
Thanks 😍
hi really helpful, is there any where i can download the template?
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
thanks you so much for this very useful video of yours God bless.
Thank you for this, Mr. It is very helpful
Thank you so much for sharing this valuable video 🙏🙏🙏
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..???
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 ?
Do you have any video showing how to create warehouse locations in Excel for a beginner?
Thanks a lot! This save me a lot of labour time key in data manually! 🤩
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!
What if we want to add an existing product with a different price ? than how we can manage the change in price while selling that item?
Thanks same I want to know that
does it work when working in different spreadsheets ??
Yes, it does
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
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 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?
Sometimes, we've got a problem of credit, as, many times we've to give the things on credit....so is there a way to manage the credit part as well?
Thank you for this learning but I have a doubt, how to add a new item to existing stock ?
Hi, thank you for the details. Sir how can we make a printed document of all items for a particular month. For example no. of an item bought and sold in a month and the amount. Thank you
Really helpful! Thanks!!!! Salute from Philippines!!
Thanks to the teacher, he explained is so well. Do you have any website?
U made it super easy 👏
Sir After copying from purchases table to sales table if item code is entered item name is not shown..
=SUMIFS(V5:V15,S5:S15,Z5), WHAT DOES Z5 STAND FOR? I M NEW . THANK YOU! VERY GOOD VIDEO!
Z5 is cell no. in which we have criteria... Based on which formula will decide what to sum and what not to
@@MicrosoftOfficeTutorials ，thank you!
Hi.thank you so much for your tutorial. awesome 👍
Ηello sir there is any way to add any kind of ability like barcode reader in order to automatically read the products from an invoice (and automatically adding them on the excel app? ?
Yes possible
Wondering tutorial, i will appreciate though if you vould dhow ud the F4 application in dedktop.
We are waiting for this kind of vedio with changes in prices
Very informative video, Thank you so much
Thank you so much for your guide
You are great.super easy way to teach.
Stay Blessed Bro
Thank you very much. This is really helpful.
If you want to learn Excel in Hindi or Urdu language please hit the below link to Subscribe and learn Excel in Hindi / Urdu 😊
youtube.com/@MegaMindTech?sub_confirmation=1
P
you are the best! Thx.
love your way of explaining
Thanks
Thanks for valuable explanation.
Very helpful, thank you! Subscribed
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..
Amazing tutorial....Helped me lot.. :) Thanks for sharing
Very nice video, but how do you add products?
magnificent my friend..
When you paste
How do you maintain previous width of table
Well done, but i think there is two points uncovered #1 price of purchasing not the same as selling #2 items have the same not allowed to add new items
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?
How do you solve underflow problem (if opening stock is 0 and stocking out some item)
Nice video ❤️❤️❤️❤️
Great video
Please do a video on inventory valuation using Weighted Average Cost of Capital
super useful. thank you sir
Hi, Thank you for sharing your knowledge. If I want to add on more Item Code, how to change the formats again?
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
The great and impressive tutorial ever in Inventory management, keep it up
Thanks
mery bhai video aap ki achi ha par Urdu main b kuch bna lo greebon ka b bhala ho jay ga
Hi Sultan
Please iss channel ko b subscribe kr lain..
Ye hnara channel urdu maen ha
RUclips.Com/UrduHindiLectures