If you like this video, I have many free classes at CZcams on my home page here: free at CZcams. Here it is: www.youtube.com/@excelisfun Here is the Excel Basics free video class: czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
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
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.
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!
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 !
I have one. Its free at CZcams. Here it is: czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html If you go to my excelisfun CZcams home page you will see the many free classes that I offer. Here is intro video on home page: www.youtube.com/@excelisfun
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!!
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?
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?
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?
If you like this video, I have many free classes at CZcams on my home page here: free at CZcams. Here it is: www.youtube.com/@excelisfun
Here is the Excel Basics free video class: czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
best tutories
"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 for uncovering those things we used years ago. I'm going to go to the ribbon to add other icons for sure.
Yes!!! It is a great icon button to have, Keith : )
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 :):)
You are Form Boom Welcome for this great little feature trick : )
I can't stress enough how helpful this is. Thanks man
Glad it helps, Levi!!!!
I did it I watch this video 3 times and I know how to do it is best man :)
: )
Wow, it is amazing what excel hides underneath. Thanks for the interesting video!
Yes, so many hidden treasures!!!!
Each new video in this channel adds up new things to learn .. thanks Mike
You are welcome for each new videos!!!!
Amazing Excel Teacher of my life.Who Teaches Very Basic to Super Advanced level of Excel with Same patience.
Yes, the same patience for basic to advanced. It is all fun : ) : ) : ) : )
I appreciate your time and effort. Thanks for helping a newbie
You are welcome!
NEW FOR ME! AND VERY EFFICIENT,I THINK WE CAN'T REACH THE END OF EXCEL LEARNING 🙂👍
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 : ) : ) : ) : )
@@excelisfun yes indeed :)
@@DIGITAL_COOKING : ) : ) : )
Very helpful. Thank you Mike
Glad it is helpful, Sinayoko!!!
You are an excellent teacher!...thank you so much!..Greetings from Vancouver, Canada.
Better than my entyr teachers of my university
Glad this helps!
Hi Sir... I really love the way you teach 💖
Really appreciated 👍
You are really welcome, SYED!!!!!
What good would the internet be without people like you?🤔😥🙃🧐😈😇🙂😎
I am glad I can help with good stuff on the internet, Lisa : )
Your teaching is great and insightful! Thank You!
I like the way you explain it. It comes very clearly
Glad the clarity helps, George!!!!
Thanks so.much from Afghanistan.
Thanks a lot for your support and contributions.
Thanks men for coming in handy, am entering data now. You you are such smart, i did not know.
Glad this helps : ) : )
you are a great guy
nicely explained
Glad you like the video!
Great Mike. I Always learn something new from u 👌👌😀
Glad you can learn some new cool tips, Nader!!!
Way cool Mike. I was always using the keyboard shortcut ALT + D + O to get that form. The ribbon icon seems cooler !
LOVE that old keyboard!!!!! Back in the days when form was in the menu : )
Thank you so much !
Tx for mentioning ALT+D+O...so much easier!
THANK YOU for the Turn Off for Whole File tip at 3:04 I have been on a search for this! Great video!
Wow this is mind blowing Mike ...Superb 👍👍
Glad you like it, Rashmi!!!
That was so cool.. thnx for this video.. now I think I can create my own data base for my students..
Glad it helps : )
Very nice tutorial
Glad it helps, Wlison!
Very helpful information.
Glad it was helpful, William!!!
Outstanding, very useful dear Mike!, Hi from Limón, Costa Rica.
Glad you like it, Limon!!!
thanks so much. this was very helpful.
Glad it helps : )
your incredibly talented!!
I am glad that I can help you to learn Excel : )
Nice to learn about the “Form” feature.
: )
Wonderful tricks to enter a data in table without using VBA codes...💥💥💥💥
Glad you like that non-VBA trick : ) : )
Yes of course. Non-Vba really easy to do...💥💥💥💥
It's a useful video, thanks a ton Sir.
You are welcome!!!
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
Thanks Mike. Best regards. Salim
You are welcome, K D Salim : )
Thanks Mike. Never knew about disabling the auto hyper text as you type feature. Thanks for the lesson.
You are welcome for the lesson, kevin !!
Thanks sir
You are right infarction
So thanks
I am from India
Important Video sir 🙏🙏🙏🙏🙏
I was having a ton of trouble with this before watching this video
Glad this helps!
best easiest tutorial.This helped me so much thanks a ton
You are welcome!
I like your system. Thanks a lot!
You are welcome a lot!!!
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 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.
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!
Wonderful videos 😎
Glad you like the videos, Rishav!!!
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 !
I think that you should open an online class for beginners.
I have one. Its free at CZcams. Here it is:
czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
If you go to my excelisfun CZcams home page you will see the many free classes that I offer. Here is intro video on home page: www.youtube.com/@excelisfun
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!!
You are welcome and thanks for the killer keyboard : )
Thanks ; good stuff...and no foreign accent.
Very interesting. Thanks a lot for the tutorial.
You are welcome, Ernest!!!!
Amazing!
I also would like to see a data entry in other sheet where a none professional can easily enter the data
Number one, thanks
You are welcome, vivou!!!!
thank you, well explained
You are welcome!
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 😂❤
Totally Awesome Mike. Thanks a lot.
You are welcome a lot, Khan!!!!
Excellent!
Glad you like it, PG!!!!
Wow great work
Really helpful. Thanks
Glad it was helpful!
Excellent video. Thanks so much for uploading it.
You are welcome!
Thank you, just well understand through your Video 💜🙏🙏
You are welcome, Khim!!!!
Just...excellent video. Thanks so much!
You are welcome! I am glad that you liked the EXCELlent video ; )
Great Video, thanks
You are welcome, wofdigy!!!!
That is great, you explained very well. I can do that. Well done.
You are welcome!
Superb !!
Glad it is superb for you, Shaheen !!!
great work sir
Glad you like it : )
Thanks Mike! This is useful and fun!
Glad it is useful and fun, Kerron!!!
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?
Good video Mike!
Thanks, Teammate Chris : )
Thank you Mike for these wonderful videos.
You are welcome!!!
So helpful. Thank you so much. Love you work!
Glad to help!
Very useful. Easy explanation. Thanks for sharing
You are welcome for the share, Nono : )
This is very helpful! Thank you so much for sharing.
Thanks I got benefit
Can you do this for assigning a membership number to someone joining a club?
Not that I know... : (
Happy New Year, though!
Thank you sir . Its very interesting . My doubt is how many records we can enter i this form ? and another is will works in google sheets ?
ANd the best thing is... you don't need VBA! :) Mike, thanks for sharing!
Yes, no VBA : )
thanks for this short rich videos!
You are welcome!
I am indian sir well explained
Thank u sir
You are welcome : )
thank you! this is a great help for me.
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?
it's great i want to understand it more
The patriarch of excel, thanks mucho mucho.
You are welcome!
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?
Great job thank you
You are welcome, Bewket!!!!
Thanks. It's really help me.
Mike, I love your videos! 💪
Glad you love em, Predrag!!!!
professor of Excel ♥
Thanks, Hazem : ) : ) : ) : )
VERY HELPFULL
lots a help god speed sir
You are welcome, diego!!!!
very nice
I am glad that it is nice for you : )
Great. Thank you
You are welcome!
Cool. But what are the drop down arrows for?
The dropdowns at the top of each column are for sorting and filtering.
Form very useful. Thanks Mike!
You are welcome, Luiano!!!
Excel programmers team should really develop a form technique like that in MS Access.
Very neat!
Glad you like it, John!!!
Excellent presentation 👏
Glad you like it!
Wow. That's amazing. Thanks Mike.
You are welcome, Syed MM : ) : ) : ) : )
It would've perfect if you can't add porcentaje ruler for expenses budget... Thanks 👍😊
You are welcome, squirtmph!!!
Thanks so much. It helped me tons.