Easily explained in a professional way. Thank you very much 🤗👍
@PowerExbyJitendra3 жыл бұрын
Thanks Brother
@rajdhar3273 жыл бұрын
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
@sandipkisan95874 жыл бұрын
Perfect information sir ji,need more information ..
@PowerExbyJitendra4 жыл бұрын
Thanks Sandip ji
@indrajeetraj69563 жыл бұрын
Computer band hone ke bad micro kam nahi karta hai
@girish13ful3 жыл бұрын
आदरणीय, आपके द्वारा, निःशुल्क शिक्षा दान के लिये, आपका श्रद्धापुर्वक हार्दिक आभार/अभिनंदन।
@Askarijoniour3 жыл бұрын
Hi sir very advanced Nd professional VDO But sir multiple item ki entry kaise karenge ek bill ho kyi sare item ho
@SS_Infotech.3 жыл бұрын
kzbin.info/www/bejne/hnrHgZawqJ2LpdE
@manjit.sarania2 жыл бұрын
Your teaching on data entry form without vba..is a great help for me..🙏🙏🙏
@PowerExbyJitendra2 жыл бұрын
Thanks
@SehrawatFitHealth4 жыл бұрын
very professional video.. otherhan other excel guru
@harshadvegda80973 жыл бұрын
What a very short method explained for a very big job !!!. SIr, Congratulations. Many Thanks. God Bless You.
@PowerExbyJitendra3 жыл бұрын
Thank you very much Harshad Bhai God bless you
@harshadvegda80973 жыл бұрын
@@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.
@PowerExbyJitendra3 жыл бұрын
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
@dharavpatel82164 жыл бұрын
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..
@PowerExbyJitendra4 жыл бұрын
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 kzbin.info/www/bejne/rZalpnaQjNeWiq8
@shashanksriwastava88432 жыл бұрын
@@PowerExbyJitendra sir how to create beautiful attendance sheet in excel
@Generalshortss2 жыл бұрын
nice information
@VarshaKashyap7503 жыл бұрын
Thank you... Because of you I solved my Biggest problem. Thank you Sooo much. I'm glad that i watched your video.
@Pakhtoon91993 жыл бұрын
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
@mahidehasan6273 жыл бұрын
Salute you man....You helping More and more peoples.... God Bless you...Thanks a lot
@PowerExbyJitendra3 жыл бұрын
I would like to thank you for your blessings and love.
@shrikantinamdar97814 жыл бұрын
can i input order details by selecting from drop down and same data i can transpose to respective sheet
@PowerExbyJitendra4 жыл бұрын
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: kzbin.info/www/bejne/epKld3V7btlpgas
@totalkids97233 жыл бұрын
Monthly items wise sale purchase kaise dekha jate hai sir Tumhari information good sir👍🙏
@naziya19844 жыл бұрын
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?
@PowerExbyJitendra4 жыл бұрын
Yes you can create drop down list of your products. You may watch our video on drop down list by clicking on following link: kzbin.info/www/bejne/j4KoeJ-XnM2neKs
@mohammadjasimuddin45793 жыл бұрын
@@PowerExbyJitendra Sir how can I cancel or delete wrong entry
@tanmaypandya11025 ай бұрын
Very easy, not required basic excel knowledge, great video thanks 👍
@Digitaltrick5672 жыл бұрын
Very impressive sir ,I have made more advance with the help of your video thank u sirji .... Again thank u
@simonsher45333 жыл бұрын
im From pakistan,wanted to make something like this for my clinic,im doing it with your video,its great.bundles of thanks
@PowerExbyJitendra3 жыл бұрын
You are welcome sir
@simonsher45333 жыл бұрын
@@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.
@ReviewHouse13 жыл бұрын
really appreciated video.....i was searching free stock software......but after ur video my searching is stopped
@PowerExbyJitendra3 жыл бұрын
It is a privilege for me.
@dayashankar911 Жыл бұрын
Bahut easy orr simple way me aapne samjhaya h
@PowerExbyJitendra Жыл бұрын
Thanks
@allaiba.R3 жыл бұрын
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
@PowerExbyJitendra3 жыл бұрын
Ok Abdul ji thoda bimar ho gaya tha isliye video upload nahi kar paya ab aap continue video dekhoge
@PowerExbyJitendra3 жыл бұрын
Please continue your kind support
@numankhan3143 жыл бұрын
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.
@uzzalray75743 жыл бұрын
Sir! How to save stock management excel document. Please say. Thank you!!❤️❤️❤️
@AVI-ow3cn3 жыл бұрын
Finally macro run krna aa gya or save v thank you so much 🙏🙏🙏
@PowerExbyJitendra3 жыл бұрын
Mujhe bahut khushi hui Abhishek ji
@Gomzie21 Жыл бұрын
The most helpful video I have ever seen thank you so much sir❤
@PowerExbyJitendra Жыл бұрын
Thanks a lot
@syedakmal80064 жыл бұрын
Beautifully explained. Excellent. There are thousands videos on Excel learning but this is wonderful.
@PowerExbyJitendra4 жыл бұрын
It's your pleasure
@officework17923 жыл бұрын
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 kzbin.info/www/bejne/nWbViKWFmJmag5o And for complete Accounting & Excel course subscribe channel
@pramodagrawal26833 жыл бұрын
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
@viswasbhujel91463 жыл бұрын
maine aaj kar ke dekhaya yeh same 😀
@PowerExbyJitendra3 жыл бұрын
Ok thanks
@viswasbhujel91463 жыл бұрын
@@PowerExbyJitendra or v excel ka video banaiye sir
@PowerExbyJitendra3 жыл бұрын
Great
@muhammadnaeem71124 жыл бұрын
May Allah Bless you Dear Brother. Excellent job done by You. Got 5 Starrrrrrrrrrrrrrrr.
@PowerExbyJitendra4 жыл бұрын
Dear Naeem, So much thanks for your wishes.
@shabuthambi65124 жыл бұрын
Excellent tutorial. So helpful. Thankyou verymuch.
@PowerExbyJitendra4 жыл бұрын
Thanks🌹
@nivashkumar18713 жыл бұрын
Isme profit & loss bhi rhta to bhut achha rhta Waise Good information 👍👍
@PowerExbyJitendra3 жыл бұрын
Thank you Nivash
@dreamparadise15203 жыл бұрын
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.
@RaviShankar-dv4wm3 жыл бұрын
Thanks for help sir... It's useful for me to maintaining stock in company where I'm working 😊
@bhartinavita22833 жыл бұрын
Sir mai apka fan ho gya hu sir
@PowerExbyJitendra3 жыл бұрын
Thanks a lot Bharti ji
@ruthsonia40703 жыл бұрын
Best tutorial...and best faculty...very easy in learning....thanks a lot sir....
@PowerExbyJitendra3 жыл бұрын
Very much thanks
@ferroperro36392 жыл бұрын
Hi Jitender Thanks for your Tutorials Please write tutorials for Budget , Expense trackers and Banks Transactions .... Thanks a lot Have Good Day
@PowerExbyJitendra2 жыл бұрын
Thanks a lot
@subhojitkarmakar18534 жыл бұрын
Bahut accha vedio hain😀..but isiper net stock add kar dega toh accha hoga ,.. Kohi product return aya toh kaise add karega???
@PowerExbyJitendra4 жыл бұрын
Ji Subhojit, product return ke liye zaroor improvement ki zarurat hai. Thanks for valid suggestion
@PowerExbyJitendra4 жыл бұрын
kzbin.info/www/bejne/eZi0dZ2faL96etU
@RahulKumar-xu7hc2 жыл бұрын
grt explanation. was searching for such a video.
@PowerExbyJitendra2 жыл бұрын
Thanks
@Rklamsum3 жыл бұрын
Curent Sale ka calculate or bill print ka bhi video de dijiye
@patelmubarak3 жыл бұрын
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.
@kenmarkvalencia19242 жыл бұрын
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..
@satwinderkaur18722 жыл бұрын
HI Jitender, you have explained, it very well and in easy words. Excellent job and keep up the great work... Big thanks
@allaiba.R3 жыл бұрын
Thanku So Much i like ur video i want learn all ur viedos
@PowerExbyJitendra3 жыл бұрын
It is so kind of you abdul ji
@baapjiyadav27694 жыл бұрын
Sir Bahut aachha hain Ye trick
@PowerExbyJitendra4 жыл бұрын
Thanks Yadav ji
@kishorpatil55014 жыл бұрын
Really nice information and useful for stock management
@PowerExbyJitendra4 жыл бұрын
Thanks Kishor ji
@suryakantvaidya4261 Жыл бұрын
Sir, Very Nice. One Issue is that, how to hide Purchase, Store Sheet in Worksheet after Macro assign ?
@elementsfoodcourt61173 жыл бұрын
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
@tiyashabasu57524 жыл бұрын
Very good information.... Cafe ka stock maintain plz bataye
@PowerExbyJitendra4 жыл бұрын
Thanks
@RajkwsComputer2 жыл бұрын
You are powerful idea for excel
@PowerExbyJitendra2 жыл бұрын
Thanks ji
@PiyushMedicalKnowledge4 жыл бұрын
1 like from my side
@PowerExbyJitendra4 жыл бұрын
Thanks Piyush
@ehtesham40093 жыл бұрын
Very useful trick and nice explain
@PowerExbyJitendra3 жыл бұрын
Thanks Sir
@ksrazmi2813 жыл бұрын
Kamal ki trik hai sir good
@PowerExbyJitendra3 жыл бұрын
Thanks
@herbalscience-ne3du3 жыл бұрын
Thanks a lot make more video excel for freelancing
@sureshprabhu57113 жыл бұрын
👍demonstration is nice thank u
@TheTeach-fe4ft Жыл бұрын
Thank u so much Dear sir अगर इन तीनो शीटों का डाटा को एक ही शीट मे collect karnaa hi to कैसे करेंगे 🙏🙏
@martinkulasmotovlogs9020 Жыл бұрын
can you make a video tutorial about multiple sales, 8 product sales entry for 1 customer.
@happyfeliz65642 жыл бұрын
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...
@happyfeliz65642 жыл бұрын
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
@PowerExbyJitendra2 жыл бұрын
Dear please save the file as Macro Enabled Workbook
@maakalienterprises73203 жыл бұрын
aisa video banaiye jisme customer sell details bhi add Ho jaye with bill no ke sath
@PowerExbyJitendra3 жыл бұрын
Ok ji
@AshokKumar-yr2oi4 жыл бұрын
Jitendra ji the way you explain is awesome. Keep posting such videos.
@PowerExbyJitendra4 жыл бұрын
Thank you so much Ashok ji
@goluchouksey27942 ай бұрын
Super se upar sir.
@PowerExbyJitendra2 ай бұрын
Thanks a lot
@atanusantra98313 жыл бұрын
Stock sheet mai item name ko kaise unique ke base par automatically lekar aye... Please 🙏 sir guide
@kavitachaudhary8562 жыл бұрын
Thank you so much,this is very helpful for me .
@PowerExbyJitendra2 жыл бұрын
Thanks 🙏
@my_Islam5433 жыл бұрын
Great bhaii 🤘👍🤲
@PowerExbyJitendra3 жыл бұрын
Thanks ji
@ifatjan91852 жыл бұрын
SIR HOW WE MAKE MARKS CARDS FOR STUDENTS .Please make one video
@PowerExbyJitendra2 жыл бұрын
Dear I have video on it please watch
@anjumfaki81614 жыл бұрын
Excellent explanation fabulous, superb
@PowerExbyJitendra4 жыл бұрын
Thanks Anjum ji
@shantilalrajput87082 жыл бұрын
V.nice Thank You Sir 🇮🇳🇮🇳🇮🇳
@gymemon97063 жыл бұрын
THANKU sIR aAJ dUA kARUGA aAPKE liYE BAHUT hI aMAZING
@PowerExbyJitendra3 жыл бұрын
Mai bhi apke liye dua karta hu aap hamesha khush rahe
@pamartz67794 жыл бұрын
Bhut hi helpful sir
@PowerExbyJitendra4 жыл бұрын
Thanks ji
@neeshugupta8473 жыл бұрын
Sar ak video bnaiye jisme sell purchase with amount ke sath ho jisse hme profit loss ka bhi pta chale
@PowerExbyJitendra3 жыл бұрын
Ok ji
@PowerExbyJitendra3 жыл бұрын
Thanks for watching and keep continue your support
@PowerExbyJitendra3 жыл бұрын
Ha ji zaroor
@jGcreations66943 жыл бұрын
Sir really easily teach
@sayantikachowdhury76543 жыл бұрын
Very good presentation
@PowerExbyJitendra3 жыл бұрын
Thanks ji
@SatheeshKumar-qj8nm3 жыл бұрын
Very good explanation
@Danish_Official14 жыл бұрын
Thanks for the video, Excel 2007 me bhi ye kaam kar rha he. But 1st entry ke baad 2nd entry, 1st entry ke niche aani chahiye lekin uske uper kyu enter ho rha he data?
@PowerExbyJitendra4 жыл бұрын
Exactly
@PowerExbyJitendra4 жыл бұрын
Please watch this video: kzbin.info/www/bejne/epKld3V7btlpgas
@mummudivarapukishore10203 жыл бұрын
I loved the macro the way u simply designed
@PowerExbyJitendra3 жыл бұрын
Thanks ji
@amjadabbasi45097 ай бұрын
Plz make video for on bakery recipe and inventory
@vmslanka26963 жыл бұрын
I'm from sri lanka.thankas bro
@PowerExbyJitendra3 жыл бұрын
Thanks for watching
@numair33 жыл бұрын
I appreciate your efforts
@PowerExbyJitendra3 жыл бұрын
Thanks Mirza ji
@UmarFarooq-pd9hl3 жыл бұрын
Great work... 1 query thi k jb table pey ja k paste special krny k bad row select kr k insert krty ha... Waha date descending order ma q ati ha i.e(pehly 2 phr 3)...waha ascending order ma kesy aye gi i.e(1-jan...than 2-jan)... Plz guide
@PowerExbyJitendra3 жыл бұрын
Farooq bhai aapse gujaris hai is cheez ko samajhne ke liye video ka part 2 zaroor dekhe : kzbin.info/www/bejne/epKld3V7btlpgas
@UmarFarooq-pd9hl3 жыл бұрын
G ma dekhta hu... Kindly mjy ap ka whatsapp nbr mil skta ha... Ma ny ap ki video dekh k wo same software bnaya ha.. Lkn us ma thori complications aa rhi ha.. Q k business different ha to items b diffrent ha... Wo ma ap se nbr pey guidence ley lu ga..
@UmarFarooq-pd9hl3 жыл бұрын
Kindly ap petrol pump management system py video bna skty ha..??
@onlinebucket6754 жыл бұрын
Thank You Sir ALLAH apko kamyab kry
@PowerExbyJitendra4 жыл бұрын
Aapko bhi Ramzan bhai tarakki aur kamyabi hansil ho
@vishalshinde74982 жыл бұрын
Really helpful 👌
@PowerExbyJitendra2 жыл бұрын
Thanks
@mdhasim073 жыл бұрын
Nice tutorial sir but i have facing an issue that is Run time error 438 ...plz make a video fir debugging it
@Fav_clips04 жыл бұрын
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 ❤️❤️❤️❤️❤️❤️
@PowerExbyJitendra4 жыл бұрын
Thanks for your lovely comment
@adibmakki8954 жыл бұрын
👍Pleasant video Thank you 💫💫💫💫💫
@PowerExbyJitendra3 жыл бұрын
Thanks Abid bhai
@dilippawar64913 жыл бұрын
JB Very nice presentation! You are doing great!
@PowerExbyJitendra3 жыл бұрын
Thank you so much❤
@sanabuddhadev3 жыл бұрын
I TRY AND SUCCESSFUL FOR YOUR VIDEO THANK YOU
@PowerExbyJitendra3 жыл бұрын
Great👍
@excelpointstudy1273 жыл бұрын
Aaise hi video aur bnaiye
@PowerExbyJitendra3 жыл бұрын
Ok ji Chauhan ji
@sspcentralkarachi Жыл бұрын
very good teaching
@aaliyagazala61504 жыл бұрын
Really sir, you have a very good knowledge and the best way to tell you is very good.
@PowerExbyJitendra4 жыл бұрын
Thanks Sir
@sherazazam2363 жыл бұрын
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????
@milindsohoni14072 жыл бұрын
Can you guide us if in a single purchase bill multiple items and same as in a single sale bill then how to make.
@alimohammed-ri2zd3 жыл бұрын
Thank You sir when i write sumif criteria is hidden can u tell me the problem?
@GauravKumar-wu5wo3 жыл бұрын
Very Helpful Video sir . Thanks But how can i protect our files
@AnkitPal-ql7cv3 жыл бұрын
Thankyou Very important info
@PowerExbyJitendra3 жыл бұрын
Welcome sir
@shobankumarnaidu47333 жыл бұрын
Good explain bro
@PowerExbyJitendra3 жыл бұрын
Thanks Shoban ji
@badarswati4503 жыл бұрын
The best way to teach
@PowerExbyJitendra3 жыл бұрын
Thank you so much
@bikashsaikia16123 жыл бұрын
Keep growning brother thank you 🌹 helped a lot
@PowerExbyJitendra3 жыл бұрын
Thank you so much Bikash ji
@seenivasanrengamani41824 жыл бұрын
Very excelent keepitup
@PowerExbyJitendra4 жыл бұрын
Thanks ji
@varshapatel96353 жыл бұрын
Big thanx for this tutorial
@PowerExbyJitendra3 жыл бұрын
Big thank for you🙏
@mohammedaslam6334 жыл бұрын
Well done boos keep it up gain more knowledge thanks for your support This is aslam
@PowerExbyJitendra4 жыл бұрын
Thank you so much Aslam bhai
@shashankrawat24803 жыл бұрын
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