How to Create Macros in Excel Tutorial

Подписаться 3 млн

Просмотров 1,5 млн

50% 1

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Learn how to create a Macro in Microsoft Excel in this step-by-step tutorial video. As full disclosure, I work at Microsoft as a full-time employee.
Find out how to enable the developer pivot, which allows you to record and run macros. Learn how to record a simple macro that formats a spreadsheet. Watch how to save your spreadsheet so you can access your macros again in the future.
See all Excel tutorial videos here: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
You can find the sheet that I used in this video here: 1drv.ms/x/s!AmxrofZZlZ-whIFRU...

Наука

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

29 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 662

@KevinStratvert 3 года назад

🤖 Learn even more about macros, including setting up if statements, loops, and much more in under one hour with this free tutorial video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IJQHMFLXk_c.html 🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@russianmusician 3 года назад

Hi! Can you do a tutorial of how to write more complex macros with variable numbers of samples?

@laurieyoung4022 3 года назад

@@russianmusician Yes! I need this too

@vyomapatel7131 3 года назад

Hi Kevin, actually when I opened this link it opened for PowerPoint. Can you please check. And thanks for this wonderful short video for introduction to Macros. Definitely, would like to learn more

@KevinStratvert 3 года назад

@@vyomapatel7131 Hmm, I just checked and it opens in Excel. Maybe try again? Thanks for the note!

@vyomapatel4271 3 года назад

@@KevinStratvert I tried opening but it displays playlist of powerpoint tips and tricks. And I am talking about the one which you've mentioned in comments for pivot tables and other stuffs. Anyways I have subscribed your channel so any playlist I can watch at anytime.:)

@veronicavids 5 месяцев назад

Thank you for filling this gap in my knowledge. I graduated with a bachelor's degree and a lot of us senior year came back from our internships and asked our professors to start including this in our curriculum because our competition had this knowledge and we felt behind.

@nushratmehjabin9850 Год назад

First I thought macros is something so difficult to learn, your video helped me to understand this under 10 mins... Thanks a lot ... Keep up the good work. :)

@abednego91 Год назад

There is coded macro, this is just recorded and it’s limited on what you can do.

@thescatterpiratesquarepant7935 5 месяцев назад

Coded macros are often just copy pasted and adjusted to your needs. Only very complex macros are hard and difficult to make. But even chatGPT or other AI are great at writing them for you.

@masia1950 2 года назад

Kevin, thanks again for a great tutorial. Learning macros for me has been a long time coming along with pivot tables. Your examples will help increase my confidence to know I can do this. 🙂

@manojdagar7346 4 года назад

Excellent!! Explained in a such a simple way, I learned in one view..Thanks. it will ease and save my time.

@christopherdonnelly1985 4 года назад

Your lesson was fantastic!! My favorite Excel teacher for sure!!

@BaranH 2 года назад

5 mins into it, i was able to figure out what i needed. Great video and very , i mean VERY CLEAR instructions and content! Thank you!

@christinehowell 2 года назад

Thank you for this. You always explain things so clearly. I'm familiar with Macros but it's useful to have this overview . I'm on a Mac and have Microsoft 365 for Macs but Power Query isn't available for Macs so I'm going to focus on macros as the next best alternative and your tutorials are going to be a great help.

@danielhill6978 3 года назад

Thanks for a great video. If MS isn’t sponsoring these, they should. I learned more in watching a few of your videos than I learned in over 20 years of using the products. These videos make the products so much more valuable to me. These short videos are a big improvement over the complicated tutorials of the past. Nice easy and methodical instruction that shows all the little nuances that you never got from the manuals and previous workshops. You’re an awesome teacher. Keep it up.

@harjybargy8002 4 года назад

Really loved your lesson. Can you go through a range of different types of macros from simple to intermediate to advanced.

@MrSpextacular187 3 года назад

Great tutorial, I start my first role since being made redundant due to Covid on Jan 4th and a big part of the job will include working on Excel so this is great! Thanks

