How to keep Inventory using an Excel Spreadsheet - [create your own Template]

Подписаться 35 тыс.

Просмотров 855 тыс.

50% 1

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

Хобби

Опубликовано:

21 ноя 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1,4 тыс.

@abdullahiabiodun7512 9 месяцев назад

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 9 месяцев назад

Glad it helped! :-)

@user-ls6sv6oh9p 7 месяцев назад

Pls do you mind putting me through because I find myself in the same position now

@louisawelsh1169 2 года назад

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 Год назад

❤

@Ingrid-gd1js 2 месяца назад

Uiñ8uuuuiyi0pñpuppppppppippi😂Qi5iiiiiiiiiiiiiiiíiiiiiiiiiiiíiiiiiiiiiiiiiíiiiiiioiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii77iìiiiii7iiiii7ii7iiiiii777777777ìiiuuuuuuú😂5😊😊😊😊😊😊😊 6😂@@lizavergara6115

@Ingrid-gd1js 2 месяца назад

@user-qe1zs1gz3j 28 дней назад

I was just getting ready to beg my boss to buy inventory software . . . THANK YOU!!!

@MrSpreadSheet 28 дней назад

Glad I could help! :-)

@amadougitteh2058 3 года назад

thank you CFI, my excel knowledge is always improving thanks to you, Mr Spreadsheet.

@MrSpreadSheet 3 года назад

That's great :-)

@sk00770 Год назад

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 7 месяцев назад

@sk00770 now the entire government can just find your spreadsheet in the “cloud” 😂🤣 paper can’t be hacked!!! Lol

@lisajohns8586 2 года назад

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 😊 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html

@AngelMartinez-lf6sp Год назад

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. :-)

@shawnharmon6666 3 года назад

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 :-)

@stewartwilkinsonsnr 2 года назад

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 2 года назад

That's great, glad to help ... :-)

@tanyastaten6931 3 года назад

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.

@thebigbacon Год назад

AWESOME!!, just created an inventory management spreadsheet for my warehouse. Thank you, this was very easy to follow.

@MrSpreadSheet Год назад

Well done Enrique 🙌

@nozisikhonde6426 Год назад

The best Excel tutorial! So easy to follow and concise. Thank you! Now for a sales template please.

@MrSpreadSheet Год назад

Thanks Nozi :-)

@kwasidzah1457 Год назад

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 Год назад

Hi Kwasi, a common question, I will cover this in a future video :-)

@oluwatosindada2164 8 месяцев назад

@@MrSpreadSheet grabs seat to wait for this

@colleenvolpone4515 2 месяца назад

Has this feature been put into a video yet? I find myself in need of this feature also.

@foodpantry4240 3 года назад

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 :-)

@joclare656 Год назад

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 Год назад

You're very welcome!

@grittysmitty5028 Год назад

I don't even know what you're selling, but I'm buying it! 😆

@joclare656 Год назад

@@grittysmitty5028 🤣🤣

@shahzadshah146 2 года назад

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 :-)

@billohearn9015 2 года назад

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 RU-vid - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8W34BMsWNKE.html. It is available for purchase at a one-time price of $14.99 only.

@cbalian 3 года назад

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 7 месяцев назад

Would love a copy of this spreadsheet please.

@fosternkansahboye5327 3 года назад

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 :-)

@carolfletcher3533 3 года назад

WOW! I'm a computer DUMMY and have never learned Excel, this was AWESOME! Thank you!

@MrSpreadSheet 3 года назад

Glad it was helpful!

@phoebedavis5526 Год назад

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 :-)

@niceperfume8442 2 года назад

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 😊 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html

@jonathanbernardini75 Год назад

This was amazing! Step-by-step and completely idiot-proof so I should be good. Thx Mr. SpreadSheet.

@MrSpreadSheet Год назад

Thanks Jonathan and good luck :-)

@mvakili11 2 года назад

Thank you, It was excellent, so simply and accurately explained.

@MrSpreadSheet 2 года назад

You're very welcome!

@chelsav7479 2 года назад

Super video solved some problems I had setting up my inventory spreadsheet. Thank you

@MrSpreadSheet 2 года назад

Glad it helped!

@stewartwilkinsonsnr 2 года назад

Wow just created a spreadsheet to monitor our Medicines, using the same layout as the Inventory Spreadsheet. Thanks again Mr SpreadSheets 👍

@MrSpreadSheet 2 года назад

Fantastic!

@pamgde 2 года назад

Awesome instructions, they were better than my college instructor. I actually understood this time!

@MrSpreadSheet 2 года назад

Thanks Phyllis, glad it helped :-)

@Up2RunTechnology 2 года назад

Thanks for keeping it simple and clear.

@MrSpreadSheet 2 года назад

Glad it was helpful!

@penicameron66 2 года назад

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 2 года назад

Glad it helped!

@joanwilliams4002 Год назад

This was super helpful and so clearly explained. Thank you.

@MrSpreadSheet Год назад

Thanks Joan :-)

