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

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

[nep]

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

[ljubicar]

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

[HusseinKorish]

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

[keithduchnicki]

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

[krn]

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

[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 !

[leslienorden]

Your teaching is great and insightful! Thank You!

[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

[Kulbir]

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

[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 :):)

[robertlohman]

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

[wayneedmondson]

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!!

[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!

[allyndraper]

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

[aaboualy]

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

[lansanatolno]

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.

[georgeodhiambo]

I like the way you explain it. It comes very clearly

[renegadek]

Nice to learn about the “Form” feature.

[HiTechDiver]

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