Тёмный

Beginners Guide to Excel Macros - Create Excel Shortcuts 

Technology for Teachers and Students
Подписаться 1,5 млн
Просмотров 488 тыс.
50% 1

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

Хобби

Опубликовано:

 

28 июл 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 171   
@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
@angelicamoran534
@angelicamoran534 4 года назад
Wow! Macros!!!! I never knew what they were before this video, thanks!!! :)
@TK-ne2yo
@TK-ne2yo 4 года назад
Finally made it through all 42 videos. Thank you for this amazing content!
@nicolasboucheronlinevideos454
@nicolasboucheronlinevideos454 4 года назад
Thank you for making it look so simple!
@djjammindave
@djjammindave 4 года назад
Excellent presentation, and remarkable tips in how to use Excel.
@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!
@kamauwilliamk
@kamauwilliamk 4 года назад
Waooo..it looks simple,but so impressive... Thank you
@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!
@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😅
@yattyc
@yattyc 3 года назад
You are a legend! Thanks for all these well-made lessons!!
@MillennialTravelConfessions
@MillennialTravelConfessions 4 года назад
Very well explained! Thank you so much! 🙌🙌🙌
@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.
@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.
@lisasisk3713
@lisasisk3713 9 месяцев назад
You are Awesome! Your speech is impeccable and it is very easy to follow, understand and learn. Thank You! So Much!
@Boomerbaby48
@Boomerbaby48 4 года назад
Thank you! you made it so simple to 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!
@lauradilaurenzio2098
@lauradilaurenzio2098 2 месяца назад
Great video with easy to understand instructions. Thanks again and I will definitely watch your other videos!
@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 😊😊
@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
@simoiyahector-morales9521
@simoiyahector-morales9521 4 года назад
excellent vid, thanks for the simple and concise explanation
@Pips4DGods
@Pips4DGods 2 года назад
How did I not know this channel for years
@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!
@vannakr25
@vannakr25 4 года назад
I love it. I know better what are some of the functionalities of the Macros features.
@arvinndssinha3390
@arvinndssinha3390 2 года назад
Best Intro video on Macros. Thank you, Sir.
@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!!!
@IrmaBermudez
@IrmaBermudez 3 года назад
Your content is amazing, very practical And to the point.
@user-pz6et7bi5w
@user-pz6et7bi5w 3 года назад
This was a great learning for me. Thanks for making this video.
@the_wandering_pirate2304
@the_wandering_pirate2304 2 года назад
Simply brilliant.. so easy to understand and execute. Perfect for a beginner like me👏👏👏👏👏👏
@cbsuresh5631
@cbsuresh5631 3 года назад
Classic, clear sound is something.. attract me to hear full video &understand.
@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.
@user-vi8hw3tt9p
@user-vi8hw3tt9p 8 месяцев назад
Your tutorial is quite amazing, thanks for educating the world.
@erindav1
@erindav1 4 года назад
Used this today.. Thank so much
@afnanshaban6069
@afnanshaban6069 3 года назад
This really new for me , and good to change between long and short videos . Thank you
@mr.minimal6466
@mr.minimal6466 5 месяцев назад
Yes, your are a great teacher & with a very good content. Thanks a lot.
@nazilla1974
@nazilla1974 3 года назад
Excellent tutorial. Thank you so much!
@carolynoca1481
@carolynoca1481 5 месяцев назад
This was a fantastic tutorial! Thank you so much!
@abduljabbarkhan9107
@abduljabbarkhan9107 3 года назад
Wonderfully explained in a seamless and lucid mannee.
@hedwigwendell-crumb91
@hedwigwendell-crumb91 4 года назад
Very useful. Thank you.
@kingZeuz
@kingZeuz 3 года назад
you have made my life so much easier thank you thank you
@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 :)
@hrishabhkumar5372
@hrishabhkumar5372 3 года назад
Thank you so much! This was really helpful.
@geraldtaguinod4708
@geraldtaguinod4708 4 года назад
little by little I am learning macros...cheers!
@evolutionbe7150
@evolutionbe7150 4 года назад
i want to cry, i can't believe you even have one on macros... ;-;
@muhammadnazeem2563
@muhammadnazeem2563 4 года назад
You are the man. Thank you so much
@KA-vx2xs
@KA-vx2xs 2 года назад
Thank you. Ditto Jane Draisey. Great job explaining Macros.
@jakkulapraveen611
@jakkulapraveen611 4 года назад
Nice explanation, easy to understand.
@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!
@tymothylim6550
@tymothylim6550 4 года назад
Thank you again for another helpful video :)
@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.
@axelace5136
@axelace5136 3 года назад
This tutorial is so amazing, thank you for this 😌😌😌
@HtopSkills
@HtopSkills 4 года назад
Nice Excel macros video for beginners
@praveenkumar_0143
@praveenkumar_0143 9 месяцев назад
I love Macros😍😍 and it saves lots of time!!
@symbiosis4093
@symbiosis4093 3 года назад
I found it interesting...I would love to have a video having examples with different set of data using macro recording..
@timothykuek8856
@timothykuek8856 3 года назад
Thank you alot for the tips.
@lisaworldwidequeen3642
@lisaworldwidequeen3642 2 года назад
Thank yu sooooo much for this tutorial now I have an idea how Macro Button and Categorizing by Color work.
@Mahesh-nu4hi
@Mahesh-nu4hi 4 года назад
THANK YOU SO MUCH.
@foxydproduction
@foxydproduction 2 года назад
Tutorials like this is what all should be like 👍🏻
@sirerrol1293
@sirerrol1293 4 года назад
Thank you for the info my friend.
@ashleystrong-green6870
@ashleystrong-green6870 2 года назад
This was very helpful. Thanks!
@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!
@weldingsolutionskck2798
@weldingsolutionskck2798 3 года назад
Very nice. Great teaching style.
@berlianabernadettasianturi1599
@berlianabernadettasianturi1599 4 года назад
THANK YOU SO MUCH!!!!💖
@franciscoespinosa6810
@franciscoespinosa6810 Год назад
Super helpful! Thanks!
@austinCharlee
@austinCharlee 2 года назад
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... :/
@marksummers463
@marksummers463 2 года назад
V-E-R-Y G-O-O-D!!!
@Nubbe999
@Nubbe999 3 года назад
Wow i really learned something useful today. great :)
@sengkianchua6198
@sengkianchua6198 3 года назад
Thank you, very useful
@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.
@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?
@wandagreer9144
@wandagreer9144 2 года назад
Wow! Great info here! Thanks!
@krishnaprakash3422
@krishnaprakash3422 2 года назад
That was , superb sir ! Thanks !
@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.
@avideshmukh6308
@avideshmukh6308 2 года назад
Great video. Avi Deshmukh, MD. Will like to support you, just pace down your your speech.
@francisadeogun5382
@francisadeogun5382 3 года назад
This is super. Thanks
@shariarbijoy9363
@shariarbijoy9363 2 года назад
Thanks sir lots of love💙
@fazilm1
@fazilm1 Год назад
nicely done.....thanks
@fengfuxu4822
@fengfuxu4822 5 месяцев назад
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?
@somewhereupthere
@somewhereupthere 4 года назад
wow! thank you!
@adonisambrocio452
@adonisambrocio452 Год назад
Thank you
@tilakavin447
@tilakavin447 3 года назад
It would be helpful if you keep the spreadsheets which are related to each video in the playlist.
@user-sy4lm5lq1l
@user-sy4lm5lq1l 2 года назад
THANK YOU!!!!!
@abdidekmuhumed4510
@abdidekmuhumed4510 2 года назад
Thank you 💙
@niftyexpress4505
@niftyexpress4505 2 года назад
Thanks a lot !
@richardrichard5816
@richardrichard5816 3 года назад
thank you friend
@smoothpurehoney
@smoothpurehoney 4 года назад
Excellent
@mlp4256
@mlp4256 3 года назад
Til now im still learning Microsoft!!
@yashchowmal821
@yashchowmal821 3 года назад
Thank u so much sir
@mohsinamukhtar7120
@mohsinamukhtar7120 Год назад
Thanks
@enricopunta2819
@enricopunta2819 4 года назад
Hi, I have a rather difficult question: I got a file Excel with activation macro. I use many conditional formatting and I wish that the interval of application would remain unchanged. I think that the problem are the macros but I obtain no effect registering a macro and setting the conditional formatting. Do you have any ideas? Thanks
@catherinehill8198
@catherinehill8198 6 месяцев назад
Would you delete the initial file after you have the file with the macros? Also, do you have to keep going to "save as" you build more macros? Thank you.
@bernardocaca8479
@bernardocaca8479 4 года назад
Very nice 👍🏼
@suryavoid2488
@suryavoid2488 8 месяцев назад
thanks bro
@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?
@carrieng4286
@carrieng4286 4 года назад
Do you know how to make the clean data transfer from one page to another using macro?
@vasacanganapathy7187
@vasacanganapathy7187 3 года назад
Tks Great
@tumisangmotsamai3930
@tumisangmotsamai3930 3 года назад
thanks sir
@lagoonz28
@lagoonz28 4 года назад
Is it normal to see a pop-up warning about personal information when I tried to save my macros? Is there any way to remove the personal information to prevent the pop up from displaying?
Далее
Build Anything with Perplexity, Here’s How
42:16
Просмотров 28 тыс.
KO’P GAP ESHAKKA YUK!😂
00:57
Просмотров 862 тыс.
Beginner's Guide to Excel Dashboards
14:03
Просмотров 781 тыс.
Excel Macros & VBA - Tutorial for Beginners
50:20
Просмотров 1 млн
Most Useful Excel Keyboard Shortcuts
9:22
Просмотров 1,6 млн
How to Create and Use Excel Macros 😎
13:43
Просмотров 35 тыс.
Using Checkboxes in Excel - Part 1
10:10
Просмотров 657 тыс.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Learn Macros in 7 Minutes (Microsoft Excel)
7:40
Просмотров 1,8 млн
Excel for Beginners - The Complete Course
54:55
Просмотров 4,8 млн
7 Things You're Doing WRONG⚡in Excel
15:22
Просмотров 1,2 млн
Результат невероятен🤯
0:39
Просмотров 10 млн
How to sign the letter J?❤️
0:47
Просмотров 50 млн
Капец как вкусно🤤 #overnightoats
1:01