Duration 50:23

Advanced DATA ENTRY Software in Excel | Data Entry Form in Excel | Data Entry in Excel

944 954 watched
0
23.1 K
Published 8 Jul 2021

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

Category

Show more

Comments - 835
  • @
    @mushtaqali2673 years ago Deepak beta u r genius well done keep it up. 36
  • @
    @nirjharsinha153 years ago In 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
  • @
    @hafizmuhammadshahzad498911 months ago Just related to topic awesome. This is my first video that i watched without any break. 1
  • @
    @priyankabariha70383 years ago Thank 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 ago Sir 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 ago Thanks deepak. It is very useful and easy to implement in our day to day operations. Regards from karachi pakistan. 1
  • @
    @kamranbk2 years ago Amazing. You are a star. Very big effort. Best knowledge. Thanks from leicester, uk. 1
  • @
    @sahiltajanilast year Deepak bhai thank you so much aap ishi tarah video banate rahe hume bohat kuch sikhne milta hai.
  • @
    @binodprasad51353 years ago Great. Please add print button from data base and also add standard fort for printing it will be great. 3
  • @
    @aghanaveed98693 years ago Sir 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 ago Thanks sir i was searching this types of video from a long time. 1
  • @
    @Bhise.Entertainment3 years ago Excellent, great tutorial. Thanks for your efforts. 2
  • @
    @risingstars-yf4hw4oc2g2 years ago Buhut barria, buhut acha se samjaya ha, well done. 1
  • @
    @PushpenderFromIndia3 years ago It 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 ago Such a very nice and informative video. Thanks for sharing.
  • @
    @kmanoj3923 years ago Very good information and guidelines thank you sir. 1
  • @
    @hkusutar3 years ago Hi, 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 ago Sir 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 ago Excellent job, well done deepak. No doubt you are a genius person. Keep it up thanks a lot! 1
  • @
    @jatindersingharora15083 years ago Very useful for all. Well done deepak. Good wishes. 1
  • @
    @sajan61363 years ago Deepak 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 ago Deepak, you are incredible. What a brilliant video. Very simple language and nicely explained. Well done and thanks a lot.
  • @
    @MohdArif-yb9pz3 years ago First time you tube pr acha teacher mila h.
  • @
    @mohammedhashim79943 years ago Hello, 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. ...Expand 1
  • @
    @rajeshsharma-kk8qh3 years ago Excellence video, very useful video for excel. 2
  • @
    @muhammadmubarak39213 years ago Thanks sir, you made my clerical job easy. 1
  • @
    @darshitchavda82643 years ago It' s really amazing. Awesome sirjee. 1
  • @
    @MrSuraj-lc2rh2 years ago Educative and awesome skill. Thanks for the tutoria; .
  • @
    @Saif143SB3 years ago Buhat khoob, nice & easy way to teach.
    deepak bhai keep it up.
  • @
    @mohitrawat3783 years ago Great sir apki har video dekhta hu or samjhta bhi hu, thank u so much sir.
  • @
    @ferozkhan-lz5qw3 years ago Thanks yaar
    is class ke liye
    mai zarur practice karunga.
  • @
    @saifuddinawan3 years ago Very nice. And simple. And it works as good. Well done.
  • @
    @vikaskumar-wr3bz3 years ago Really 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 ago You are father of microsoft office briliant you are a genius bro. 2
  • @
    @chopensaji2083 years ago Good effort. Pls make a video on normalization andof data in excel with line graph. 1
  • @
    @rupeshmangulkar90233 years ago Please share salary sheet format
    providing superb videos, thanks a lot for your help.
    1
  • @
    @syedmajid85973 years ago Your 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 ago Hi, 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 ago Really very impressive knowledge you are sharing in youtube best of luck bro keep it up.
  • @
    @avinashchoudhari53702 years ago Good video
    prepare video for automatic posting to different ledgers from single general journal ledger.
    1
  • @
    @surendrabhat97992 years ago Is 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 ago Really 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 ago Sir aap, waqai kamal kartay ho, thumbs up great:
    b. Regards.
    -nasir from pakistan.
    1
  • @
    @pradipsinha18452 years ago Sar,
    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 ago Thanx sir ji, aap ne mere knowledge increase kar de.
  • @
    @mangeshvasmatkar97832 years ago Hello 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 ago Deepak 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 ago Helo 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 . ...Expand 1
  • @
    @namhanu2 years ago Informative 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 ago Sir, please also make a advance data entry software for hsn summary-bill entry or total summary for gst return. Thanks.
  • @
    @siddhkumar5580last year Sir aap daily new video late smart advance data entry. Very. 1
  • @
    @anbiakhan83063 years ago Amazing
    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 ago Great, 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
    .
    ...Expand
    7
  • @
    @meantwo3 years ago In 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 ago Bhai 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 ago Will 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 ago Liked your video. Very helpful can you share how to sort the data in the sheet as we keep entering data. Thankyou. 1
  • @
    @abdulazeezn14473 years ago Sir, kindly make a video to generate pdf report from this database by selecting each student.
    (single record & multiple record)
    2
  • @
    @krfalkentube2 years ago Can 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 ago Thanks for the video, it is really awesome. I have a query, what will be the formula if wanted emp code asformat. 1
  • @
    @alokbhunia69722 years ago Can a sheet be added by adding a value in another sheet.
  • @
    @bhaskarkadam58703 years ago Hi, 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 year How to use trunc & alt formulas to separate time and date, please guide.
  • @
    @tapangogoi23943 years ago You cannot use references to other worksheets or workbooks for conditional formatting criterie.
  • @
    @vedantkumarminecraftpro82263 years ago Hi, 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 ago This 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, . ...Expand 3
  • @
    @sureshpaul10553 years ago Dear deepak, near to dob can we add auto age calculation also, if so what is the formula to use. 1
  • @
    @techmd15562 years ago Sir 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 year But 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 ago Hello 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 . ...Expand 1
  • @
    @sarangborse93143 years ago Hello 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 ago Thanks sir. Great thanks and support from nepal.
  • @
    @jogythomas19872 years ago I 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 ago For almost same reasons used two different formulas
    1. =if(isblank *cell add.*), @
    2. =if(*cell add.*="",""*"","") @ ..
    ...Expand
    1