Wow such a Great Excel Channel, I’m 73 (in age only) keep my brain active by learning new things. So started on Excel and having found this channel look forward to learning with someone who for me cares about teaching with a clear voice. Now better get started. 👍👏 16/09/2021 Just installed Excel 2019 👍
with the help of this video people, you can not imagine what I got... I was searching for my problem for one month but did not found any clue on youtube I talked with software-provided people but they asking to charge too much... by the grace of Allah Kareem I found this video and it helps me and solve my problem... I m really thank full to Mr. Spreadsheet team that they answered me on my E-mail however they straightforward denied me to solve my problem on my spoken word.. but with little knowledge of formulas editing through watching your video, I reach my achievement... thank you so much
You are fantastic, Perfect speed, clear, top of your game from my perspective with western ears - love the accent, reminds me of the butler on Downton Abbey. Thank you so much!
MANY MANY THANKS A LOT SIR.. I WAS STRUGGLING TO FIND THIS, SAW MANY VIDEOS OF DIFFERENT UA-camRS BUT NOBODY IDENTICALLY EXPLAINED. THANK U SO MUCH ONCE AGAIN SIR. IT WAS GREAT HELP FOR ME.
This has been very helpful to me especially at this time while I was given a task to do the inventory valuation for the month in my office with insufficient training. I would love to learn more from your videos. And I must say that I love your tone of explanations and the manner with which you lay things out. Thanks.
This is beyond helpful for any seller who has to maintain their inventory. Thank you so much for taking the time to make such an informative video and basically showing us how to create our own templates step-by-step. If they're still available, would you kindly send me the link for the download of your templates for these spreadsheets, so that I have some kind of reference (or unable to ) while working on my own templates? Thanks again for your time and effort.
Thank you for the excellent demonstration of how Excel can be used to create an inventory control system. I'd love to receive a copy of the spreadsheet.
👋 Say goodbye to Excel based inventory management! We at Work Tech Guide have launched a Notion powered inventory management template that works much better than Excel or Google Sheets. You can watch the detailed demo video for it right on UA-cam - ua-cam.com/video/8W34BMsWNKE/v-deo.html. It is available for purchase at a one-time price of $14.99 only.
Some of our fulfillment partners are not doing a good job on inventory balances so this is an excellent stand alone for our accounting department to make sure we don't run out of product.
Great stuff! I like the way you combined several different formulas and functions to come up with such a useful template. Thank you. I have one question though. How do you factor in a situation where the costs of your products keep changing very often? Is there a way to build in a means of updating your template without having to create a new template each time costs change or having the new costs change past transactions?
only discovered Mr Spreadsheet today via google search for what i was trying to achieve with a spreadsheet. I found exactly what i was looking for. Although i was familiar with most of the content, i discovered several unknown to me equations and solutions to both this and other problems id previously had. Wish I'd known about this before, could have saved myself hours of torment!!!. A great help and will be my first port of call for future problems
Amazing content. I'm a huge Excel geek and it never ceases to amaze me at it's capabilities. Where to go to download or look up this and other templates?
Great tutorial. Thank you for the this video. I do have a question, what is the function of the adjustment (Sales,receipt,ADJUSTMENT) did not hear you explain its function. Another thing my running Qty is not correct. how do I edit the Range name and formula. Thanks
Hi John, The Adjustment is for anything that is neither a Sale or a Purchase, such as stock losses or write offs etc. You can check your work against the original. Follow the link ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
This was awesome i just want to know what to i do with the Sale Receipt and Adjustments that we used in the R's in deep space do we leave them their forever?
Excellent. This has really helped me in my new business. I've started so many spreadsheets trying to sort inventory but I only needed one....this one! Thank you :-)
Thank you so much this has been very helpful. However, I am having an issue with product not populating with the information when I put my code in its blank and that includes the cost too. I have followed it step by step several times and even starting a new spreadsheet and the same thing keeps happening. What am I doing wrong?
Hi there, this is amazing thank you!! My sales lines aren't showing as negative quantity and value. Could you please let me know what I need to do to fix this? Thank you
@@MrSpreadSheet Hello, thank you for replying. It should work on Excel in NZ too. How do I format the cells in order to get the negative, please? Is it simply the way I format the number? Or something else? Thank you very much :)
Loved this tutorial! I begin working as a stock controller on Monday, and I believe this spreadsheet will aid me greatly. A quick one: how do I go about entering stock that's on hand?
This is such a great video . I have never really created anything on excel but with your video i followed through and created though i got stucked somewhere. I later found the template link and downloaded it but i dont really understand how to use the download. Please do you have a video or a guide that explains how i can use the template? Would appreciate it
I am going for a job interview and reviewing the excel function. Love your explanation and clear voice. Thanks a lot for making it easier to understand.
Your explanations of how to do things in excel and how to make the work is amazing. I would love it if you had a video on how to create a bill of materials and how to use it with a hire company. Can you please do a video of that?
I'm brand new to using spreadsheets for inventory. Running a startup, would really like a copy of this sheet to get us going. Thank you kindly Mr. Spreadsheet!
Glad you liked the presentation. The file you have requested can be obtained by following the guide in this video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
I was in desperate need of a simple Inventory management system and this really will do the trick. I learned so much during the presentation. Thanks for putting this on UA-cam!!! Please send me a copy of the spreadsheet
Thank you so much for this channel. I started off with your inventory listing program, and now I want to use this program. Do you have anything that explains how to use this spread sheet, or your others.
Hi Teri, Glad you found it useful. Why not take a look at the templates. Please follow the ‘Download’ guide in this link 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
This was an absolute eye opener for me being an Excellent novice. The only thing I missed, was I can’t figure out how to make ‘Sale’ in the Type drop down to subtract. It adds as receipt and adjustment do.
Frankly, I'm surprised how clear and accessible your explanations are. Very well done. Would love to get a copy of the spreadsheet (but I'll work on creating it myself anyway). Thank you.
Is there a way to always make the Sale Qty negative as you enter it? I saw your comment to a Ryan, but this begs for a more elegant solution (which I'm sure you can come up with). Would be icing on the cake - it absolutely needs a seamless solution, and it would be perfect. Thanks.
@@MrSpreadSheet I totally understand it better now. Just one more question, if I'm making this spreadsheet for a clothing/apparel line. So I would have to enter the following under The Inventory List; each item, each color, and each size individually. And on the Inventory In & Out Schedule, I would have to add them as well as receipt, in order to keep up with my inventory, and minus all the sells?
Wow such a Great Excel Channel, I’m 73 (in age only) keep my brain active by learning new things. So started on Excel and having found this channel look forward to learning with someone who for me cares about teaching with a clear voice. Now better get started. 👍👏 16/09/2021 Just installed Excel 2019 👍
That's great, glad to help ... :-)
with the help of this video people, you can not imagine what I got... I was searching for my problem for one month but did not found any clue on youtube I talked with software-provided people but they asking to charge too much... by the grace of Allah Kareem I found this video and it helps me and solve my problem... I m really thank full to Mr. Spreadsheet team that they answered me on my E-mail however they straightforward denied me to solve my problem on my spoken word.. but with little knowledge of formulas editing through watching your video, I reach my achievement... thank you so much
Thanks once again :-)
You are fantastic, Perfect speed, clear, top of your game from my perspective with western ears - love the accent, reminds me of the butler on Downton Abbey. Thank you so much!
Thanks! 😃
❤
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊
6😂@@lizavergara6115
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊
6😂@@lizavergara6115
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊
6😂@@lizavergara6115
This has helped keep my drug business efficient 😅 thank you loads
Hi Sam, That's great :-)
@@MrSpreadSheet is the link you provided still active? It says the video is private when I click it
@sk00770 now the entire government can just find your spreadsheet in the “cloud” 😂🤣 paper can’t be hacked!!! Lol
MANY MANY THANKS A LOT SIR.. I WAS STRUGGLING TO FIND THIS, SAW MANY VIDEOS OF DIFFERENT UA-camRS BUT NOBODY IDENTICALLY EXPLAINED. THANK U SO MUCH ONCE AGAIN SIR. IT WAS GREAT HELP FOR ME.
Glad it helped :-)
This has been very helpful to me especially at this time while I was given a task to do the inventory valuation for the month in my office with insufficient training. I would love to learn more from your videos. And I must say that I love your tone of explanations and the manner with which you lay things out. Thanks.
Glad it helped! :-)
Pls do you mind putting me through because I find myself in the same position now
i don't understand why it too YT so long to show me this valuable video instruction. I am hooked though. Thanks. Expertly explained.
Glad it was helpful!
This is beyond helpful for any seller who has to maintain their inventory. Thank you so much for taking the time to make such an informative video and basically showing us how to create our own templates step-by-step. If they're still available, would you kindly send me the link for the download of your templates for these spreadsheets, so that I have some kind of reference (or unable to ) while working on my own templates? Thanks again for your time and effort.
Hi Lisa, Glad it was helpful. Please follow the ‘Download’ guide in this link 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
Wow just created a spreadsheet to monitor our Medicines, using the same layout as the Inventory Spreadsheet. Thanks again Mr SpreadSheets 👍
Fantastic!
Thank you for the excellent demonstration of how Excel can be used to create an inventory control system. I'd love to receive a copy of the spreadsheet.
Hi Bill, thanks for your comments, please refer to the guide at the end of the video :-)
👋 Say goodbye to Excel based inventory management! We at Work Tech Guide have launched a Notion powered inventory management template that works much better than Excel or Google Sheets. You can watch the detailed demo video for it right on UA-cam - ua-cam.com/video/8W34BMsWNKE/v-deo.html. It is available for purchase at a one-time price of $14.99 only.
Some of our fulfillment partners are not doing a good job on inventory balances so this is an excellent stand alone for our accounting department to make sure we don't run out of product.
Glad it is of use :-)
Great stuff! I like the way you combined several different formulas and functions to come up with such a useful template. Thank you. I have one question though. How do you factor in a situation where the costs of your products keep changing very often? Is there a way to build in a means of updating your template without having to create a new template each time costs change or having the new costs change past transactions?
Hi Kwasi, a common question, I will cover this in a future video :-)
@@MrSpreadSheet grabs seat to wait for this
Has this feature been put into a video yet? I find myself in need of this feature also.
WOW! I'm a computer DUMMY and have never learned Excel, this was AWESOME! Thank you!
Glad it was helpful!
I would like a copy of the spreadsheet. Your style is quite unique and such that it encourages me.
Thank you. Please follow the guide at the end of the video to get the file.
Totally awesome....in minutes our storeroom figures have changed focus
Well done Tony :-)
only discovered Mr Spreadsheet today via google search for what i was trying to achieve with a spreadsheet. I found exactly what i was looking for. Although i was familiar with most of the content, i discovered several unknown to me equations and solutions to both this and other problems id previously had. Wish I'd known about this before, could have saved myself hours of torment!!!. A great help and will be my first port of call for future problems
That's great Deborah, glad you found it useful. 😊
Loved the simplicity. Also enjoyable to watch. Would love to get a copy of the spreadseet.
Thank you. To get a copy please refer to the guide at the end of the video :-)
Well paced, clearly explained with an appropriate level of detail. This is a very professional tutorial, thank you
Glad it was helpful!
Amazing content. I'm a huge Excel geek and it never ceases to amaze me at it's capabilities. Where to go to download or look up this and other templates?
Thanks, please refer to the guide at the end of the video :-)
Would love a copy of this spreadsheet please.
AWESOME!!, just created an inventory management spreadsheet for my warehouse. Thank you, this was very easy to follow.
Well done Enrique 🙌
This was amazing! Step-by-step and completely idiot-proof so I should be good. Thx Mr. SpreadSheet.
Thanks Jonathan and good luck :-)
This was amazingly helpful ... Thank you so much
Glad you found it useful :-)
I loveeeeeee your pronounciation, your explanation (super details!). I subscribe you from now on!!!!
Thank you! 😃
Super video solved some problems I had setting up my inventory spreadsheet. Thank you
Glad it helped!
Thank you Mr. SpreadSheet.. I've done it !.. VerySImple and helpful.. when I was struggling tried to find an apps for inventory.. thx again..
Glad it helped!
Thank you good sir, youve helped lots of people saving lots of money and time which are equally important
Thanks Mergawi :-)
I was just getting ready to beg my boss to buy inventory software . . . THANK YOU!!!
Glad I could help! :-)
Thanks very much for great knowledge on Inventory
Glad it was helpful!
Thanks for keeping it simple and clear.
Glad it was helpful!
Great tutorial. Thank you for the this video. I do have a question, what is the function of the adjustment (Sales,receipt,ADJUSTMENT) did not hear you explain its function. Another thing my running Qty is not correct. how do I edit the Range name and formula. Thanks
Hi John, The Adjustment is for anything that is neither a Sale or a Purchase, such as stock losses or write offs etc. You can check your work against the original. Follow the link ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
5:25
This was awesome i just want to know what to i do with the Sale Receipt and Adjustments that we used in the R's in deep space do we leave them their forever?
Guess so ... 😎
Mr.Spreadsheet you rock!
Thanks ...
great tool.. really helps keep track my products. easy to use and learn. thank you
Glad you found it useful :-)
SImple and easy, thanks for the instruction👍
Glad it was helpful!
Woooooooooow, an awesome content, very well explained even to a novice, thank you so much, your video has helped me plan a well-organized inventory
You're very welcome! :-)
Excellent. This has really helped me in my new business. I've started so many spreadsheets trying to sort inventory but I only needed one....this one! Thank you :-)
You're very welcome!
I don't even know what you're selling, but I'm buying it! 😆
@@grittysmitty5028 🤣🤣
This was really helpful and easy to follow. Thanks for the video
You're very welcome!
Simply excellent and easy to understand...thanks
Glad it was helpful!
Thank you so much this has been very helpful. However, I am having an issue with product not populating with the information when I put my code in its blank and that includes the cost too. I have followed it step by step several times and even starting a new spreadsheet and the same thing keeps happening. What am I doing wrong?
Hi Candy, You can check your work against the original. See the download guide video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
Thank you so much. This was such a big help for my 2023 inventory and sales. Do you have a video on how to copy the formats for my 2024?
Glad you found it useful. You can use the same template for any year. :-)
I really like this approach.
Glad you liked it :-)
Hi there, this is amazing thank you!! My sales lines aren't showing as negative quantity and value. Could you please let me know what I need to do to fix this? Thank you
Hi Tuesday, this feature works fine in the UK, however Excel settings in other regions may not support this. So, not your fault. :-)
@@MrSpreadSheet Hello, thank you for replying. It should work on Excel in NZ too. How do I format the cells in order to get the negative, please? Is it simply the way I format the number? Or something else? Thank you very much :)
very nice spread Sheet.. Great work.. God Bless You....EL CHEF....
Thanks a lot :-)
Very simple and straightforward way to get this done. Thank you and please share a copy of the spreadsheet.
Thank you Dave, I'm glad you found it useful. Please follow the guide at the end of the video to get a copy of the template :-)
@@MrSpreadSheet already done the end of the viode now how to get a copy?
Excellent video - the best I have seen thank you
Glad you enjoyed it
This is amazing for small businesses!
Thanks, glad you found it useful :-)
best video for inventory in excel
Thanks David, glad you found it useful :-)
Such a fantastic tutorial
Thank you! :-)
Excellent. This is very helpul and easy to use. May I request a copy of this spreadsheet to practice the template. Thanks.
Hi Carmelo, downloads are available at www.MrSpreadSheet.com :-)
BEST TUTORIAL. THANK YOU
Glad you liked it!
Thank you for the immense help. Very helpful.
You're very welcome! :-)
This is very helpful to me on many levels
That's great. Glad you you liked it :-)
I would love copy this was such a helpful field for my restocking !
Hi Giovanni, The file you have requested can be obtained by following the guide in this video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
excellent explanation. thank you very much
Glad you liked it :-)
Very Helpfull and super easy to understand.
Glad it was helpful! :-)
Loved this tutorial! I begin working as a stock controller on Monday, and I believe this spreadsheet will aid me greatly.
A quick one: how do I go about entering stock that's on hand?
Hi, Glad you found it useful. Enter Open Stock with Qty and Average Unit Value :-)
Excellent video and very helpful. Thank you very much. 👍
Glad you enjoyed it!
This is such a great video . I have never really created anything on excel but with your video i followed through and created though i got stucked somewhere. I later found the template link and downloaded it but i dont really understand how to use the download. Please do you have a video or a guide that explains how i can use the template? Would appreciate it
Hi, Thanks for your comments. Simply open up the download in Excel and then copy/examine the various functions and formulae. :-)
I am going for a job interview and reviewing the excel function. Love your explanation and clear voice. Thanks a lot for making it easier to understand.
Best of luck!
Your explanations of how to do things in excel and how to make the work is amazing.
I would love it if you had a video on how to create a bill of materials and how to use it with a hire company. Can you please do a video of that?
Thanks Brooke, BoM is definitely on the 'To Do' list :-)
Very clear and easy to understand! I've watched few .. this one is the best. A copy of the template will be very helpful. Thank you.
Glad it was helpful! :-)
very informative, and I understood everything
Glad it was helpful!
thank you CFI, my excel knowledge is always improving thanks to you, Mr Spreadsheet.
That's great :-)
Thank you, It was excellent, so simply and accurately explained.
You're very welcome!
Thank you for posting. Thank you, I received it!
Hi Luge, please see the guide at the end of the video :-)
Great tutorial, is it possible to still have this run correctly if I want the Inventory In and Out section on a different tab?
Hi, Yes, that should be OK :-)
Awesome instructions, they were better than my college instructor. I actually understood this time!
Thanks Phyllis, glad it helped :-)
Really helpful tutorial. Thank you.
You're welcome!
Using for a new job. Thank you
That's great - Good Luck with the new job :-)
I'm brand new to using spreadsheets for inventory. Running a startup, would really like a copy of this sheet to get us going. Thank you kindly Mr. Spreadsheet!
Hi Bryce, The file you have requested can be obtained by following the guide in this video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
@@MrSpreadSheet Thank you kindly! I look forward to learning more from your great videos! You have a new fan. :)
A great tutoring!! may i have the template of this inventory spreadsheet. Thanks
Glad you liked the presentation. The file you have requested can be obtained by following the guide in this video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
Very clear and precise. Thank you!
You're very welcome!
What does Adjustment mean on the IN & OUT SCHEDULE that will be under Type column?
Hi Kima, any adjustment to inventory that is not a purchase or a sale. For example, damaged items, samples given etc...
Thank you for this informative video
Glad it was helpful!
This was super helpful and so clearly explained. Thank you.
Thanks Joan :-)
Great demonstration
Thanks Rique, glad you liked it :-)
I was in desperate need of a simple Inventory management system and this really will do the trick. I learned so much during the presentation. Thanks for putting this on UA-cam!!!
Please send me a copy of the spreadsheet
Glad it helped! Please follow the guide at the end of the video 😊 to get a copy
This is just what I needed to set up inventory. Thanks
Glad you found it useful :-)
Great Tutorial.
Thanks!
Thank you so much for this channel. I started off with your inventory listing program, and now I want to use this program. Do you have anything that explains how to use this spread sheet, or your others.
Hi Teri, Glad you found it useful. Why not take a look at the templates. Please follow the ‘Download’ guide in this link 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
This was an absolute eye opener for me being an Excellent novice. The only thing I missed, was I can’t figure out how to make ‘Sale’ in the Type drop down to subtract. It adds as receipt and adjustment do.
Hi Kellyhouse03, the value needs to be entered as a negative value. :-)
@@MrSpreadSheet - Got it! Thanks again for this awesome video!
Well described thank you,it’s helpful
Hi Hanan, Glad you found it useful.
Excellent video this is what I was looking . Can I get a copy of this Spreadsheet thanks
Please see our ‘Free Mr. SpreadSheet templates’ video 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
Great video! Thanks so much!
Glad it was helpful!
Excellent tutorial
Glad you liked it
I figured it out... hahaha thank you! I enjoy the videos, I appreciate it! Easy to follow and you are a great teacher for sure!.
Glad to help! :-)
Hello, your videos are very helpful and would love to obtain a copy of this specific spreadsheet. Thank you
Hi, Downloads are available at www.MrSpreadSheet.com :-
Good made it easy to understand 👍
Glad you liked it!
Frankly, I'm surprised how clear and accessible your explanations are. Very well done. Would love to get a copy of the spreadsheet (but I'll work on creating it myself anyway). Thank you.
Is there a way to always make the Sale Qty negative as you enter it? I saw your comment to a Ryan, but this begs for a more elegant solution (which I'm sure you can come up with). Would be icing on the cake - it absolutely needs a seamless solution, and it would be perfect. Thanks.
Thanks for your comments Sam, The Negative Sales is a standard Excel number format. :-)
I really love the presentation. May I request for the copy of templatr please. Thank you.
Hi Kervin, Please see our ‘Free Mr. SpreadSheet templates’ video 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
This video is very helpful! Do you have anything to help you when your product costs change or increase as more inventory is purchased, etc?
Hi Amy, We are planning a new video to cover exactly this. Should be live within weeks. :-)
@@MrSpreadSheet Great! I will wait to implement until this video is out!
Looks Great! Now to attempt it....I'm an Excel novice.
Go for it!
Appreciate it, this was very helpful. Just one question, what the difference between the three (Sale, Receipt, and Adjustment?
Hi DeOntae, They are the types of inventory movements, i.e. In/Out for purchase and sales, Adjustment for anything other than these, :-)
@@MrSpreadSheet I totally understand it better now. Just one more question, if I'm making this spreadsheet for a clothing/apparel line. So I would have to enter the following under The Inventory List; each item, each color, and each size individually. And on the Inventory In & Out Schedule, I would have to add them as well as receipt, in order to keep up with my inventory, and minus all the sells?
Wow! Really like It. Best one
Thanks a lot 😊
Cj I love this tutorial.
Thanks Chris :-)
This was very helpful. I would very much line a copy of this spreadsheet.
Hi Brian, The file you have requested can be obtained by visiting 😊 www.MrSpreadsheet.com/products/free-inventory-spreadsheet-template
Thanks for sharing it is valuable video.
Glad it was helpful!
多謝!
? :-)
Just what I was looking for. Great video🤟
Glad I could help
Clear and concise, i will be re-visiting for further info. Thank You
Glad it was helpful!