Work with macros

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You want to automate a repetitive task in Excel so that you can do the task again with a single click. The best way to do that? Record a macro. And the macro recorder is the easiest way to create a new macro in Excel. Take this course to learn more.

Inside this course:

Work with macros (5:08)
The best way to automate a repetitive task in Excel so that you can do the task again with a single click? Record a macro.

Edit a macro (3:29)
Watch this video to see how to edit a macro in a special text editor called the Visual Basic Editor. Visual Basic is the programming language that macros are recorded in.

Save your macro (3:09)
To make sure your macro is always available on your computer, save it to your Personal Macro Workbook, which is a special hidden workbook that loads every time you start Excel.

Assign a button to a macro (2:55)
In this final video, we’ll hook the macro up with a button and make it available in two places: In a custom group on the Developer tab, and on the Quick Access Toolbar.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Applies To: Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language