INVENTORY UPDATE! How to Create a Dynamic/Expandable IN & OUT INVENTORY in Excel • How to Create Expandab... FREE EXCEL INVENTORY MANAGEMENT TEMPLATE (FREE DOWNLOAD) • Excel Inventory System...
Пікірлер: 318
@robertharris97696 жыл бұрын
The F4 key will let you cycle through absolute and relative ranges, instead of editing and adding the $ symbol. Also add another column so you can have both a cost price and a sales price. That would allow you to calculate profit. If you turn your code column into a named range, you can then create pull downs with data validation for the other tables.
@njinicrispus6246 жыл бұрын
This is one of the simplest and most powerful inventory management system established on Ms Excel. Thumps up man
@faustopf-.2 жыл бұрын
This help me a lot in my first Barcode System. I made it in just an hour with more features. Thanks a lots for this gem!!
@flagspoles34026 жыл бұрын
Thank you for the example, I'm going to re-create this to get a better idea of how I want to run my inventory system!
@saiaungchit4186 жыл бұрын
do you know how to add more item ?. I try to add but it only show the previous item list we did. if you know, please share you idea
@Shabeerali5656 жыл бұрын
i have the same doubt .Do u get it ?
@ragielyncasas85926 жыл бұрын
Thank you for this tutorial. This is what exactly i am looking for. Simple but effective.
@raqelle256 жыл бұрын
I can't tell you how thankful I am for this video! THANK YOU SOOOO MUCH. It helped me lots with a problem I had at work and this worked liked magic. :) Thanks!
@fliqur65169 ай бұрын
Great isnt it!
@ahmadtamimi61394 жыл бұрын
the best explanation ever..very simple n easy to understand..thank you for this efforts..
@tinydino16066 жыл бұрын
you're a life saver! i was looking specifically for this.
@CrisMinas6 жыл бұрын
glad the video helps :)
@alibaba-tl6cy5 жыл бұрын
@@CrisMinas can you send this to me through email plz. its emergency
@MostAwesomestChannel Жыл бұрын
Thank you for this great video. One question/suggestion: to solve the identical names issue, refer to item codes instead of item description and you won't need to change or edit the item descriptions.
@cindytrimblr4 жыл бұрын
Thank you thank you thank you for making this straight to the point and easy to understand! This inventory system is amazing I'm saving this video.
@harperjs422 жыл бұрын
I think I finally understand VLOOKUPs after this video!
@klaygallo3 жыл бұрын
Maybe its too late for me but this really helps me a lot. Thank you for sharing your knowledge.
@faizanali75264 жыл бұрын
Me: Thanks youtube for suggesting me a master piece ..thumps up dude..!!!!
@SuperKris19815 жыл бұрын
such an amazing video, real great of you to do this, can't wait to get mine started. I've literally searched the whole of youtube for something simple like this
@CrisMinas5 жыл бұрын
Thanks, check this out too, it allows you to add more items coz it's more dynamic and expandable. It has a sample template too that you use right away.
@SuperKris19815 жыл бұрын
Cris Minas how do I create the in and out on a monthly basis, for jan, feb, mar etc. Do I need to create a new sheet each month and copy everything over. Thanks
@homahealthcarecenter4 жыл бұрын
@@SuperKris1981 create and save as template and every month you can add new . its tiresome agreed
@mamadoujallow82137 жыл бұрын
Thanks alot Chris your tutorial was wonderful. With it I was able to develop a stock inventory for my lab which I believe would be very useful in maintaining our stock. Thank you
@patrishcasila19065 жыл бұрын
Patrish Casila I've learned about the vlookup today. It has been a great help because we have a research and watching this made it easy for us. I also learned the importance of the dollar sign, and other functions of the ms excel.
@SuNsHiNe_1194 жыл бұрын
what is the importance ?
@BillingSoftwareGuru4 жыл бұрын
જોરદાર. બવ સરસ માહિતી છે 🥇.
@mr.movieclips0016 жыл бұрын
Amazingly, I needed this workout today as I'm preparing a new shop inventory system
@valmendez72997 жыл бұрын
thank you for the tutorial i hope i can use this to my present job as a warehouseman
@rubybernadez26673 жыл бұрын
i hope you add tutorials like your are speaking at the same time
@darkren884 жыл бұрын
wow its a great video. my only issue on this is how it approaches its cost. the price in the inventory changes from time to time. and editing the item list price may affect the history cost.
@uziensalino39615 жыл бұрын
This is helpful. I learn alot. I hope you can upload a video for this inventory excel, on how to in and out the product with the use of barcode scanner thanks a lot. ❤😇
@ErikG11657 жыл бұрын
Nice example... you would be better off turning all of these into TABLES -- to make dynamic so you can keep adding inventory and sales for hundreds of transactions. Also just a note... to hard to type "$" to lock cells.. when the range is colorized just press the [F4] key to lock cells. just to save time
@UGComputerVision6 жыл бұрын
its like a Movie....its so entertaining
@tahaqutub8716 жыл бұрын
Can u Help me . quantity is not appear in stock list even in add in stock in.
@junaidjaved1941 Жыл бұрын
Thank you dear for such type of video
@ASINSTRUTECH3 жыл бұрын
Wow Amazing Tricks
@pepphm3 жыл бұрын
exactly what im looking for, thank you so much.
@felipegarduno79493 жыл бұрын
Thank you Cris
@nelsonayop52455 жыл бұрын
Thanks man!These is so great you help me learned this thing in such an easy way...
@mylifeoverseasmixedvlogs27863 жыл бұрын
Thank you xoxoxo.U help a lot for my Quiz😂😘
@worldentertainment80293 жыл бұрын
thank you very much for this video
@tcubet34 жыл бұрын
Thank u so much. U helped me a lot 👍👍👍
@athuladasanayake68154 жыл бұрын
Thats great.Simple. Thumps up man.
@eansomnang59263 жыл бұрын
It's amazing!! Thank you so much for sharing this content
@mr.RAND55844 жыл бұрын
Love it. I m going to put it in python and mysql database with customer.
@sumbalbutt99813 жыл бұрын
You have done a great job👍
@doraandfamily36285 жыл бұрын
You shouldve use drop down list on codes and names, because if you have many items it will be hard to memorize all of those codes. :)
@wojciechm24283 жыл бұрын
Simple and usefull! Best Regards!
@USAStars3 жыл бұрын
Thanks so much sir
@robinmazorca55622 жыл бұрын
thanks for this video
@williameddy88566 жыл бұрын
You made working Excel bad ass! 👍
@junjetrato25934 жыл бұрын
HI THANK YOU FOR SHARING THIS APPLICATION FOR INVENTORY BUT IS NOT WORKING THE CODE UNTIL 200 ITEMS WHEN IN ENTERING THAT CODE WHICH IS NOT AUTOMATIC.
@pichkhmer73653 жыл бұрын
your inventory look like easy but I would need to calculate profit and lose at the end of the month ect.
@vikramsangtani18046 жыл бұрын
i like your video how find out total stock purchge in my sheet
@golds34763 жыл бұрын
Nice very informative 👌
@hollyt56713 жыл бұрын
Can you do for aswey management?? Please?? Like how to maintain an asset register
@questionresearch87212 жыл бұрын
Thank you.
@MrFaisalShafi6 жыл бұрын
It looks good and simple, I like it.
@markruffles5 жыл бұрын
this template doesn't consider price changes for one item over time. it is great but only for constant prices over the year for each item
@megand66042 жыл бұрын
I mean, you can just not include the price in the VLOOKUP code and enter the price you purchase it for as you go. That seems like the easiest solution to me.
@awychoi5 жыл бұрын
Put the vlookup formulae inside an iferror formula and set it to show blank if error. Just a user friendly small mod.
@jenyroseroadiel73223 жыл бұрын
helps me alot!
@paoli66254 жыл бұрын
Thanks you so much for your sharing 🙏🙏🙏
@sasakalak46813 жыл бұрын
great job, but what happens when the received list is full? we need to delete the input in the row to make place for new one but that changes to quantity in the storage too,right?
@LongPiset4 жыл бұрын
Very good 👍👍👍
@beegee83323 жыл бұрын
This REALLY helped a lot..thnx
@mohammedfajoui61613 жыл бұрын
Very good
@TruthLoveandFreedom3 жыл бұрын
Thanks 🙏🏻
@Qwazangwenya4 жыл бұрын
Awesome. This is great
@macrosweb81324 жыл бұрын
good Job.
@katlapur4 жыл бұрын
In the last stock inventory box why don't you use simple formula like =+k4 in the received field and =+r4 in the sales field? Cause your formula and this simple formula do the same. Please tell why????
@thishabakhtiar9273 жыл бұрын
Greetings! Can u help me? My problem is the stock inventory is not changing but im already update the received item table. Can i know how to solve it? Thank you
@nelmar1015 жыл бұрын
Better to use index match nesting instead of vlook up. It more flexible. 👍
@hollyt56713 жыл бұрын
Yet more complex
@kutserosabinondo3 жыл бұрын
Will it still work if I put the stock table on another sheet?
@omanshhimachalvlogs81124 жыл бұрын
Osm for beginners
@irsanbauer5824 жыл бұрын
Very great!!!
@azimjamal97264 жыл бұрын
Tip: You can use the data validation on the CODES column to make it easier
@patrick56923 жыл бұрын
Thank you so much sir!
@yutheathou83844 жыл бұрын
Many thanks for sharing these special tips. :) you are so amazing!
@clemspaulo5404 жыл бұрын
Thank you for sharing 😊
@Alibabachalise5 жыл бұрын
Thank you very much for the very good lesson
@sheanesufungura62293 жыл бұрын
Thank you so much for helping us get control of our inventory and making it simple for us. I have a question with regards to the price/item. In reality, the price of an item is a variable. How do we account for it in this system?
@ThalantyrBF3 Жыл бұрын
Just make the price variable for each purchase/incoming or sales/outgoing. The system is only displaying that value for ease of viewing. It's not required.
@saiaungchit4186 жыл бұрын
It is esay to understand and very simple to use. Thanks a lot.
@TheLovestory0176 жыл бұрын
Good tool Cris, I am really appreciated that but could you please share us how to control the PRICE as we know that same product but may not same price. I am looking to hearing from you soon.
@CrisMinas6 жыл бұрын
Create pricelist in another sheet and use index function. Buy hey, If you're trying to create your inventory, i have free to download check my new video 😊
@rushikeshganne6 жыл бұрын
Thanks for Sharing. It was very helpful.
@imeemenghnani28124 жыл бұрын
Very helpful thank u😊
@jonathanorel85176 жыл бұрын
this is good enough if the product price won't change and you don't need the historical record of inventory and sales with the effective prices.
@jamesscott68645 жыл бұрын
This is my problem. If the product price change how can it not affect the old records of that product
@saberconstruction722428 күн бұрын
Awesome
@mikefrancisco94815 жыл бұрын
Just what I need. However, how do I like make an average of the price... I purchase the same kind of products from different stores (with different purchase price)? Was hoping you could help me out on how to go about it. Thanks
@Fahimayaztz2 жыл бұрын
how can I automate Code No in stock inventory table? also if i have multiple entries "A1" in purchase table, how do I combine them in Stock inventory table?
@worldentertainment80293 жыл бұрын
I am facing one issue in this sheet if we have same product or item code at different price how we can deal in this senerio?
@khalil23able4 жыл бұрын
Thank you, so easy and well explained
@ashoksardana50306 жыл бұрын
Great Video .. It would be great if you please upload any video on Double Bin Inventory System in EXCEL
@dd59444 жыл бұрын
thanks bro
@marvinvillapando63614 жыл бұрын
Wow thank you! I ve made my own.
@frozenheart7027 Жыл бұрын
well done, u did a great job. is it possible to have this file ?
@CrisMinas Жыл бұрын
Yes, link is in the description.
@marcuspow5 жыл бұрын
If you don't add that music. It would be much better. Simple you teach we learn. Trench music for the Pub not in the classroom. By the way that's good lesson.
@indianskinclinic4 жыл бұрын
Nice
@Mrruwanga6 жыл бұрын
This is very useful... Thank you...
@alializadeh8195 Жыл бұрын
Thanks
@mahajeetsingh62503 жыл бұрын
itry to follow your step but my vlookup formula always show error dont know why
@izherfayaz64075 жыл бұрын
Good video Nice 👍 Sir
@CrisMinas5 жыл бұрын
Thank you, you turn this into a more dynamic inventory watch here kzbin.info/www/bejne/j4POq2loeJdma8k
@SrbinIlijaIV5 жыл бұрын
Is this possible with changing dates in rows. For example in sheet received goods different rows different dates, automatically filled in different rows in stock sheet? The same way for sales.
@MrTimgrimm11 ай бұрын
Can you use this setup with a barcode scanner if so how would you intergrade it thank you
@tarasmytkalyk61846 жыл бұрын
Thanks for sharing! What is the best way to add stores, to which I source products for further sale?
@svetoslavgeorgiev55426 жыл бұрын
Thanks a lot - great job:)
@CrisMinas6 жыл бұрын
You're welcome
@sadekahmed6476 жыл бұрын
Thank you for this video .
@margaritarosales29943 жыл бұрын
Instead of changing product name you should’ve just referenced the codes. That’s what codes are for.
@snip-sniptear9564 жыл бұрын
I thought this would take me hours to finish but only took me about 20 minutes. It was quite fast because most of the input were repetitive, thus easier to follow.