how to maintain store inventory in excel

Поделиться
HTML-код
  • Опубликовано: 10 янв 2020
  • inventory spreadsheet template - excel product tracking maintain store inventory in excel.
    _/LINKS\
    ► Facebook:➜ / shahabislam123
    ► Twitter:➜ / shahabislam123
    ► Instagram:➜ / shahabislam6
    ► Website:➜ advanceexcelonline.blogspot.com/
    ================================================
    #StoreInventory #ExcelInvemtory

Комментарии • 158

  • @vishalbugale7729
    @vishalbugale7729 2 года назад +2

    Thank You So Much Sir Bahut Kuch shikhane ko mila apali videos se

  • @nadeeshadilrukshi8636
    @nadeeshadilrukshi8636 Год назад

    Thank you so much for your excellent and clear explanation🙏🙏🙏 very useful👏👏

  • @beautifullafghanistan449
    @beautifullafghanistan449 2 года назад

    very good video and very excellent method of teaching i love this video

  • @ShakeelAhmed-rt2mq
    @ShakeelAhmed-rt2mq 4 года назад +3

    👌👍🤝
    Excellent work by you
    &
    Excellent way of teaching the very tough topic very beautifully and convincingly taught by you....
    Hats off...

  • @saranyaecesaran
    @saranyaecesaran 3 года назад

    It is very useful. 100% working.Thank you very much sir

  • @servicemoto2579
    @servicemoto2579 2 года назад

    Gajab sir ji
    Thanks so much
    Maine sikh liya banana.
    Very very thanks

  • @ajitindustries
    @ajitindustries 3 года назад +1

    Thanks for so wisely teaching

  • @sajibbhowmik6384
    @sajibbhowmik6384 2 года назад

    Excellent work. Appreciating a lot. Keep it up.

  • @jithalder
    @jithalder Год назад

    Excellent work, kindly make a video and share us on "if current stock closed below a particular no then it should highlight in current stock report"

  • @220kvmardanmardan2
    @220kvmardanmardan2 3 года назад +1

    REALLY GREAT JOB

  • @sujithkumar2150
    @sujithkumar2150 2 года назад

    Sir excellent work .thanks for your help

  • @zakimujawar6312
    @zakimujawar6312 4 года назад +2

    Thanks, you make it so simple

  • @ashutoshacharya2988
    @ashutoshacharya2988 3 года назад +1

    Gajab hai bhai...ese kaise👍

  • @mohammedkhaleel2880
    @mohammedkhaleel2880 3 года назад +1

    Superb sir 👌 👏

  • @adeebasiddiqui5422
    @adeebasiddiqui5422 3 года назад +4

    Master Mind Ho Bhai Jaan
    Allah Aur Ilm Aata Kre

  • @mdjasim-qq2fc
    @mdjasim-qq2fc 4 года назад +1

    Superb video sir

  • @saeedbasabain4188
    @saeedbasabain4188 3 года назад

    Thanks brother

  • @rheajobin06
    @rheajobin06 2 года назад

    Thank you sir!!

  • @dillipmoharana1731
    @dillipmoharana1731 2 года назад

    Thank you very much

  • @Sumitjjoriya
    @Sumitjjoriya 3 года назад +1

    Thnx sir zabardast nahi bahut zabardast ha

  • @muhammadshakeel3471
    @muhammadshakeel3471 4 года назад +1

    Assalamualaikum Awesome

  • @r.bhaktisangrah9321
    @r.bhaktisangrah9321 4 года назад

    Sir, Really you are the great. Please provide the link of this format.

  • @TamilSelvan-vu4bl
    @TamilSelvan-vu4bl 3 года назад +1

    nice tutor video

  • @shafeeqspeaks6382
    @shafeeqspeaks6382 4 года назад +1

    Very good. I need video on vlookup

  • @informationtoallj
    @informationtoallj 4 года назад

    Mashallah 👍

  • @azij_khwa5428
    @azij_khwa5428 4 года назад +2

    Plz explain more formulas which are commonly used in stock management data .

    • @shahabislam4912
      @shahabislam4912  4 года назад +1

      ruclips.net/video/_3l-r_jHIwQ/видео.html
      ruclips.net/video/nthYdWXQ4Rw/видео.html
      ruclips.net/video/gBPJ3yWQ6UI/видео.html
      ruclips.net/video/aGlwx6Pk4aw/видео.html
      ruclips.net/video/26-0f9DGk6c/видео.html

  • @apnashoq3950
    @apnashoq3950 4 года назад +1

    so nice

  • @Mirzaiiui
    @Mirzaiiui Год назад +1

    Salam Shahab
    how are you, thank you for your giving us the best knowledge I am from Pakistan, and I have a problem, there are a lot of videos for stock inventory, but I never find Stock inventory for manufacturing units, From raw materials to finish Goods, For example, I have 3 employees I am giving them raw material and they are giving me finish product how can we deduct raw material by finish goods when they give it back, and how to maintain my stock inventory left with my employee and in my warehouse hope you will resolve my issue i am much needed this time

  • @TVSCDN
    @TVSCDN 3 года назад +2

    Good👍

  • @anwarwali6653
    @anwarwali6653 3 года назад

    Sirjee, its very helpful sheet u prepared and i am using it now, but the problem is it gets very heavy and takes alot time for processing, one entry to complete takes 15 mints, could u help me out

  • @muhammadshakeel4482
    @muhammadshakeel4482 4 года назад +1

    JazakAllah

  • @muhammadshakeel4482
    @muhammadshakeel4482 4 года назад +1

    Marvellous

  • @jogendrapadhan9198
    @jogendrapadhan9198 4 года назад

    Sir, Is that not working in Excel 2007? Because I tried menu time and not succeed.When I select 2nd sheet of iron column ,Data, validation and list ,the 1st sheet is not inserted anyway.So what to do ?

  • @umerijaz5748
    @umerijaz5748 2 года назад

    boht aala

  • @muhammadsohailkhan8451
    @muhammadsohailkhan8451 4 года назад +1

    sir how to print out single customer detail from outward sheet please help

  • @ulaveshvs1637
    @ulaveshvs1637 3 года назад

    👌👌👌👌👌

  • @shaikhasif4430
    @shaikhasif4430 3 года назад

    Vedio is good. But very fast. It should be little. Slow for better under standing. Steps should be explained to the viewers.

  • @pakpromotion786
    @pakpromotion786 4 года назад +1

    AOA sir apka channel pasnd aya mujay may ap say sikhna chata hn kay Excel pay medical records mantain kasay karay with the help of barcode jasay hum nay ek medicine insert kiya with name or scan karay barcode to us may add hojay

  • @RafiqKhan-xp2ic
    @RafiqKhan-xp2ic 4 года назад +1

    Useful, mashallah

    • @atiyaenterprises
      @atiyaenterprises 4 года назад

      AOA
      Can we connect our sale in excel sheet online like Amazon selling
      Please assir

  • @atulshukal4072
    @atulshukal4072 4 года назад

    Good Sir

  • @joshuakenyatta4907
    @joshuakenyatta4907 2 года назад

    Nice one

  • @minjesse1816
    @minjesse1816 2 года назад +1

    HELPP!!!! Its good but when i input the 3rd time same item code, in my description it was empty. Please help

  • @sunnybachpanvideo
    @sunnybachpanvideo 3 года назад +1

    Bhut jldi samajh gya

  • @sailakshmi8126
    @sailakshmi8126 4 года назад

    Please make civil store inventory format

  • @rizwanali170
    @rizwanali170 4 года назад

    Nicevideo

  • @informationpoint786
    @informationpoint786 10 месяцев назад

    Sir Data entry k liye kon sa software use hota hai Dubai ma

  • @AdbhutGhyan
    @AdbhutGhyan 3 года назад

    Bhai pls ek bat batao same code ki hum 1 se jayada bar entry krte h to master sheet mei ad nhi hota aesa kyn

  • @amolfatale8361
    @amolfatale8361 2 года назад

    Very Nice How to download sheet?

  • @anshikakhan136
    @anshikakhan136 2 года назад

    Sir abudhabi dubai jaise country mai isi tarah se work hota hai kya please ek video aisi banao jisse dubai mai store keeper or data entry work ka kam kaise kare!! please help🥺🙏🏻

  • @SAPforyou
    @SAPforyou 4 года назад

    sir how to maintain sales for many customers pls expain and provide excel as well as
    Thanks
    Santy Tanwar

  • @shailendersingh5830
    @shailendersingh5830 3 года назад

    Good

  • @Wasif4334
    @Wasif4334 3 года назад

    Hello sir Item code Data validation se ni ho rha h
    Inward se stocksheet pr ni ja rha to phir select kaise kru Item code

  • @snehamehra9946
    @snehamehra9946 4 года назад

    sir mujhe reliance trends me boh back of the house ka work mila hai ..plz bataye ki isme kya work hoga aur kese work kiya jayega

  • @Vicky-vlogs01
    @Vicky-vlogs01 3 года назад

    Bro Items kie sell ham online check kar sakta Hain Mobile pai

  • @atulkumar-fn3pm
    @atulkumar-fn3pm 4 года назад

    Please make vedio of purchase orders tracking sheet

    • @shahabislam4912
      @shahabislam4912  4 года назад

      ruclips.net/video/cUBp446Rgys/видео.html

  • @saching6241
    @saching6241 3 года назад +1

    Sir Thankyou for help
    kya aap muze customize report banake de sakate ho
    1st sheet main data rahega 2nd sheet main barcode No scan karke auto qty reflect hoga aisa
    Please aapka no dejiye ya muze mail kar sakte ho

  • @ravishah9021
    @ravishah9021 3 года назад

    bro is it ok for clothes shop

  • @GopalSingh-km6vt
    @GopalSingh-km6vt 3 года назад

    Sir how do make inventory in warehouse

  • @mohammedthahir3044
    @mohammedthahir3044 4 года назад

    Sir how to arrive landed cost import material

  • @shalinikumari9504
    @shalinikumari9504 3 года назад

    SIR IT IS VERY NICE BUT I AM NOT ABLE TO MERGE STOCK SHEET TO INWARD SHEET

  • @mdejajalam9803
    @mdejajalam9803 4 года назад

    Koi bhi Company me overtime work hota hai
    Overtime ko days me kaise badlege

  • @hashirpathan5135
    @hashirpathan5135 Год назад

    5:48 I’m unable to bring $ sign in the Formula please help

  • @shamimalaminuk
    @shamimalaminuk 3 года назад

    Sir stoch sheet list create karny mai select nahi horahi

  • @shahbazahmed2429
    @shahbazahmed2429 2 года назад

    Sir Administration Store ke liye bhi video baanay naa
    Misalan Chai ka saman ho gay milk tea bags & janitorial staff ka item Mop garbage detol or bhi bahot see chizain

    • @shahabislam4912
      @shahabislam4912  2 года назад

      ruclips.net/video/wnfs3zQF1mU/видео.html

  • @shivprasadsahu464
    @shivprasadsahu464 3 года назад

    I am try but data validation list not accept in another sheet

  • @Asif5392
    @Asif5392 4 года назад +1

    Sir what's the different between "price" & "purchage price" in Inward sheet? If you advice then it will helpful for me. Waiting for your kind advise. Thanks.

    • @shahabislam4912
      @shahabislam4912  4 года назад

      Purchase Price Meaning who purchased You.

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

      ​@@shahabislam4912
      Sir
      Meri Grocery Shop Hai Almost 1000+ Items Hai
      Sir Mai Chahta hu. Jis trh Ye Vedio Hai Products Wise Details hai...
      Ussi Trah..
      Agr Mere Shop me 1000+ Items Hai.
      Koi Coustom Aaya Usne Kuch Selected Items liya Hai alg alg Weights and Prices ki
      Mai Chahta Hu Ki Bss Wahi Grocery items Shows ho jo usne Liya hai Check list krta jau mai Weight and prices vii total Bills hota jye...

  • @noorulameen6752
    @noorulameen6752 4 года назад

    Shab Bhai multiple locator wise stock report kaise banaye ge

    • @shahabislam4912
      @shahabislam4912  4 года назад

      ruclips.net/channel/UCcOsbNCxgUZMPoHEI1w-1RAsearch?query=stock

  • @nouranalantably6242
    @nouranalantably6242 Год назад

    WHY DID U WRITE PRICE AND SALES PRICE FOR INWARD SHEET and vice verse in outward sheet?

  • @tarungupta8303
    @tarungupta8303 3 года назад

    @Shahab Islam Sir yeh to thik hai but hum months k end me closing kese kare and next month sheet mein balance stock kese add kre please help sir humein month closing kese kare bataiye please rlp sir.........

  • @syedumair2619
    @syedumair2619 3 года назад

    Sir sheet to 1st class hai par farmulas Thora slow samjhay takay achay say samjh aye

  • @ankitverma6508
    @ankitverma6508 3 года назад

    Top tan

  • @FAISALKHAN-tj5df
    @FAISALKHAN-tj5df 4 года назад +1

    Sir please excel me balance sheet managment explain kare

  • @sonigajanand
    @sonigajanand 2 года назад

    aap ke video ke template ya sheet download ki ja sakti hai kya

  • @MK-ib9fd
    @MK-ib9fd 4 года назад +1

    After working for two hours, i noticed if the same item code used "twice" the current stock is not updating ..

  • @ImranAli-gq7rb
    @ImranAli-gq7rb 4 года назад +2

    Besy

  • @prodip.newar99
    @prodip.newar99 Год назад

    I suggested the make a vedios please Brother

  • @nirjuaghera1292
    @nirjuaghera1292 4 года назад

    Sheet 2 me sheet 1 ka data validation kese kare

  • @anilkumarjain6789
    @anilkumarjain6789 3 года назад

    SIR, I WANT TO MAQKE THIS EXCEL SHEET OF MANI GODOWN AS WED HAVE 5 GODOWN THIS IS ONE GODOWN EXCEL SHEET SO HOW TO MAINTAIN STOCK IN ONE EXEL SHEETGIVE ME THE LINK SO WE CAQN DOWNLOAD THIS EXCEL SHEET AND LEARN TO HOW TO MAKE STOCK SHEET

  • @aditya.patel9987
    @aditya.patel9987 4 года назад

    agar aapke pass seet redy he to uski b link dijiye taki hum uspe stde kar k sikh sake

    • @shahabislam4912
      @shahabislam4912  4 года назад

      advanceexcelonline.blogspot.com/p/excel-file-download.html

  • @asifnaikwadi3453
    @asifnaikwadi3453 3 года назад

    sir a link work nahi horahi help me.....

  • @asifrazaansari
    @asifrazaansari 2 года назад

    File tou download krny ky lye link de dia kr bhai. Ab kon itni mehnt kre

  • @sadeeqali3393
    @sadeeqali3393 4 года назад

    Sir ek product code me 10 sizes usko kaisa enter karna

  • @corsair1994
    @corsair1994 3 года назад

    I want this excel sheet
    plz

  • @10Luqman
    @10Luqman 3 года назад +1

    Bhai aisa lag raha hai tum khud ko hi sikha rahe ho 😂 😂 thora slow or aheesta aheesta batao itna fast.. 😂

  • @mdejajalam9803
    @mdejajalam9803 4 года назад

    Overtime than overtime ko days me kaise badlege sir

    • @hassanaziz7116
      @hassanaziz7116 4 года назад

      sub sy pehly total salary ko 30 days py divide karo per day ki salary nikal aye gye then per day ko duty hour py divide kar do per hour ki salary nikal aye gye us k badh jitna over time laga ho ga usko per hour jo ap ny nikala ha us k sath multiply kar do

  • @parthpant4365
    @parthpant4365 4 года назад

    10:29 Please help me sir in outward section apna cantaloupe ki price purchase price sa कम ली है ya to jyda honi chahiye thi

  • @hirenvaghasiya1913
    @hirenvaghasiya1913 4 года назад

    HELLO SIR, HOW TO ADD OPENING STOCK

  • @AbhishekSahuabhixek
    @AbhishekSahuabhixek 4 года назад

    Incomplete, If same item inward/outward 2nd time, quantity not updating..

    • @ps7299
      @ps7299 4 года назад

      Same ques

    • @ps7299
      @ps7299 4 года назад

      Solution hai bt lengthy hai...same item ki sale purchase table bna k total me discription de kar value vlookup de kar utha lo...

  • @ruchitasharma1427
    @ruchitasharma1427 4 года назад

    Can you share this template?

    • @shahabislam4912
      @shahabislam4912  4 года назад

      advanceexcelonline.blogspot.com/p/excel-file-download.html

  • @Vicky-vlogs01
    @Vicky-vlogs01 3 года назад

    Please guide me

  • @brightasinde7034
    @brightasinde7034 3 года назад

    You are too fast not for learners , you are just displaying your skills

  • @firegame67890
    @firegame67890 3 года назад

    Goood Hai, from where we get copy

  • @osamanasr5000
    @osamanasr5000 3 года назад

    What he did at 5:45 ?

    • @babalu-oc6iu
      @babalu-oc6iu 3 года назад

      Changed cell reference to relative vs absolute, look it up on google. 😉

  • @mahakhan1553
    @mahakhan1553 3 года назад

    Kia koi bta sakta hai roshi open hora hai?

  • @nokeshdeshmukh8394
    @nokeshdeshmukh8394 4 года назад

    Excel 2007 me ye link provide kijiye..

  • @nagarajumailapuram9991
    @nagarajumailapuram9991 3 года назад

    Hai sir may i request you can you explain in telugu sir

  • @rushikeshpatil9499
    @rushikeshpatil9499 3 года назад

    Hi

  • @benbourogaa9999
    @benbourogaa9999 4 года назад +1

    Just wondering, what 3 languages are you using in the video? Very confusing.

  • @FAYYAZBOOKCENTER
    @FAYYAZBOOKCENTER 3 года назад

    aoa bhai jan ya tamplete kdr sa download ho ga

  • @lawrencejunction1876
    @lawrencejunction1876 4 года назад

    sir ye samjh ni Aya kafi fast