Stock Management in Excel (Hindi)

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

КОМЕНТАРІ • 1,3 тис.

  • @abdulattiff
    @abdulattiff 4 роки тому +7

    Easily explained in a professional way. Thank you very much 🤗👍

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

    Wah Kya Baat. Kitni achchi tarike se sab kuchh step-by-step sikhaya. Thank You, Sir.
    Green Purchase Button= Purchase Register; Orange Purchase Button= Purchase Entry
    Green Sales Button = Sales Register; Orange Sales Button= Sales Entry
    Green Stock Button= Stock Register

  • @sandipkisan9587
    @sandipkisan9587 4 роки тому +5

    Perfect information sir ji,need more information ..

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

    आदरणीय, आपके द्वारा, निःशुल्क शिक्षा दान के लिये, आपका श्रद्धापुर्वक हार्दिक आभार/अभिनंदन।

  • @Askarijoniour
    @Askarijoniour 4 роки тому +4

    Hi sir very advanced Nd professional VDO
    But sir multiple item ki entry kaise karenge ek bill ho kyi sare item ho

    • @SS_Infotech.
      @SS_Infotech. 3 роки тому

      ua-cam.com/video/PIdPczs8Xoo/v-deo.html

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

    Salute you man....You helping More and more peoples.... God Bless you...Thanks a lot

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

      I would like to thank you for your blessings and love.

  • @SehrawatFitHealth
    @SehrawatFitHealth 4 роки тому +11

    very professional video.. otherhan other excel guru

  • @manjit.sarania
    @manjit.sarania 2 роки тому +1

    Your teaching on data entry form without vba..is a great help for me..🙏🙏🙏

  • @dharavpatel8216
    @dharavpatel8216 4 роки тому +6

    Perfect information.. as per ur gauid line i created file as per my requirements... N its work. But have one problem when we closed file and reopen it than maicro can no run... N even didnt see in view mairco who we saved before..

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

      Thanks bro
      Please save file as Excel Macro Enabled workbook. It will definitely work.
      Please watch the below video, at the end you will know it very well
      ua-cam.com/video/weBuCZWrcTM/v-deo.html

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

      @@PowerExbyJitendra sir how to create beautiful attendance sheet in excel

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

      nice information

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

    Bahut easy orr simple way me aapne samjhaya h

  • @shrikantinamdar9781
    @shrikantinamdar9781 4 роки тому +4

    can i input order details by selecting from drop down and same data i can transpose to respective sheet

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

      Yes sir definitely, you may watch our video Stock Management Part 2 in which I have created drop down of items list.
      Link is below:
      ua-cam.com/video/DaBFBE9t6KI/v-deo.html

  • @tanmaypandya1102
    @tanmaypandya1102 6 місяців тому

    Very easy, not required basic excel knowledge, great video thanks 👍

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

    Hi sir hope that u will be fine!
    Sir Please also include Total, Previous, Paid, Closing Balance for Sales Costumers and also include paid closing balance for purchase option in this system

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

    Thank you... Because of you I solved my Biggest problem. Thank you Sooo much. I'm glad that i watched your video.

  • @naziya1984
    @naziya1984 4 роки тому +4

    Sir, Thanks for such an informative video, Just wanted to know, this is the case when, say i have a new establishment and i am entering the data 1 by 1, what if i already have a established shop, and i know the list of products that I have already mastered, can we create a dropdown list, for item name, if yes, how do we do that?

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

      Yes you can create drop down list of your products. You may watch our video on drop down list by clicking on following link:
      ua-cam.com/video/YQEGlaghtBI/v-deo.html

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

      @@PowerExbyJitendra Sir how can I cancel or delete wrong entry

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

    Very impressive sir ,I have made more advance with the help of your video thank u sirji ....
    Again thank u

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

    What a very short method explained for a very big job !!!. SIr, Congratulations. Many Thanks. God Bless You.

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

      Thank you very much Harshad Bhai
      God bless you

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

      @@PowerExbyJitendra
      I can say you Beta !, because I have been using Computer since 1970 !!..
      From Card Punching IBM, then using PC of 20MB Memory !...Journey to FORTRAN, dBASE, Foxpro, Clipper, Lotus 123, Developed Many Programs, MS WIndows...a great invention of our time, then learning C, C++ at the age of 54, from Vijay Mukhi...taught C of Kanitkar, but...but... it is not possible to keep pace with Information Technology, trying now Excel, Applying it, gained expertise....so at 71+,....I have a right to bless you, so gave blessings. Keep it Up. HE who teaches, without any rewards, to one and all becomes real Shishya of Maa Sarswati to gain more and more blessings and knowledge from Her.
      I thought you will write some code for all buttons, but learnt new methods of using Hyper Link and Macro Recording from your Video...KEEP IT UP......and impart knowledge to many, all over the Globe ... Once more.... God Bless You !!..... Harshad Vegda.

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

      You can definitely call me son. I am nothing in front of you. You have very log experience not only of computer but also of life.
      It is your greatness that you praised me. Otherwise I am nothing.
      I want to thank you with folded hands for your kindness and your blessings.
      I want you to stay connected with me forever.
      With Best Regards
      Jitendra

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

    The most helpful video I have ever seen thank you so much sir❤

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

    Monthly items wise sale purchase kaise dekha jate hai sir
    Tumhari information good sir👍🙏

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

    maine aaj kar ke dekhaya yeh same 😀

  • @allaiba.R
    @allaiba.R 3 роки тому

    kuwait me dekh raha hoon tumhara viedo aur main start ker raha hoon new buiesnes kuwait me
    tumhara video mere liye bahout help full rahega please aisa video excel ka our viedo upload karo please

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

      Ok Abdul ji thoda bimar ho gaya tha isliye video upload nahi kar paya ab aap continue video dekhoge

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

      Please continue your kind support

  • @RahulKumar-xu7hc
    @RahulKumar-xu7hc 2 роки тому

    grt explanation. was searching for such a video.

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

    im From pakistan,wanted to make something like this for my clinic,im doing it with your video,its great.bundles of thanks

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

      You are welcome sir

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

      @@PowerExbyJitendra sir thank you for your reply.iam having a little problem ,hope you can help me out.till macro recording it worked good but when i enter data in purchase or sales it doesnt go further and show error.

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

    Really nice information and useful for stock management

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

    👍demonstration is nice thank u

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

    Excellent tutorial. So helpful. Thankyou verymuch.

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

    Best tutorial...and best faculty...very easy in learning....thanks a lot sir....

  • @SatheeshKumar-qj8nm
    @SatheeshKumar-qj8nm 3 роки тому

    Very good explanation

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

    Very useful trick and nice explain

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

    hello, sir
    you did an amazing stock management!!! GREAT JOB...
    I follow all your steps but I still having problems .... when i save it and open the excel file again it does not let me !!! like when click ( purchase or sale) doesnt work!!!! can you please help me out...

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

      i save it and when the next day i want to updated the ( purchase or sale ) does not click and says " the macro may not be available in this work book or all macro may be disable " !!!!! please help help help. thanks

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

      Dear please save the file as Macro Enabled Workbook

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

    Sir! How to save stock management excel document.
    Please say.
    Thank you!!❤️❤️❤️

  • @allaiba.R
    @allaiba.R 3 роки тому

    Thanku So Much i like ur video i want learn all ur viedos

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

    Very impressive.
    Sir, agar hum porani entries ko remove karna chahain tou woh kaisay karain agar delete kartay hain tou phir problem aanay lagti hai.

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

    Sir mai apka fan ho gya hu sir

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

    1 like from my side

  • @herbalscience-ne3du
    @herbalscience-ne3du 3 роки тому

    Thanks a lot make more video excel for freelancing

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

    awesome just wow i was looking for this type of tips since years.i wish you can show us how to get reports and purchased items for each project with credit or cash feature.

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

    Sir Bahut aachha hain Ye trick

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

    Excellent explanation fabulous, superb

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

    Very nice sir..ur way if explaining is tooo good sir...sir yahi formula manufacturing process ke liye bhi batao jahan raw material purchase hota hai aur product taiyar hone ke baad uska name change ho jata hai..saath hi raw material ka alag stock aur finished goods ka alag stock kaise mantain karein

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

    Sir, Very Nice.
    One Issue is that, how to hide Purchase, Store Sheet in Worksheet after Macro assign ?

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

    Good explain
    I have query about entry submit after purchase or sales click by mouse any setting possibilities to press any special key to press purchase or sales.

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

    really appreciated video.....i was searching free stock software......but after ur video my searching is stopped

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

    You are powerful idea for excel

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

    HI Jitender, you have explained, it very well and in easy words. Excellent job and keep up the great work... Big thanks

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

    Sir really easily teach

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

    May Allah Bless you Dear Brother. Excellent job done by You. Got 5 Starrrrrrrrrrrrrrrr.

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

    Thank you so much,this is very helpful for me .

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

    Great bhaii 🤘👍🤲

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

    Well done boos keep it up gain more knowledge thanks for your support
    This is aslam

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

    Wow sir thank you for this tutorial. I hope you can make a tutorial for customer profile , amount purchase and contact number with search bar..

  • @AVI-ow3cn
    @AVI-ow3cn 3 роки тому +2

    Finally macro run krna aa gya or save v thank you so much 🙏🙏🙏

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

    Kamal ki trik hai sir good

  • @RaviShankar-dv4wm
    @RaviShankar-dv4wm 3 роки тому

    Thanks for help sir... It's useful for me to maintaining stock in company where I'm working 😊

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

    Very good presentation

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

    Super se upar sir.

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

    JB
    Very nice presentation!
    You are doing great!

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

    Really helpful 👌

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

    Very nice and informative. Thanks

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

    Beautifully explained.
    Excellent.
    There are thousands videos on Excel learning but this is wonderful.

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

      It's your pleasure

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

      Quick Book Accounting Software Complete Course Class 1
      Total 29 videos Every week 2 videos will be uploaded Subscribe channel for complete course & press the bell icon
      Click on this link
      ua-cam.com/video/g5rWrOc4gM8/v-deo.html
      And for complete Accounting & Excel course subscribe channel

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

    Very good information....
    Cafe ka stock maintain plz bataye

  • @alimohammed-ri2zd
    @alimohammed-ri2zd 3 роки тому

    Thank You sir when i write sumif criteria is hidden can u tell me the problem?

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

    Curent Sale ka calculate or bill print ka bhi video de dijiye

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

    👍Pleasant video
    Thank you 💫💫💫💫💫

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

    Sir agar next day main fir sa entry Karu to ya same macro came karaga?

  • @GauravKumar-wu5wo
    @GauravKumar-wu5wo 3 роки тому

    Very Helpful Video sir . Thanks
    But how can i protect our files

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

    V.nice Thank You Sir 🇮🇳🇮🇳🇮🇳

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

    Phly ye column banana hai sales purchase ya ye automatic Bana hua hy

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

    Great video sir ji

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

    Nice work. Sir ya file save ni kr skty kia..?

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

    very good teaching

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

    Can you guide us if in a single purchase bill multiple items and same as in a single sale bill then how to make.

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

    I TRY AND SUCCESSFUL FOR YOUR VIDEO
    THANK YOU

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

    Hi it was really help for me and i did it for first time and my friends like it very mush appreciated me
    Can you create Macro for Break event point

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

    Kya isme product image add kar sakte hai please bataiye

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

    I appreciate your efforts

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

    Sir I want suggestions for my Business Account's

  • @AnkitPal-ql7cv
    @AnkitPal-ql7cv 3 роки тому

    Thankyou
    Very important info

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

    Good explain bro

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

    Isme profit & loss bhi rhta to bhut achha rhta
    Waise
    Good information 👍👍

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

    can you make a video tutorial about multiple sales, 8 product sales entry for 1 customer.

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

    Hi Jitender Thanks for your Tutorials Please write tutorials for Budget , Expense trackers and Banks Transactions ....
    Thanks a lot
    Have Good Day

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

    Very helpful video. Thank you.

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

    Big thanx for this tutorial

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

    Aur ha jo data transpose kr k copy kiya hai purchase aur sales sheet me wo remove karne k baad bhi kya uske upar wale row koi changes honge

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

    The best way to teach

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

    Hiiii....hopefully you doing great....
    I do step by step...but when I enter in stock in hand step....it shows zero...don't know why...please guide

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

    Thank You Sir ALLAH apko kamyab kry

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

    Nice tutorial sir but i have facing an issue that is Run time error 438 ...plz make a video fir debugging it

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

    Can I prepared by using 2007 excel?

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

    I'm from sri lanka.thankas bro

  • @amjadabbasi4509
    @amjadabbasi4509 9 місяців тому

    Plz make video for on bakery recipe and inventory

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

    THANKU sIR aAJ dUA kARUGA aAPKE liYE BAHUT hI aMAZING

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

    Very Nice And Professional Work
    I Like Your NEW idea Vedio 👍

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

    aisa video banaiye jisme customer sell details bhi add Ho jaye with bill no ke sath

  • @AshokKumar-yr2oi
    @AshokKumar-yr2oi 4 роки тому

    Jitendra ji the way you explain is awesome. Keep posting such videos.

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

    very very useful video sir

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

    Sir Stocks sheet main stocks ki entry pehle se hi Karke rakhna hain kya...pls samjayiye

  • @md.alamgirchowdhury4648
    @md.alamgirchowdhury4648 3 роки тому

    nice teaching sir continuous on

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

    ,💛✨💚love you bro💛✨💚