New Automated Data Entry Software in Excel | Data Entry Form in Excel

New Automated Data Entry Software in Excel | Data Entry Form in Excel | Data Entry in Excel

Рет қаралды 1,524,768

2 жыл бұрын

New Automated Data Entry Software in Excel | Data Entry Form in Excel | Data Entry in Excel
This video is about a Fully Automated Data Entry Form in Excel. If you want to make the task of data entry easy, then definitely watch this video. This video explains how you can create a fully automated data entry form without VBA coding. No major Excel Functions have been used in it.
So watch the video and if you find it valuable please subscribe our channel:
/ powerexbyjitendra
And if you want to download our file, click on below link:
==============================
drive.google.com/file/d/11c5O...
==============================
Related Videos:
1. If Function in Excel in Hindi
• If Function in Excel i...
2. If Function in Excel With Multiple Conditions | Nested If Function (Hindi)
• If Function in Excel W...
3. Conditional Formatting with Formulas
• Conditional Formatting...
4. Conditional Data Entry in Excel Using Data Validation
• Conditional Data Entry...
5. How To Create Drop Down List In Excel Hindi
• How To Create Auto Upd...
6. How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi ?
• How to use COUNT, COUN...
7. Option Buttons
• Search Data in Excel w...
8. Check Boxes in Excel
• Updating Payment Statu...
-------------------------------------------------------------
Other videos on Data Entry Form
1. How to Make Data Entry Form in Excel Using Macro in Hindi | Like a Software
• How to Make Data Entry...
2. Super Easy Excel Data Entry Form (No VBA) in Hindi
• Super Easy Excel Data ...
3. Data Entry Form in Excel without VBA | Data Entry in Excel | Like a Software
• Data Entry Form in Exc...
-------------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#dataentryform
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
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.
Thanks

Пікірлер: 712

@AHKHacker Жыл бұрын

Very nice.. thankyou so much... Perfect and very smoothly teach everything

@PowerExbyJitendra Жыл бұрын

Thank you so much

@mohankathe3332 Жыл бұрын

@@PowerExbyJitendra Why are you not helping us, I have asked you a question above, cannot add a second line in merge and center under(Terms and conditions)How did you add that in the video? Please reply...

@ArunPKR Жыл бұрын

@@PowerExbyJitendra button enabled even during white filled cell, allowing it for incomplete entry. how to disable it?

@Dhoni466 4 ай бұрын

Kindly share Excel sheet

@richculture4160 Жыл бұрын

Linked Picture and Appending records in the database through Macro is really excellent. So many years I have been using Excel but not knowing this powerful utility. Thanks for the same.

@jeremyjizzy1 Жыл бұрын

I want to say a BIG THANK YOU! Although i didnt understand the Language, i was able to follow the video!

@krishikatiwari9632 9 ай бұрын

Wow, a perfect teacher, aaj tak maine koi movie bhi 40 min lagatar nahi dekhi but your teaching style is birrliant. Bhagwan aapko samrridhi de.

@PowerExbyJitendra 9 ай бұрын

It is your kindness. Thanks a lot.

@mohammadjamshaid410 Жыл бұрын

Hello Dear, May Allah/God give you special reward for this brilliant & Excellent support and professional knowledge about excel for recording of data in bulk form with accuracy in this world and hereafter. Ameen I really appreciate your energy and time. Jazak Allah

@abroazhar Жыл бұрын

great. apne is ek video me buhut kuch samjha diya... If function, Conditional Formatting, VBCode, Macro Recording, Some tricks to Hide data.... Amazing...

@SUNEELKANDA 3 ай бұрын

बहुत बार सीखने का प्रयास किया। बहुत कुछ सीखा। मैक्रो रिकॉर्ड करते समय भूल हो जाया करती थी। आसान भाषा में जब तुमने समझाया तब सच में उसको पूरी तरह समझ गया हूं। एक्सेल को सिखाने में बहुत सी पुस्तकें और यूट्यूब का और कंटेंट बनाने वालो का कोटी कोटी धन्यवाद। तुम्हारा विशेष रूप से धन्यवाद। मधुर वाणी के स्वामी हो। मेरा विशेष स्नेह स्वीकार करें। मैं सुनील काण्डा आगरा ताज नगरी उत्तर प्रदेश भारत से।

