Stock Management in Excel (Hindi)

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ก.ย. 2024
  • Stock Management in Excel (Hindi)
    In this excel tutorial you will learn how to make Stock Management Software in Excel in Hindi.
    If you need to maintain stock register in excel then this Stock register will help you to Enter the Inward quantity of stock and to maintain the Outward quantity of Stock to get the net report of stock maintain in Excel.
    Download Our Excel File:
    drive.google.c...
    You can use this as Stock register format in excel to maintain your stock report.
    Our Best videos:
    1. How to Create a Quick and Simple Excel Chart with just One Click and Excel Chart Formatting Tutorial
    • How to Create a Quick ...
    2. 12 Useful Excel Pivot Table Tips and Tricks everyone should know | Advance Pivot Table Tips in Hindi
    • 12 Useful Excel Pivot ...
    3.Vlookup Formula in MS Excel with Examples| Finding Particular Data in Same/Different Workbooks Hindi
    • Vlookup Formula in MS ...
    4. How to Get Multiple Results by Using Vlookup Formula with Columns Formula in MS - Excel in Hindi
    • How to Get Multiple Re...
    5. How to Use Vlookup with Match Function in Excel | Two Dimensional Vlookup in MS Excel (Hindi)
    • How to Use Vlookup wit...
    6. Using Hlookup Formula in MS Excel in Hindi Hlookup and Columns Function Explained With Examples
    • Using Hlookup Formula ...
    7. How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi ?
    • How to use COUNT, COUN...
    8.Sumif formula in Excel in Hindi | How to use Sumif Formula in excel in Hindi | With Examples
    • Sumif formula in Excel...
    9. Sumifs Formula in Excel in Hindi || Sumif and Sumifs Excel Functions | PowerEx by Jitendtra
    • Sumifs Formula in Exce...
    10. How to Automatically Transfer Data from one sheet to another in Excel using macros (Hindi)
    • How to Automatically T...
    11. How to Move Data Automatically from One Workbook to Another in Excel | Using Macro |
    • How to Move Data Autom...
    video is created by Jitendra
    Published on Powerex by Jitendra
    #stockmanagement
    #powerxbyjitendra
    #excel
    Contact Us:
    Instagram: ...
    Facebook : / powerex-by-jitendra-10...
    Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
    Fair use is a permitted by copyright statute that might otherwise be infringing.
    Non-profit, educational or personal use tips the balance in favor of fair use.

