Excel 2010-Using Macros

About the Class:

This workshop lasts 90 minutes.

Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel 2010, how to make them easily available, and how to share their recorded macros with other Excel users.

What You’ll Learn:

  • Create simple macros to automate complex actions
  • Learn about macro security issues
  • Assign a macro to the Quick Access toolbar and a keyboard shortcut
  • Edit macros
  • Make macros available to other workbooks and users

What You Need to Know:

  • Create and rename subtotals
  • Enter data into cells
  • Use built-in functions
  • Sort and filter lists

If you don’t have those skills, consider first taking the workshop:

  • Excel 2010 – Data Management

Resources

Excel 2010(PC) Excel 2011(Mac)
Microsoft Office (Video): Create a Simple Macro Microsoft Office: Create, Run, or Delete a Macro
 Microsoft Office: Edit a Macro Microsoft Office: Enable or Disable Macros