@jacobusdewaal8755 2 года назад

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 😊 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html

@getdean1 Год назад

This is just what I needed to set up inventory. Thanks

@MrSpreadSheet Год назад

Glad you found it useful :-)

@wongtongmin8542 2 года назад

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 :-)

@mysch5728 Год назад

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 😊 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html

@Bottca 3 года назад

Very useful, thank you, its easier when you can see how to do things. :)

@MrSpreadSheet 3 года назад

Glad it was helpful!

@lugeexperience4813 2 года назад

Thank you for posting. Thank you, I received it!

@MrSpreadSheet 2 года назад

Hi Luge, please see the guide at the end of the video :-)

@martinireland661 3 года назад

Clear and concise, i will be re-visiting for further info. Thank You

@MrSpreadSheet 3 года назад

Glad it was helpful!

@samuelesther5483 Год назад

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! :-)

@jasminec8278 Год назад

MANY MANY THANKS A LOT SIR.. I WAS STRUGGLING TO FIND THIS, SAW MANY VIDEOS OF DIFFERENT RU-vidRS BUT NOBODY IDENTICALLY EXPLAINED. THANK U SO MUCH ONCE AGAIN SIR. IT WAS GREAT HELP FOR ME.

@MrSpreadSheet Год назад

Glad it helped :-)

@brookechapman2935 Год назад

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 :-)

@Xx-xz8bs Год назад

I loveeeeeee your pronounciation, your explanation (super details!). I subscribe you from now on!!!!

@MrSpreadSheet Год назад

Thank you! 😃

@timothyrose4052 2 года назад

Very clear and precise. Thank you!

@MrSpreadSheet 2 года назад

You're very welcome!

@tonychirenje6686 Год назад

Totally awesome....in minutes our storeroom figures have changed focus

@MrSpreadSheet Год назад

Well done Tony :-)

@cecelliamenezes9534 2 года назад

Thank you for the immense help. Very helpful.

@MrSpreadSheet 2 года назад

You're very welcome! :-)

@richardbrooman9464 Месяц назад

This was amazingly helpful ... Thank you so much

@MrSpreadSheet Месяц назад

Glad you found it useful :-)

@xnbet Год назад

Wow - great stuff. Simple but solid!

@MrSpreadSheet Год назад

Glad you like it!

@wandagreer9144 Год назад

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!

@richardmitchell7386 Год назад

Mr.Spreadsheet you rock!

@MrSpreadSheet Год назад

Thanks ...

@brinaborn Год назад

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 Год назад

Glad to help! :-)

@alanhuynh8957 3 года назад

That was amazing, thank-you!

@MrSpreadSheet 3 года назад

Glad you enjoyed it!

@brijrajsinghrathore4819 2 года назад

Thanks very much for great knowledge on Inventory

@MrSpreadSheet 2 года назад

Glad it was helpful!

@jeffduring1 Год назад

This was very informative and fairly easy to set up. Thank you

@MrSpreadSheet Год назад

Glad it was helpful!

@RejeesVlogz Год назад

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! 😊

@nganduchinene247 29 дней назад

great tool.. really helps keep track my products. easy to use and learn. thank you

@MrSpreadSheet 29 дней назад

Glad you found it useful :-)

@Ozoned Год назад

SImple and easy, thanks for the instruction👍

@MrSpreadSheet Год назад

Glad it was helpful!

@giovannisanchez8147 Год назад

I would love copy this was such a helpful field for my restocking !

@MrSpreadSheet Год назад

Hi Giovanni, The file you have requested can be obtained by following the guide in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html 😊

@oluwatosindada2164 8 месяцев назад

This was really helpful and easy to follow. Thanks for the video

@MrSpreadSheet 8 месяцев назад

You're very welcome!

@donnasisung8966 3 месяца назад

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?

@MrSpreadSheet 3 месяца назад

Glad you found it useful. You can use the same template for any year. :-)

@hananabdulhamid7752 Год назад

Well described thank you,it’s helpful

@MrSpreadSheet Год назад

Hi Hanan, Glad you found it useful.

@cynquenneville2553 2 года назад

thanks for this video! I can't wait to try it.

@MrSpreadSheet 2 года назад

Hi Cyn, Glad you liked it :-)

@Madam-pj8fg 2 года назад

Thank you for this good explanation in this video. I’d love to receive a copy of this spreadsheet for my small business

@MrSpreadSheet 2 года назад

Hi Madam, Glad you liked it, please see the guide at the end of the presentation :-)

@sticksailmjt 3 года назад

WOW this is great! Thank you very much.

@MrSpreadSheet 3 года назад

Glad you liked it!

@craigpeters1755 Год назад

Just what I was looking for. Great video🤟

@MrSpreadSheet Год назад

Glad I could help

@AndreaGonzalez-gt1cb 2 года назад

Great video! Thanks so much!

@MrSpreadSheet 2 года назад

Glad it was helpful!

@davemartinich9099 2 года назад

Very simple and straightforward way to get this done. Thank you and please share a copy of the spreadsheet.