@PowerExbyJitendra 3 ай бұрын

सुनील जी बहुत बहुत आभार 🙏

@PedroMartinez-nl1gr Жыл бұрын

Great job, although I do not speak your language I was able to follow and understand the concept. Really appreciate your work and effort. Thank you .... and yes, I subscribed 👍

@3bi573 Жыл бұрын

this is the solution to my problems...thanks very much and you deserve all thumbs up

@nirmalmehta9833 Жыл бұрын

Its really helpful to me. Thank you sir for explaining Automated Data Entry Form in simple way. Again thank you so much.

@yjtechnical4700 Жыл бұрын

Excellent video, very nicely explained. A good tutorial for all computer users (beginner , advanced).

@devendrarawat2402 11 ай бұрын

kzfaq.info/get/bejne/i9GDf7KDub3Ml5s.html

@sanjaydahiya8438 Жыл бұрын

SIR, I HAVE SEEN THIS VIDEO FULLY. VERY USEFUL AND WELL DESCRIBED

@n12adam96 Жыл бұрын

I have tried this step until the software finished, all I can say to the creators video is that u r super informative or like useful video for who want to gain software knowledge in M.Excel. TQ

@PowerExbyJitendra Жыл бұрын

Thank you so much

@stop007michaela Жыл бұрын

Thank you very much, I don´t speak your language, but it completely doesn´t maether, because you are explaining and showing so good, that I have understood everything. It is huge help for me. Thank you very much for your video 🤩😊😊

@keshariprasad1992 2 жыл бұрын

You have lots of information about MS excel. Thank you for sharing your knowledge.

@PowerExbyJitendra 2 жыл бұрын

Thank you so much

@irfanchauhan313 Жыл бұрын

Very well explained and demonstrated.... Hoping for more Vdos on Excel VBA with Code and Design.... and also expect to get Source File (Please)

@kamala2300 Жыл бұрын

Excellent! I don't know Hindi, however, I am able to understand and follow up on your instructions. Really very helpful. Thank you so much.

@PowerExbyJitendra Жыл бұрын

Thanks

@PD_incredible 2 жыл бұрын

Jitendra, Incredible video. Step by step creation of data entry screen - very well done. Brilliant explanation. 👍🙌

@PowerExbyJitendra 2 жыл бұрын

Thanks Sir

@md.emamuddin1950 Жыл бұрын

Very useful for advanced Learner. Expect more and more similar Clip. Thank You Very Much.

@PowerExbyJitendra Жыл бұрын

Thanks for your lovely comment

@rajeevgosavi4514 Жыл бұрын

One of the best tutorials on Macro making it to understand in simple manner. Thanks.

@PowerExbyJitendra Жыл бұрын

Thanks🙏

@balochzaicoding5871 11 ай бұрын

Very well explained and demonstrated. I applied these to my workbook and it came out very well..... thank you very much!!!!

@devendrarawat2402 11 ай бұрын

kzfaq.info/get/bejne/i9GDf7KDub3Ml5s.html

@aznibas 2 жыл бұрын

Wonderful teaching methodology. Keep up your teaching amazing way. Thank you.

@PowerExbyJitendra 2 жыл бұрын

Thanks🙏

@nusratlines4947 2 жыл бұрын

@@PowerExbyJitendra outstand job.. you teach very simply

@academyofmaths8624 Жыл бұрын

God bless you bro this video tutorial was much better for me. I wanted such a great format for data entry in Excel. Now you made it very easy. Thank you so much.

@PowerExbyJitendra Жыл бұрын

Thanks a lot

@infoStationpt Жыл бұрын

The Best, smooth and simple way, Matchless, Thanks👍

@PowerExbyJitendra Жыл бұрын

Thanks

@ik___mcstan1084 Жыл бұрын

Every doubts are cleared today it's an awesome 👍 tq so much GURU🙏

@PowerExbyJitendra Жыл бұрын

Thanks 🙏

@getfanmedia Жыл бұрын

I'm a follower of your videos they are all interesting thanks for sharing your knowledge.

@saghirahmed5459 3 ай бұрын

barri gal a g. ma computer to nai janta magar janab aap ne samjaya bohat acha ha. well done. and bravo!

