Inventory Management | Excel Inventory Management (Super Easy)

Поділитися
Вставка
  • Опубліковано 4 лют 2025

КОМЕНТАРІ • 370

  • @thankwel
    @thankwel 3 роки тому +10

    Struggled 3 years at college & 4 years at Uni due to unprecise teaching from Professors.
    Luckily, UA-cam 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

  • @Jaxxy35
    @Jaxxy35 4 роки тому +53

    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.

  • @MicrosoftOfficeTutorials
    @MicrosoftOfficeTutorials  3 роки тому +3

    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

  • @LivingstoneHawells
    @LivingstoneHawells 2 роки тому +3

    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

  • @DingDongGrahamBell
    @DingDongGrahamBell Рік тому +3

    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!

  • @swapnalitambe7694
    @swapnalitambe7694 Рік тому +2

    After searching the whole net finally found what I wanted 🤩thank y so much

  • @bhavinantala8242
    @bhavinantala8242 Рік тому

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

    • @JACCAdmin
      @JACCAdmin 8 місяців тому

      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 ?

  • @Loida304
    @Loida304 3 роки тому +1

    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

  • @27coolparth
    @27coolparth Рік тому +1

    Wow. Just amazing. I was looking for this, will save so much trouble for me. Thank you boss!

  • @dorseteco5779
    @dorseteco5779 4 роки тому +14

    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.

  • @mjjohnson3270
    @mjjohnson3270 3 роки тому +12

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

  • @tabvidfan
    @tabvidfan 2 роки тому +3

    To the point, useful, easy to follow. Exactly what I needed to manage my inventory. Thank you!

  • @Denny_Kurnia
    @Denny_Kurnia 2 роки тому +1

    Thanks.. I found the best Inventory management sheet as i want !! Thanks a lot

  • @sidikiekonneh6248
    @sidikiekonneh6248 8 місяців тому +1

    Thanks so much for this great work
    you have help me with employment
    I had always needed this to complete my jobs

  • @cliffjandeecanete462
    @cliffjandeecanete462 2 роки тому +5

    exactly what i was looking for! Easy and precise. Perfect!! Thank you for making this video ❤️

  • @sanchezjunmar9264
    @sanchezjunmar9264 Рік тому

    Amazing and truly helpful for my inventory. Thank you so much sir for sharing this video.

  • @md.taifuranam7904
    @md.taifuranam7904 4 роки тому +15

    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.

  • @FarhanAslam2243
    @FarhanAslam2243 2 роки тому +1

    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.

  • @nhialreathnyuon8029
    @nhialreathnyuon8029 6 місяців тому +1

    Really appreciate this lecture of inventory management on excel

  • @abhishekprabhu1
    @abhishekprabhu1 Рік тому +1

    Thank you very much it was very useful, i have found it at the right time, thanks

  • @gitali
    @gitali Рік тому

    Very helpful for my small business. Thanks for sharing!

  • @anitaoforimensah7061
    @anitaoforimensah7061 2 роки тому +1

    Thank you very much for the video
    Very clear to understand and precise.

  • @xyzmsbright
    @xyzmsbright 2 роки тому +1

    Thank you very much. Very helpful and simple to understand.

  • @storytime-with-ali
    @storytime-with-ali 2 роки тому

    you save my timee, thank you so much for uploading this video!!

  • @Handytom
    @Handytom Рік тому

    thank you! great video, following step by step make my own tracking sheet. subscribed

  • @opioelijah4665
    @opioelijah4665 3 роки тому +2

    A very good teacher

  • @bukupandora
    @bukupandora 3 роки тому +2

    Thanks for the knowledge, WHAT A DELICIOUS CONTENT !!, this content is really cool. the explanation is easy to understand.

  • @jennypherraymond8881
    @jennypherraymond8881 2 роки тому

    I LOVE YOU! Thanks so much for this tutorial

  • @francecoflores
    @francecoflores 8 місяців тому

    This was amazing!! I learned so much. Thank you!!

  • @rizkyramdhany4549
    @rizkyramdhany4549 Рік тому

    Thanks....it was realistic to implement this in working environment

  • @samskymartirez5013
    @samskymartirez5013 3 роки тому +5

    magnificent my friend..

  • @brianrobbs7105
    @brianrobbs7105 3 роки тому +1

    Thanks for the video. It is very easy to understand and also very helpful. I refer to it often

  • @elishabatuncang8391
    @elishabatuncang8391 2 роки тому

    Thanks a lot! This save me a lot of labour time key in data manually! 🤩

  • @greenday1guitarfreak
    @greenday1guitarfreak 3 роки тому +1

    Very helpful, thank you! Subscribed

  • @rashedbond5293
    @rashedbond5293 3 роки тому +2

    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.

    • @ridmimanushika2550
      @ridmimanushika2550 3 роки тому

      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.

  • @leopastias7653
    @leopastias7653 Рік тому

    thanks you so much for this very useful video of yours God bless.

  • @marwahilayel600
    @marwahilayel600 2 роки тому +1

    you are the best! Thx.

  • @rebby2315
    @rebby2315 2 роки тому

    this was very helpful and easy to follow. you broke it down into bite sized bits instead of cramming the info at your audience :)

  • @patalmazar5597
    @patalmazar5597 3 роки тому +1

    Thank you and more power to your channel

  • @macoscarzgambo5051
    @macoscarzgambo5051 Рік тому

    Thank you for this, Mr. It is very helpful

  • @rungnapachatpan5984
    @rungnapachatpan5984 3 роки тому +1

    Thank you very much. This is really helpful.

  • @krishanarjun8866
    @krishanarjun8866 3 роки тому

    Woww... wonderful and valuable information..🙏🙏

  • @arvzlampria9159
    @arvzlampria9159 3 роки тому +1

    its so easy to follow.nice tutorial👏🏻👏🏻👏🏻

  • @saminakhalid8072
    @saminakhalid8072 4 роки тому +1

    Very good tutorial, really every step guided in very good manner

  • @araffhoque2075
    @araffhoque2075 Рік тому

    Very informative video, Thank you so much

  • @staceywilliams-ng7995
    @staceywilliams-ng7995 3 роки тому

    Thank you so much! I learned so much and I'm sure this inventory will serve my business for years :))

  • @frowsmuhammed484
    @frowsmuhammed484 2 роки тому +1

    Thank you so much for your guide

  • @mawutmabut5352
    @mawutmabut5352 3 роки тому +1

    The great and impressive tutorial ever in Inventory management, keep it up

  • @imranomar207
    @imranomar207 4 роки тому

    Nice one keep it up

  • @johncollinsmachave9728
    @johncollinsmachave9728 Рік тому

    We are waiting for this kind of vedio with changes in prices

  • @sihlemadungandaba7101
    @sihlemadungandaba7101 4 роки тому +1

    Great teacher. I'm using this for my business.

  • @UsmanGhani-vf3ow
    @UsmanGhani-vf3ow 2 роки тому

    U made it super easy 👏

  • @danishiqbal7537
    @danishiqbal7537 4 роки тому +2

    love your way of explaining

  • @manjulapriyankara6996
    @manjulapriyankara6996 3 роки тому

    Thank you so much for sharing this valuable video 🙏🙏🙏

  • @MrKa-hv7nc
    @MrKa-hv7nc 3 роки тому +1

    Great video

  • @cyclingtraveler2595
    @cyclingtraveler2595 2 роки тому

    Hi.thank you so much for your tutorial. awesome 👍

  • @kirangurung3108
    @kirangurung3108 3 роки тому

    Thanks for valuable explanation.

  • @ollie1016
    @ollie1016 4 роки тому +2

    What an awesome video. Honestly one of the most well explained video tutorials I've watched. Thank you

  • @Jamokopun
    @Jamokopun 7 місяців тому

    Thank you, learnt much about Vlookup function.

  • @whengTV
    @whengTV 3 роки тому +1

    thanks, ver informative 👍

  • @kisembostories2139
    @kisembostories2139 2 роки тому

    This is Genius. Thankyou

  • @rofiqulislam7544
    @rofiqulislam7544 2 роки тому +1

    Nice video ❤️❤️❤️❤️

  • @brylleflores8855
    @brylleflores8855 3 роки тому +1

    Nice video thank you so much

  • @adrianjayjaymalin9043
    @adrianjayjaymalin9043 4 роки тому

    Really helpful! Thanks!!!! Salute from Philippines!!

  • @joshyoosh
    @joshyoosh 2 роки тому

    super useful. thank you sir

  • @mohammedbarqawi8113
    @mohammedbarqawi8113 8 місяців тому

    Thank you very good explanation ❤

  • @centuryticles6172
    @centuryticles6172 Рік тому

    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

  • @Timothythebrewer
    @Timothythebrewer 3 роки тому

    Well done! Thank you.

  • @letsahbright4909
    @letsahbright4909 2 роки тому +1

    💯 accurate thanks so much 🙂

  • @adminshashwatgreenbuilding6893
    @adminshashwatgreenbuilding6893 4 роки тому

    Amazing tutorial....Helped me lot.. :) Thanks for sharing

  • @mingoximar3137
    @mingoximar3137 2 роки тому

    Thank you so much for this knowledgeable video!

  • @umarhkhan5946
    @umarhkhan5946 2 роки тому

    Thanks you Sir very much helps

  • @immaculatenthigah2233
    @immaculatenthigah2233 Рік тому

    You are the best

  • @antokannampallil
    @antokannampallil 11 місяців тому

    Excellent

  • @piabascon7216
    @piabascon7216 3 роки тому

    Thank you very much. This is what I'm looking for!

  • @mabeltimela2558
    @mabeltimela2558 3 роки тому

    Great stuff

  • @timgroenterprises
    @timgroenterprises 4 роки тому +10

    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?

  • @mohamedazeem2310
    @mohamedazeem2310 3 роки тому +1

    Thank you 👌

  • @raymondmonmendoza3627
    @raymondmonmendoza3627 3 роки тому

    clever! thanks for sharing, my friend ;)

  • @mohamediyoobibralebbe7094
    @mohamediyoobibralebbe7094 3 роки тому +1

    Thanks my dear

  • @j.karlosp7059
    @j.karlosp7059 4 роки тому

    Very simple and very useful. Thanks man!

  • @kairitac
    @kairitac 2 роки тому

    very helpful thanks

  • @umartalal5070
    @umartalal5070 5 років тому

    You are great.super easy way to teach.
    Stay Blessed Bro

  • @dihanmahmood132
    @dihanmahmood132 3 роки тому

    Super video

  • @syedwaqashussaini9115
    @syedwaqashussaini9115 3 роки тому +1

    wao amazing

  • @Gharibyar
    @Gharibyar 4 роки тому

    Very useful and great explanations.

  • @Antishkr
    @Antishkr 4 роки тому +2

    Thank you! I learned from seeing your video.

  • @sherko965
    @sherko965 2 роки тому +1

    amazing

  • @SittComani
    @SittComani 3 роки тому +1

    GREAT CONTENT! Quick question and I hope your still answering questions for this, is this for daily update inventory?

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  3 роки тому +1

      Yes you can use it for daily update

    • @SittComani
      @SittComani 3 роки тому

      @@MicrosoftOfficeTutorials ty for quick response, i'll be subscribing!!!

  • @mohamedyusuf7111
    @mohamedyusuf7111 2 роки тому

    hi bro this same excel I'm following in my shop thank you

  • @zakariandao236
    @zakariandao236 8 місяців тому

    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.

    • @zakariandao236
      @zakariandao236 8 місяців тому

      Also the "price/unit" in "opening stock" is it the purchasing price or the selling price of the product

  • @corleenx
    @corleenx 3 роки тому +5

    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?

    • @mjjohnson3270
      @mjjohnson3270 3 роки тому

      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!

  • @raghavchauhan8655
    @raghavchauhan8655 4 роки тому

    Awesome Video❤️

  • @kalpeshmistry8060
    @kalpeshmistry8060 4 місяці тому

    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

  • @MsOfficeLearning
    @MsOfficeLearning 3 роки тому +1

    Thank you for your great lesson!!

  • @farhadnooryar9558
    @farhadnooryar9558 2 роки тому +1

    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??

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  2 роки тому

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

  • @samuelzewdu3122
    @samuelzewdu3122 2 роки тому

    Wondering tutorial, i will appreciate though if you vould dhow ud the F4 application in dedktop.

  • @ShayDiBBS
    @ShayDiBBS 3 роки тому

    Thank you so much for this!!

  • @thomassherwin1254
    @thomassherwin1254 3 роки тому

    Nice this is exactly what I was looking for

  • @dielikakone4631
    @dielikakone4631 4 роки тому

    THANK YOU IT IS VERY HELPFUL CLEAR