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

If you like this video, I have many free classes at RU-vid on my home page here: free at RU-vid. Here it is: www.youtube.com/@excelisfun Here is the Excel Basics free video class: ru-vid.com/group/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

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

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

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

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 !

Your teaching is great and insightful! Thank You!

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

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

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

Thanks a lot for your support and contributions.

Totally Awesome Mike. Thanks a lot.

Thanks so.much from Afghanistan.

Thanks Mike. Best regards. Salim

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

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!

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

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

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

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?

Excellent video and very nearly solves the problem I'm having. However, the exposure to the quick access bar capability leaves me with much more to learn. Getting back to the data entry form, a problem arises if you've set up data validation requirements in the original database/table. The data validation only occurs when you try to enter the transaction into the table, and then it only tells you it doesn't meet the validation requirement. Entering directly into the table, the table will provide you with a dropdown menu of options matching the data you're trying to enter. In a financial transaction table, fields like "accounts", "Categories" & "Payee/Payors" would most likely require data validation. The only way the form would work is if you typed out the exact spelling of the account, category and/or Payee/Payor. One spelling typo and you would have to do your own spellcheck in the form. manually. Not productive.

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

Excellent video. Thanks so much for uploading it.

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

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

Just...excellent video. Thanks so much!

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

Wow. That's amazing. Thanks Mike.

Can you do this for assigning a membership number to someone joining a club?

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

The patriarch of excel, thanks mucho mucho.

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?

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

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

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

Wow great work

thanks for this short rich videos!

Excellent!

Very neat!

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?

thank you! this is a great help for me.

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

Very useful. Easy explanation. Thanks for sharing

I think that you should open an online class for beginners.

Another cool video, greetings from Under Down

Thanks a lot for this one!!!

I’m looking to pull data back out using a form but user friendly and so need the form to stay visible so users can see it easily.

Great job thank you

Thanks. It's really help me.

lots a help god speed sir

I am indian sir well explained Thank u sir

Is there a way we can have the entry form permanently present on the spreadsheet? Can we do some data validation on some of the fields?

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

Its very helpful!!!

Awesome !!!!

Wonderful mike , cool tricks

really amazing. very instructive

amazing...Thanks

it is super helpful thanks

Thank Mike :) :)

U're a genius!

Thanks Mike, is new option for me

Thanks sir

THANKS YOU VERY MUCH

Awesome

When using an entry form in a spreadsheet that sums some of the columns the previous column is altered when the new record is added. Does using an entry form not work with formulas.

very nice

Good workk sir

I smashed the like button instead

Can dropdown lists be incorporated into the form to minimize typing repetitive data? I naively thought I could create a drop down in the database table but it doesn't show up in the form.

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

My first field is by last name and I’m wondering if it’s possible to have the records be in alphabetical order or if a new record will be just sent to the bottom always

good sir

Thanks

"Form" Should be standard features in " Insert " Menu.

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

Hi, I am a regular viewer of your channel, I am stuck in a situation where I have to extract some tabular data from the email to build my own records. I resorted to excel built in form like the one in this video but I am getting the message "TOO MANY FIELDS IN THE DATA FORM". My Data spans from Column A to AS (total 45 columns).

super!!

Super

Thank you.

Nice

GREAT, thank u

hello i have just one question i can`t find the form in my excel file

Is there a toggle where the quick filter drop down arrow does not cover the Feild Name in the table? Mine usually covers the last part and I can't see all of the field name of my tables.

THAT BEAUTIFUL FEATURE IS NOWHERE TO BE FOUND ON MY EXCEL very latest VERSION of Microsoft 16.68 - I am not finding this anywhere 😭😭😭😭😭😭😭😭

hi could you help me on how to add a dropdown selection list to the data entry form? because i need to select from 20 items from the list instead of typing them to avoid typo, is it possible? thanks :)

Wow....

I want to create a Form the Data has 45 columns the prompt I receive is too Many files Is there a limit to the columns? Is 10 the Maximum.?

Thank you!

Great

What is the limit of "Fields" one can use like this ??? I have read 27 but I have never tested it. 2nd Question could the Table automatically stay sorted by a predefined column say "Name" ???

I assume this is still only available to windows and not Mac?

How about sorting the names in alphabetical order

Thank you

Hi mike, is there a way to create a drop down option in any of these fields to pick from a previously created LIST ?

Great tutorial, where do I find FORM in Excel 365 on a Mac? Many thanks

Very useful! Thank you for all that I have learned from you. I use Excel 365 in Norwegian, and can not find the form button. Do you know if it can be translated into something else?

Hello Mike, can excel use drop down menus with information to chose from in the froms?

Hi love the video is it possible to link this table to an automatically generated payslip

This is not available for excel 2021 for mac :(

when I click the form button, nothing happens at all???