@anthonykyei-barffour9203 2 года назад

This was so helpful, Kevin. Many thanks. Been cracking my brains on how to edit and update my macro enabled spreadsheets , and this came along. Bless you.

@Koonstheman Год назад

With respect, this is magical because it has been pre-prepared. It may be useful to explain potential pitfalls that don't require a PhD in Computer Science to understand the VBA coding. I consider myself a pretty advanced Excel user and simply cannot get the relative reference to work in a simple sorting procedure with multiple sets of similar columns. The results are utterly incomprehensible.

@omaribrahim7344 2 года назад

This guy is unbelievable, makes ANYTHING looks easy. Thank you Kevin.

@ajf9408 7 месяцев назад

The explanation was great, following along with the visuals was easy, and the whole thing was short and compact. Great job man. You have a gift for teaching and I hope that it continues to be utilized and rewarded.

@sandratripkovic6789 3 года назад

Thank you Kevin. I need Excel for my current job position and I have never used it that much. Your tutorials are helpful. :) Much appreciated.

@rawansafhi8756 Год назад

Thank you very much Mr. Stratvert your way of explaining the materials is organized, clear, simple, and understandable. I am very glad to discover your great channel

@jerilynn365 4 года назад

Thank you so very much Kevin. This tutorial speaks to my kind of language - Easy!!!! Huge help!!

@arunavabasak8330 3 года назад

Thak you Kevin, till now i'm using individual tools for different tasks, but after found your channel now i can do same tasks with MS Office, VLC, etc. You really make my job easy.Thanks again.

@DreamBigBeRamz Год назад

Wow, so easy! Your videos are leading me to land my first Analyst role! Thank you, Kevin!

@robincaruso2230 3 года назад

Thank you so much for the tutorial. Very brave of you to use your own info as an example. I'm older and new to this. I feel better with the security knowing you have that much faith to use your own personal info. Thank you very much for the informative video!!!

@sandyb.4490 3 года назад

Thank you for this awesome tutorial! Clear and easy to understand.

@DIYNate 11 месяцев назад

Excellent content, Kevin - appreciate your video and was thrilled to see you had a video on the topic of macros! I haven't spent much time with them but knew what they could do and how they can automate repetitive processes. Your tutorial was exactly the level of detail with a perfect explanation and walkthrough that I was looking for! Appreciate the great content, sir! - DIYNate

@bananibbal 4 года назад

Thank you so much for your help. Now I can tell my friends at school about what I learnt!

@phoebetongxinliu8506 2 года назад

Very straightforward and helpful, thanks for the tutorial

@monicacolino1641 4 года назад

THANK YOU! This just helped me immensely with one of my first work projects!

@jamessims3983 3 года назад

Thank you Kevin!! My Excel skills can just about stretch to pivot tables at the moment (LOL), however, in my new role I spend hours every morning / week pulling data from our systems into Excel and manipulating it into the format I need to present it. I really want to streamline the process and wondered if there is a way I can get the data to pull automatically, within certain parameters, from the systems we use and populate in the format I need. Happy to watch your videos if you have done one already on this :)

@CANIbirne 4 года назад

thanks so much for taking the time to record this video :)

@albou3172 4 года назад

This is awesome! OMG you just saved me so much time!! Thank you!!

@chggg567 2 года назад

Super! This is great succinct revision for me, I sort of forgot my two years ago macros knowledge as long time didn't use it. Now I'm back in action!

@airleclair 4 года назад

I had to do the Excel tutorials in LMS (former MS guy also), but it never sunk in. Thanks for the tutorial!

@dragonintheroom 3 года назад

Dude.... I was learning python to automate some repetitive "Soul Sucking" PDF form filling function at work, but after watching your videos I can do it all with MS office and Excel Macros!! Hot Diggity Dog!! Love your suggestions on how to use this new knowledge to your advantage. Personally, I'm just gonna, kick it back with some extra time with my kids. This is what RU-vid was meant for! Well at least for those who want to get ahead. Want you to know you have greatly and positively impacted another family's life with your video. Thank you!

