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

Поділитися
Вставка
  • Опубліковано 19 гру 2024

КОМЕНТАРІ •

  • @excelisfun
    @excelisfun  11 місяців тому +5

    If you like this video, I have many free classes at UA-cam on my home page here: free at UA-cam. Here it is: www.youtube.com/@excelisfun
    Here is the Excel Basics free video class: ua-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html

  • @lihyinlee4548
    @lihyinlee4548 3 роки тому +2

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

  • @nep401
    @nep401 Рік тому +12

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

  • @darrylmorgan
    @darrylmorgan 4 роки тому +2

    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
      @excelisfun  4 роки тому

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

  • @leslienorden8483
    @leslienorden8483 9 місяців тому

    Your teaching is great and insightful! Thank You!

  • @henrbenbrown
    @henrbenbrown 6 місяців тому

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

  • @HusseinKorish
    @HusseinKorish 4 роки тому +2

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

    • @excelisfun
      @excelisfun  4 роки тому +1

      You are welcome for each new videos!!!!

  • @empiresoundstt
    @empiresoundstt Рік тому +1

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

  • @jerrymiles7804
    @jerrymiles7804 2 роки тому +1

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

    • @excelisfun
      @excelisfun  2 роки тому +1

      Glad you like it, Limon!!!

  • @CAKimberlyLewis
    @CAKimberlyLewis Рік тому

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

  • @Kulbir92
    @Kulbir92 3 роки тому +12

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

  • @simfinso858
    @simfinso858 4 роки тому +1

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

    • @excelisfun
      @excelisfun  4 роки тому +1

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

  • @kingmasternice1975
    @kingmasternice1975 2 роки тому +1

    Better than my entyr teachers of my university

  • @rashmidhanda4370
    @rashmidhanda4370 4 роки тому +2

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

    • @excelisfun
      @excelisfun  4 роки тому

      Glad you like it, Rashmi!!!

  • @nadermounir8228
    @nadermounir8228 4 роки тому +3

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

    • @excelisfun
      @excelisfun  4 роки тому +1

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

  • @akhtarmohammadsajid1205
    @akhtarmohammadsajid1205 Рік тому +1

    Thanks so.much from Afghanistan.

  • @georgeodhiambo7664
    @georgeodhiambo7664 2 роки тому +1

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

    • @excelisfun
      @excelisfun  2 роки тому

      Glad the clarity helps, George!!!!

  • @ljubicar1987
    @ljubicar1987 4 роки тому +9

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

    • @excelisfun
      @excelisfun  4 роки тому

      Yes, so many hidden treasures!!!!

  • @rattlefate378
    @rattlefate378 2 роки тому +1

    you are a great guy
    nicely explained

  • @keithduchnicki349
    @keithduchnicki349 4 роки тому +5

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

    • @excelisfun
      @excelisfun  4 роки тому

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

  • @mebcool
    @mebcool 11 місяців тому

    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 !

  • @allyndraper8640
    @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
    @zarinamercado8517 3 роки тому +1

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

  • @HiTechDiver
    @HiTechDiver 7 місяців тому

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

  • @MARYCARMAN-p7e
    @MARYCARMAN-p7e Рік тому +1

    thanks so much. this was very helpful.

  • @lisamccray6481
    @lisamccray6481 4 роки тому

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

    • @excelisfun
      @excelisfun  4 роки тому +1

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

  • @sinayokoabdoulaye6165
    @sinayokoabdoulaye6165 4 роки тому +8

    Very helpful. Thank you Mike

    • @excelisfun
      @excelisfun  4 роки тому

      Glad it is helpful, Sinayoko!!!

  • @evansjohnarek2271
    @evansjohnarek2271 3 роки тому +1

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

  • @abuqeisimran9676
    @abuqeisimran9676 Рік тому +1

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

  • @williamfulford4744
    @williamfulford4744 3 роки тому +1

    Very helpful information.

    • @excelisfun
      @excelisfun  3 роки тому

      Glad it was helpful, William!!!

  • @aqeel12342
    @aqeel12342 4 роки тому +9

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

    • @excelisfun
      @excelisfun  4 роки тому +1

      You are really welcome, SYED!!!!!

  • @nirmalkumar-fh3yg
    @nirmalkumar-fh3yg 4 роки тому

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

    • @excelisfun
      @excelisfun  4 роки тому +1

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

    • @nirmalkumar-fh3yg
      @nirmalkumar-fh3yg 4 роки тому

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

  • @aklakhorchannel...8706
    @aklakhorchannel...8706 2 роки тому

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

  • @MrLoccis
    @MrLoccis 3 роки тому +1

    Very nice tutorial

  • @ismailhossain2324
    @ismailhossain2324 2 роки тому +1

    I like your system. Thanks a lot!

  • @remotelylucy
    @remotelylucy 3 роки тому +1

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

  • @ADfamily81
    @ADfamily81 2 роки тому +1

    your incredibly talented!!

    • @excelisfun
      @excelisfun  2 роки тому

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

  • @rishavraj7798
    @rishavraj7798 3 роки тому +1

    Wonderful videos 😎

    • @excelisfun
      @excelisfun  3 роки тому

      Glad you like the videos, Rishav!!!

  • @MizZPottyCat
    @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 😂❤

  • @maenetha
    @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

  • @DIGITAL_COOKING
    @DIGITAL_COOKING 4 роки тому +4

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

    • @excelisfun
      @excelisfun  4 роки тому +3

      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
      @DIGITAL_COOKING 4 роки тому +1

      @@excelisfun yes indeed :)

    • @excelisfun
      @excelisfun  4 роки тому +1

      @@DIGITAL_COOKING : ) : ) : )

  • @pedjanbgd4221
    @pedjanbgd4221 4 роки тому +1

    Mike, I love your videos! 💪

    • @excelisfun
      @excelisfun  4 роки тому

      Glad you love em, Predrag!!!!

  • @kerronduncan6697
    @kerronduncan6697 4 роки тому +7

    Thanks Mike! This is useful and fun!

    • @excelisfun
      @excelisfun  4 роки тому +1

      Glad it is useful and fun, Kerron!!!

  • @delorissmith8248
    @delorissmith8248 3 роки тому +1

    Excellent video. Thanks so much for uploading it.

  • @renegadek9
    @renegadek9 4 роки тому

    Nice to learn about the “Form” feature.

  • @sasavienne
    @sasavienne 4 роки тому +4

    Thanks Mike. Best regards. Salim

    • @excelisfun
      @excelisfun  4 роки тому

      You are welcome, K D Salim : )

  • @chrism9037
    @chrism9037 4 роки тому +4

    Good video Mike!

    • @excelisfun
      @excelisfun  4 роки тому

      Thanks, Teammate Chris : )

  • @vivoumontreal6934
    @vivoumontreal6934 3 роки тому +1

    Number one, thanks

    • @excelisfun
      @excelisfun  3 роки тому

      You are welcome, vivou!!!!

  • @alexmoreno7275
    @alexmoreno7275 4 роки тому

    The patriarch of excel, thanks mucho mucho.

  • @khanabdussabur8604
    @khanabdussabur8604 4 роки тому +3

    Totally Awesome Mike. Thanks a lot.

    • @excelisfun
      @excelisfun  4 роки тому

      You are welcome a lot, Khan!!!!

  • @KDSuam
    @KDSuam Рік тому

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

  • @jonaskalonga4621
    @jonaskalonga4621 3 роки тому +1

    great work sir

  • @josephinebarker4470
    @josephinebarker4470 2 роки тому +1

    Great. Thank you

  • @wamu8851
    @wamu8851 2 роки тому

    Just...excellent video. Thanks so much!

    • @excelisfun
      @excelisfun  2 роки тому

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

  • @ernestbagambiki4824
    @ernestbagambiki4824 3 роки тому +1

    Very interesting. Thanks a lot for the tutorial.

    • @excelisfun
      @excelisfun  3 роки тому

      You are welcome, Ernest!!!!

  • @khimseily
    @khimseily 3 роки тому +1

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

  • @maysounabdallah1545
    @maysounabdallah1545 2 роки тому

    Thank you Mike for these wonderful videos.

  • @rx6588
    @rx6588 3 роки тому +2

    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?

  • @joeypanganiban
    @joeypanganiban Рік тому

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

  • @solarworxnorthernrivers-ya5705
    @solarworxnorthernrivers-ya5705 2 роки тому +1

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

  • @ilyaskhan-td3db
    @ilyaskhan-td3db 3 роки тому +1

    Wow great work

  • @elpa6206
    @elpa6206 3 місяці тому

    great video, thanks for uploading.

  • @donaldwilcox2467
    @donaldwilcox2467 3 роки тому +1

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

  • @omahawarrior4837
    @omahawarrior4837 3 роки тому

    Excellent presentation 👏

  • @royvarghese3382
    @royvarghese3382 2 роки тому +1

    amazing...Thanks

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 4 роки тому +1

    Wow. That's amazing. Thanks Mike.

    • @excelisfun
      @excelisfun  4 роки тому

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

  • @nonoobott8602
    @nonoobott8602 4 роки тому

    Very useful. Easy explanation. Thanks for sharing

    • @excelisfun
      @excelisfun  4 роки тому +1

      You are welcome for the share, Nono : )

  • @hazemali382
    @hazemali382 4 роки тому +1

    professor of Excel ♥

    • @excelisfun
      @excelisfun  4 роки тому

      Thanks, Hazem : ) : ) : ) : )

  • @bewketmelese4329
    @bewketmelese4329 3 роки тому +1

    Great job thank you

    • @excelisfun
      @excelisfun  3 роки тому +1

      You are welcome, Bewket!!!!

  • @robertlohman8947
    @robertlohman8947 4 роки тому +6

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

    • @excelisfun
      @excelisfun  4 роки тому

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

    • @m.raedallulu4166
      @m.raedallulu4166 3 роки тому

      Thank you so much !

    • @Julieoolums
      @Julieoolums 2 роки тому

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

  • @td-jf2lp
    @td-jf2lp Рік тому

    Thanks a lot for your support and contributions.

  • @career5267
    @career5267 2 роки тому +1

    thanks for this short rich videos!

  • @nl-gaming7329
    @nl-gaming7329 2 роки тому

    Omg you helped me so much i had a exam and because of this video iam gonna make it!

  • @wayneedmondson1065
    @wayneedmondson1065 4 роки тому +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
      @excelisfun  4 роки тому +1

      You are welcome and thanks for the killer keyboard : )

  • @houssamayoubi8715
    @houssamayoubi8715 4 роки тому

    Another cool video, greetings from Under Down

    • @excelisfun
      @excelisfun  4 роки тому

      Glad it is cool for you : ) : )

  • @antomac
    @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!

  • @krn14242
    @krn14242 4 роки тому +1

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

    • @excelisfun
      @excelisfun  4 роки тому

      You are welcome for the lesson, kevin !!

  • @karunakarsaladi123
    @karunakarsaladi123 3 роки тому

    I am indian sir well explained
    Thank u sir

  • @diegoalcala8830
    @diegoalcala8830 3 роки тому +1

    lots a help god speed sir

    • @excelisfun
      @excelisfun  3 роки тому

      You are welcome, diego!!!!

  • @pgsrinivas5211
    @pgsrinivas5211 3 роки тому +1

    Excellent!

  • @wofdigy
    @wofdigy 4 роки тому +2

    Great Video, thanks

    • @excelisfun
      @excelisfun  4 роки тому

      You are welcome, wofdigy!!!!

  • @Luciano_mp
    @Luciano_mp 4 роки тому

    Form very useful. Thanks Mike!

    • @excelisfun
      @excelisfun  4 роки тому

      You are welcome, Luiano!!!

  • @wahidbarekzai3875
    @wahidbarekzai3875 2 роки тому +1

    Thank you sir

    • @excelisfun
      @excelisfun  2 роки тому

      You are welcome, wahid!!!!

  • @MalinaC
    @MalinaC 4 роки тому

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

  • @helenasolen3145
    @helenasolen3145 4 місяці тому

    thank you! this is a great help for me.

  • @shaheen677
    @shaheen677 4 роки тому +3

    Superb !!

    • @excelisfun
      @excelisfun  4 роки тому

      Glad it is superb for you, Shaheen !!!

  • @manuhernz4431
    @manuhernz4431 2 роки тому

    Thanks so much. It helped me tons.

  • @LyndaAlsford
    @LyndaAlsford Рік тому +1

    Really helpful. Thanks

  • @aziserak4743
    @aziserak4743 3 роки тому +1

    thank you, well explained

  • @kamalsharma-kw7ms
    @kamalsharma-kw7ms 3 роки тому +1

    WOW ! , that was awesome :)

    • @excelisfun
      @excelisfun  3 роки тому

      Glad it was awesome for you, kamal!!!!

  • @kudakwashemakado1616
    @kudakwashemakado1616 Рік тому

    it's great i want to understand it more

  • @technorickconstructionserv9385

    Thanks. It's really help me.

  • @mohans760
    @mohans760 4 роки тому

    Wonderful mike , cool tricks

    • @excelisfun
      @excelisfun  4 роки тому

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

  • @lansanatolno4840
    @lansanatolno4840 2 роки тому

    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
      @excelisfun  2 роки тому

      You are welcome, Lansana!!!

  • @SaHj-pr2kt
    @SaHj-pr2kt 11 місяців тому +1

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

    • @excelisfun
      @excelisfun  11 місяців тому

      I have one. Its free at UA-cam. Here it is:
      ua-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
      If you go to my excelisfun UA-cam home page you will see the many free classes that I offer. Here is intro video on home page: www.youtube.com/@excelisfun

  • @M4rt1nX
    @M4rt1nX 4 роки тому +3

    Thanks a lot for this one!!!

    • @excelisfun
      @excelisfun  4 роки тому +1

      You are welcome a lot for this one, luz : ) : )

  • @rentals5740
    @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?

  • @euh4367
    @euh4367 10 місяців тому

    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?

  • @randomrandy3059
    @randomrandy3059 3 роки тому +1

    Cool. But what are the drop down arrows for?

    • @excelisfun
      @excelisfun  3 роки тому +1

      The dropdowns at the top of each column are for sorting and filtering.

  • @jcecil2930
    @jcecil2930 3 роки тому +1

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

    • @excelisfun
      @excelisfun  3 роки тому

      Not that I know... : (
      Happy New Year, though!