@sabiruli Жыл бұрын

This is amazing bro. Very easy to understand. Thanks from Bangladesh

@imdadhussain5856 5 ай бұрын

What A Video .. What A Style of Teaching ... Thank U So Much Sir .. I cant find words to describe your Kindness ...🥰🥰

@PowerExbyJitendra 5 ай бұрын

Thanks you so much bro 🙏🙏🙏🙏🙏

@hindiinfotech_official 2 жыл бұрын

Your voice modulations is very fine Explaining techniques is 👍

@PowerExbyJitendra 2 жыл бұрын

Thank you so much

@hnquran1002 9 ай бұрын

Thank you so much, Perfect and very smoothly teach everything

@bantax2008 6 ай бұрын

Wonderful video, explained so clearly. Thank you!

@ceetravels9925 Жыл бұрын

Very nice.. thankyou so much... Perfect and very smoothly teach everything

@user-kt7zu8eg3r Жыл бұрын

Hello and Thank you, an excellent video done with lots of patience. Can you also inform us how to make a form for longitudinal data where we do multiple entries for one id. eg Measuring Height and Weight of children over a period of 2 years

@viralsanghaviassociatespcs9576 Жыл бұрын

Very easy way of explaining this complex sheet. thanks.

@khizarkhan3245 29 күн бұрын

MashaAllah What a wonderful lecture... i was searching for this type of lectures on youtube for almost 3 months, but today fortunately i got this one. Thank you so much. i have subscribed your channel just not.

@pakudimudi 7 ай бұрын

what a clear clarification.... i salute your effort

@chas194 Жыл бұрын

Super and easy teaching well-done boss

@sayedyaqub2326 Жыл бұрын

This is a very good way you explain all the procedures. Thanks a Lot.

@PowerExbyJitendra Жыл бұрын

Thanks 🌹

@HolyQuran0992 Жыл бұрын

Thank You so much very Easy without coding.. Really Professional

@YASIRTECHNO Жыл бұрын

Bhai aap jaise samjhaye Dil khush hogya Like to Banta hai aur shear bhi

@PowerExbyJitendra Жыл бұрын

Thank you very much my friend

@DimuthKularatne Жыл бұрын

Hi mr. Jitendra, your video is excellet. Very well explained and demonstrated. I applied these to my workbook and it came out very well..... thank you very much!!!! One question to ask... can't we protect only the database sheet from others and allow them the first page only? Please advise.... 🙏🙏

@ajaybind1305 7 ай бұрын

I think you can lock the 2nd sheet with a password and sheet 1 will be open for use to every one

@KEERTHIMKS2023 Жыл бұрын

I recommend my friends for see your videos for development of their excel skill to betterment. Thank you 🌹🌹🌹

@PowerExbyJitendra Жыл бұрын

Thank you so much

@yogeshlokhande1336 11 ай бұрын

You made my learning easy,thank you very much.

@salahfida 3 ай бұрын

Thank you Mr.Jitendra for such a detail video. Salah from Pakistan.

@PowerExbyJitendra 3 ай бұрын

Thanks a lot

@kirankumar7830 11 ай бұрын

Great teach brother... u made me first class person with the form creation for my work....

@PowerExbyJitendra 11 ай бұрын

Thanks a lot

@rushpubg3774 Жыл бұрын

bro i like the way how you explain all i just enjoy it and learn allot from this thank you so much

@idlesudhanshu Жыл бұрын

Really helpful sir... It worked for me 💯🖤

@praveenmethe4765 21 сағат бұрын

जबरदस्त सर... लय भारी

@user-hf2pt2tf1n 5 ай бұрын

Very very good representation Sir. Thanks a lot.

@chandankumarsingh335 6 ай бұрын

Wow Sir, you have great and more knowladge about EXCEL.

@PowerExbyJitendra 6 ай бұрын

Thanks a lot🙏🙏🙏

@mcdee367 2 жыл бұрын

i have learned new things today. thank you very much sir.

@PowerExbyJitendra 2 жыл бұрын

Welcome

@atiqullahbayat2919 Жыл бұрын

Hello Sir, First, I appreciate your efforts. Second, can we enter from different PC into a single database that you have made. I mean PC Data Entry From but a single database using Excel?? Thanks