@sujeetparsewar90 3 года назад

Amazing work!! Great learning experience. Thank you Kevin! Thank you Ruchi for recommending this video.

@89asimshah 4 года назад

Very simple and precise. Loved the last tip that to tell manager how hard the work is lolx. Thanks for sharing your knowledge.

@barbaramcclanahan1423 Год назад

Hi Kevin, Thank you this really helped me a great deal and to prepare for a job interview! Keep up the great work and keep it coming Sir!

@laurabutt2548 3 года назад

2nd vid of yours I've watched - both have been very helpful !!! Thank you for taking the time to do these tutorials.

@laurieyoung4022 3 года назад

GREAT Video! Straight forward and easy to understand. I have been looking for some good excel videos

@SnakeEyes291992 3 года назад

Hey Kevin, That was very helpful. I am preparing a pricing tool for my company.

@jennifersklener Год назад

Thank you. I was interviewing for some positions and this came up. Glad to see it was pretty straight forward.

@mummy_gen Месяц назад

I actually thought macros was difficult to learn, after watching this video I learned how to use macros 💯...a big thanks to you 🙏

@kanakvashisht3163 3 года назад

your tutorials always save me , these are so fun and easy . thankyouu so much

@js-bk6fm 3 года назад

This is by the far the easiest tutorial to follow thank you so much !!!!

@melissa2133 3 года назад

Thank you so much! Your lessons are so easy to follow along and understand!

@lakshyajhanmb22 3 года назад

you are just amazing, u did so well, i haven't feel any confusion.

@hibaabdirizak4452 Год назад

Best teacher, I really appreciate the way he makes things clear

@psychedupbruce 3 года назад

Geez Louise. I was so scared that macros would be difficult. Now I feel silly for not using them sooner. Thank you!

@crsytallee7489 Год назад

I can't believe I held off learning Macros for so long. You're the best!

@pushkarkothekar19492 2 года назад

I think this is one of the videos that explains Macros in the simplest way! Thanks @kevin

@lorenacarrasco4109 3 года назад

I appreciate your easy to understand explanations, the videos are digestable in small sections. Can you please create a household budget template tutorial, and how to keep it updated monthly, thank you!

@estelacordova2618 3 года назад

Hi Kevin, I hope you can add more videos regarding Macros, please? I love your tutorial strategies because it so easy to follow.

@cday728 3 года назад

Hi Kevin, I really enjoy your excel videos. Can you please teach us macros in depth. How to pull them up again and again everyday in different sheets, VBA etc

@yingjiaoxu8141 3 года назад

Clear and easy to understand! Thank you!

@kingofhearts2776 Год назад

Man you are absolutely a best teacher and this was what i wanted from begining and now i found it and it was very freakin simple

@khulekani_ndlovu 3 года назад

Thanks for this. This will help me with my monthly active directory audits where i have to manipulate large amounts of data.

@mommyof2431 3 года назад

so nicely explained. Love your work!

@sedarathnadcd 4 года назад

Thank you, it is simple but comprehensive.

@calculustv9125 4 года назад

pls when teaching take your time and explain, i enjoyed thank you

@geotech6 3 года назад

Thank you for posting this, macros can be time saving.

@iktrrosa7419 4 года назад

Thank you for sharing Kevin!

@krishaykarthick6529 3 года назад

THANKS YOU!This is the first time me trying macros well explained!

@user-zf4bn8bx2v 10 месяцев назад

Thank you for the video! That's so clearly and kindly explained :)! Looking forward to explore more of your content.

@rohitbhargava6090 2 года назад

Thanks Kevin... Awesome video... All scenarios explained in a simplified way

@michaeldushanin28 Год назад

Great tutorial. Very clear and easy to understand.

@michelleward4450 2 года назад

