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

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

[@excelisfun]

If you like this video, I have many free classes at KZbin on my home page here: free at KZbin. Here it is: www.youtube.com/@excelisfun Here is the Excel Basics free video class: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

[@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 😂😂😂

[@mebcool]

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 !

[@ljubicar1987]

Wow, it is amazing what excel hides underneath. Thanks for the interesting video!

[@excelisfun]

Yes, so many hidden treasures!!!!

[@leslienorden8483]

Your teaching is great and insightful! Thank You!

[@HusseinKorish]

Each new video in this channel adds up new things to learn .. thanks Mike

[@excelisfun]

You are welcome for each new videos!!!!

[@krn14242]

Thanks Mike. Never knew about disabling the auto hyper text as you type feature. Thanks for the lesson.

[@excelisfun]

You are welcome for the lesson, kevin !!

[@Geralt9213]

I can't stress enough how helpful this is. Thanks man

[@excelisfun]

Glad it helps, Levi!!!!

[@keithduchnicki349]

Thanks for uncovering those things we used years ago. I'm going to go to the ribbon to add other icons for sure.

[@excelisfun]

Yes!!! It is a great icon button to have, Keith : )

[@allyndraper8640]

Nice clip. I learned what I was researching and learned a couple of things on the side. Well with the 8 minute watch Thanks!

[@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]

You are an excellent teacher!...thank you so much!..Greetings from Vancouver, Canada.

[@CAKimberlyLewis]

THANK YOU for the Turn Off for Whole File tip at 3:04 I have been on a search for this! Great video!

[@darrylmorgan]

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]

You are Form Boom Welcome for this great little feature trick : )

[@wayneedmondson1065]

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]

You are welcome and thanks for the killer keyboard : )

[@KDSuam]

This is very helpful! Thank you so much for sharing.

[@kerronduncan6697]

Thanks Mike! This is useful and fun!

[@excelisfun]

Glad it is useful and fun, Kerron!!!

[@maysounabdallah1545]

Thank you Mike for these wonderful videos.

[@excelisfun]

You are welcome!!!

[@robertlohman8947]

Way cool Mike. I was always using the keyboard shortcut ALT + D + O to get that form. The ribbon icon seems cooler !

[@excelisfun]

LOVE that old keyboard!!!!! Back in the days when form was in the menu : )

[@m.raedallulu4166]

Thank you so much !

[@Julieoolums]

Tx for mentioning ALT+D+O...so much easier!

[@solarworxnorthernrivers-ya5705]

So helpful. Thank you so much. Love you work!

[@excelisfun]

Glad to help!

[@johnborg5419]

Thanks Mike. I use that frequently. Very Convenient. : )

[@excelisfun]

Cool. You already use it : )

[@HiTechDiver]

Thanks ; good stuff...and no foreign accent.

[@aaboualy03]

Thank you, really appreciate your efforts , that was simply awesome

[@excelisfun]

You are welcome!

[@lansanatolno4840]

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]

You are welcome, Lansana!!!

[@empiresoundstt]

I appreciate your time and effort. Thanks for helping a newbie

[@excelisfun]

You are welcome!

[@Luciano_mp]

Form very useful. Thanks Mike!

[@excelisfun]

You are welcome, Luiano!!!

[@sinayokoabdoulaye6165]

Very helpful. Thank you Mike

[@excelisfun]

Glad it is helpful, Sinayoko!!!

[@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?

[@akhtarmohammadsajid1205]

Thanks so.much from Afghanistan.

[@joeypanganiban]

Amazing! I also would like to see a data entry in other sheet where a none professional can easily enter the data

[@td-jf2lp]

Thanks a lot for your support and contributions.

[@roberte8564]

Very Helpful, thank you. How would I go about printing a single record to something like a label?

[@ismailhossain2324]

I like your system. Thanks a lot!

[@excelisfun]

You are welcome a lot!!!

[@nadermounir8228]

Great Mike. I Always learn something new from u 👌👌😀

[@excelisfun]

Glad you can learn some new cool tips, Nader!!!

[@simfinso858]

Amazing Excel Teacher of my life.Who Teaches Very Basic to Super Advanced level of Excel with Same patience.

[@excelisfun]

Yes, the same patience for basic to advanced. It is all fun : ) : ) : ) : )

