How to keep Inventory using an Excel Spreadsheet - [create your own Template]
Тәжірибелік нұсқаулар және стиль
If you need to keep an Inventory for your products and would like to use an Excel spreadsheet to do this, then please watch this short video, where, I will create an Inventory List table and an Inventory Movements schedule.
These two spreadsheets can form the basis for your business to keep accurate Inventory records both in terms of Value and Quantity.
The finished template uses many Excel techniques such as Drop Down boxes, VLOOKUP commands, SUMIF commands and DATA VALIDATIONS all of which are explained in detail.
As usual you can request a copy of the finished template for you to study and practice on. Just follow the instructions at the end of the video.
Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks
Free Inventory Spreadsheet Template - www.MrSpreadsheet.com/product...
You can also visit our websites at:
USA & Canada & World - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
Or our Social channels:
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting
Пікірлер: 1 500
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 👍
@MrSpreadSheet
3 жыл бұрын
That's great, glad to help ... :-)
This has helped keep my drug business efficient 😅 thank you loads
@MrSpreadSheet
Жыл бұрын
Hi Sam, That's great :-)
@user-ew8bm8cl4q
Жыл бұрын
@@MrSpreadSheet is the link you provided still active? It says the video is private when I click it
@willdunham6724
8 ай бұрын
@sk00770 now the entire government can just find your spreadsheet in the “cloud” 😂🤣 paper can’t be hacked!!! Lol
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!
@MrSpreadSheet
2 жыл бұрын
Thanks! 😃
@lizavergara6115
2 жыл бұрын
❤
@Ingrid-gd1js
3 ай бұрын
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊 6😂@@lizavergara6115
@Ingrid-gd1js
3 ай бұрын
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊 6😂@@lizavergara6115
@Ingrid-gd1js
3 ай бұрын
Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊 6😂@@lizavergara6115
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
@MrSpreadSheet
2 жыл бұрын
Thanks once again :-)
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.
@MrSpreadSheet
10 ай бұрын
Glad it helped! :-)
@user-ls6sv6oh9p
8 ай бұрын
Pls do you mind putting me through because I find myself in the same position now
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.
@MrSpreadSheet
2 жыл бұрын
Hi Lisa, Glad it was helpful. Please follow the ‘Download’ guide in this link 😊 kzread.info/dash/bejne/n2uOyJqYhbq2d7Q.html
thank you CFI, my excel knowledge is always improving thanks to you, Mr Spreadsheet.
@MrSpreadSheet
3 жыл бұрын
That's great :-)
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.
@MrSpreadSheet
3 жыл бұрын
Glad it is of use :-)
Loved the simplicity. Also enjoyable to watch. Would love to get a copy of the spreadseet.
@MrSpreadSheet
3 жыл бұрын
Thank you. To get a copy please refer to the guide at the end of the video :-)
I would like a copy of the spreadsheet. Your style is quite unique and such that it encourages me.
@MrSpreadSheet
3 жыл бұрын
Thank you. Please follow the guide at the end of the video to get the file.
This is excellent and exactly what I needed to keep track of my inventory for my small business.
@MrSpreadSheet
Жыл бұрын
Glad you found it useful Angel. :-)
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.
@MrSpreadSheet
2 жыл бұрын
Hi Bill, thanks for your comments, please refer to the guide at the end of the video :-)
@worktechguide
2 жыл бұрын
👋 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 KZread - kzread.info/dash/bejne/aotnlqSGo7q0e6g.html. It is available for purchase at a one-time price of $14.99 only.
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?
@MrSpreadSheet
2 жыл бұрын
Hi Kwasi, a common question, I will cover this in a future video :-)
@oluwatosindada2164
10 ай бұрын
@@MrSpreadSheet grabs seat to wait for this
@colleenvolpone4515
4 ай бұрын
Has this feature been put into a video yet? I find myself in need of this feature also.
I was just getting ready to beg my boss to buy inventory software . . . THANK YOU!!!
@MrSpreadSheet
2 ай бұрын
Glad I could help! :-)
WOW! I'm a computer DUMMY and have never learned Excel, this was AWESOME! Thank you!
@MrSpreadSheet
3 жыл бұрын
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?
@MrSpreadSheet
3 жыл бұрын
Thanks, please refer to the guide at the end of the video :-)
@keithcranston1509
8 ай бұрын
Would love a copy of this spreadsheet please.
Wow just created a spreadsheet to monitor our Medicines, using the same layout as the Inventory Spreadsheet. Thanks again Mr SpreadSheets 👍
@MrSpreadSheet
3 жыл бұрын
Fantastic!
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 :-)
@MrSpreadSheet
2 жыл бұрын
You're very welcome!
@grittysmitty5028
2 жыл бұрын
I don't even know what you're selling, but I'm buying it! 😆
@joclare656
2 жыл бұрын
@@grittysmitty5028 🤣🤣
AWESOME!!, just created an inventory management spreadsheet for my warehouse. Thank you, this was very easy to follow.
@MrSpreadSheet
Жыл бұрын
Well done Enrique 🙌
This was amazing! Step-by-step and completely idiot-proof so I should be good. Thx Mr. SpreadSheet.
@MrSpreadSheet
Жыл бұрын
Thanks Jonathan and good luck :-)
The best Excel tutorial! So easy to follow and concise. Thank you! Now for a sales template please.
@MrSpreadSheet
Жыл бұрын
Thanks Nozi :-)
Awesome instructions, they were better than my college instructor. I actually understood this time!
@MrSpreadSheet
3 жыл бұрын
Thanks Phyllis, glad it helped :-)
Thank you very much, I really love this. Thanks once again for the knowledge shared, really appreciate.
@MrSpreadSheet
3 жыл бұрын
Thanks Foster, you're comments are always welcome :-)
Thank you, It was excellent, so simply and accurately explained.
@MrSpreadSheet
2 жыл бұрын
You're very welcome!
Thanks for keeping it simple and clear.
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful!
This was an amazing video and very helpful. Looking forward to a copy of the spreadsheet
@MrSpreadSheet
2 жыл бұрын
Please see our ‘Free Mr. SpreadSheet templates’ video 😊 kzread.info/dash/bejne/n2uOyJqYhbq2d7Q.html
Thank you Mr. SpreadSheet.. I've done it !.. VerySImple and helpful.. when I was struggling tried to find an apps for inventory.. thx again..
@MrSpreadSheet
3 жыл бұрын
Glad it helped!
MANY MANY THANKS A LOT SIR.. I WAS STRUGGLING TO FIND THIS, SAW MANY VIDEOS OF DIFFERENT KZreadRS BUT NOBODY IDENTICALLY EXPLAINED. THANK U SO MUCH ONCE AGAIN SIR. IT WAS GREAT HELP FOR ME.
@MrSpreadSheet
2 жыл бұрын
Glad it helped :-)
This was very helpful and easy to use, just the templet one would use in every day asset control to keep track of your assets. Looking forward to a copy of the spreadsheet.
@MrSpreadSheet
2 жыл бұрын
Please follow the ‘Download’ guide in this link 😊 kzread.info/dash/bejne/n2uOyJqYhbq2d7Q.html
This was super helpful and so clearly explained. Thank you.
@MrSpreadSheet
2 жыл бұрын
Thanks Joan :-)
Really enjoyed this tutorial! Easy to follow and implement! I have Someka's stock and inventory tool for google sheets and it's really well designed and easy to use but it's good to know how to create this kind of templates from scratch! Thanks:)
@MrSpreadSheet
Жыл бұрын
Thank's Phoebe, glad you found it useful :-)
Clear and concise, i will be re-visiting for further info. Thank You
@MrSpreadSheet
3 жыл бұрын
Glad it was helpful!
I loveeeeeee your pronounciation, your explanation (super details!). I subscribe you from now on!!!!
@MrSpreadSheet
2 жыл бұрын
Thank you! 😃
Very useful, thank you, its easier when you can see how to do things. :)
@MrSpreadSheet
3 жыл бұрын
Glad it was helpful!
That was amazing, thank-you!
@MrSpreadSheet
3 жыл бұрын
Glad you enjoyed it!
Thank you for the excellent video. It is very suitable and useful for tracking my inventory. I'd love to receive a copy of the spreadsheet.👍👍👍
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful! Please see the instructions at the end of the video :-)
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.
@MrSpreadSheet
2 жыл бұрын
Best of luck!
Totally awesome....in minutes our storeroom figures have changed focus
@MrSpreadSheet
Жыл бұрын
Well done Tony :-)
Mr.Spreadsheet you rock!
@MrSpreadSheet
Жыл бұрын
Thanks ...
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
@MrSpreadSheet
Жыл бұрын
You're very welcome! :-)
Super video solved some problems I had setting up my inventory spreadsheet. Thank you
@MrSpreadSheet
2 жыл бұрын
Glad it helped!
Wow - great stuff. Simple but solid!
@MrSpreadSheet
Жыл бұрын
Glad you like it!
Very clear and precise. Thank you!
@MrSpreadSheet
2 жыл бұрын
You're very welcome!
i don't understand why it too YT so long to show me this valuable video instruction. I am hooked though. Thanks. Expertly explained.
@MrSpreadSheet
Жыл бұрын
Glad it was helpful!
This is just what I needed to set up inventory. Thanks
@MrSpreadSheet
Жыл бұрын
Glad you found it useful :-)
Thank you for posting. Thank you, I received it!
@MrSpreadSheet
2 жыл бұрын
Hi Luge, please see the guide at the end of the video :-)
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
@MrSpreadSheet
Жыл бұрын
That's great Deborah, glad you found it useful. 😊
Thank you for the immense help. Very helpful.
@MrSpreadSheet
2 жыл бұрын
You're very welcome! :-)
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!.
@MrSpreadSheet
2 жыл бұрын
Glad to help! :-)
WOW this is great! Thank you very much.
@MrSpreadSheet
3 жыл бұрын
Glad you liked it!
SImple and easy, thanks for the instruction👍
@MrSpreadSheet
Жыл бұрын
Glad it was helpful!
Well described thank you,it’s helpful
@MrSpreadSheet
Жыл бұрын
Hi Hanan, Glad you found it useful.
Great video! Thanks so much!
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful!
Just what I was looking for. Great video🤟
@MrSpreadSheet
Жыл бұрын
Glad I could help
thanks for this video! I can't wait to try it.
@MrSpreadSheet
3 жыл бұрын
Hi Cyn, Glad you liked it :-)
Thanks for sharing, very helpful!
@MrSpreadSheet
2 жыл бұрын
Hi Stephen, Glad you found it helpful :-)
Thanks so much for the great video!
@MrSpreadSheet
2 жыл бұрын
Thanks Mike :-)
Thanks very much for great knowledge on Inventory
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful!
Using for a new job. Thank you
@MrSpreadSheet
13 күн бұрын
That's great - Good Luck with the new job :-)
This was very informative and fairly easy to set up. Thank you
@MrSpreadSheet
Жыл бұрын
Glad it was helpful!
Absolutely amazing wonderful
@MrSpreadSheet
2 жыл бұрын
Thank you very much!
This is excellent and exactly what I need!
@MrSpreadSheet
Жыл бұрын
Hi Namayombo, glad you found it useful :-)
This was amazingly helpful ... Thank you so much
@MrSpreadSheet
3 ай бұрын
Glad you found it useful :-)
You are great! Thank you!
@MrSpreadSheet
2 жыл бұрын
Thank you :-)
Excellent! Very informative.
@MrSpreadSheet
Жыл бұрын
Hi Peter, thank you so much!
You are a life saver!!! Thank you!!!
@MrSpreadSheet
2 жыл бұрын
Happy to help!
Thank you good sir, youve helped lots of people saving lots of money and time which are equally important
@MrSpreadSheet
Жыл бұрын
Thanks Mergawi :-)
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.
@samlicorish5645
2 жыл бұрын
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
2 жыл бұрын
Thanks for your comments Sam, The Negative Sales is a standard Excel number format. :-)
Great video…thank you!!
@MrSpreadSheet
2 жыл бұрын
Glad you liked it! :-)
Really helpful tutorial. Thank you.
@MrSpreadSheet
Жыл бұрын
You're welcome!
Simply amazing!!! thanks a lot
@MrSpreadSheet
3 жыл бұрын
Glad you liked it!
Hello! I'm excited to learn more and practice with the downloadable templates (for all three spreadsheets, if available). Thank you so much! Happy New Year!
@MrSpreadSheet
Жыл бұрын
Hi Mysch57, Please see our ‘Free Mr. SpreadSheet templates’ video 😊 kzread.info/dash/bejne/n2uOyJqYhbq2d7Q.html
Thank you very much!! It was clear.
@MrSpreadSheet
3 жыл бұрын
Glad it helped!
This was really helpful and easy to follow. Thanks for the video
@MrSpreadSheet
10 ай бұрын
You're very welcome!
Thanks very much for this video, it was very helpful
@MrSpreadSheet
2 жыл бұрын
You are welcome!
Thank you very much, It is really helpful
@MrSpreadSheet
3 жыл бұрын
You are welcome!
I will love a copy, I've given the video a thumbs up.
@MrSpreadSheet
3 жыл бұрын
Hi Prince, please message me on FB :-)
Great video, I knew most of the formulas but couldn't picture using multiple tabes to get the answers I needed. Thanks
@MrSpreadSheet
3 жыл бұрын
Glad it helped!
Great demonstration
@MrSpreadSheet
Жыл бұрын
Thanks Rique, glad you liked it :-)
Great! Thank you.
@MrSpreadSheet
8 ай бұрын
Glad you liked it!
Excellent presented, clear and precise!
@MrSpreadSheet
Жыл бұрын
Glad it was helpful!
Amazing! Thanks.
@MrSpreadSheet
2 жыл бұрын
Thank you too!
Thank you. Very clear and understandable.
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful! :-)
You're the best!
@MrSpreadSheet
3 жыл бұрын
Thanks Tim...
excellent explanation. thank you very much
@MrSpreadSheet
2 жыл бұрын
Glad you liked it :-)
so helpful!! thank you
@MrSpreadSheet
Жыл бұрын
Glad it was helpful! 😊
Such a fantastic tutorial
@MrSpreadSheet
2 жыл бұрын
Thank you! :-)
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?
@MrSpreadSheet
Жыл бұрын
Thanks Brooke, BoM is definitely on the 'To Do' list :-)
Great tutorial!!! Very useful!!
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful!
Awesome video. I learned alot!
@MrSpreadSheet
Жыл бұрын
Hi Harla, glad you found it useful! :)
Thank you for this ❤
@MrSpreadSheet
6 ай бұрын
You're welcome 😊
Excellent video and very helpful. Thank you very much. 👍
@MrSpreadSheet
2 жыл бұрын
Glad you enjoyed it!
Thank you for this informative video
@MrSpreadSheet
Жыл бұрын
Glad it was helpful!
Thank you very much for the great information, by this I m made my own data sheet to use my business
@MrSpreadSheet
Жыл бұрын
Glad it was helpful! 😊
These videos are very well done and yes I would love a template of this
@MrSpreadSheet
3 жыл бұрын
Hi Jason, please follow the guide at the end of the video :-)
This was very helpful. I would very much line a copy of this spreadsheet.
@MrSpreadSheet
Жыл бұрын
Hi Brian, The file you have requested can be obtained by visiting 😊 www.MrSpreadsheet.com/products/free-inventory-spreadsheet-template
Just set this up. Thank you
@MrSpreadSheet
6 ай бұрын
Well done :-)
Simply excellent and easy to understand...thanks
@MrSpreadSheet
2 жыл бұрын
Glad it was helpful!
BEST TUTORIAL. THANK YOU
@MrSpreadSheet
Жыл бұрын
Glad you liked it!
wery useful, thanks a lot!
@MrSpreadSheet
2 жыл бұрын
Glad it helped! :-)