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.
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.
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😅
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
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 😊😊
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.
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.
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... :/
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 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?
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!!!
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.
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..
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
Can you please show how can we combine multiple excel files to multiple excel sheets of single excel file using maco..like if we have 50 excel files to be combined to 50 excel sheets of single excel file..is it possiblle in macro?
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.
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?
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!
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?
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?
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.
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
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.
How did I not know this channel for years
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😅
Your voice alone encourages learning... Well done
This lecture is really helpful! I really appreciate the National Population Commission for organizing this online training. God bless you sir!
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
Bundles of thanks. it is very easy to understands. 😊👌👍
Pppp
Tutorials like this is what all should be like 👍🏻
Finally made it through all 42 videos. Thank you for this amazing content!
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 😊😊
I'm doing a course and couldn't understand anything the lecturer was saying. Your explanations are so easy to follow. New subscriber!
You are Awesome! Your speech is impeccable and it is very easy to follow, understand and learn. Thank You! So Much!
Just in time!! I have a worksheet that has over 20 tabs and this is exactly what I needed!! You have a new fan!
Great video with easy to understand instructions. Thanks again and I will definitely watch your other videos!
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!
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.
Just finish watching the ads in his video to help him.
@@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.
Thank you thank you thank you! You are by far the best channel on UA-cam!!!
You are a legend! Thanks for all these well-made lessons!!
Best Intro video on Macros. Thank you, Sir.
Classic, clear sound is something.. attract me to hear full video
&understand.
Wow! Macros!!!! I never knew what they were before this video, thanks!!! :)
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.
Glad it helped!
Your tutorial is quite amazing, thanks for educating the world.
Yes, your are a great teacher & with a very good content. Thanks a lot.
Hey Tech you are awesome but pls could you do a macro video on sheets for a Chromebook I cants find it, also VBA🙏
Thank yu sooooo much for this tutorial now I have an idea how Macro Button and Categorizing by Color work.
This was a fantastic tutorial! Thank you so much!
This really new for me , and good to change between long and short videos .
Thank you
Simply brilliant.. so easy to understand and execute. Perfect for a beginner like me👏👏👏👏👏👏
Great video. Avi Deshmukh, MD.
Will like to support you, just pace down your your speech.
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... :/
I love Macros😍😍 and it saves lots of time!!
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 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?
Thank you. Ditto Jane Draisey. Great job explaining Macros.
Nice explanation, easy to understand.
Amazing video, great explanation and wooowww Excel, you can do things!! :) Thank you for your help by teaching us how to use this tool.
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!!!
This was very helpful. Thanks!
Great explanation, Thanks.
Very nice. Great teaching style.
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?
you have made my life so much easier thank you thank you
Super helpful! Thanks!
Wow! Great info here! Thanks!
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.
Hi can i make it for a big amount of worksheets to access from a single worksheets ?
That was , superb sir ! Thanks !
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..
Thanks sir lots of love💙
Nice Excel macros video for beginners
i want to cry, i can't believe you even have one on macros... ;-;
Very useful. Thank you.
Waooo..it looks simple,but so impressive... Thank you
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
I love it. I know better what are some of the functionalities of the Macros features.
This was a great learning for me. Thanks for making this video.
Can I lock or freeze that button as I scroll up and down?
Excellent presentation, and remarkable tips in how to use Excel.
Excellent tutorial. Thank you so much!
Wonderfully explained in a seamless and lucid mannee.
little by little I am learning macros...cheers!
Hi! This tutorial is amazing....simple to understand the complicated Macros. Why don't you start an online course on Excel? Just a suggestion.
Can you please show how can we combine multiple excel files to multiple excel sheets of single excel file using maco..like if we have 50 excel files to be combined to 50 excel sheets of single excel file..is it possiblle in macro?
nicely done.....thanks
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?
This tutorial is so amazing, thank you for this 😌😌😌
excellent vid, thanks for the simple and concise explanation
Thank you 💙
Where can I find excel worksheet to follow along with you?
Very well explained! Thank you so much! 🙌🙌🙌
Thank you for making it look so simple!
Is it working in Excel sheets?
Thank you, very useful
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.
how did you add shift in shortcut key
You are the man. Thank you so much
Thank you so much! This was really helpful.
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?
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!
Are there practice files for this video?
and how to delete the button or the macro?
can we hide (not display)the blue macro that you made while it still functioned?
Do you know how to make the clean data transfer from one page to another using macro?
Used this today.. Thank so much
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 :)
THANK YOU!!!!!
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?
Wow i really learned something useful today. great :)
Thanks a lot !
Can I add a Macro in Excel that if I click on it takes me to a word document?
Thumbs up for great explanation.
Your content is amazing, very practical
And to the point.
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?
V-E-R-Y G-O-O-D!!!
Thank you! you made it so simple to understand!
I found it interesting...I would love to have a video having examples with different set of data using macro recording..
Thank you alot for the tips.
It would be helpful if you keep the spreadsheets which are related to each video in the playlist.