Beginners Guide to Excel Macros - Create Excel Shortcuts

  Рет қаралды 490,611

Technology for Teachers and Students

Technology for Teachers and Students

4 жыл бұрын

My entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to use Excel macros to build time-saving shortcuts in Excel. These shortcuts can then be linked to buttons that you create so you can perform the shortcut with just the click of a button. It's much easier than you would think to start building Excel macros, and this video will teach you everything you need to begin building your own macros. #excel #exceltutorial #excelmacros ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...

Пікірлер: 172
@KatieLaws
@KatieLaws Жыл бұрын
I have ADHD & a hearing issue. You are seriously an AWESOME teacher with a great voice that is easy to understand & holds my attention. I have learned so much with your tutorials! The calm, clear & concise teaching style & information presented is easy to follow. So appreciative & I recommend you to other people too.
@pocamitchell1696
@pocamitchell1696 3 жыл бұрын
I'm certified, but you make me feel so much more confident and reassured. I feel like I paid a lot of money for something that I could have learned for free! Can't thank you enough.
@bilalhassansayed8178
@bilalhassansayed8178 3 жыл бұрын
support him on patreon
@segunadetimehin5815
@segunadetimehin5815 4 жыл бұрын
Your voice alone encourages learning... Well done
@TK-ne2yo
@TK-ne2yo 4 жыл бұрын
Finally made it through all 42 videos. Thank you for this amazing content!
@Arbitrarytoads
@Arbitrarytoads 2 жыл бұрын
Wow, I've been through many Excel classes and tutorials and the way you explain Excel in all your videos makes it seem so easy! Great job!
@angelicamoran534
@angelicamoran534 4 жыл бұрын
Wow! Macros!!!! I never knew what they were before this video, thanks!!! :)
@Chef-1707
@Chef-1707 3 жыл бұрын
that is so helpful beyond belief...this has been driving me nuts for ages and trying to figure out and you sorted within a few minutes..really grateful and massive thanks
@cycleSCUBA
@cycleSCUBA 2 жыл бұрын
Very good lesson. The explanation at the end about saving to a Macro enabled workbook was great. A tip for the form control button for fairly short lists is to make the button height all the way down the list. That way you don't need to move it when you're scrolling your way down the list.
@yattyc
@yattyc 3 жыл бұрын
You are a legend! Thanks for all these well-made lessons!!
@djulecabahug2458
@djulecabahug2458 4 жыл бұрын
Thank you so much for making this series, it saved so much of my time that could have been extended for much longer without your contribution with your videos in your channel. Keep it up and I hope I could support you with your Patreon but right now I don't have the resources to do that but I just want to let you know that I appreciate the amazing work you've done and that you've helped so many people who needed help with using Microsoft's products with your tutorials. In addition to that, your voice is somewhat therapeutic, somehow calming in a strange way and apparently reassuring, making me feel that Excel is not as hard as it seems to be.
@g.j
@g.j 2 жыл бұрын
Just finish watching the ads in his video to help him.
@nodnalneyugn8753
@nodnalneyugn8753 2 жыл бұрын
@@g.j does he even have ads in his videos? I turned off ad blocker just for his videos. I didn't see any ads.
@lauradilaurenzio2098
@lauradilaurenzio2098 2 ай бұрын
Great video with easy to understand instructions. Thanks again and I will definitely watch your other videos!
@djjammindave
@djjammindave 4 жыл бұрын
Excellent presentation, and remarkable tips in how to use Excel.
@lisasisk3713
@lisasisk3713 10 ай бұрын
You are Awesome! Your speech is impeccable and it is very easy to follow, understand and learn. Thank You! So Much!
@nicolasboucheronlinevideos454
@nicolasboucheronlinevideos454 4 жыл бұрын
Thank you for making it look so simple!
@KatEyze1015
@KatEyze1015 Жыл бұрын
Just in time!! I have a worksheet that has over 20 tabs and this is exactly what I needed!! You have a new fan!
@Boomerbaby48
@Boomerbaby48 4 жыл бұрын
Thank you! you made it so simple to understand!
@kamauwilliamk
@kamauwilliamk 4 жыл бұрын
Waooo..it looks simple,but so impressive... Thank you
@simoiyahector-morales9521
@simoiyahector-morales9521 4 жыл бұрын
excellent vid, thanks for the simple and concise explanation
@arvinndssinha3390
@arvinndssinha3390 2 жыл бұрын
Best Intro video on Macros. Thank you, Sir.
@Pips4DGods
@Pips4DGods 2 жыл бұрын
How did I not know this channel for years
@the_wandering_pirate2304
@the_wandering_pirate2304 2 жыл бұрын
Simply brilliant.. so easy to understand and execute. Perfect for a beginner like me👏👏👏👏👏👏
@MillennialTravelConfessions
@MillennialTravelConfessions 4 жыл бұрын
Very well explained! Thank you so much! 🙌🙌🙌
@afnanshaban6069
@afnanshaban6069 3 жыл бұрын
This really new for me , and good to change between long and short videos . Thank you
@user-pz6et7bi5w
@user-pz6et7bi5w 3 жыл бұрын
This was a great learning for me. Thanks for making this video.
@erindav1
@erindav1 4 жыл бұрын
Used this today.. Thank so much
@nazilla1974
@nazilla1974 3 жыл бұрын
Excellent tutorial. Thank you so much!
@kingZeuz
@kingZeuz 3 жыл бұрын
you have made my life so much easier thank you thank you
@vannakr25
@vannakr25 4 жыл бұрын
I love it. I know better what are some of the functionalities of the Macros features.
@mr.minimal6466
@mr.minimal6466 5 ай бұрын
Yes, your are a great teacher & with a very good content. Thanks a lot.
@thalescamargo1044
@thalescamargo1044 3 жыл бұрын
Outstanding video. Even though, I have never used macros, your information have given me more tools and skills to deal with Excel files. Thank you so much!!!
@KazeemRaheem-ro1cb
@KazeemRaheem-ro1cb Жыл бұрын
This lecture is really helpful! I really appreciate the National Population Commission for organizing this online training. God bless you sir!
@user-vi8hw3tt9p
@user-vi8hw3tt9p 8 ай бұрын
Your tutorial is quite amazing, thanks for educating the world.
@hedwigwendell-crumb91
@hedwigwendell-crumb91 4 жыл бұрын
Very useful. Thank you.
@johnonyemenam1814
@johnonyemenam1814 3 жыл бұрын
My boss sent a document to add macros and this video did the magic for me, thanks for knowledge sharing, really fulfilled to accomplish the task.
@kaym.2854
@kaym.2854 Жыл бұрын
I'm doing a course and couldn't understand anything the lecturer was saying. Your explanations are so easy to follow. New subscriber!
@muhammadnazeem2563
@muhammadnazeem2563 4 жыл бұрын
You are the man. Thank you so much
@hrishabhkumar5372
@hrishabhkumar5372 3 жыл бұрын
Thank you so much! This was really helpful.
@louisewallace4359
@louisewallace4359 3 жыл бұрын
I agree this tutorial is excellent! I’ve only started learning Excel this week due to starting a new job on Monday and I’m in awe of your teaching skills, I’ve just followed this tutorial whilst trying to perform the tasks at the same time on my MacBook and have successfully created a button to switch between sheets! I didn’t even know such a thing existed. I thank you so very much Sir for sharing your knowledge. Instead of now fearing Excel I want to learn more! Such a wonderful man you are! 😊 Thank you
@naeemabid7066
@naeemabid7066 2 жыл бұрын
Bundles of thanks. it is very easy to understands. 😊👌👍
@ash-ej5sw
@ash-ej5sw 2 жыл бұрын
Pppp
@geraldtaguinod4708
@geraldtaguinod4708 4 жыл бұрын
little by little I am learning macros...cheers!
@IrmaBermudez
@IrmaBermudez 3 жыл бұрын
Your content is amazing, very practical And to the point.
@carolynoca1481
@carolynoca1481 5 ай бұрын
This was a fantastic tutorial! Thank you so much!
@rachelcurrry
@rachelcurrry 3 жыл бұрын
thanks for the video!! im new to learning the functions of excel and this video gave me a really good idea of what a macro is :)
@jakkulapraveen611
@jakkulapraveen611 4 жыл бұрын
Nice explanation, easy to understand.
@abduljabbarkhan9107
@abduljabbarkhan9107 3 жыл бұрын
Wonderfully explained in a seamless and lucid mannee.
@deepalibhadoria2019
@deepalibhadoria2019 8 ай бұрын
Its my first time learning "Macros", and I'm very happy to find this video , your explanation is very clear and steps are easy to understand , thank-you sir 😊😊
@foxydproduction
@foxydproduction 2 жыл бұрын
Tutorials like this is what all should be like 👍🏻
@chefSqueez
@chefSqueez 3 ай бұрын
OMG! ur instructions are so spot on! I have been scratching my head for the longest when trying to understand what a Macro is much less trying to use it. Haha! Thanks to U, I am no longer confused! Yaaaaaaaaaa for me! Thank you so much. I almost thought u were AI cause this is just too perfect😅
@tymothylim6550
@tymothylim6550 4 жыл бұрын
Thank you again for another helpful video :)
@Mahesh-nu4hi
@Mahesh-nu4hi 4 жыл бұрын
THANK YOU SO MUCH.
@axelace5136
@axelace5136 3 жыл бұрын
This tutorial is so amazing, thank you for this 😌😌😌
@ashleystrong-green6870
@ashleystrong-green6870 2 жыл бұрын
This was very helpful. Thanks!
@timothykuek8856
@timothykuek8856 3 жыл бұрын
Thank you alot for the tips.
@cbsuresh5631
@cbsuresh5631 3 жыл бұрын
Classic, clear sound is something.. attract me to hear full video &understand.
@praveenkumar_0143
@praveenkumar_0143 9 ай бұрын
I love Macros😍😍 and it saves lots of time!!
@weldingsolutionskck2798
@weldingsolutionskck2798 3 жыл бұрын
Very nice. Great teaching style.
@berlianabernadettasianturi1599
@berlianabernadettasianturi1599 4 жыл бұрын
THANK YOU SO MUCH!!!!💖
@sirerrol1293
@sirerrol1293 4 жыл бұрын
Thank you for the info my friend.
@franciscoespinosa6810
@franciscoespinosa6810 Жыл бұрын
Super helpful! Thanks!
@lisaworldwidequeen3642
@lisaworldwidequeen3642 3 жыл бұрын
Thank yu sooooo much for this tutorial now I have an idea how Macro Button and Categorizing by Color work.
@sengkianchua6198
@sengkianchua6198 3 жыл бұрын
Thank you, very useful
@wandagreer9144
@wandagreer9144 2 жыл бұрын
Wow! Great info here! Thanks!
@HtopSkills
@HtopSkills 4 жыл бұрын
Nice Excel macros video for beginners
@fazilm1
@fazilm1 2 жыл бұрын
nicely done.....thanks
@antonijamohar7985
@antonijamohar7985 2 жыл бұрын
Amazing video, great explanation and wooowww Excel, you can do things!! :) Thank you for your help by teaching us how to use this tool.
@Nubbe999
@Nubbe999 3 жыл бұрын
Wow i really learned something useful today. great :)
@krishnaprakash3422
@krishnaprakash3422 2 жыл бұрын
That was , superb sir ! Thanks !
@francisadeogun5382
@francisadeogun5382 3 жыл бұрын
This is super. Thanks
@evolutionbe7150
@evolutionbe7150 4 жыл бұрын
i want to cry, i can't believe you even have one on macros... ;-;
@abdidekmuhumed4510
@abdidekmuhumed4510 2 жыл бұрын
Thank you 💙
@user-sy4lm5lq1l
@user-sy4lm5lq1l 3 жыл бұрын
THANK YOU!!!!!
@shariarbijoy9363
@shariarbijoy9363 2 жыл бұрын
Thanks sir lots of love💙
@somewhereupthere
@somewhereupthere 4 жыл бұрын
wow! thank you!
@KA-vx2xs
@KA-vx2xs 2 жыл бұрын
Thank you. Ditto Jane Draisey. Great job explaining Macros.
@symbiosis4093
@symbiosis4093 3 жыл бұрын
I found it interesting...I would love to have a video having examples with different set of data using macro recording..
@adonisambrocio452
@adonisambrocio452 Жыл бұрын
Thank you
@hennasafer8249
@hennasafer8249 4 жыл бұрын
Hello, thank you so very much for this wonderful tutorial that you gave us. Can you PLEASE make tutorials on coding for excel (modules codes). PLEASE! i have seen tons of tutorials but they are too confusing. Thanks!
@niftyexpress4505
@niftyexpress4505 2 жыл бұрын
Thanks a lot !
@MesameBendicta
@MesameBendicta 8 күн бұрын
Hey Tech you are awesome but pls could you do a macro video on sheets for a Chromebook I cants find it, also VBA🙏
@smoothpurehoney
@smoothpurehoney 4 жыл бұрын
Excellent
@yashchowmal821
@yashchowmal821 3 жыл бұрын
Thank u so much sir
@richardrichard5816
@richardrichard5816 3 жыл бұрын
thank you friend
@thushnipillay8920
@thushnipillay8920 8 ай бұрын
this is so awesome. I have just used this video in conjunction with a task on Excel now...I get it!!!! Thank you!! I got my color buttons💃. I will do it often to familiarize myself.
@techteachersandstudents
@techteachersandstudents 8 ай бұрын
Glad it helped!
@bernardocaca8479
@bernardocaca8479 4 жыл бұрын
Very nice 👍🏼
@grafxgrl8030
@grafxgrl8030 4 жыл бұрын
Excellent! Do you have a tutorial on exporting data to Word? I have a workbook with various staff accomplishments that need to go in a Word file, formatted in specific ways, e.g., APA style for publications, other styles for podium and poster presentations at conferences, etc.
@marksummers463
@marksummers463 2 жыл бұрын
V-E-R-Y G-O-O-D!!!
@mohsinamukhtar7120
@mohsinamukhtar7120 Жыл бұрын
Thanks
@austinCharlee
@austinCharlee 3 жыл бұрын
Omg I had phys 216 last semester with so much data to process. You are saying I could've used a macro to cut the time in a 1/4th!? Thank you so much. This was incredibly simple. I will probably use it in future classes. I wish I looked at this sooner... :/
@tumisangmotsamai3930
@tumisangmotsamai3930 3 жыл бұрын
thanks sir
@suryavoid2488
@suryavoid2488 8 ай бұрын
thanks bro
@vasacanganapathy7187
@vasacanganapathy7187 3 жыл бұрын
Tks Great
@giacobbepietro9836
@giacobbepietro9836 4 жыл бұрын
Thumbs up for great explanation.
@mlp4256
@mlp4256 3 жыл бұрын
Til now im still learning Microsoft!!
@avideshmukh6308
@avideshmukh6308 2 жыл бұрын
Great video. Avi Deshmukh, MD. Will like to support you, just pace down your your speech.
@andreagustave8072
@andreagustave8072 4 жыл бұрын
Yes, U rock !
@homesweethome3050
@homesweethome3050 3 жыл бұрын
Hi! This tutorial is amazing....simple to understand the complicated Macros. Why don't you start an online course on Excel? Just a suggestion.
@ahmedlam7215
@ahmedlam7215 4 жыл бұрын
BEST!
@jacksonzheng4288
@jacksonzheng4288 4 жыл бұрын
Before: what the heck is mAcro After: ohh I see Thanks
@rohansargar610
@rohansargar610 3 жыл бұрын
Great video... so 1 question- do we need to record macro if we re working on different sheets(same kind of data) every month? cant we copy paste the macro?
@tilakavin447
@tilakavin447 3 жыл бұрын
It would be helpful if you keep the spreadsheets which are related to each video in the playlist.
@AJ-et3vf
@AJ-et3vf Жыл бұрын
nice
Beginner's Guide to Excel Dashboards
14:03
Technology for Teachers and Students
Рет қаралды 785 М.
Excel Macros & VBA - Tutorial for Beginners
50:20
Kevin Stratvert
Рет қаралды 1,1 МЛН
Они убрались очень быстро!
00:40
Аришнев
Рет қаралды 3 МЛН
Why You Should Always Help Others ❤️
00:40
Alan Chikin Chow
Рет қаралды 104 МЛН
Climbing to 18M Subscribers 🎉
00:32
Matt Larose
Рет қаралды 20 МЛН
Most Useful Excel Keyboard Shortcuts
9:22
Technology for Teachers and Students
Рет қаралды 1,6 МЛН
How to Create and Use Excel Macros 😎
13:43
Website Learners
Рет қаралды 37 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 268 М.
How to Create & Use Excel Macros (Real world example)
10:09
Leila Gharani
Рет қаралды 1,6 МЛН
Learn Macros in 7 Minutes (Microsoft Excel)
7:40
Cody Baldwin
Рет қаралды 1,8 МЛН
Intermediate Excel Skills, Tips, and Tricks Tutorial
20:18
Technology for Teachers and Students
Рет қаралды 6 МЛН
One Pack Of Pringles Contained M&M's And Coca-Cola🤪😃
0:43
BorisKateFamily
Рет қаралды 26 МЛН
Kashvi gir gayi 🥲 (she is fine now)
0:25
Cute Krashiv
Рет қаралды 18 МЛН