Beginners Guide to Excel Macros - Create Excel Shortcuts
ฝัง
- เผยแพร่เมื่อ 27 ก.ย. 2024
- 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...
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.
Your voice alone encourages learning... Well done
Finally made it through all 42 videos. Thank you for this amazing content!
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.
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!
Wow! Macros!!!! I never knew what they were before this video, thanks!!! :)
Hey Tech you are awesome but pls could you do a macro video on sheets for a Chromebook I cants find it, also VBA🙏
Just in time!! I have a worksheet that has over 20 tabs and this is exactly what I needed!! You have a new fan!
You are a legend! Thanks for all these well-made lessons!!
I'm doing a course and couldn't understand anything the lecturer was saying. Your explanations are so easy to follow. New subscriber!
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 😊😊
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
Thank you thank you thank you! You are by far the best channel on TH-cam!!!
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!!!
You are Awesome! Your speech is impeccable and it is very easy to follow, understand and learn. Thank You! So Much!
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.
Simply brilliant.. so easy to understand and execute. Perfect for a beginner like me👏👏👏👏👏👏
Classic, clear sound is something.. attract me to hear full video
&understand.
Best Intro video on Macros. Thank you, Sir.
This really new for me , and good to change between long and short videos .
Thank you
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... :/
Great video with easy to understand instructions. Thanks again and I will definitely watch your other videos!
Your tutorial is quite amazing, thanks for educating the world.
Tutorials like this is what all should be like 👍🏻
Great explanation, Thanks.
Nice Excel macros video for beginners
Thank yu sooooo much for this tutorial now I have an idea how Macro Button and Categorizing by Color work.
Yes, your are a great teacher & with a very good content. Thanks a lot.
Excellent presentation, and remarkable tips in how to use Excel.
i want to cry, i can't believe you even have one on macros... ;-;
I love it. I know better what are some of the functionalities of the Macros features.
Nice explanation, easy to understand.
you have made my life so much easier thank you thank you
Very useful. Thank you.
Very well explained! Thank you so much! 🙌🙌🙌
Hi! This tutorial is amazing....simple to understand the complicated Macros. Why don't you start an online course on Excel? Just a suggestion.
Wonderfully explained in a seamless and lucid mannee.
excellent vid, thanks for the simple and concise explanation
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!
You are the man. Thank you so much
Used this today.. Thank so much
Before: what the heck is mAcro
After: ohh I see
Thanks
This tutorial is so amazing, thank you for this 😌😌😌
It would be helpful if you keep the spreadsheets which are related to each video in the playlist.
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 :)
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.
Great video. Avi Deshmukh, MD.
Will like to support you, just pace down your your speech.
Super helpful! Thanks!
Thanks sir lots of love💙
Wow! Great info here! Thanks!
Thank you so much! This was really helpful.
Thank you 💙
nicely done.....thanks
THANK YOU SO MUCH.
Can I lock or freeze that button as I scroll up and down?
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.
support him on patreon
Hi can i make it for a big amount of worksheets to access from a single worksheets ?
Thank you, very useful
Wow i really learned something useful today. great :)
So...is there an advanced guide on macros? For example I would like to automate a process that whenever I click a cell and a button, it automatically calculates the difference between this cell and a cell in another worksheet and print it on the side?
Poor Jina Pullin, still working at 83.
Naughty you😂
She must be 83 with a work ethic of a 35year
Stevie woolverton and Carola hunton also poor😢
And Poor Carola Hunton as well
😂😂😂
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?
Thank you alot for the tips.
Thank you again for another helpful video :)
Is it working in Excel sheets?
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?
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?
Where can I find excel worksheet to follow along with you?
Thanks
how did you add shift in shortcut key
can we hide (not display)the blue macro that you made while it still functioned?
THANK YOU!!!!!
This is super. Thanks
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
Can I add a Macro in Excel that if I click on it takes me to a word document?
thanks sir
thanks bro
Thank you for the info my friend.
V-E-R-Y G-O-O-D!!!
Thank u so much sir
Are there practice files for this video?
Tks Great
wow! thank you!
Seems like the "recording" works for only one sheet. Because I "recorded" flipping through several sheets, but it just ends up jumping to the last sheet.
Yes sir
Thank you
I am an Excel rookie...need to learn how to create a macro that converts the excel file i am working on to a PDF...Please help
Nice job 1m
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?
I NEED HELP! PLZZ
im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months.
i'm trying to recreate an app that i was using but doesn't track enough details.
in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all"
and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow.
i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be
PLEASE TELL ME if you think that is at all possible on excel
can i do this with macros?
yesterday I have tried macro right after your video and progressed it, but forgot to save as you have mentioned in your video, the next day I opened that file and it was unable to show progressed macro then I remake new macros but it showed an error, guys plz assist me to the macros
do u have an intermediate to VBA and Macros video link ?
Wow i did it
Bytheway still can not blv finaly i learn how to use macros .tks
nice
so fun
how do i enable macro on wps office??? the macro button is not working
DONE
where is the excel file
.thumbs up.