Fully Automated data entry Software in Excel - Data Entry User Form - Data Entry In Excel
HTML-код
- Опубликовано: 19 июн 2024
- Fully Automated data entry Software in Excel - Data Entry User Form - Data Entry In Excel
Dosto bina VBA ke Microsoft Excel me accha sa Data Entry Software bnaya ja sakta hai ? ab aap soch rahe honge ki bina VBA ke Data Entry Form kaise ban sakta hai ?
is video me maine btaya hai ki kaise vba ke bina hi hum excel me accha sa fully automatic and fully dynamic data entry user form bna saktey hain. ye user form online forms ki tarh kaam karega aur form ko submit kartey hi entry automatic database me save ho jayengi. agar aap excel me definitely kuch nya seekhna chahate ho to ye video jarur dekhe
in this video you will learn how to create Fully Automatic and Fully Dynamic Data Entry Software without using VBA in Microsoft Excel.
Subscribe My New Channel DEEPAK TECHWORLD bit.ly/3qFrbl5
Download Template : bit.ly/3wKuABY
Chapters
00:00 intro
03:04 Creating Data Entry Form Without VBA
20:20 Connecting Form to Database
26:04 Outro
#DataEntryForm
#Userform
#Userform_in_Excel
#Data_Entry_in_Excel
#DataEntry
#Excel_Formulas_and_Functions
#Excel
#Excel_Tips_and_Tricks
#ExcelTips
#Excel_online_course
#deepakeduworld
#Microsoft_Excel
#How_To
#excelvba
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Thanks for watching
बहुत ही शानदार वीडियो बनाया है आपने बिना Excel VBA के भी इतनी शानदार वीडियो इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद हमें आशा है कि हमारे लिए इतने हेल्पफुल वीडियो और बनाएंगे
Sach bolai hai brother 💞
@@pkmahato15 5 either 🐸5555t 🍌5 yuruyuri we rt5 hn
Good
Jai shree Ram
Aisa teacher mile to koi bhi unpad na rahe. Nicely explain sir, hats off to you
I was like what a hell, but I was patient to watch fully automated functional excel without coding. It really worth it. Kudos guy, you tried. I just learn a powerful approach.
Very Good Bhai From Pakistan
Aesi hi videos bnatay rhen.👌🏿
I am running a Clinic and as i cant afford a fancy software for patients data, This video made my day! I kept following every second of your vdo and made my patients data entry basic software kind of stuff ! Thank You sir 🙏🏻👍
Great information and excellent work. As you mentioned in the beginning no one made such a wonderful video regarding excel form without coding in youtube. I was really searching such a work since long time. May God bless you to achieve the peak of success and increase your knowledge beyond the limits so that it will be great help to the needy in future too. Thanks again 🙏🙏🙏🙏
Aameen
bro you are really an honest teacher in this selfish world...so amazing...love from Pakistan
Me sirf data transfer trick k liye dekh raha tha. Mujhe ye pata tha ki vba se karoge aap. Par ye nhi pata tha ki record macro se hi kaam ho jayega. Bahot bahot dhanyawad
दीपक जी
🙏
निश्चय ही Excel बहुत से लोगों को आता होगा लेकिन पढ़ाया कैसे जाए या सिखाया कैसे जाय, ये भी एक कला है।
और आप इस कला के माहिर शिल्पकार हैं। बहुत-बहुत शुभकामनाएँ ।
Thanks vinay g 🙏
Bhut sunder Deepak ji...ur r amazing Teacher....Thanks for share with everyone 👍👍👍👍👍🙏🙏🙏
It was really a wonderful excel tutorial. Taught in such a friendly and easy way. Hats off to you brother.
ruclips.net/p/PLjOmfoUx9xOvFoscCpa6AIKl9R6IAL1kP
Just awesome 👌👌👌
Fantastic Creation, easy to understand and smooth learning.
Thank you so much.
Excellent video for learning a simple data entry form which can be used by any basic user!
Ya ALLAH har insan kamyab ho har insan ko sehat izat reham or karma farma meray Malik.
AMEEN YA RAB UL AALAMEEN
Ameen
@Fact Munde v7
Aameen summa aameen
Ur whatsapp me from kashmir
Although I am also fluent in Excel but this tutorial was "Zara Hat kay"🙏
Love from 🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰
Very useful and creative video and that too without "vba". I want to add photos of each person, i.e., like id cards in this form. (many of us would be waiting for the same).....pls make the video...we all would be very grateful....Keep up the good work. Best wishes.
Really loved the technique to insert a row instead of scrolling down to the end of the list.
I appreciate your talent. Pls. make the "Save Entry" button inactive when any data is blank. ie., make a condition to stop running the macro when the "Save Entry" button is fade in colour so that no blank data be saved.
Good question... Go to macro coding and use if statement for the cell value = 6 then
Else
End if
Hope you have under stood..
How we can save micro work in excel ? I try to save sheet but it’s didn’t work after saving .
@@punjab7158 CHOOSE MACRO ENABLED WORKBOOK IN "FILE TYPE" AND THEN SAVE
@@punjab7158 Save it as .xlsm file
thank you so much sir for this effort. i also appreciated your talent
Hello
formula kya hai bhai pata nahi chal raha hai comment me batana
@@GaneshKumar-do7lo
I have posted a video. Will be useful
ruclips.net/video/iSL19GiG_SU/видео.html
एकदम खूबसूरत डेटा एन्ट्री आपको सलाम 👌👌👌
Learned a lot from this video.... Thanks for making a true and helpful for learners
Excellent brother, one question, Can we picture with same type of working.?
Excellent video sir 🙏🙏 I would like to appriciate your knowledge.i learnt excel from your videos.lot of thx for sharing your great knowledge 👍👍
Your way of explaining is just awesome itna toh paise deke v nai sikh sakte jitna apki video deakh k sikh lete hai . thanks bro
Hey brother i m learning dashboard from your video kal thora practice kari thi aaj v karaungi .you are such a good teacher
Ya ALLAH har insan kamyab ho har insan ko Izat or Sehat ata farma.
Amin Bhai
Masha Allah ❤️
@Ganesh Kumar
I have posted a video. Will be useful
ruclips.net/video/iSL19GiG_SU/видео.html
Actually i need macro recording part but watched completely without forwarding. Tq very much
Thank you bro. Your way of teaching is simple & easy.
It's really good to know the use of excel like this ...this is very Inspirational video ..nd I like this 😊
SIR PLZ MAKE A VIDEO ON STONE CRUSHER SOFTWARE OF INVENTORY, BILL, LEADGER OF ALL PARTY
If I have three options instead of two,(Good,Batter,Best) then how can the formula be applied?
Not only this video, all your videos are just great.
Thanks and hats off to you for your efforts 👏
Bhai Ye Hui baat आपने मुझे बहुत अच्छा चीज सिखाया है उसके लिए धन्यवाद❤️
Lets begin the ttttttttooooopic...
9:55 developer tab
16:00 button
22:00 macro recorder
Thank You So Much For Sharing Your Excel Knowledge In A Very Simple And Easy To Understand Way.
Thank you Dipak... 🙏
I was searching for this type of technique in excel from long time...
Macro record kar ke to koi bhi kar lega, actual VBA code ke sath batao sir.
ye sab to pahle se pata tha.
Aap kuch naya bta do please maam
App k mohelay main jo dukandar hay osay kehna ker k dikhaey, very funny. Miss this one for those people who don't know programming. Otherwise there are dozen of languages better than VBA. appreciate the simple working rather than criticism.
Mam ye Excel hai is video me VBA ki coading nahi sikhayi ja rahi hai...
@@vishaljaiswal203
pata hona chahiye, VBA excel ke liye he hai, koi alag nhi hai.
@@mussawarhussain waise to aap rikshe wale se monday ya tuesday ki spelling bhi puchoge to nhi bata payega. koi bhi ka mera matlab tha jo log is field me hai.
That way you showed is awesome... Its easy to implement and pretty helpful... Thanks man...
Very good video. Thanks for the same. I always thought these things are very difficult. But you have made it so simple. 💙💙💙💙👌👌👌👌👍👍👍👍👍👍
Bhaii bhot kaam ayi aapki video haal hi me Maine ye class li thi aur mujhe kuchh khaas smjh me nii ayii thii but aapki ye video dekh ke merii sari confusion door ho gyii so thank u so much
I did not understand a word from you except Ctrl C Ctrol V etc, but I have learnt this staff from your.video Thank you so much.
Hello deepak,your videos are really helpfull , i really appreciate your efforts.i made a invoicing system in google sheets , now i will incorporate this too into my invoicing system to convert the data automatically to a ledger.
Thanks
This is amazing brother your are legend man of MS Office in Excel. ❤️❤️❤️🎉🎉🎉💐💐💐
Great respected teacher, You are master of Excel Sir, keep upload such type of important lectures of Excel, waiting for your next lecture, accept my love 💕 from Pakistan.
कमाल की वा वीडियो बनाई है आपने, आप सदा सेहतमंद रहें और सुखी रहें।
बहुत ही शानदार वीडियो बनाया है आपने बिना Excel VBA के भी इतनी शानदार वीडियो इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद हमें आशा है कि हमारे लिए इतने हेल्पफुल वीडियो और बनाएंगे Thank you.... 🙏🙏🙏🙏
3
Best work done from your side. I Appreciate your hardwork thats free to us. Love from pakistan
Sir ye to super se uper hai, bas ek chij ki dikkat hai agar next entry neche vale row mein add hoti toh kamaal ho jata, apka ye vedio dekh kar boat kuchh sikha jo pehle socha hi nai tha. Like formatting ka itna axhha use, fir vo micro ka use kamaal kar diya sir.
Unfortunately teacher lots of respect from Pakistan.. You did great job
आप व्हिडीओ बहोत अच्छी तरिके से और आसान भाषा में जानकारी देते है
बहोत बहोत शुक्रिया...
Thanks sir aapke knowledge se mujhe bahot fayda ho raha hai🙏🏻🙏🏻💐
22:00
Your Way Of Teaching Is Amazing
धन्यवाद आपका ये वीडियो से बहुत सारा सीखने को मिला ।
Bahut achha knowledge Diya h Apne. Salute sir
Bahut aasan ho gya mera kaam Deepak sir 👍 thank you sir
बहुत ही शानदार वीडियो बनाया है ,इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद !!
You're the BEST!! Hat's off to your expertise!! Just superb!!
Dum hai sir.... Jo VB se nahi seekh ppaya.. Aaj iss se sikha
Sir, today I have seen your this video... Really Appreciated.... Excellent sir... It helps me so much.... Your way of explaining and teaching is very good..... Thanks for this video sir✌✌✌✌✌✌✌
Bahut hi sandar video bnai h aapne 🙏🙏🙏🙏thanku 🙏🙏🙏
Really very much smart and Amazing Really sir i appreciate your struggle nice complimentable work
It’s really amazing Brother. Thanks a lot.🥰💕 I found you today and I tried it. 💕
Very Well Deepak I appriciate your effort & work you have done areally really good job & put a deep knoweldge about Ms excel in our minds. Keep it up
Bahut achha video banaya Deepak Bhai, Thank you!
Amazing video sir g aj tak main ne eisa data base form nahi deka never ...love u sir good luck and good wishes
Thank you .... Too much learn from this video.
Boss Great video 👍👍👍 kuch naya sikhne ko mila...
Bahut acha laga, detail me bataya apne..thnk you..
Deepak sir bahut achha he mera kaam aasan ho gya bahut
bahut hi jordar jankari di aapne
aaisa to ms office coaching wale nahi batate
Superb . Apne bahut acha kaam Kiya h .mujhe ye vedio bahut achi lagi .mujhe bahut help hui
Zabardast..just the one I required...thank you brother..dhanyawaad...this is ekdum magic
Complicated but very useful.
Thanks for sharing.
Deepak sahib ap boht achi trah define kerty hn mujhy ap sey bhot kuch sekhny ko mila hy allah ap ko khush rekhy
Masha Allah... Bhai Jan Kamal kar dia.. bohut Dino Kay bad RUclips say kuch acha seeknay ko Mila... Etna Khushi huwa kah kardia like our subscribe.. Inayat Ur Rahman from Pakistan
Very helpful useful and easily understandable video thank you! great job sir👍
Sir dil se bhot mahant ki aapne or bhot shandarr or easy way may samjhaya hai thank you so much 💜
MashaALLAH. Rab e Kareem Ap k ilam men aur izafa Kare. Ameen
MashaALLAH Zabardast.
Ap ne Kam asan kar deya h
Brother.... It was really work.... And very impressed with your teaching method and get great knowledge from you
Dear Deepak very Help full for my office work thanks full to you.
form Islamabad PK.
Thank you so much for your all videos may you live long
Thank you so much for ur video
It's really very useful
I like this channel
From Sri Lanka
what a nice acheivement bhai
i learn these all from you
thank u very much
very good explanation by you
Dear Deepak ! Great work indeed. Really very helpful for all. Love from Pakistan 🇵🇰
मुझे इस तरहि फॉर्म चाहिए था, धन्यवाद दिपकजी
I am don't know Hindi brother but I am completely understand what u teached. Thank you
😊
Very nice... To the point... Excellent way to describe the process. 👍🏼
Great Job Deepak 👍
Respect 🌹from Pakistan 🇵🇰
You made my day, very informative vlog.
It was really a wonderful excel tutorial. Taught in such a friendly and easy way. Hats off to you brother.Pakistan Zindabad☑
Enjoyed New Cell Data Entry Metric Is Very Fantastic
Thank you so much sir for this wonderful session.
Most useful vba lesson with excellent narration
great guidance of uses Excel. thanks bro
आप बहुत अच्छा समझते हैं
Hello Sir aap bhut Achaa video banate ho bilkul achha se samjhne me aa jata hai
thank you sir love from nepal your sharing of knowledge such great
Hi Deepak ji. Very clever use of functions and features in Excel. Superb !
Kudos to your Efforts and Jugad
Jio Hazare Saal
No doubt...Apka video ekdm Solid💥