[@donaldwilcox2467]

That is great, you explained very well. I can do that. Well done.

[@excelisfun]

You are welcome!

[@carlfogarthy6508]

Very nice, thanks! is it possible to create multiple tables and make them to be in relation? (= relational database)

[@niavras]

Thank you very much once again Mike!

[@excelisfun]

You are welcome, kostas!!

[@edward1412]

Thanks dude. I really appreciate it.

[@aklakhorchannel...8706]

Thanks sir You are right infarction So thanks I am from India Important Video sir 🙏🙏🙏🙏🙏

[@remotelylucy]

best easiest tutorial.This helped me so much thanks a ton

[@excelisfun]

You are welcome!

[@renegadek9]

Nice to learn about the “Form” feature.

[@excelisfun]

: )

[@nonoobott8602]

Very useful. Easy explanation. Thanks for sharing

[@excelisfun]

You are welcome for the share, Nono : )

[@wamu8851]

Just...excellent video. Thanks so much!

[@excelisfun]

You are welcome! I am glad that you liked the EXCELlent video ; )

[@khanabdussabur8604]

Totally Awesome Mike. Thanks a lot.

[@excelisfun]

You are welcome a lot, Khan!!!!

[@SyedMuzammilMahasanShahi]

Wow. That's amazing. Thanks Mike.

[@excelisfun]

You are welcome, Syed MM : ) : ) : ) : )

[@antomac]

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!

[@jerrymiles7804]

Outstanding, very useful dear Mike!, Hi from Limón, Costa Rica.

[@excelisfun]

Glad you like it, Limon!!!

[@aqeel12342]

Hi Sir... I really love the way you teach 💖 Really appreciated 👍

[@excelisfun]

You are really welcome, SYED!!!!!

[@lihyinlee4548]

I did it I watch this video 3 times and I know how to do it is best man :)

[@excelisfun]

: )

[@delorissmith8248]

Excellent video. Thanks so much for uploading it.

[@excelisfun]

You are welcome!

[@MyFakeBrand]

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]

I have a video in my Excel Basics class and in my upcoming 365 class about the amazing QAT : ) Old School Form is fun!

[@rx6588]

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?

[@allenmatte5870]

With the Excel Data Entry Form, Can it be modified to be a lot larger and Can a macro be added to click one time on the worksheet to start the Excel Default Data Entry Form? Thanks Great Video and work!!

[@TerranceHinton-dk6xt]

This is awesome! Thanks so much. I do have a question. I completed all the steps and love how everything is working, but I have some dropdown lists on several of my columns. They don't show up in the form. Is there a way to fix that?

[@ppanigrahi]

Thanks Mike. That was really of great help. Can we make the form permanent and appear when we open the excel file and hide the worksheets?

[@excelisfun]

Not that I know of, at least not without writing VBA code.

[@khimseily]

Thank you, just well understand through your Video 💜🙏🙏

[@excelisfun]

You are welcome, Khim!!!!

[@MizZPottyCat]

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 😂❤

[@pedjanbgd4221]

Mike, I love your videos! 💪

[@excelisfun]

Glad you love em, Predrag!!!!

[@zarinamercado8517]

That was so cool.. thnx for this video.. now I think I can create my own data base for my students..

[@excelisfun]

Glad it helps : )

[@rashmidhanda4370]

Wow this is mind blowing Mike ...Superb 👍👍

[@excelisfun]

Glad you like it, Rashmi!!!

[@evansjohnarek2271]

Thanks men for coming in handy, am entering data now. You you are such smart, i did not know.

[@excelisfun]

Glad this helps : ) : )

[@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..

[@MalinaC]

ANd the best thing is... you don't need VBA! :) Mike, thanks for sharing!

[@excelisfun]

Yes, no VBA : )

[@pierremenard9245]

really amazing. very instructive

[@excelisfun]

Glad it helps, Pierre!!!!

[@abuqeisimran9676]

It's a useful video, thanks a ton Sir.

[@excelisfun]

You are welcome!!!

[@DIGITAL_COOKING]