@MrSpreadSheet 2 года назад

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 :-)

@johanschico8768 2 года назад

@@MrSpreadSheet already done the end of the viode now how to get a copy?

@lumoss494 Год назад

Would love to have the template to use in my school presentation. Thank you so much for your help.

@MrSpreadSheet Год назад

Hi Lumos, you can download this template at www.MrSpreadSheet.com :-)

@briankuisel3321 Год назад

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

@namayombomgonela3540 Год назад

This is excellent and exactly what I need!

@MrSpreadSheet Год назад

Hi Namayombo, glad you found it useful :-)

@mikeyoung8444 Год назад

Thanks so much for the great video!

@MrSpreadSheet Год назад

Thanks Mike :-)

@megandean7923 Год назад

SIR! Let me just tell you, I have lots of Excel experience but am under pressure to create a fix-all Inventory Management workbook to be used at several locations by others - plus I'm an over-achiever. YOUR video helped me visualize a far more seamless method, and the amazing pre-filled options will avoid human error and restrict entry into only one table. YAY! However I'm struggling with one thing I can't figure out and is making this take far too long. I have added a drop down column where I've listed about 6-8 codes for an adjustment being made - some are a positive adj reason, some are negative. I want what is chosen to dictate whether the amount being adjusted should be a positive or negative/plus or minus number. Thiat number will be formatted to be subtracted or added to the total quantity column. It's basically like a Debit/Credit drop down, where when chosen that debited/credited amount has an added or subtracted affect on the total amount - except with far more options than just Debit and Credit. I've looked everywhere & read every single forum and website - ANY help you have, would be tremendously appreciated!

@MrSpreadSheet Год назад

Hi Megan, Try creating a table with your Adjustment types listed. Alongside each adjustment type enter a 1 for positive and a zero for negative. Name this table. Then use Vlookup =VLOOKUP(Adjustment Type,TableName,2,false) to extract the 1 or zero and combine this with a simple IF Statement =IF(Value Returned=1,+Adjustment Value,-Adjustment Value). This will should do the job. :-)

@mergawinabi2842 Год назад

Thank you good sir, youve helped lots of people saving lots of money and time which are equally important

@MrSpreadSheet Год назад

Thanks Mergawi :-)

@rajeskrishnan2103 2 года назад

Thank you. Very clear and understandable.

@MrSpreadSheet 2 года назад

Glad it was helpful! :-)

@princewisdomifenkwe6600 3 года назад

I will love a copy, I've given the video a thumbs up.

@MrSpreadSheet 3 года назад

Hi Prince, please message me on FB :-)

@deborahdelord6248 Год назад

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. 😊

@stephenbanda6927 2 года назад

Thanks for sharing, very helpful!

@MrSpreadSheet 2 года назад

Hi Stephen, Glad you found it helpful :-)

@bryanpittman6455 11 месяцев назад

Really helpful tutorial. Thank you.

@MrSpreadSheet 11 месяцев назад

You're welcome!

@peterdieduardo6792 Год назад

Excellent! Very informative.

@MrSpreadSheet Год назад

Hi Peter, thank you so much!

@sitizaharahyahya3481 Год назад

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 Год назад

Best of luck!

@jimminrod1567 3 года назад

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!

@bryceclark409 Год назад

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!

@MrSpreadSheet Год назад

Hi Bryce, The file you have requested can be obtained by following the guide in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html 😊

@bryceclark409 Год назад

@@MrSpreadSheet Thank you kindly! I look forward to learning more from your great videos! You have a new fan. :)

@dezciene Год назад

BEST TUTORIAL. THANK YOU

@MrSpreadSheet Год назад

Glad you liked it!

@luzsgiraldo7186 3 года назад

Thank you very much!! It was clear.

@MrSpreadSheet 3 года назад

Glad it helped!

@lolipits9047 Год назад

You are a life saver!!! Thank you!!!

@MrSpreadSheet Год назад

Happy to help!

@azieharun80 2 года назад

Excellent video and very helpful. Thank you very much. 👍

@MrSpreadSheet 2 года назад

Glad you enjoyed it!

@antonetbehr1995 Год назад

EPIC! And yes please a copy would be GREAT.

@MrSpreadSheet Год назад

Hi Antonet, a download is available at www.MrSpreadSheet.com :-)

@yourgarageorganizer2186 2 года назад

You are great! Thank you!

@MrSpreadSheet 2 года назад

Thank you :-)

@jasonmounteer9470 3 года назад

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 :-)

@davideaton7578 2 года назад

Great video…thank you!!

@MrSpreadSheet 2 года назад

Glad you liked it! :-)

@royarguelles1025 Год назад

really helpful, thank you very much for this content ❤

@MrSpreadSheet Год назад

Glad you found it useful Roy. :-)

@sthembisomaphumulo3887 2 года назад

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.👍 I did as you directed at the end of the video

@MrSpreadSheet 2 года назад

Hi Sthembiso, Please follow the ‘Download’ guide in this link 😊 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m7Zf8_UWPGQ.html