Nader Bahri
Nader Bahri
  • 2
  • 167 987
macintosh and iOS interface in microsoft Access !!
Experience the beautiful appearance of Macintosh in MS Access.
This file is completely open source and you can use it in your access files.
Переглядів: 271

Відео

simple inventory and warehouse management in excel
Переглядів 168 тис.4 роки тому
There are three simple steps you can take to create a warehouse software in Excel. Using VLOOKUP and Sumifs If you need more advanced training or a program, just follow us and write in the comments

КОМЕНТАРІ

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

    im stuck at 6:04, my excel say too man argument, please help

  • @muhammedasifali7433
    @muhammedasifali7433 10 місяців тому

    Excellent, very useful

  • @christineanney.macaraeg2287
    @christineanney.macaraeg2287 11 місяців тому

    Thank you very much! Very helpful. Excellent. more tuitorial please!

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

    Poor camera

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

    Excellent programming video! Thanks for sharing. How may I request for the advance level program video and spreadsheet formulas from you sir?

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

    so happy to have someone move along quickly so we don't fall asleep!

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

    very bad quality of video

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

    It is a good template. Thank you. But one problem is... When I add same item on output twice or multiple times (once IN and other times OUT), the quality on "Remain" sheet will automatically lookup the value of Quantity on "Main" sheet just keeping the sequence only even if the items are not same. Any solution for this?

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

    You explained very fast

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

    If the same code added twice in InOut sheet , Remaining sheet show both lines and final quantity is double. ?

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

      Yes. I was looking for a solution for that but I couldn't find one. Anything you come up with as a solution pls?

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

    Very Good... I think you need to slow down a bit

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

    Only u can understand that...show slowly bro

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

    The teacher doesn't teach well. Poor teaching. Doing everything by himself without considering other people watching. Very poor. Do not understand anything

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

    Than You!

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

    Hi, Great video’s I would like help how to solve a problem, how to assign, tables, ranges, Vlookup etc. Eg: What lures are best to catch different fish. Select type of fish from dropdown list. Eg: Cod, Trout, Bream Select lure type from dropdown list. Eg: Spinnerbait, Soft plastic, Hardbody Have a list of Lure Brands for each type of fish. By selecting fish type Eg: Cod, Lure Type Eg: Spinnerbait, Would bring up the list of spinnerbait brands for Cod in the third column.

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

    Brother thank a lot and how can I download the template, please

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

    Absolutely amazing wonderful

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

    Great video! Thank you! Can you also make a video where it includes the price and can tally to customers especially repetitive customers

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

    Nyc

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

    Good

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

    Thanks so much for this. Am a new warehouse manager, please how do I get this excel sheet?

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

    Thank you for the video, very good for learning

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

      Hello, did the formula work for you? For the Sum of in i am still getting '0"

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

    @Nader Bahri For the "Sum of In" portion, I am still retrieving 0, even though my sheet has 10 products that came in.Can you Help??

  • @Mohamed.musthafa
    @Mohamed.musthafa 2 роки тому

    want download the sheet

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

    is there a way i can call inventory by date? meaning , is there a way i can create reports ?

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

    Nice! I will try this. How many products can I add? Is it difficult to search if I add more than 100 products?

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

    Please make video on Advance program training. continue to upload videos Please Please Please

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

    Very nice Nader, now can you please do another video if you have multiple warehouse locations and want to track the expiry date

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

    Bro work on your english, speak slowly

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

      He already speaks slowly, and it is pretty understandable.

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

      @@turetskiy_shpion_44 Do you know what he says at :58? It sounds like "Alt A, V V", but that's not working for me. Any help is appreciated. Thanks!

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

      @@AlisaChagnon123 Alt+A+V+V is the short cut for the Data Validation section

  • @nickb.829
    @nickb.829 3 роки тому

    This was great 👏

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

    Brillant! definitely love to have the advanced program training. thank you

  • @k.3036
    @k.3036 3 роки тому

    Thank you soooo much! you've just saved my life. i want the advanced one too.

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

    This is great Nader. Hope we can download your template in google drives. =)

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

    Share your sheet mate thanks

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

      if you want an inventory application for warehousing i can make it for you in ms access

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

    Hi mate can you please send us the link of this file? it's really a big help mate... GOD BLESS

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

    good job

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

    For future reference can you caption the video with shortcuts youre using as well as move a bit slower when entering the formulas

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

    Hello, great tutorial. I need so help as well. It might be an easy question, but it got me searching for

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

    Hello can u send me link of same excel

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

    Hello can u send me link of same excell

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

    Hello mate where can I download your template for warehouse inventory management thanks..

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

    Please contract

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

    Hi I need it , please share me masum@klga-cambodia.com

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

    Share your sheet

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

    Hi Nader, Thank you for your video, Can you share the link of the same excel file?