About MArco in Excel 2010

Save time by creating and running macros in Excel 2010

https://support.office.com/en-au/article/Save-time-by-creating-and-running-macros-in-Excel-2010-45c3e78e-9396-4476-967d-653174b5f7f3

HQ

3:19/5:50

• • 
  • 1
  • 5:50
  • Create and run macros in Excel 2010
 
• • 
  • 2
  • 4:33
  • Edit an existing macro to change what it does
 
• • 
  • 3
  • 3:32
  • Save my macro in the Personal Workbook
 
• • 
  • 4
  • 3:18
  • Assign a button to my macro

Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do that repetitive work for you? Macros are sets of instructions based on actions that you record while you work in your spreadsheet. After you record a macro, you can use it again as the need arises.

Goals

After completing this course you will be able to:

• Create a macro by using the Macro Recorder.
• Run the macro that you recorded.
• Make some minor changes to the macro by using the Visual Basic Editor in Excel.
• Save the macro to your personal macro workbook and assign a button to it.

Practice

We’re sorry, the practice session is not available.

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.