ความคิดเห็น • 1.3K

  • @abdulattiff
    @abdulattiff 3 ปีที่แล้ว +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

  • @SehrawatFitHealth
    @SehrawatFitHealth 3 ปีที่แล้ว +10

    very professional video.. otherhan other excel guru

  • @girish13ful
    @girish13ful 3 ปีที่แล้ว

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

  • @dharavpatel8216
    @dharavpatel8216 3 ปีที่แล้ว +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  3 ปีที่แล้ว +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
      th-cam.com/video/weBuCZWrcTM/w-d-xo.html

    • @shashanksriwastava8843
      @shashanksriwastava8843 2 ปีที่แล้ว

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

    • @Generalshortss
      @Generalshortss ปีที่แล้ว

      nice information

  • @manjit.sarania
    @manjit.sarania 2 ปีที่แล้ว +1

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

  • @Pakhtoon9199
    @Pakhtoon9199 3 ปีที่แล้ว +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

  • @tanmaypandya1102
    @tanmaypandya1102 2 หลายเดือนก่อน

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

  • @sandipkisan9587
    @sandipkisan9587 3 ปีที่แล้ว +5

    Perfect information sir ji,need more information ..

  • @harshadvegda8097
    @harshadvegda8097 3 ปีที่แล้ว +2

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

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว +1

      Thank you very much Harshad Bhai
      God bless you

    • @harshadvegda8097
      @harshadvegda8097 3 ปีที่แล้ว

      @@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  3 ปีที่แล้ว

      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

  • @Askarijoniour
    @Askarijoniour 3 ปีที่แล้ว +3

    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 ปีที่แล้ว

      th-cam.com/video/PIdPczs8Xoo/w-d-xo.html

  • @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.

  • @shrikantinamdar9781
    @shrikantinamdar9781 3 ปีที่แล้ว +4

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

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว +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:
      th-cam.com/video/DaBFBE9t6KI/w-d-xo.html

  • @AVI-ow3cn
    @AVI-ow3cn 3 ปีที่แล้ว +2

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

  • @naziya1984
    @naziya1984 3 ปีที่แล้ว +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  3 ปีที่แล้ว +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:
      th-cam.com/video/YQEGlaghtBI/w-d-xo.html

    • @mohammadjasimuddin4579
      @mohammadjasimuddin4579 2 ปีที่แล้ว

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

  • @numankhan314
    @numankhan314 3 ปีที่แล้ว +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.

  • @muhammadnaeem7112
    @muhammadnaeem7112 3 ปีที่แล้ว +1

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

  • @mahidehasan627
    @mahidehasan627 3 ปีที่แล้ว

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

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว

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

  • @syedakmal8006
    @syedakmal8006 3 ปีที่แล้ว +1

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

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว

      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
      th-cam.com/video/g5rWrOc4gM8/w-d-xo.html
      And for complete Accounting & Excel course subscribe channel

  • @RaviShankar-dv4wm
    @RaviShankar-dv4wm 3 ปีที่แล้ว

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

  • @shabuthambi6512
    @shabuthambi6512 3 ปีที่แล้ว +1

    Excellent tutorial. So helpful. Thankyou verymuch.

  • @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.

  • @Gomzie21
    @Gomzie21 ปีที่แล้ว

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

  • @dayashankar911
    @dayashankar911 9 หลายเดือนก่อน

    Bahut easy orr simple way me aapne samjhaya h

  • @manav4792
    @manav4792 3 ปีที่แล้ว +1

    So helpful 😯😯😯😯😯need more vedieos like this sir ji and explain all formulas which r u using in your vedieos .thank u so much sir ❤️❤️❤️❤️❤️❤️

  • @totalkids9723
    @totalkids9723 3 ปีที่แล้ว +1

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

  • @ruthsonia4070
    @ruthsonia4070 3 ปีที่แล้ว

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

  • @kavitachaudhary856
    @kavitachaudhary856 2 ปีที่แล้ว

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

  • @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

  • @Sammy-xv7mq
    @Sammy-xv7mq 3 ปีที่แล้ว +1

    Your video is excellent and very understandable, clear instructions
    I have learned and put in practice already and it works
    Thank you 🙏 so much
    God bless
    Excellent training video

    • @SS_Infotech.
      @SS_Infotech. 3 ปีที่แล้ว

      th-cam.com/video/PIdPczs8Xoo/w-d-xo.html

  • @ReviewHouse1
    @ReviewHouse1 3 ปีที่แล้ว

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

  • @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

  • @aaliyagazala6150
    @aaliyagazala6150 3 ปีที่แล้ว

    Really sir, you have a very good knowledge and the best way to tell you is very good.

  • @mummudivarapukishore1020
    @mummudivarapukishore1020 3 ปีที่แล้ว +1

    I loved the macro the way u simply designed

  • @uzzalray7574
    @uzzalray7574 3 ปีที่แล้ว +1

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

  • @herbalscience-ne3du
    @herbalscience-ne3du 3 ปีที่แล้ว

    Thanks a lot make more video excel for freelancing

  • @shantilalrajput8708
    @shantilalrajput8708 2 ปีที่แล้ว

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

  • @sanabuddhadev
    @sanabuddhadev 3 ปีที่แล้ว

    I TRY AND SUCCESSFUL FOR YOUR VIDEO
    THANK YOU

  • @AshokKumar-yr2oi
    @AshokKumar-yr2oi 3 ปีที่แล้ว

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

  • @RajkwsComputer
    @RajkwsComputer 2 ปีที่แล้ว

    You are powerful idea for excel

  • @RahulKumar-xu7hc
    @RahulKumar-xu7hc 2 ปีที่แล้ว

    grt explanation. was searching for such a video.

  • @vinaynigam4909
    @vinaynigam4909 3 ปีที่แล้ว

    Nicely explained. To the point. Short and sweet. 👍

  • @jjcreations6694
    @jjcreations6694 3 ปีที่แล้ว

    Sir really easily teach

  • @gymemon9706
    @gymemon9706 3 ปีที่แล้ว

    THANKU sIR aAJ dUA kARUGA aAPKE liYE BAHUT hI aMAZING

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว

      Mai bhi apke liye dua karta hu aap hamesha khush rahe

  • @ehtesham4009
    @ehtesham4009 3 ปีที่แล้ว

    Very useful trick and nice explain

  • @sspcentralkarachi
    @sspcentralkarachi ปีที่แล้ว

    very good teaching

  • @SatheeshKumar-qj8nm
    @SatheeshKumar-qj8nm 3 ปีที่แล้ว

    Very good explanation

  • @kishorpatil5501
    @kishorpatil5501 3 ปีที่แล้ว

    Really nice information and useful for stock management

  • @saeedmart
    @saeedmart 3 ปีที่แล้ว

    Thanks a lot for this Excellent Lecture/Video. Best Regards: Ikram Saeed from Lahore, Pakistan.

  • @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..

  • @bikashsaikia1612
    @bikashsaikia1612 3 ปีที่แล้ว +1

    Keep growning brother thank you 🌹 helped a lot

  • @elementsfoodcourt6117
    @elementsfoodcourt6117 2 ปีที่แล้ว

    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

  • @ksrazmi281
    @ksrazmi281 3 ปีที่แล้ว +1

    Kamal ki trik hai sir good

  • @zahidsiraj4861
    @zahidsiraj4861 3 ปีที่แล้ว

    Bro very good vedio and very very helpfull for me thanks
    i am requst bro you give me loss and proft vedio thanks

  • @mohammedaslam633
    @mohammedaslam633 3 ปีที่แล้ว

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

  • @numair3
    @numair3 2 ปีที่แล้ว

    I appreciate your efforts

  • @bhartinavita2283
    @bhartinavita2283 2 ปีที่แล้ว

    Sir mai apka fan ho gya hu sir

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 3 ปีที่แล้ว +1

    1 like from my side

  • @seenivasanrengamani4182
    @seenivasanrengamani4182 3 ปีที่แล้ว +2

    Very excelent keepitup

  • @sudarshankothari5404
    @sudarshankothari5404 3 ปีที่แล้ว

    I have done the right direction as you have shoon

  • @sherazazam236
    @sherazazam236 2 ปีที่แล้ว +1

    I got it but a little problem. When the data transfer to other sheet the "Go to main menu" button moves to downward as a new row inserts .... how i can make button freeze or any solution????

  • @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.

  • @ferroperro3639
    @ferroperro3639 ปีที่แล้ว

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

  • @nareshsuna659
    @nareshsuna659 3 ปีที่แล้ว

    Excellent sir jii... bahut achhe

  • @vmslanka2696
    @vmslanka2696 2 ปีที่แล้ว

    I'm from sri lanka.thankas bro

  • @RaviSingh-uu4ur
    @RaviSingh-uu4ur 3 ปีที่แล้ว

    Too easy too good

  • @masquaresoftware2472
    @masquaresoftware2472 3 ปีที่แล้ว

    Great video sir ji

  • @allaiba.R
    @allaiba.R 3 ปีที่แล้ว

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

  • @sureshprabhu5711
    @sureshprabhu5711 3 ปีที่แล้ว

    👍demonstration is nice thank u

  • @anjumfaki8161
    @anjumfaki8161 3 ปีที่แล้ว

    Excellent explanation fabulous, superb

  • @trivedikumarsonesh4194
    @trivedikumarsonesh4194 3 ปีที่แล้ว

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

  • @pamartz6779
    @pamartz6779 3 ปีที่แล้ว

    Bhut hi helpful sir

  • @baapjiyadav2769
    @baapjiyadav2769 3 ปีที่แล้ว

    Sir Bahut aachha hain Ye trick

  • @afvlog3954
    @afvlog3954 3 ปีที่แล้ว

    Very nice and informative. Thanks

  • @nivashkumar1871
    @nivashkumar1871 3 ปีที่แล้ว

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

  • @sam6524
    @sam6524 3 ปีที่แล้ว

    Very nice video and well explained. Thank you.

  • @dipakbasnet0
    @dipakbasnet0 3 ปีที่แล้ว

    very very useful video sir

  • @buddhikaeranda2246
    @buddhikaeranda2246 3 ปีที่แล้ว +1

    Excellent!

  • @truongtu8734
    @truongtu8734 3 ปีที่แล้ว

    Great,thanks!

  • @amandeepshankhdhar5891
    @amandeepshankhdhar5891 ปีที่แล้ว

    Thanks u so much for this excel

  • @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

  • @onlinebucket675
    @onlinebucket675 3 ปีที่แล้ว

    Thank You Sir ALLAH apko kamyab kry

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 ปีที่แล้ว

      Aapko bhi Ramzan bhai tarakki aur kamyabi hansil ho

  • @my_Islam543
    @my_Islam543 3 ปีที่แล้ว

    Great bhaii 🤘👍🤲

  • @tariqulmajid6119
    @tariqulmajid6119 2 ปีที่แล้ว

    I love this video ................

  • @excelpointstudy127
    @excelpointstudy127 3 ปีที่แล้ว

    Aaise hi video aur bnaiye

  • @amjadabbasi4509
    @amjadabbasi4509 4 หลายเดือนก่อน

    Plz make video for on bakery recipe and inventory

  • @vishalshinde7498
    @vishalshinde7498 2 ปีที่แล้ว

    Really helpful 👌

  • @JJ-gi8nx
    @JJ-gi8nx ปีที่แล้ว

    Sir thank you very much for this video, its so simly and well explained . But if you could refer me how we can select the products by scanning EAN that would have saved alot of time. Thank you .

  • @martinkulasmotovlogs9020
    @martinkulasmotovlogs9020 ปีที่แล้ว

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

  • @alimohammed-ri2zd
    @alimohammed-ri2zd 3 ปีที่แล้ว

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

  • @dilippawar6491
    @dilippawar6491 2 ปีที่แล้ว

    JB
    Very nice presentation!
    You are doing great!

  • @rinkuindian9969
    @rinkuindian9969 3 ปีที่แล้ว

    So helpful, smart tutorial.
    Thank you

  • @varshapatel9635
    @varshapatel9635 3 ปีที่แล้ว

    Big thanx for this tutorial

  • @vishwajeetkadlag1473
    @vishwajeetkadlag1473 3 ปีที่แล้ว

    Very nice video

  • @satyamonlineservice5152
    @satyamonlineservice5152 3 ปีที่แล้ว

    jitendra bhai dhashu hai thank you

  • @helaluddin6323
    @helaluddin6323 3 ปีที่แล้ว

    Excellent work, thanks a lot for such presentation

  • @badarswati450
    @badarswati450 3 ปีที่แล้ว

    The best way to teach

  • @hassaanlion5663
    @hassaanlion5663 5 หลายเดือนก่อน

    Sir love from Pakistan 🇵🇰

  • @Aaj_Se_Start_0.1
    @Aaj_Se_Start_0.1 3 ปีที่แล้ว +1

    Great ❤️