@asokmithra2775 Жыл бұрын

Very nice and clear explanation.

@khinmaungtun4810 Ай бұрын

Thank you very much for your support Sir, it was very helpful to me in Accounting and other development feature by Excel though I don't understand your native language at all but It was very clear to learn from you.

@ahmedsuraj4619 Жыл бұрын

Thank you so much for this wonderful tutorial. You explained it in the best and easiest of form. Great one!

@PowerExbyJitendra Жыл бұрын

Thank you so much

@nagendraprathap9697 2 жыл бұрын

Excellent Guru ji 👌👌

@PowerExbyJitendra 2 жыл бұрын

Thanks Nagendra ji

@anilbagate3751 2 жыл бұрын

Very excellent and easy way to teach. We like it

@PowerExbyJitendra 2 жыл бұрын

Thanks

@emonthesoldier7327 9 ай бұрын

Such a great video. Learn many thing for many purposes. Thank you so much bro❤❤

@PowerExbyJitendra 9 ай бұрын

Thanks a lot

@jesieestrada5314 2 жыл бұрын

I love your video tutorial, can you please make a video about Purchase request/Order in excel without VBA (source of fund, date of purchase, description, unit, price, total amount) in English version. thanks

@allinoneyt2340 2 жыл бұрын

Checkout learn Solutions channel

@halimghole8089 14 күн бұрын

Very very very very nice I learned the whole things in single tutorial gooooood

@Explore_Nature_And_Wildlife Жыл бұрын

Wonderful. Excellent Way of explanation. Keep it up.

@PowerExbyJitendra Жыл бұрын

Thanks

@nepal0384 2 жыл бұрын

Wonderful. Thank you for incredible vedio😊

@PowerExbyJitendra 2 жыл бұрын

Thanks

@H-do8tr 2 жыл бұрын

How can I add number fields with multiple rows at once with condition (the total must be balanced)?

@albanoteles4924 2 жыл бұрын

Another a Great Work, Thanks for sharing

@PowerExbyJitendra 2 жыл бұрын

Thanks 🙏

@sanaullahkhansafi2713 8 ай бұрын

VERY GOOD TEACHING METHOD STEP BY STEP LEARNING PROCESS.

@PowerExbyJitendra 8 ай бұрын

Thanks

@BhaveshhPawar Жыл бұрын

Great video, but add information in it for error for invalid entry, for example incase pin number entered is less than or greater than 6 digits or as any space or aplhabate gets entered then it will show error message and same for contact, date, reg. no.

@malikshahraam Жыл бұрын

woder full brother you are very helpful person GOD BLESS YOU

@PowerExbyJitendra Жыл бұрын

Thanks

@shahjalaldewan2547 Жыл бұрын

Excellent explanation, thank you so much sir....

@PowerExbyJitendra Жыл бұрын

Thank you so much

@dannforall 5 ай бұрын

Fantastic, well explained. thank you Jitendra

@PowerExbyJitendra 5 ай бұрын

Thanks🙏

@richculture4160 Жыл бұрын

Excellent Video... Very nice work by PowerEx Jitendra.....🙏

@PowerExbyJitendra Жыл бұрын

Thanks

@user-om8ip7tv8w Жыл бұрын

Very nice.. thankyou so much... Excellent teaching

@nemalconsashutosh8665 Жыл бұрын

Hi, Thank you so much for the video, very well explained, made it simple but I am getting error message 1004. What to do. This is in two instances. One when entering info in database and second during clearing data. Please help.

@baharali7429 2 жыл бұрын

Another level great work thanks sir

@PowerExbyJitendra 2 жыл бұрын

Thanks

@cherrymehta4275 Жыл бұрын

Thank you very much. Can we create single entry form for multiple worksheets in a workbook?

@aminj4991 2 жыл бұрын

Excellent video, very helpful

@PowerExbyJitendra 2 жыл бұрын

Thanks

@grselectronicshobbytutoring 2 жыл бұрын

Excellent Bhai saab very usefull Dhanyvaad

@PowerExbyJitendra 2 жыл бұрын

Thanks 🙏

@ajaymane8776 Жыл бұрын

Very good video. Very informative.

@jiaulsk3744 Жыл бұрын