I may be a little late to the game but...OMG! Thank you for the tutorial. This is going to make things so much better.

@SisterGraphics Год назад

Great video so simple and to the point just the kind I love to learn from !!! Thank you

@ahmadimanimustafa1556 3 года назад

thanks bro..i received good performance review from my manager just because creating simple macro based on your tutorial..

@JMcGarryEX10 3 месяца назад

Thanks Kevin. Great job. Needed to revise and update my Macro skills and your inro video was perfect. 😊

@Avidcommentor32 3 года назад

This is beautiful. Thank you Kevin!

@mohammadislam3870 3 года назад

Thanks a lot Kevin. Nicely and very simple way you showed brother!!! Thanks again.

@mrmissmatch09 3 месяца назад

Always very helpful, plain and simple that any beginners can follow! Kudos!

@avpproduction381 3 года назад

Amazing. Thank you so much for this simple technique.

@ConniePloch Год назад

Awesome! Love the way you instruct us in cyberspace. Thank you!

@user-mq2sy6lf8i 2 года назад

Kevin thank you very much for the effort and your teaching method. Really helpful. Greetings from Athens, GR

@reneefuller1505 4 года назад

Thank you so much for this introductory tutorial! This was so helpful and clear.

@sudhac3044 4 года назад

Thank you Kevin, you made it more simple

@ehsanurrahman921 2 года назад

Simple instruction but does the job 100%. Thanks

@naaemahnaylor2806 4 года назад

Thank you so much Kevin. You have saved hours for me.

@JolliAllGenGamer 3 года назад

Very helpful. Need a refresher in my job I am starting to look and create a macro.

@workmydestiny4331 25 дней назад

Thankyou for explaining in such a easy way.. your video was really helpful for me.. god bless you..and thankyou again

@raedabuhamad6547 3 года назад

Thanks dude, this video was great. Very informative & nice presentation! Have a great one!

@mellisabotha6871 Год назад

The easiest tutorial I have ever seen, thank you!

@melaninpoppin8175 3 года назад

I needed this thank you!

@mohammedhassanali9511 5 месяцев назад

Thanks Kevin. This is my first time. Will look up for more tutorials on Macro

@ChelynPereira 2 месяца назад

Hello Kevin... Thank you for your video tutorial... It was easy to understand the basics of macros

@SathyaSandy1 3 года назад

I just tried the tricks which was showed, and it's really worked well. Thanks for ur tutorial

@ezekielisiah-wp7197 3 года назад

Great video. I knew they were easy to make but this made it very clear

@leechengng1412 4 года назад

Excellent! Good guide, appreciate it!

@alnseven4244 4 года назад

Thank you!!! Could you cover Pivot Tables and their uses?

@kksal4375 4 года назад

Great video!!! Thank you for sharing

@user-uh5wy1si9b 11 месяцев назад

Easy to understand. I thought so difficult but u made it very easy. Thank you

@Bahraini1970 4 года назад

Very nice ..very good simple tutorial for beginners ..keep up 👍👍

@sushmaraskar268 Месяц назад

Thank you..the way you explain its very easy than I imagined

@angelalu3172 4 года назад

Thank you so much for this great help!

@BobG-eh5fc 3 года назад

I created macro based on your video... thanks. Forgot about the use Relative reference!!! Very valuable.

@maryamfatima5882 Год назад

thank you so much for the video as well for the attachment. I tried with the data you have given and have successfully done it.

@keizaKutos 2 года назад

Thanks Kevin for the lesson. I love them

@jeshmoonsamy 3 года назад

brilliant explanation, was easy to follow, Thank you

@stephaniebanks122 3 года назад

Dude you are alright, it's like going to school. Great teacher.

@azharmohammed4638 3 года назад

Excellent.....Wow.. A very simplified and good explanation...It is really helping my now in practicing some stuff

@XLLearner_Courses 8 месяцев назад

Simple and clear explanation 👍

@violetd333 5 месяцев назад

That was super helpful ty kevin