Beginners Guide to Excel Macros - Create Excel Shortcuts

  Рет қаралды 533,444

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

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

Пікірлер: 178
@KatieLaws
@KatieLaws 2 жыл бұрын
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 4 жыл бұрын
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
@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.
@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 3 жыл бұрын
Bundles of thanks. it is very easy to understands. 😊👌👍
@ash-ej5sw
@ash-ej5sw 2 жыл бұрын
Pppp
@Pips4DGods
@Pips4DGods 2 жыл бұрын
How did I not know this channel for years
@undercover513
@undercover513 4 ай бұрын
Thank you thank you thank you! You are by far the best channel on KZbin!!!
@chefSqueez
@chefSqueez 9 ай бұрын
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😅
@lisasisk3713
@lisasisk3713 Жыл бұрын
You are Awesome! Your speech is impeccable and it is very easy to follow, understand and learn. Thank You! So Much!
@TK-ne2yo
@TK-ne2yo 5 жыл бұрын
Finally made it through all 42 videos. Thank you for this amazing content!
@arvinndssinha3390
@arvinndssinha3390 2 жыл бұрын
Best Intro video on Macros. Thank you, Sir.
@deepalibhadoria2019
@deepalibhadoria2019 Жыл бұрын
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 😊😊
@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!
@KatEyze1015
@KatEyze1015 2 жыл бұрын
Just in time!! I have a worksheet that has over 20 tabs and this is exactly what I needed!! You have a new fan!
@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!
@mr.minimal6466
@mr.minimal6466 11 ай бұрын
Yes, your are a great teacher & with a very good content. Thanks a lot.
@yattyc
@yattyc 3 жыл бұрын
You are a legend! Thanks for all these well-made lessons!!
@lauradilaurenzio2098
@lauradilaurenzio2098 8 ай бұрын
Great video with easy to understand instructions. Thanks again and I will definitely watch your other videos!
@angelicamoran534
@angelicamoran534 5 жыл бұрын
Wow! Macros!!!! I never knew what they were before this video, thanks!!! :)
@AmaduSarjoh
@AmaduSarjoh Жыл бұрын
Your tutorial is quite amazing, thanks for educating the world.
@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 3 жыл бұрын
Just finish watching the ads in his video to help him.
@nodnalneyugn8753
@nodnalneyugn8753 3 жыл бұрын
@@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.
@praveenkumar_9143
@praveenkumar_9143 Жыл бұрын
I love Macros😍😍 and it saves lots of time!!
@carolynoca1481
@carolynoca1481 11 ай бұрын
This was a fantastic tutorial! Thank you so much!
@cbsuresh5631
@cbsuresh5631 3 жыл бұрын
Classic, clear sound is something.. attract me to hear full video &understand.
@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!
@thushnipillay8920
@thushnipillay8920 Жыл бұрын
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 Жыл бұрын
Glad it helped!
@the_wandering_pirate2304
@the_wandering_pirate2304 2 жыл бұрын
Simply brilliant.. so easy to understand and execute. Perfect for a beginner like me👏👏👏👏👏👏
@KA-vx2xs
@KA-vx2xs 2 жыл бұрын
Thank you. Ditto Jane Draisey. Great job explaining Macros.
@afnanshaban6069
@afnanshaban6069 3 жыл бұрын
This really new for me , and good to change between long and short videos . Thank you
@kingZeuz
@kingZeuz 4 жыл бұрын
you have made my life so much easier thank you thank you
@foxydproduction
@foxydproduction 3 жыл бұрын
Tutorials like this is what all should be like 👍🏻
@Chef-1707
@Chef-1707 4 жыл бұрын
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
@lisaworldwidequeen3642
@lisaworldwidequeen3642 3 жыл бұрын
Thank yu sooooo much for this tutorial now I have an idea how Macro Button and Categorizing by Color work.
@anshrastogi9430
@anshrastogi9430 4 ай бұрын
Great explanation, Thanks.
@thalescamargo1044
@thalescamargo1044 4 жыл бұрын
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!!!
@jakkulapraveen611
@jakkulapraveen611 4 жыл бұрын
Nice explanation, easy to understand.
@weldingsolutionskck2798
@weldingsolutionskck2798 3 жыл бұрын
Very nice. Great teaching style.
@ashleystrong-green6870
@ashleystrong-green6870 2 жыл бұрын
This was very helpful. Thanks!
@abduljabbarkhan9107
@abduljabbarkhan9107 4 жыл бұрын
Wonderfully explained in a seamless and lucid mannee.
@kamauwilliamk
@kamauwilliamk 5 жыл бұрын
Waooo..it looks simple,but so impressive... Thank you
@cycleSCUBA
@cycleSCUBA 3 жыл бұрын
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.
@djjammindave
@djjammindave 5 жыл бұрын
Excellent presentation, and remarkable tips in how to use Excel.
@krishnaprakash3422
@krishnaprakash3422 3 жыл бұрын
That was , superb sir ! Thanks !
@geraldtaguinod4708
@geraldtaguinod4708 4 жыл бұрын
little by little I am learning macros...cheers!
@user-pz6et7bi5w
@user-pz6et7bi5w 4 жыл бұрын
This was a great learning for me. Thanks for making this video.
@franciscoespinosa6810
@franciscoespinosa6810 2 жыл бұрын
Super helpful! Thanks!
@vannakr25
@vannakr25 4 жыл бұрын
I love it. I know better what are some of the functionalities of the Macros features.
@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... :/
@nazilla1974
@nazilla1974 3 жыл бұрын
Excellent tutorial. Thank you so much!
@axelace5136
@axelace5136 3 жыл бұрын
This tutorial is so amazing, thank you for this 😌😌😌
@wandagreer9144
@wandagreer9144 2 жыл бұрын
Wow! Great info here! Thanks!
@antonijamohar7985
@antonijamohar7985 3 жыл бұрын
Amazing video, great explanation and wooowww Excel, you can do things!! :) Thank you for your help by teaching us how to use this tool.
@HtopSkills
@HtopSkills 5 жыл бұрын
Nice Excel macros video for beginners
@hedwigwendell-crumb91
@hedwigwendell-crumb91 5 жыл бұрын
Very useful. Thank you.
@shariarbijoy9363
@shariarbijoy9363 2 жыл бұрын
Thanks sir lots of love💙
@simoiyahector-morales9521
@simoiyahector-morales9521 5 жыл бұрын
excellent vid, thanks for the simple and concise explanation
@marksummers463
@marksummers463 3 жыл бұрын
V-E-R-Y G-O-O-D!!!
@muhammadnazeem2563
@muhammadnazeem2563 5 жыл бұрын
You are the man. Thank you so much
@sengkianchua6198
@sengkianchua6198 3 жыл бұрын
Thank you, very useful
@IrmaBermudez
@IrmaBermudez 3 жыл бұрын
Your content is amazing, very practical And to the point.
@nicolasboucherfinance
@nicolasboucherfinance 5 жыл бұрын
Thank you for making it look so simple!
@MesameBendicta
@MesameBendicta 5 ай бұрын
Hey Tech you are awesome but pls could you do a macro video on sheets for a Chromebook I cants find it, also VBA🙏
@hrishabhkumar5372
@hrishabhkumar5372 3 жыл бұрын
Thank you so much! This was really helpful.
@fazilm1
@fazilm1 2 жыл бұрын
nicely done.....thanks
@Nubbe999
@Nubbe999 4 жыл бұрын
Wow i really learned something useful today. great :)
@MillennialTravelConfessions
@MillennialTravelConfessions 5 жыл бұрын
Very well explained! Thank you so much! 🙌🙌🙌
@fengfuxu4822
@fengfuxu4822 11 ай бұрын
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object?
@erindav1
@erindav1 5 жыл бұрын
Used this today.. Thank so much
@abdidekmuhumed4510
@abdidekmuhumed4510 3 жыл бұрын
Thank you 💙
@rachelcurrry
@rachelcurrry 4 жыл бұрын
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 :)
@timothykuek8856
@timothykuek8856 4 жыл бұрын
Thank you alot for the tips.
@evolutionbe7150
@evolutionbe7150 5 жыл бұрын
i want to cry, i can't believe you even have one on macros... ;-;
@SweetBiddi
@SweetBiddi 3 жыл бұрын
THANK YOU!!!!!
@Boomerbaby48
@Boomerbaby48 4 жыл бұрын
Thank you! you made it so simple to understand!
@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.
@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.
@Dramapopp
@Dramapopp 3 ай бұрын
if u dont want to use a macro, a really short simple way to do this is to simply insert an icon or button and link it to the another sheet. just 3 steps, macros can be used for other purposes
@niftyexpress4505
@niftyexpress4505 2 жыл бұрын
Thanks a lot !
@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!
@Mahesh-nu4hi
@Mahesh-nu4hi 5 жыл бұрын
THANK YOU SO MUCH.
@giacobbepietro9836
@giacobbepietro9836 5 жыл бұрын
Thumbs up for great explanation.
@francisadeogun5382
@francisadeogun5382 4 жыл бұрын
This is super. Thanks
@thangaveluraj
@thangaveluraj 2 жыл бұрын
Very very useful... Thanks a ton... Additionally, Since this is for beginners, you could have warned viewers not to open any downloaded attachments that is xlsm file, for it may contain dangerous malware.. we are living in an age of menacing cyber threats every day..
@rohansargar610
@rohansargar610 4 жыл бұрын
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?
@richardrichard5816
@richardrichard5816 4 жыл бұрын
thank you friend
@yashchowmal821
@yashchowmal821 3 жыл бұрын
Thank u so much sir
@sklee1644
@sklee1644 Жыл бұрын
Can this be used if I want the result of a calculation go to a cell if positive, to another cell if negative? Or a IF function can do?
@avideshmukh6308
@avideshmukh6308 3 жыл бұрын
Great video. Avi Deshmukh, MD. Will like to support you, just pace down your your speech.
@smoothpurehoney
@smoothpurehoney 5 жыл бұрын
Excellent
@mynameisujjal
@mynameisujjal 4 жыл бұрын
I found it interesting...I would love to have a video having examples with different set of data using macro recording..
@tymothylim6550
@tymothylim6550 4 жыл бұрын
Thank you again for another helpful video :)
@ellahehvarshowsaz605
@ellahehvarshowsaz605 2 жыл бұрын
Hi can i make it for a big amount of worksheets to access from a single worksheets ?
@mohsinamukhtar7120
@mohsinamukhtar7120 2 жыл бұрын
Thanks
@mlp4256
@mlp4256 4 жыл бұрын
Til now im still learning Microsoft!!
@idolsensei7
@idolsensei7 3 жыл бұрын
hello thanks for this video. What if you had a mistake on highlighting a certain name with blue, is there a way to undo it?
@vasacanganapathy7187
@vasacanganapathy7187 3 жыл бұрын
Tks Great
@bernardocaca8479
@bernardocaca8479 4 жыл бұрын
Very nice 👍🏼
@tumisangmotsamai3930
@tumisangmotsamai3930 3 жыл бұрын
thanks sir
@tilakavin447
@tilakavin447 4 жыл бұрын
It would be helpful if you keep the spreadsheets which are related to each video in the playlist.
@suryavoid2488
@suryavoid2488 Жыл бұрын
thanks bro
Beginner's Guide to Excel Dashboards
14:03
Technology for Teachers and Students
Рет қаралды 834 М.
Excel Conditional Formatting in Depth
17:39
Technology for Teachers and Students
Рет қаралды 320 М.
I thought one thing and the truth is something else 😂
00:34
عائلة ابو رعد Abo Raad family
Рет қаралды 14 МЛН
ТВОИ РОДИТЕЛИ И ЧЕЛОВЕК ПАУК 😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 7 МЛН
FOREVER BUNNY
00:14
Natan por Aí
Рет қаралды 36 МЛН
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 7 МЛН
Create Your First Excel Macro: A Step-by-Step Guide for Beginners🚀
11:57
Excel Shortcut Keys | Full Guide
15:39
Kevin Stratvert
Рет қаралды 637 М.
Intermediate Excel Skills, Tips, and Tricks Tutorial
20:18
Technology for Teachers and Students
Рет қаралды 6 МЛН
Excel Macro Class 1 - Getting Started Programming Macros
15:47
TeachExcel
Рет қаралды 627 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 886 М.
How to Create & Use Excel Macros (Real world example)
10:09
Leila Gharani
Рет қаралды 1,7 МЛН
Learn Excel VBA to Automate Anything
14:02
Kenji Explains
Рет қаралды 497 М.
The Beginner's Guide to Excel - Excel Basics Tutorial
21:47
Technology for Teachers and Students
Рет қаралды 20 МЛН
I thought one thing and the truth is something else 😂
00:34
عائلة ابو رعد Abo Raad family
Рет қаралды 14 МЛН