Work with macros

Work with macros

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.

Level:
Length:
Rating:
Applies to:
File Size:

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.