المدة الزمنية 50:23

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

بواسطة Deepak EduWorld

944 961 مشاهدة

23.1 K

تم نشره في 2021/07/08

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

الفئة

عرض المزيد

تعليقات - 835

@

@mushtaqali267منذ 3 سنوات Deepak beta u r genius well done keep it up 36
@

@nirjharsinha15منذ 3 سنوات 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
@

@hafizmuhammadshahzad4989العام الماضي Just related to topic awesome. This is my first video that i watched without any break. 1
@

@narbdaمنذ 3 سنوات इस तरह का वीडियो सिर्फ एक जीनियस ही बना सकता है। वास्तव में बहुत ही ज्यादा नॉलेज है sir आपको। बहुत बहुत धन्यवाद 1
@

@priyankabariha7038منذ 3 سنوات Thank you sir aise hi Margdarshan karte rahiyega maine aapki videos se bahut kuch sikha hai I'm very thankful to you 1
@

@RakeshPandey-nw5qlمنذ 2 سنوات 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
@

@kashifkhan4981منذ 3 سنوات Thanks Deepak. It is very useful and easy to implement in our day to day operations. Regards from Karachi Pakistan 1
@

@kamranbkمنذ 2 سنوات Amazing. you are a Star. Very big effort. Best knowledge. Thanks from Leicester, UK 1
@

@sahiltajaniالعام الماضي deepak bhai thank you so much aap Ishi tarah video banate rahe hume bohat kuch sikhne milta hai
@

@binodprasad5135منذ 3 سنوات Great. Please add print button from data base and also add standard Fort for printing it will be great. 3
@

@aghanaveed9869منذ 3 سنوات 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-wc7tjمنذ 2 سنوات Thanks sir I was searching this types of video from a long time. 1
@

@Bhise.Entertainmentمنذ 3 سنوات Excellent, great tutorial. Thanks for your efforts 2
@

@risingstars-yf4hw4oc2gمنذ 2 سنوات Buhut barria, buhut acha se samjaya ha, well done 1
@

@PushpenderFromIndiaمنذ 3 سنوات It is very beautiful,practical and educational for everyone ,work place and also as a student .this is great work done by you . congratulations for your work dear . You Rock ❤️ Jai Hind Jai Bharat 2
@

@shahzadjakharمنذ 2 سنوات Such a very nice and informative video. Thanks for sharing.
@

@kmanoj392منذ 3 سنوات Very good information and guidelines thank you sir 1
@

@hkusutarمنذ 3 سنوات 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
@

@yourdreams297منذ 2 سنوات 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-dr6nzمنذ 3 سنوات Excellent job, well done Deepak. No doubt you are a genius person. keep it up thanks a lot! 1
@

@jatindersingharora1508منذ 3 سنوات Very useful for all.Well done Deepak. Good wishes 1
@

@sajan6136منذ 3 سنوات 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 id="hidden6" class="buttons"> or aaj muje ms word completely aagaya hai. Main ms word main kuch v kar sakta hu. But avi muje excel sikna chata hu plz ap se ek request hain plz jase ap ne ms word ki sare tool ki video cover keya same excel ki v kardej plz. ms word or excel ki thoda same tool hain tu thoda tu knowledge hain. But excel main or v different tool hai uske bare main knowledge nhi hain . SO plz excel k all tool k v video chya.OR jo v mera comment se Sahamata(Agree) hain plz comment ko like kardena plz. (Lots of love from Nepal) ....وسعت
@

@dnpyahooمنذ 2 سنوات Deepak, You are incredible. What a brilliant video. Very simple language and nicely explained. Well done and Thanks a lot.
@

@MohdArif-yb9pzمنذ 3 سنوات First time you tube pr acha teacher mila h
@

@mohammedhashim7994منذ 3 سنوات 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 presentation..and id="hidden7" class="buttons"> easy to understand. expecting more useful video.. from U. Best regards.. Mohammad Hashim ....وسعت 1
@

@rajeshsharma-kk8qhمنذ 3 سنوات Excellence Video, Very Useful Video for Excel 2
@

@muhammadmubarak3921منذ 3 سنوات Thanks sir, you made my clerical job easy. 1
@

@darshitchavda8264منذ 3 سنوات It's really amazing . awesome sirjee. 1
@

@MrSuraj-lc2rhمنذ 2 سنوات educative and awesome skill. thanks for the tutoria;
@

@Saif143SBمنذ 3 سنوات Buhat Khoob, Nice & Easy way to Teach.!
Deepak Bhai Keep it up.
@

@mohitrawat378منذ 3 سنوات Great sir apki har video dekhta hu or samjhta bhi hu,,, thank u so much sir
@

@ferozkhan-lz5qwمنذ 3 سنوات Thanks yaar
Is class ke liye
Mai zarur practice karunga
@

@saifuddinawanمنذ 3 سنوات very nice. and simple. and it works as good. well done.
@

@vikaskumar-wr3bzمنذ 3 سنوات Really sir, you have put a lot of hard work. Thank you so much for uploading the video. Please keep sharing such useful knowledge.
@

@aahilcombat5348منذ 3 سنوات You are father of Microsoft Office briliant you are a genius bro 2
@

@chopensaji208منذ 3 سنوات Good effort. Pls make a video on normalization and standardization of data in excel with line graph. 1
@

@MukeshKumar-jq4vjمنذ 3 سنوات सर जी नमस्कार आपका ये वीडियो बहुत अच्छा लगा
ऐसे ही स्कूल की फीस रिसिप्ट का वीडियो बनाना रिसिप्ट प्रिंट कर सके ऑटोमेटिक डाटा दूसरी सीट में ट्रांसफर हो सके 1
@