Informative video.... thanks a lot

@harshitmehta1372 2 жыл бұрын

Super.... explanation ❤️❤️

@PowerExbyJitendra 2 жыл бұрын

Thanks

@piyushsalunke5448 Жыл бұрын

Great Sir...Thank you so much

@shameedkhan8436 Ай бұрын

really great as plus perfect teaching

@sarabjeetsinghkailay7657 5 ай бұрын

informative video.. its really helpful.. Thanks for explaining in details

@PowerExbyJitendra 5 ай бұрын

Thanks

@merlyindaniel3146 Жыл бұрын

Sir can we add search box in the sheet to look for the particular student?

@kunacsc335 Жыл бұрын

very intersting sir ..good study 👍👍

@yeshuhijeevanhai08 Жыл бұрын

mast maza agaya sikhne me sir thank you

@PowerExbyJitendra Жыл бұрын

Thank you so much

@pravinpatilofficial Жыл бұрын

hi sir your explanation is very good and the form is very helpful to me, but let me know can I connect this form to my PHP website? please reply thanks

@3aslogisticspakistan538 Жыл бұрын

very easy to understand video Jitendra Jee, Maza aa gaya :)

@PowerExbyJitendra Жыл бұрын

Thank you so much

@kushalmukhoti Жыл бұрын

Wonderful video. I would like to point out one thing - the submit button remains active even when it is not clearly visible (looks like inactive) and transfers default data to the Database sheet when the button is clicked. I have tried to protect the 'Data Entry form' from accidental deletion by keeping the editable cells unprotected, but it is not working. Will you please advise me on how to protect the whole 'Data Entry Sheet' by leaving only the data entry fields and the two buttons ( Clear and Submit) operable?

@asokmithra2775 Жыл бұрын

Yes exactly the submit is active though looks like inactive. In that case if we click it takes all values as zero

@UmeshKumar-hp2jv Жыл бұрын

If master file is huge data then give code detail shows in automated data form

@feeder198 Жыл бұрын

any solution for this little problem?

@mehedihasanfaysal2518 Жыл бұрын

Amazing. From Bangladesh

@Sheik41 2 жыл бұрын

சிறப்பு ❤️👌🙏💪

@PowerExbyJitendra 2 жыл бұрын

Thanks

@kushalmukhoti Жыл бұрын

Mr. Sheikh Faisal, What does சிறப்பு (CiRappu) mean? I think it means 'extraordinary' form the lavish use of emojis.

@Som4you 5 ай бұрын

what an invention! Thanks Jitendra

@PowerExbyJitendra 4 ай бұрын

Thanks a lot

@MK_464 Жыл бұрын

bohot hi achha laga👌

@ravikantlakhotiya7012 11 ай бұрын

Thank you. This is really helpful. Just 1 query, how to disable the macro button if all mandatory cells are not updated. With current formulas and coding as shown, if all mandatory cells are not filled then macro button will not highlight but still it’s active. Pls help.

@vishmilasoyza9672 Жыл бұрын

Best video very useful & perfect video thank u very much & all the very best for your future works.

@PowerExbyJitendra Жыл бұрын

Thanks a lot

@stiertjuh Жыл бұрын

Great tutorial, even though i can't understand the language. One question you may be able to help me with: How can each new row entry appear on the first row below the headers instead of at the bottom?

@abroazhar Жыл бұрын

I am not Excel Master, ... but what i understood from the video... What He Did... @31:55... He selected: cell L1, then by Ctrl+Down Arrow (took you to the bottom of page)... then Ctrl+Left Arrow (took you very left of the page) then Ctrl+Up Arrow (take to you the Last Entered Record/or Filled Data...) {Ctrl+ Arrow Keys, Do not take to the Very End of the Page, but Instead, Last Cell Where Data is Entered.} {In this process, you tell the Cursor, where to start (cell L1), and where to stand in the last... which would be Last Entered Record,) but in end, you do "One Arrow Key Down" , which is is Empty Line. . Use Relative Reference button also might do something in this regard.

@idlesudhanshu Жыл бұрын

Sir I want to make a calculator tool where I put a price, it should automatically calculate the value after my specified taxes, discounts, charges etc If you have a video related to this please share the video or take this as a suggestion 🙏🙏