Advanced DATA ENTRY Software in Excel | Data Entry Form in Excel | Data Entry in Excel
Dosto jo excel user Microsoft excel me kuch nya seekhna or smart work karna pasand kartey hain ye video unke liye hai.
is video me maine btaya hai ki excel me fully automatic fully dynamic complete form validation ke sath data entry software kaise bana saktey hain. ye data entry software sach me bahut kmaal ka hai jisko maine bina vba ke bnaya hai aur ye data entry form bilkul online forms ki tarh hi kaam karta hai. agar aap excel user ho aur ye soch rhe ho ki excel me smart data entry kaise kare to ye video apke liye hai.
in this video you will learn How to Create Advanced & Fully Automatic DATA ENTRY Software in Excel | Data Entry Form in Excel | Data Entry in Excel in Hindi | User form in Excel
My Channels :
Deepak Techworld : https://bit.ly/3qFrbl5
Deepak EduWorld :https://bit.ly/3zWWtIS
Deepak Nehra : https://bit.ly/364SVGV
Download Training File : https://bit.ly/3xDKXAV
Chapters
00:00 intro
05:11 Creating User Form Without VBA
22:36 Applying Form Validation
41:05 Submit Form Data into Database
49:47 How To Save This Data Entry Software
50:16 Outro
#DataEntry
#DataEntryForm
#Userform
#Userform_in_Excel
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
/watch/0PbyNhBrkeOry
ADVANCED EXCEL ►
https://goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
https://goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
https://goo.gl/wAj1jh
MS WORD ►
https://goo.gl/B4TeSA
HTML5 & CSS3 ►
https://goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
https://goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
https://goo.gl/dFhg54
PHOTOSHOP ►
/watch/84VcwHkNK4mNc
Subscribe Deepak EduWorld ► /deepakeduworld� ��
Instagram ► https://www.instagram.com/deepakeduworld
Facebook page ► https://www.facebook.com/deepakeduworld� ��
LinkedIn ► https://www.linkedin.com/in/deepakeduworld
Facebook Group ► https://www.facebook.com/deepakedu� ��world
Thanks for watching
data entry software in excel,automated data entry software in excel,user form in excel,excel data entry form,data entry form in excel,data entry software,excel data entry,data entry from without vba,userform,data entry,excel online course,excel for analysts,deepak eduworld,data entry work,डाटा एंट्री,excel,Data entry kaise kare,userform in excel,data entry in excel
@mushtaqali2673 years agoDeepak beta u r genius well done keep it up. 36
@
@nirjharsinha153 years agoIn the era of digital teaching where the ed tech companies are looting students charging lot of money, people like you are a gem who is teaching us free of cost. thanks a lot sir. 12
@
@hafizmuhammadshahzad4989last yearJust related to topic awesome. This is my first video that i watched without any break. 1
@
@priyankabariha70383 years agoThank you sir aise hi margdarshan karte rahiyega maine aapki videos se bahut kuch sikha hai i' m very thankful to you. 1
@
@RakeshPandey-nw5ql2 years agoSir aap sikhane ka tarika bahut asan hai, video dekhkar dil khus ho jata hai, aap hi ka video dekhakar mai excel aur ms word chalna sikhe hai.
@
@kashifkhan49813 years agoThanks deepak. It is very useful and easy to implement in our day to day operations. Regards from karachi pakistan. 1
@
@kamranbk2 years agoAmazing. You are a star. Very big effort. Best knowledge. Thanks from leicester, uk. 1
@
@sahiltajanilast yearDeepak bhai thank you so much aap ishi tarah video banate rahe hume bohat kuch sikhne milta hai.
@
@binodprasad51353 years agoGreat. Please add print button from data base and also add standard fort for printing it will be great. 3
@
@aghanaveed98693 years agoSir g you are great you ate spreading the light of knowledge to everyone and aalo share your excell sheets without any charges. God bless you. 1
@
@AsifAli-wc7tj2 years agoThanks sir i was searching this types of video from a long time. 1
@
@Bhise.Entertainment3 years agoExcellent, great tutorial. Thanks for your efforts. 2
@
@risingstars-yf4hw4oc2g2 years agoBuhut barria, buhut acha se samjaya ha, well done. 1
@
@PushpenderFromIndia3 years agoIt is veryand educational for everyone, work place and also as a student. This is great work done by you. For your work dear. You rock jai hind jai bharat. 2
@
@shahzadjakhar2 years agoSuch a very nice and informative video. Thanks for sharing.
@
@kmanoj3923 years agoVery good information and guidelines thank you sir. 1
@
@hkusutar3 years agoHi, thanks a lot, it is very useful. I want if someone wants to do only using keyboard and blank cells are should be skipped, cursor should be stops on field' s only. 8
@
@yourdreams2972 years agoSir mene apki 3 se 4 videos watch ki hein a1 video hein apki smjhane ka tareeqa boht acha laga mujhy or sath hee me traing file dena bhi acha laga. i like your videos thank you sir thanks for again.
@
@MAhmad-dr6nz3 years agoExcellent job, well done deepak. No doubt you are a genius person. Keep it up thanks a lot! 1
@
@jatindersingharora15083 years agoVery useful for all. Well done deepak. Good wishes. 1
@
@sajan61363 years agoDeepak sir kasam se bol ra hu ap jesa youtuber avi tak nhi dekha. Ap mera leya great ho. Maine ap ka ms word ke sare video dekha or 1 week practice keya. ...Expand
@
@dnpyahoo2 years agoDeepak, you are incredible. What a brilliant video. Very simple language and nicely explained. Well done and thanks a lot.
@
@MohdArif-yb9pz3 years agoFirst time you tube pr acha teacher mila h.
@
@mohammedhashim79943 years agoHello, i am a regular viewer form kerala. I am appreciate ur efforts. Ur videos are very interested as well as very important. It is ver simple easy to understand. Expecting more useful video. From u. Best regards. Mohammad hashim. ...Expand1
@
@rajeshsharma-kk8qh3 years agoExcellence video, very useful video for excel. 2
@
@muhammadmubarak39213 years agoThanks sir, you made my clerical job easy. 1
@
@darshitchavda82643 years agoIt' s really amazing. Awesome sirjee. 1
@
@MrSuraj-lc2rh2 years agoEducative and awesome skill. Thanks for the tutoria; .
@
@Saif143SB3 years agoBuhat khoob, nice & easy way to teach. deepak bhai keep it up.
@
@mohitrawat3783 years agoGreat sir apki har video dekhta hu or samjhta bhi hu, thank u so much sir.
@
@ferozkhan-lz5qw3 years agoThanks yaar is class ke liye mai zarur practice karunga.
@
@saifuddinawan3 years agoVery nice. And simple. And it works as good. Well done.
@
@vikaskumar-wr3bz3 years agoReally sir, you have put a lot of hard work. Thank you so much for uploading the video. Please keep sharing such useful knowledge.
@
@aahilcombat53483 years agoYou are father of microsoft office briliant you are a genius bro. 2
@
@chopensaji2083 years agoGood effort. Pls make a video on normalization andof data in excel with line graph. 1
@
@rupeshmangulkar90233 years agoPlease share salary sheet format providing superb videos, thanks a lot for your help. 1
@
@syedmajid85973 years agoYour all lectures are veryand great. Your teaching pattern is very friendly. requesting you to please avoid word " hay na" or use this word minimum regards. 1
@
@psboyrizwan3 years agoHi, very useful info, can u plz give one demo for 2 points data entry database. Suppose for issue (full product) and receive (empty product) items under same invoice. I will be grateful to you. Thanks. 2
@
@AmekinEjal2 years agoReally very impressive knowledge you are sharing in youtube best of luck bro keep it up.
@
@avinashchoudhari53702 years agoGood video prepare video for automatic posting to different ledgers from single general journal ledger. 1
@
@surendrabhat97992 years agoIs it possible to add a file upload field as well just like we do in forms? Can a user be asked to upload files along with other fields in this custom designed form? 1
@
@Pankajkumar-yv5dr2 years agoReally appreciable job, what to do if we need it to repeat it daily wise and wish to have records every day on separate sheets.
@
@dreamparadise15203 years agoSir aap, waqai kamal kartay ho, thumbs up great: b. Regards. -nasir from pakistan. 1
@
@pradipsinha18452 years agoSar, i am really thanksful to you by watching your wonderful data entry form designing video. Sar i have a question that- if i want to put alphanumeric. ...Expand
@
@PawanKumar-lc3du3 years agoThanx sir ji, aap ne mere knowledge increase kar de.
@
@mangeshvasmatkar97832 years agoHello deepak, thank you for creating a nice video. Going forward i am wondering how we can show/hide rows and columns based on the selection criteria from. ...Expand
@
@addspanda36018 months agoDeepak great job. Can you develop a system to search any record based on any key word which can gather the relevant data from master sheet where data is stored.
@
@ahsangullg2 years agoHelo respected sir! I am from punjab, pakistan. App ke demos dekhaiy, bhout acha laga, or asani say samjh main bhi ayaay. Main ap say request karta hoon. ...Expand1
@
@namhanu2 years agoInformative video. Good work. One question: how can i make entry in different field with enter key without using mouse? Eg. Once you finished typing id="hidden16" name of field and upon pressing enter, the cursor should move to another field automatically. ...Expand
@
@radheymohan74653 years agoSir, please also make a advance data entry software for hsn summary-bill entry or total summary for gst return. Thanks.
@
@siddhkumar5580last yearSir aap daily new video late smart advance data entry. Very. 1
@
@anbiakhan83063 years agoAmazing sir one question can we make more databases like if there is a blank of class name in data entry and the boys are admitted in this class you made just on sheet. ...Expand
@
@usmanzaib13 years agoGreat, good job sir. I have a question, please provide a formula that allows us to repeat the form if we enter the same emp-id then the form should be awaiting your response. thank you and best regards. ...Expand7
@
@meantwo3 years agoIn ms word texts and numbers (e. G, fraction, integration etc ) in equation box become smaller when pressing space after the equation box and not matching the texts of the other lines. How to solve this problem? 1
@
@khanjunaid17073 years agoBhai yadi koi colum blank chod de to bhi submit button dikhai na de esa kuch krna tha na video to aap ne best banaya h. Great.
@
@spmsharaf2 years agoWill you please teach me how to generate admission no. Or employer id automatically while creating database. That is at first the id shouuld come as 001. ...Expand
@
@pkrishnaprasad663 years agoLiked your video. Very helpful can you share how to sort the data in the sheet as we keep entering data. Thankyou. 1
@
@abdulazeezn14473 years agoSir, kindly make a video to generate pdf report from this database by selecting each student. (single record & multiple record) 2
@
@krfalkentube2 years agoCan you make an automated data entry form for weekly money collection and loan return. It should consist of 20 people and data is added weekly. The columns. ...Expand
@
@samsamir39423 years agoThanks for the video, it is really awesome. I have a query, what will be the formula if wanted emp code asformat. 1
@
@alokbhunia69722 years agoCan a sheet be added by adding a value in another sheet.
@
@bhaskarkadam58703 years agoHi, thanks it is very useful. I want create video for grapes farming. Opening stock of medicine, use of medicine & closing stock of medicine & end of year its total expenditure of medicine.
@
@tarunsarkar749last yearHow to use trunc & alt formulas to separate time and date, please guide.
@
@tapangogoi23943 years agoYou cannot use references to other worksheets or workbooks for conditional formatting criterie.
@
@vedantkumarminecraftpro82263 years agoHi, i have seen many videos on excel. I am seeking your help on what will be the formula in column a to make sure that if the statement is matched then it calculates % from column c. ...Expand
@
@nityaneeds63743 years agoThis is really great. I was looking for something like this. But i am stuck with one major problem. My database sheet is overriding the entry everytime,. ...Expand3
@
@sureshpaul10553 years agoDear deepak, near to dob can we add auto age calculation also, if so what is the formula to use. 1
@
@techmd15562 years agoSir aapke videos bahit hee badhiya hote hai, sir ek request hai please aap ek baar school ke result system par ek video banaiye, bahot shukriya! 1
@
@HighVoltagel14last yearBut we cannot use the arrow button to go to next. This is the greatest disadvantages. Because we have to use mouse everytime we want to go to next, which slows down our work. 1
@
@hunny05082 years agoHello deepak, great video. In addition to this can you also tell that with the same form if i want data to move on 1 tab if i select male and if it is. ...Expand1
@
@sarangborse93143 years agoHello sir, your videos are very informative and i get a lot of knowledge with it. However, i was using this software, and after saving the form new entry wipes out the old entry in database sheet. Need your advice.
@
@mr.adhikari45952 years agoThanks sir. Great thanks and support from nepal.
@
@jogythomas19872 years agoI have tried this. I think there is an error! When an entry is given on the third time onwards it is not stored in a new row in the database sheet rather it replaces the second row leaving only two entries in the database. 1
@
@chetan10083 years agoFor almost same reasons used two different formulas 1. =if(isblank *cell add.*), @ 2. =if(*cell add.*="",""*"","") @ .....Expand1
Related videos for Advanced DATA ENTRY Software in Excel | Data Entry Form in Excel | Data Entry in Excel:
thanks a lot sir. 12
i like your videos
thank you sir thanks for again.
deepak bhai keep it up.
is class ke liye
mai zarur practice karunga.
providing superb videos, thanks a lot for your help. 1
requesting you to please avoid word " hay na" or use this word minimum
regards. 1
prepare video for automatic posting to different ledgers from single general journal ledger. 1
b. Regards.
-nasir from pakistan. 1
i am really thanksful to you by watching your wonderful data entry form designing video. Sar i have a question that- if i want to put alphanumeric . ...Expand
sir one question
can we make more databases
like if there is a blank of class name in data entry and the boys are admitted in this class you made just on sheet. ...Expand
thank you and best regards. ...Expand 7
video to aap ne best banaya h. Great.
(single record & multiple record) 2
what will be the formula in column a to make sure that if the statement is matched then it calculates % from column c. ...Expand
1. =if(isblank *cell add.*), @
2. =if(*cell add.*="",""*"","") @ .. ...Expand 1