@rupeshmangulkar9023منذ 3 سنوات please share salary sheet format
Providing superb videos, Thanks a lot for your help 1
@

@syedmajid8597منذ 3 سنوات Your all Lectures are very Good,Excellent, and great. your Teaching pattern is very friendly.
Requesting you to please avoid word " HAY NA" or use this word minimum
Regards. 1
@

@psboyrizwanمنذ 3 سنوات 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
@

@muhabbath100منذ 3 سنوات advanced.thx bro .keep uploading 1
@

@AmekinEjalمنذ 2 سنوات Really very impressive knowledge you are sharing in YouTube Best of Luck bro Keep it up
@

@SUNILKUMAR-vw3qsالعام الماضي Very nice.. Superb.simple and sweet..well explained.thanks 1
@

@avinashchoudhari5370منذ 2 سنوات Good video
Prepare video for automatic posting to different ledgers from single general journal ledger 1
@

@surendrabhat9799منذ 2 سنوات 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-yv5drمنذ 2 سنوات 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
@

@dreamparadise1520منذ 3 سنوات Sir Aap, Waqai kamal kartay ho, thumbs up great :)
B. Regards.
-NasiR From Pakistan. 1
@

@pradipsinha1845منذ 2 سنوات 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 id="hidden12" class="buttons"> data within a cell then how can I define the data validation rule for the specific cell. I am in waiting for you instruction. ....وسعت
@

@PawanKumar-lc3duمنذ 3 سنوات Thanx Sir ji, Aap ne mere knowledge increase kar de.
@

@mangeshvasmatkar9783منذ 2 سنوات 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 id="hidden13" class="buttons"> one of cell and the button we made using micro. Please help to understand the same. ....وسعت
@

@addspanda3601قبل 8 أشهر 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. ❤
@

@ahsangullgمنذ 2 سنوات 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 id="hidden15" class="buttons"> keh Ap Exel main, School Records(Student Admissions, Fee slips, Defaulter Students, Results, etc) Aik hee file main Demo dain. Umeed hai keh Ap meri humble request par ghour karay gay! ....وسعت 1
@

@namhanuمنذ 2 سنوات 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" class="buttons"> name of field and upon pressing enter, the cursor should move to another field automatically. ....وسعت
@

@radheymohan7465منذ 3 سنوات Sir, please also make a advance data entry software for Hsn summary-bill entry or total summary for gst return. Thanks
@

@siddhkumar5580العام الماضي Sir aap daily new video late smart advance data entry. Very 1
@

@anbiakhan8306منذ 3 سنوات 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 id="hidden17" class="buttons"> and they are sent to their own classes database sheet.
In this class you made just on sheet ....وسعت
@

@usmanzaib1منذ 3 سنوات 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 id="hidden18" class="buttons"> filled automatically with all the details related to the specific Emp-ID.
Awaiting your response.
Thank you and best regards. ....وسعت 7
@

@meantwoمنذ 3 سنوات 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
@

@khanjunaid1707منذ 3 سنوات 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
@

@spmsharafمنذ 2 سنوات 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 id="hidden20" class="buttons"> by default and after entering and submitting the first data, next No. should display for entering the next data. ....وسعت
@

@pkrishnaprasad66منذ 3 سنوات Liked your video. Very helpful can you share how to sort the data in the sheet as we keep entering data. Thankyou 1
@

@abdulazeezn1447منذ 3 سنوات Sir, kindly make a video to generate pdf report from this database by selecting each student.
(single record & multiple record) 2
@

@krfalkentubeمنذ 2 سنوات 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 id="hidden21" class="buttons"> needed are "Date, name, present/absent, weekly amount, loan return amt, etc. And in database i need some columns additional. That is adding weekly amt and loan amt to a column named total. Also need another column which substract loan return amt from a fixed amt (to get rest loaned amt). This whole thing needs to repeat in next week and loan balance need to substract from previous week loan rest amt ....وسعت
@

@samsamir3942منذ 3 سنوات Thanks for the video, it is really awesome. I have a query , what will be the formula if wanted Emp code as 2405678/04/2021 format 1
@

@alokbhunia6972منذ 2 سنوات Can a sheet be added by adding a value in another sheet
@

@bhaskarkadam5870منذ 3 سنوات 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.
@

@tarunsarkar749العام الماضي how to use TRUNC & ALT formulas to separate Time and date, Please guide
@

@tapangogoi2394منذ 3 سنوات You cannot use references to other worksheets or workbooks for conditional formatting criterie
@

@vedantkumarminecraftpro8226منذ 3 سنوات 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 id="hidden23" class="buttons"> written in column B (in another column),
then it calculates % from column C. ....وسعت
@

@nityaneeds6374منذ 3 سنوات 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, id="hidden24" class="buttons"> though I followed the exact steps mentioned in the macro creation. Can you help? ....وسعت 3
@

@sureshpaul1055منذ 3 سنوات Dear Deepak, Near to DOB can we add auto age calculation also, if so what is the formula to use. 1
@

@techmd1556منذ 2 سنوات 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
@

@HighVoltagel14العام الماضي 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
@

@hunny0508منذ 2 سنوات 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 id="hidden26" class="buttons"> Female then the data should move to another tab. My Logic is I want separate Tab for Male Data and Separate for Female Data. Thanks in advance. ....وسعت 1
@

@sarangborse9314منذ 3 سنوات 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.adhikari4595منذ 2 سنوات Thanks Sir. great thanks and support from Nepal
@

@jogythomas1987منذ 2 سنوات 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
@

@chetan1008منذ 3 سنوات For almost same reasons used two different formulas
1. =if(isblank *cell add.*), @
2. =if(*cell add.*="",""*"","") @ ....وسعت 1