Create Excel Database and Data Entry Form. Excel Magic Trick 1690.

  Рет қаралды 822,396

ExcelIsFun

ExcelIsFun

Күн бұрын

Download Excel File: excelisfun.net/files/EMT1690....
Learn how to create an Excel Database. Add Data Entry Form. Add button to toolbar to open form. Technically, we are not creating an actual database, but in Excel when you want to store data, you use the Excel Table feature.
Topics:
1. (00:00) Introduction.
2. (00:19) Step 1: Field Names with Format.
3. (00:44) Step 2: First Record with correct Number Formatting
4. (03:21) Step 3: Convert to an Excel Table
5. (04:38) Step 4: Add Form button to Quick Access Toolbar.
6. (06:14) Step 4, part 2: Use Form to add records.
7. (07:25) Summary, Closing and Video Links

Пікірлер: 439
@excelisfun
@excelisfun 5 ай бұрын
If you like this video, I have many free classes at KZfaq on my home page here: free at KZfaq. Here it is: www.youtube.com/@excelisfun Here is the Excel Basics free video class: kzfaq.info/sun/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
@nep401
@nep401 Жыл бұрын
"Now technically in Excel this is not a database but for us it's a table where we can store data" I swear that is so funny and smart 😂😂😂
@ljubicar1987
@ljubicar1987 3 жыл бұрын
Wow, it is amazing what excel hides underneath. Thanks for the interesting video!
@excelisfun
@excelisfun 3 жыл бұрын
Yes, so many hidden treasures!!!!
@keithduchnicki349
@keithduchnicki349 3 жыл бұрын
Thanks for uncovering those things we used years ago. I'm going to go to the ribbon to add other icons for sure.
@excelisfun
@excelisfun 3 жыл бұрын
Yes!!! It is a great icon button to have, Keith : )
@Geralt9213
@Geralt9213 3 жыл бұрын
I can't stress enough how helpful this is. Thanks man
@excelisfun
@excelisfun 3 жыл бұрын
Glad it helps, Levi!!!!
@HusseinKorish
@HusseinKorish 3 жыл бұрын
Each new video in this channel adds up new things to learn .. thanks Mike
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome for each new videos!!!!
@krn14242
@krn14242 3 жыл бұрын
Thanks Mike. Never knew about disabling the auto hyper text as you type feature. Thanks for the lesson.
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome for the lesson, kevin !!
@mebcool
@mebcool 5 ай бұрын
Hey, thanks man. This isn't "exactly" what I was looking for, but great video work. Nice audio and clear instruction... great job dude. Saving this to my hard drive for future reference. Cheers !
@leslienorden8483
@leslienorden8483 3 ай бұрын
Your teaching is great and insightful! Thank You!
@darrylmorgan
@darrylmorgan 3 жыл бұрын
Boom!Didn't Realise You Could Add A Data Form Button.Just Added It To My Quick Access What A Great Little Feature...Thank You Mike :):)
@excelisfun
@excelisfun 3 жыл бұрын
You are Form Boom Welcome for this great little feature trick : )
@kerronduncan6697
@kerronduncan6697 3 жыл бұрын
Thanks Mike! This is useful and fun!
@excelisfun
@excelisfun 3 жыл бұрын
Glad it is useful and fun, Kerron!!!
@maenetha
@maenetha Жыл бұрын
U freakin Rock You didn’t ask for a subscribe , like or comment till the end. You know your shit and rolled through it great. Not a lot of bs just helpful ,applicable, to the point information that gets it done. Thank you God bless u for the no bs. Love it love you
@henrbenbrown
@henrbenbrown 17 күн бұрын
You are an excellent teacher!...thank you so much!..Greetings from Vancouver, Canada.
@MrLoccis
@MrLoccis 2 жыл бұрын
Very nice tutorial
@excelisfun
@excelisfun 2 жыл бұрын
Glad it helps, Wlison!
@sinayokoabdoulaye6165
@sinayokoabdoulaye6165 3 жыл бұрын
Very helpful. Thank you Mike
@excelisfun
@excelisfun 3 жыл бұрын
Glad it is helpful, Sinayoko!!!
@allyndraper8640
@allyndraper8640 8 ай бұрын
Nice clip. I learned what I was researching and learned a couple of things on the side. Well with the 8 minute watch Thanks!
@CAKimberlyLewis
@CAKimberlyLewis 8 ай бұрын
THANK YOU for the Turn Off for Whole File tip at 3:04 I have been on a search for this! Great video!
@rishavraj7798
@rishavraj7798 2 жыл бұрын
Wonderful videos 😎
@excelisfun
@excelisfun 2 жыл бұрын
Glad you like the videos, Rishav!!!
@akhtarmohammadsajid1205
@akhtarmohammadsajid1205 Жыл бұрын
Thanks so.much from Afghanistan.
@td-jf2lp
@td-jf2lp Жыл бұрын
Thanks a lot for your support and contributions.
@robertlohman8947
@robertlohman8947 3 жыл бұрын
Way cool Mike. I was always using the keyboard shortcut ALT + D + O to get that form. The ribbon icon seems cooler !
@excelisfun
@excelisfun 3 жыл бұрын
LOVE that old keyboard!!!!! Back in the days when form was in the menu : )
@m.raedallulu4166
@m.raedallulu4166 2 жыл бұрын
Thank you so much !
@Julieoolums
@Julieoolums 2 жыл бұрын
Tx for mentioning ALT+D+O...so much easier!
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Hi MIke. Great tips.. as always. For those who like keyboard shortcuts, note that you can open the built in data entry form with the key sequence: ALT, d, o. Of course the pointer must be in the table for this to work. Thanks for the Monday database and form filling fun :)) Thumbs up!!
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome and thanks for the killer keyboard : )
@solarworxnorthernrivers-ya5705
@solarworxnorthernrivers-ya5705 2 жыл бұрын
So helpful. Thank you so much. Love you work!
@excelisfun
@excelisfun 2 жыл бұрын
Glad to help!
@nadermounir8228
@nadermounir8228 3 жыл бұрын
Great Mike. I Always learn something new from u 👌👌😀
@excelisfun
@excelisfun 3 жыл бұрын
Glad you can learn some new cool tips, Nader!!!
@ismailhossain2324
@ismailhossain2324 2 жыл бұрын
I like your system. Thanks a lot!
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome a lot!!!
@johnborg5419
@johnborg5419 3 жыл бұрын
Thanks Mike. I use that frequently. Very Convenient. : )
@excelisfun
@excelisfun 3 жыл бұрын
Cool. You already use it : )
@georgeodhiambo7664
@georgeodhiambo7664 2 жыл бұрын
I like the way you explain it. It comes very clearly
@excelisfun
@excelisfun 2 жыл бұрын
Glad the clarity helps, George!!!!
@aaboualy03
@aaboualy03 3 жыл бұрын
Thank you, really appreciate your efforts , that was simply awesome
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome!
@khanabdussabur8604
@khanabdussabur8604 3 жыл бұрын
Totally Awesome Mike. Thanks a lot.
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome a lot, Khan!!!!
@lansanatolno4840
@lansanatolno4840 2 жыл бұрын
Thank you very much for this wonderful tutorial. It was so great for me and I like to have more from you. I really appreciate enjoyed it a lot.
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome, Lansana!!!
@maysounabdallah1545
@maysounabdallah1545 2 жыл бұрын
Thank you Mike for these wonderful videos.
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome!!!
@kingmasternice1975
@kingmasternice1975 Жыл бұрын
Better than my entyr teachers of my university
@excelisfun
@excelisfun Жыл бұрын
Glad this helps!
@sasavienne
@sasavienne 3 жыл бұрын
Thanks Mike. Best regards. Salim
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome, K D Salim : )
@user-gp1ni9ln8r
@user-gp1ni9ln8r Жыл бұрын
thanks so much. this was very helpful.
@excelisfun
@excelisfun Жыл бұрын
Glad it helps : )
@Luciano_mp
@Luciano_mp 3 жыл бұрын
Form very useful. Thanks Mike!
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome, Luiano!!!
@rashmidhanda4370
@rashmidhanda4370 3 жыл бұрын
Wow this is mind blowing Mike ...Superb 👍👍
@excelisfun
@excelisfun 3 жыл бұрын
Glad you like it, Rashmi!!!
@jerrymiles7804
@jerrymiles7804 2 жыл бұрын
Outstanding, very useful dear Mike!, Hi from Limón, Costa Rica.
@excelisfun
@excelisfun 2 жыл бұрын
Glad you like it, Limon!!!
@aqeel12342
@aqeel12342 3 жыл бұрын
Hi Sir... I really love the way you teach 💖 Really appreciated 👍
@excelisfun
@excelisfun 3 жыл бұрын
You are really welcome, SYED!!!!!
@vivoumontreal6934
@vivoumontreal6934 2 жыл бұрын
Number one, thanks
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome, vivou!!!!
@renegadek9
@renegadek9 3 жыл бұрын
Nice to learn about the “Form” feature.
@excelisfun
@excelisfun 3 жыл бұрын
: )
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 3 жыл бұрын
Wow. That's amazing. Thanks Mike.
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome, Syed MM : ) : ) : ) : )
@LyndaAlsford
@LyndaAlsford Жыл бұрын
Really helpful. Thanks
@excelisfun
@excelisfun Жыл бұрын
Glad it was helpful!
@jonaskalonga4621
@jonaskalonga4621 2 жыл бұрын
great work sir
@excelisfun
@excelisfun 2 жыл бұрын
Glad you like it : )
@KDSuam
@KDSuam 11 ай бұрын
This is very helpful! Thank you so much for sharing.
@HiTechDiver
@HiTechDiver Ай бұрын
Thanks ; good stuff...and no foreign accent.
@simfinso858
@simfinso858 3 жыл бұрын
Amazing Excel Teacher of my life.Who Teaches Very Basic to Super Advanced level of Excel with Same patience.
@excelisfun
@excelisfun 3 жыл бұрын
Yes, the same patience for basic to advanced. It is all fun : ) : ) : ) : )
@niavras
@niavras 3 жыл бұрын
Thank you very much once again Mike!
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome, kostas!!
@lihyinlee4548
@lihyinlee4548 2 жыл бұрын
I did it I watch this video 3 times and I know how to do it is best man :)
@excelisfun
@excelisfun 2 жыл бұрын
: )
@lisamccray6481
@lisamccray6481 3 жыл бұрын
What good would the internet be without people like you?🤔😥🙃🧐😈😇🙂😎
@excelisfun
@excelisfun 3 жыл бұрын
I am glad I can help with good stuff on the internet, Lisa : )
@williamfulford4744
@williamfulford4744 2 жыл бұрын
Very helpful information.
@excelisfun
@excelisfun 2 жыл бұрын
Glad it was helpful, William!!!
@pgsrinivas5211
@pgsrinivas5211 2 жыл бұрын
Excellent!
@excelisfun
@excelisfun 2 жыл бұрын
Glad you like it, PG!!!!
@donaldwilcox2467
@donaldwilcox2467 2 жыл бұрын
That is great, you explained very well. I can do that. Well done.
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome!
@munayusuf9938
@munayusuf9938 6 ай бұрын
Thanks I got benefit
@ADfamily81
@ADfamily81 2 жыл бұрын
your incredibly talented!!
@excelisfun
@excelisfun 2 жыл бұрын
I am glad that I can help you to learn Excel : )
@nonoobott8602
@nonoobott8602 3 жыл бұрын
Very useful. Easy explanation. Thanks for sharing
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome for the share, Nono : )
@evansjohnarek2271
@evansjohnarek2271 2 жыл бұрын
Thanks men for coming in handy, am entering data now. You you are such smart, i did not know.
@excelisfun
@excelisfun 2 жыл бұрын
Glad this helps : ) : )
@francisvalenti2541
@francisvalenti2541 2 жыл бұрын
Bravo!!!!!!!
@excelisfun
@excelisfun 2 жыл бұрын
Glad this helps!
@rattlefate378
@rattlefate378 Жыл бұрын
you are a great guy nicely explained
@excelisfun
@excelisfun Жыл бұрын
Glad you like the video!
@remotelylucy
@remotelylucy 2 жыл бұрын
best easiest tutorial.This helped me so much thanks a ton
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome!
@pedjanbgd4221
@pedjanbgd4221 3 жыл бұрын
Mike, I love your videos! 💪
@excelisfun
@excelisfun 3 жыл бұрын
Glad you love em, Predrag!!!!
@ilyaskhan-td3db
@ilyaskhan-td3db 2 жыл бұрын
Wow great work
@edward1412
@edward1412 3 жыл бұрын
Thanks dude. I really appreciate it.
@JennRankine
@JennRankine Жыл бұрын
Thank you! Thank you! Thank you!!!
@delorissmith8248
@delorissmith8248 3 жыл бұрын
Excellent video. Thanks so much for uploading it.
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome!
@joeypanganiban
@joeypanganiban 10 ай бұрын
Amazing! I also would like to see a data entry in other sheet where a none professional can easily enter the data
@chrism9037
@chrism9037 3 жыл бұрын
Good video Mike!
@excelisfun
@excelisfun 3 жыл бұрын
Thanks, Teammate Chris : )
@abduljalil-fz2bx
@abduljalil-fz2bx 3 жыл бұрын
Outstanding!!
@abuqeisimran9676
@abuqeisimran9676 10 ай бұрын
It's a useful video, thanks a ton Sir.
@excelisfun
@excelisfun 10 ай бұрын
You are welcome!!!
@technorickconstructionserv9385
@technorickconstructionserv9385 Жыл бұрын
Thanks. It's really help me.
@imtiazkhan8942
@imtiazkhan8942 11 ай бұрын
VERY HELPFULL
@jonljacobi
@jonljacobi 2 жыл бұрын
I was having a ton of trouble with this before watching this video
@excelisfun
@excelisfun 2 жыл бұрын
Glad this helps!
@johnborg5419
@johnborg5419 3 жыл бұрын
Thank Mike :) :)
@JadDCPH
@JadDCPH Жыл бұрын
This is so cool! do you have a video where we can select a data from dropdown button but it's like this as well..
@shaheen677
@shaheen677 3 жыл бұрын
Superb !!
@excelisfun
@excelisfun 3 жыл бұрын
Glad it is superb for you, Shaheen !!!
@MyFakeBrand
@MyFakeBrand 3 жыл бұрын
Thanks for re-teaching an old dog an old trick. Used to use the form years ago but forgot about it after moving on to to doing other things in Excel. I’ll have to put this one back in the tool kit. Pretty handy at times. Have you done a video on “must have” buttons to put on the quick access toolbar? I bet that would be a hit.
@excelisfun
@excelisfun 3 жыл бұрын
I have a video in my Excel Basics class and in my upcoming 365 class about the amazing QAT : ) Old School Form is fun!
@zarinamercado8517
@zarinamercado8517 2 жыл бұрын
That was so cool.. thnx for this video.. now I think I can create my own data base for my students..
@excelisfun
@excelisfun 2 жыл бұрын
Glad it helps : )
@wamu8851
@wamu8851 2 жыл бұрын
Just...excellent video. Thanks so much!
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome! I am glad that you liked the EXCELlent video ; )
@bridgets.6464
@bridgets.6464 Жыл бұрын
Thank you so much! :)
@aklakhorchannel...8706
@aklakhorchannel...8706 2 жыл бұрын
Thanks sir You are right infarction So thanks I am from India Important Video sir 🙏🙏🙏🙏🙏
@MizZPottyCat
@MizZPottyCat 6 ай бұрын
Thank you so much, the way you explained everything was amazing .. But I couldn’t help feeling it’s was Nicolas Cage behind the scenes 😂❤
@user-tx5ed2bp7p
@user-tx5ed2bp7p Жыл бұрын
Its very helpful!!!
@DIGITAL_COOKING
@DIGITAL_COOKING 3 жыл бұрын
NEW FOR ME! AND VERY EFFICIENT,I THINK WE CAN'T REACH THE END OF EXCEL LEARNING 🙂👍
@excelisfun
@excelisfun 3 жыл бұрын
You are correct. There is no end. This is a good thing : ) No end to the fun and to how it can help us to solve problems : ) : ) : ) : )
@DIGITAL_COOKING
@DIGITAL_COOKING 3 жыл бұрын
@@excelisfun yes indeed :)
@excelisfun
@excelisfun 3 жыл бұрын
@@DIGITAL_COOKING : ) : ) : )
@rentals5740
@rentals5740 Жыл бұрын
This is great and tells me how to get information into the table. Do you have a video for getting info from the table and putting it into a payroll stub?
@khimseily
@khimseily 2 жыл бұрын
Thank you, just well understand through your Video 💜🙏🙏
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome, Khim!!!!
@roberte8564
@roberte8564 Жыл бұрын
Very Helpful, thank you. How would I go about printing a single record to something like a label?
@pierremenard9245
@pierremenard9245 3 жыл бұрын
really amazing. very instructive
@excelisfun
@excelisfun 3 жыл бұрын
Glad it helps, Pierre!!!!
@houssamayoubi8715
@houssamayoubi8715 3 жыл бұрын
Another cool video, greetings from Under Down
@excelisfun
@excelisfun 3 жыл бұрын
Glad it is cool for you : ) : )
@m.raedallulu4166
@m.raedallulu4166 2 жыл бұрын
Excel programmers team should really develop a form technique like that in MS Access.
@wofdigy
@wofdigy 3 жыл бұрын
Great Video, thanks
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome, wofdigy!!!!
@bewketmelese4329
@bewketmelese4329 2 жыл бұрын
Great job thank you
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome, Bewket!!!!
@johnporcella2375
@johnporcella2375 2 жыл бұрын
Very neat!
@excelisfun
@excelisfun 2 жыл бұрын
Glad you like it, John!!!
@antomac
@antomac 8 ай бұрын
Excellent tutorial Sir... Good work. My number one tip with Excel quick access ribbon...is to move the "Undo" icon away from the "Save" icon...I could never understand the Muppetology Reason why Microsoft placed them a heart beat twitch of a finger apart from each other with ensuing potential for disaster!
@diegoalcala8830
@diegoalcala8830 2 жыл бұрын
lots a help god speed sir
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome, diego!!!!
@manuhernz4431
@manuhernz4431 Жыл бұрын
Thanks so much. It helped me tons.
@jennysqueo3704
@jennysqueo3704 19 күн бұрын
It’s very useful
@tubakzgn1102
@tubakzgn1102 5 ай бұрын
it is super helpful thanks
@rx6588
@rx6588 2 жыл бұрын
I like that video it was very clear thanks But i got a question i got some repetitive data that i have to insert is there a way to get it to pop up when i type the start of it?
@MalinaC
@MalinaC 3 жыл бұрын
ANd the best thing is... you don't need VBA! :) Mike, thanks for sharing!
@excelisfun
@excelisfun 3 жыл бұрын
Yes, no VBA : )
@josephinebarker4470
@josephinebarker4470 2 жыл бұрын
Great. Thank you
@excelisfun
@excelisfun 2 жыл бұрын
You are welcome!
@alexmoreno7275
@alexmoreno7275 3 жыл бұрын
The patriarch of excel, thanks mucho mucho.
@excelisfun
@excelisfun 3 жыл бұрын
You are welcome!
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 309 М.
How To Create A Fillable Form With A Submit Button In Excel
29:20
Melissa Compton
Рет қаралды 123 М.
We Got Expelled From Scholl After This...
00:10
Jojo Sim
Рет қаралды 62 МЛН
How to Create a Database in Excel
7:23
ExcelDemy
Рет қаралды 19 М.
Creating Easy Data Entry Forms in Excel
9:52
Technology for Teachers and Students
Рет қаралды 2,9 МЛН
SUPER EASY Excel Data Entry Form (NO VBA)
6:22
Leila Gharani
Рет қаралды 2 МЛН
How to Easily Create an Data Entry Form in Excel | No VBA
22:30
Jopa Excel
Рет қаралды 11 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Simple Excel Data Entry Work Form Tutorial
10:49
Kevin Stratvert
Рет қаралды 114 М.
How to make Macro enabled Form in Excel Sheet?
17:49
TheDataLabs
Рет қаралды 1,7 МЛН
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
Make a Search Bar in Excel to Find Anything!
10:35
Kenji Explains
Рет қаралды 312 М.
We Got Expelled From Scholl After This...
00:10
Jojo Sim
Рет қаралды 62 МЛН