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.
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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.