If you like this video, I have many free classes at KZitem on my home page here: free at KZitem. Here it is: www.youtube.com/@excelisfun Here is the Excel Basics free video class: kzitem.info/door/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
@fekadugudisa7
26 күн бұрын
best tutories
@darrylmorgan
4 жыл бұрын
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
4 жыл бұрын
You are Form Boom Welcome for this great little feature trick : )
@lihyinlee4548
2 жыл бұрын
I did it I watch this video 3 times and I know how to do it is best man :)
@excelisfun
2 жыл бұрын
: )
@Kulbir92
3 жыл бұрын
I can't stress enough how helpful this is. Thanks man
@excelisfun
3 жыл бұрын
Glad it helps, Levi!!!!
@HusseinKorish
4 жыл бұрын
Each new video in this channel adds up new things to learn .. thanks Mike
@excelisfun
4 жыл бұрын
You are welcome for each new videos!!!!
@DIGITAL_COOKING
4 жыл бұрын
NEW FOR ME! AND VERY EFFICIENT,I THINK WE CAN'T REACH THE END OF EXCEL LEARNING 🙂👍
@excelisfun
4 жыл бұрын
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
4 жыл бұрын
@@excelisfun yes indeed :)
@excelisfun
4 жыл бұрын
@@DIGITAL_COOKING : ) : ) : )
@simfinso858
4 жыл бұрын
Amazing Excel Teacher of my life.Who Teaches Very Basic to Super Advanced level of Excel with Same patience.
@excelisfun
4 жыл бұрын
Yes, the same patience for basic to advanced. It is all fun : ) : ) : ) : )
@aqeel12342
4 жыл бұрын
Hi Sir... I really love the way you teach 💖 Really appreciated 👍
@excelisfun
4 жыл бұрын
You are really welcome, SYED!!!!!
@mebcool
9 ай бұрын
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
6 ай бұрын
Your teaching is great and insightful! Thank You!
@jerrymiles7804
2 жыл бұрын
Outstanding, very useful dear Mike!, Hi from Limón, Costa Rica.
@excelisfun
2 жыл бұрын
Glad you like it, Limon!!!
@georgeodhiambo7664
2 жыл бұрын
I like the way you explain it. It comes very clearly
@excelisfun
2 жыл бұрын
Glad the clarity helps, George!!!!
@krn14242
4 жыл бұрын
Thanks Mike. Never knew about disabling the auto hyper text as you type feature. Thanks for the lesson.
@excelisfun
4 жыл бұрын
You are welcome for the lesson, kevin !!
@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
@rashmidhanda4370
4 жыл бұрын
Wow this is mind blowing Mike ...Superb 👍👍
@excelisfun
4 жыл бұрын
Glad you like it, Rashmi!!!
@wayneedmondson1065
4 жыл бұрын
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
4 жыл бұрын
You are welcome and thanks for the killer keyboard : )
@td-jf2lp
Жыл бұрын
Thanks a lot for your support and contributions.
@khanabdussabur8604
4 жыл бұрын
Totally Awesome Mike. Thanks a lot.
@excelisfun
4 жыл бұрын
You are welcome a lot, Khan!!!!
@akhtarmohammadsajid1205
Жыл бұрын
Thanks so.much from Afghanistan.
@sasavienne
4 жыл бұрын
Thanks Mike. Best regards. Salim
@excelisfun
4 жыл бұрын
You are welcome, K D Salim : )
@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!
@zarinamercado8517
3 жыл бұрын
That was so cool.. thnx for this video.. now I think I can create my own data base for my students..
@excelisfun
3 жыл бұрын
Glad it helps : )
@antomac
11 ай бұрын
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!
@evansjohnarek2271
2 жыл бұрын
Thanks men for coming in handy, am entering data now. You you are such smart, i did not know.
@excelisfun
2 жыл бұрын
Glad this helps : ) : )
@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 😂😂😂
@HiTechDiver
4 ай бұрын
Thanks ; good stuff...and no foreign accent.
@rx6588
3 жыл бұрын
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?
@kingmasternice1975
2 жыл бұрын
Better than my entyr teachers of my university
@excelisfun
2 жыл бұрын
Glad this helps!
@joeypanganiban
Жыл бұрын
Amazing! I also would like to see a data entry in other sheet where a none professional can easily enter the data
@StillCrazyFL
7 ай бұрын
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.
@MizZPottyCat
9 ай бұрын
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 😂❤
@abuqeisimran9676
Жыл бұрын
It's a useful video, thanks a ton Sir.
@excelisfun
Жыл бұрын
You are welcome!!!
@delorissmith8248
3 жыл бұрын
Excellent video. Thanks so much for uploading it.
@excelisfun
3 жыл бұрын
You are welcome!
@renegadek9
3 жыл бұрын
Nice to learn about the “Form” feature.
@excelisfun
3 жыл бұрын
: )
@solarworxnorthernrivers-ya5705
2 жыл бұрын
So helpful. Thank you so much. Love you work!
@excelisfun
2 жыл бұрын
Glad to help!
@nirmalkumar-fh3yg
4 жыл бұрын
Wonderful tricks to enter a data in table without using VBA codes...💥💥💥💥
@excelisfun
4 жыл бұрын
Glad you like that non-VBA trick : ) : )
@nirmalkumar-fh3yg
4 жыл бұрын
Yes of course. Non-Vba really easy to do...💥💥💥💥
@ernestbagambiki4824
2 жыл бұрын
Very interesting. Thanks a lot for the tutorial.
@excelisfun
2 жыл бұрын
You are welcome, Ernest!!!!
@wamu8851
2 жыл бұрын
Just...excellent video. Thanks so much!
@excelisfun
2 жыл бұрын
You are welcome! I am glad that you liked the EXCELlent video ; )
@khimseily
2 жыл бұрын
Thank you, just well understand through your Video 💜🙏🙏
@excelisfun
2 жыл бұрын
You are welcome, Khim!!!!
@SyedMuzammilMahasanShahi
4 жыл бұрын
Wow. That's amazing. Thanks Mike.
@excelisfun
4 жыл бұрын
You are welcome, Syed MM : ) : ) : ) : )
@jcecil2930
2 жыл бұрын
Can you do this for assigning a membership number to someone joining a club?
@excelisfun
2 жыл бұрын
Not that I know... : ( Happy New Year, though!
@m.raedallulu4166
3 жыл бұрын
Excel programmers team should really develop a form technique like that in MS Access.
@donaldwilcox2467
2 жыл бұрын
That is great, you explained very well. I can do that. Well done.
@excelisfun
2 жыл бұрын
You are welcome!
@alexmoreno7275
3 жыл бұрын
The patriarch of excel, thanks mucho mucho.
@excelisfun
3 жыл бұрын
You are welcome!
@TerranceHinton-dk6xt
5 ай бұрын
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?
@allenmatte5870
2 жыл бұрын
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!!
@kamalsharma-kw7ms
2 жыл бұрын
WOW ! , that was awesome :)
@excelisfun
2 жыл бұрын
Glad it was awesome for you, kamal!!!!
@KDSuam
Жыл бұрын
This is very helpful! Thank you so much for sharing.
@wofdigy
4 жыл бұрын
Great Video, thanks
@excelisfun
4 жыл бұрын
You are welcome, wofdigy!!!!
@MalinaC
4 жыл бұрын
ANd the best thing is... you don't need VBA! :) Mike, thanks for sharing!
@excelisfun
4 жыл бұрын
Yes, no VBA : )
@aziserak4743
2 жыл бұрын
thank you, well explained
@excelisfun
2 жыл бұрын
You are welcome!
@MyFakeBrand
4 жыл бұрын
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
4 жыл бұрын
I have a video in my Excel Basics class and in my upcoming 365 class about the amazing QAT : ) Old School Form is fun!
@ilyaskhan-td3db
3 жыл бұрын
Wow great work
@career5267
2 жыл бұрын
thanks for this short rich videos!
@excelisfun
2 жыл бұрын
You are welcome!
@pgsrinivas5211
2 жыл бұрын
Excellent!
@excelisfun
2 жыл бұрын
Glad you like it, PG!!!!
@johnporcella2375
2 жыл бұрын
Very neat!
@excelisfun
2 жыл бұрын
Glad you like it, John!!!
@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?
@helenasolen3145
Ай бұрын
thank you! this is a great help for me.
@jonljacobi
2 жыл бұрын
I was having a ton of trouble with this before watching this video
@excelisfun
2 жыл бұрын
Glad this helps!
@johnborg5419
4 жыл бұрын
Thanks Mike. I use that frequently. Very Convenient. : )
@excelisfun
4 жыл бұрын
Cool. You already use it : )
@nonoobott8602
4 жыл бұрын
Very useful. Easy explanation. Thanks for sharing
@excelisfun
4 жыл бұрын
You are welcome for the share, Nono : )
@SaHj-pr2kt
8 ай бұрын
I think that you should open an online class for beginners.
@excelisfun
8 ай бұрын
I have one. Its free at KZitem. Here it is: kzitem.info/door/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k If you go to my excelisfun KZitem home page you will see the many free classes that I offer. Here is intro video on home page: www.youtube.com/@excelisfun
@manuhernz4431
2 жыл бұрын
Thanks so much. It helped me tons.
@houssamayoubi8715
4 жыл бұрын
Another cool video, greetings from Under Down
@excelisfun
4 жыл бұрын
Glad it is cool for you : ) : )
@M4rt1nX
4 жыл бұрын
Thanks a lot for this one!!!
@excelisfun
4 жыл бұрын
You are welcome a lot for this one, luz : ) : )
@desdonaghy
5 ай бұрын
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.
@niavras
4 жыл бұрын
Thank you very much once again Mike!
@excelisfun
4 жыл бұрын
You are welcome, kostas!!
@bewketmelese4329
2 жыл бұрын
Great job thank you
@excelisfun
2 жыл бұрын
You are welcome, Bewket!!!!
@technorickconstructionserv9385
Жыл бұрын
Thanks. It's really help me.
@kudakwashemakado1616
Жыл бұрын
it's great i want to understand it more
@josephinebarker4470
2 жыл бұрын
Great. Thank you
@excelisfun
2 жыл бұрын
You are welcome!
@diegoalcala8830
2 жыл бұрын
lots a help god speed sir
@excelisfun
2 жыл бұрын
You are welcome, diego!!!!
@karunakarsaladi123
3 жыл бұрын
I am indian sir well explained Thank u sir
@excelisfun
3 жыл бұрын
You are welcome : )
@omahawarrior4837
2 жыл бұрын
Excellent presentation 👏
@excelisfun
2 жыл бұрын
Glad you like it!
@alexandertaylor2960
3 ай бұрын
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?
@francisvalenti2541
2 жыл бұрын
Bravo!!!!!!!
@excelisfun
2 жыл бұрын
Glad this helps!
@TaxMentors
4 жыл бұрын
Thank you sir. Kindly share more videos on power query and power bi.
@excelisfun
4 жыл бұрын
I have 100s of videos about Power Query and a number of good videos about Power BI: kzitem.info/door/PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT and kzitem.info/door/PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1 and many more too.
@prabudhapanchal
Жыл бұрын
Its very helpful!!!
@cameronp5728
2 жыл бұрын
This is great but man its a bummer that you have to edit the quick access toolbar to get that form button in...Is that a user dependent setting? I have an excel file on a server that is utilized by others that neeed access to this button. I have created my own data entry of sorts using VBA. but this seems quicker, but I suppose my idea works for everyone without any tricks
@aaboualy03
3 жыл бұрын
Thank you, really appreciate your efforts , that was simply awesome
@excelisfun
3 жыл бұрын
You are welcome!
@wahidbarekzai3875
2 жыл бұрын
Thank you sir
@excelisfun
2 жыл бұрын
You are welcome, wahid!!!!
@groeisterk
2 жыл бұрын
Awesome !!!!
@excelisfun
2 жыл бұрын
Glad you like it!
@mohans760
4 жыл бұрын
Wonderful mike , cool tricks
@excelisfun
4 жыл бұрын
Glad it is wonderful for you, MOHAN S!!!
@pierremenard9245
3 жыл бұрын
really amazing. very instructive
@excelisfun
3 жыл бұрын
Glad it helps, Pierre!!!!
@shadow_gaming_sk
4 жыл бұрын
U r a excel guru
@excelisfun
4 жыл бұрын
u r well come : )
@edward1412
3 жыл бұрын
Thanks dude. I really appreciate it.
@royvarghese3382
2 жыл бұрын
amazing...Thanks
@excelisfun
2 жыл бұрын
You are welcome, Roy!
@tubakzgn1102
8 ай бұрын
it is super helpful thanks
@johnborg5419
3 жыл бұрын
Thank Mike :) :)
@helent3217
4 жыл бұрын
U're a genius!
@excelisfun
4 жыл бұрын
Thanks, Elena : )
@jennysqueo3704
3 ай бұрын
It’s very useful
@sevagj.b
4 жыл бұрын
Thanks Mike, is new option for me
@excelisfun
4 жыл бұрын
You are welcome, Sevag!
@bridgets.6464
Жыл бұрын
Thank you so much! :)
@hassantaha3116
4 жыл бұрын
Rally, you are the best.
@excelisfun
4 жыл бұрын
Glad to help you, Hassan!!!!
@taufikansari9051
3 жыл бұрын
Thanks sir
@excelisfun
3 жыл бұрын
You are welcome!
@rodolpheprince1448
2 жыл бұрын
THANKS YOU VERY MUCH
@eyhabsoft
2 жыл бұрын
Awesome
@excelisfun
2 жыл бұрын
Glad it is awesome for you, Eyhab!!!!!
@KeninRichfield
Жыл бұрын
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.
Пікірлер: 444