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.
Other videos in this course
This video is part of a training course called Work with macros. You can download the entire course or watch the videos online:
- Video: Work with macros. (You are here!) 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.
- Video: Edit a macro. 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.
- Video: Save your macro. 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.
- Video: Assign a button to a macro. 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.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.