How to Create Macros in Excel Tutorial

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.

[veronicasvideodiaries]

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.

[nushratmehjabin]

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

[masia]

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

[danielhill]

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.

[manojdagar]

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

[BaranH]

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!

[christopherdonnelly]

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

[christinehowell]

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.

[anthonykyei-barffour]

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.

[omaribrahim]

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

[ajf]

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.

[harjybargy]

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

[solocool.]

I just told an interviewer that I don't know what macro is, although I told her I can learn it within a Day.

I just stepped out, and googled it.
Boom 💥, I saw your video and I learnt it within 10 mins.

I don't know what are your heart desires.

May GOD BE With YOU

[rawansafhi]

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

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

[sandratripkovic]

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.

[MrSpextacular]

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

[arunavabasak]

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.

[robincaruso]

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

[jerilynn]

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