NEW FOR ME! AND VERY EFFICIENT,I THINK WE CAN'T REACH THE END OF EXCEL LEARNING 🙂👍

[@excelisfun]

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]

@@excelisfun yes indeed :)

[@excelisfun]

@@DIGITAL_COOKING : ) : ) : )

[@alexmoreno7275]

The patriarch of excel, thanks mucho mucho.

[@excelisfun]

You are welcome!

[@houssamayoubi8715]

Another cool video, greetings from Under Down

[@excelisfun]

Glad it is cool for you : ) : )

[@rattlefate378]

you are a great guy nicely explained

[@excelisfun]

Glad you like the video!

[@daviddarling15]

Love your style! Do you have a search function so I can see if you have a video on a particular topic? I need help formatting drop down lists. I need the font size in the drop down list to be larger - matching the font size of the surrounding cells. Thanks!

[@excelisfun]

I am sorry, I do not have a video on that topic.

[@komninoskamamis1098]

Thank you very much. God bless you

[@excelisfun]

You are welcome!

[@kingmasternice1975]

Better than my entyr teachers of my university

[@excelisfun]

Glad this helps!

[@ADfamily81]

your incredibly talented!!

[@excelisfun]

I am glad that I can help you to learn Excel : )

[@abduljalil-fz2bx]

Outstanding!!

[@williamfulford4744]

Very helpful information.

[@excelisfun]

Glad it was helpful, William!!!

[@ragyhanyfikry]

Hi. Do you have a workaround for forms not including more than 32 columns? Thanks

[@sevakj0b]

Thanks Mike, is new option for me

[@excelisfun]

You are welcome, Sevag!

[@deborahmccown4135]

this is amazing, how do you enter more than one piece of equipment each client has?

[@sasavienne]

Thanks Mike. Best regards. Salim

[@excelisfun]

You are welcome, K D Salim : )

[@TaxMentors]

Thank you sir. Kindly share more videos on power query and power bi.

[@excelisfun]

I have 100s of videos about Power Query and a number of good videos about Power BI: kzbin.info/aero/PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT and kzbin.info/aero/PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1 and many more too.

[@KS-xb1xr]

Where else can this database be stored for future references? Can we upload it to backend? Like making a template and upload or pull the records

[@saidkamolxonn]

Awesome! But, what if I want to enter data in this form using drop down list? Is it possible?

[@JennRankine]

Thank you! Thank you! Thank you!!!

[@aziserak4743]

thank you, well explained

[@excelisfun]

You are welcome!

[@lisamccray6481]

What good would the internet be without people like you?🤔😥🙃🧐😈😇🙂😎

[@excelisfun]

I am glad I can help with good stuff on the internet, Lisa : )

[@euh4367]

Thanks so much.. you have such a nice teaching style... just a query.. why do we need form? when we can directly type the database details one-by-one directly in excel sheet why we would need a form to enter details?

[@user-gp1ni9ln8r]

thanks so much. this was very helpful.

[@excelisfun]

Glad it helps : )

[@manuhernz4431]

Thanks so much. It helped me tons.

[@mohans760]

Wonderful mike , cool tricks

[@excelisfun]

Glad it is wonderful for you, MOHAN S!!!

[@helent3217]

U're a genius!

[@excelisfun]

Thanks, Elena : )

[@johnborg5419]

Thank Mike :) :)

[@bridgets.6464]

Thank you so much! :)

[@omahawarrior4837]

Excellent presentation 👏

[@excelisfun]

Glad you like it!

[@technorickconstructionserv9385]

Thanks. It's really help me.

[@hazemali382]

professor of Excel ♥

[@excelisfun]

Thanks, Hazem : ) : ) : ) : )

[@user-tx5ed2bp7p]

Its very helpful!!!

[@nirmalkumar-fh3yg]

Wonderful tricks to enter a data in table without using VBA codes...💥💥💥💥

[@excelisfun]

Glad you like that non-VBA trick : ) : )

[@nirmalkumar-fh3yg]

Yes of course. Non-Vba really easy to do...💥💥💥💥

[@chrism9037]

Good video Mike!

[@excelisfun]

Thanks, Teammate Chris : )

[@tubakzgn1102]

it is super helpful thanks