Elert & Associates Technology Training
Home About Services Delivery Methods Courseware Testimonials Contact Us
Student Links Register for a Class Course Catalog Student Resources

Excel Automating Tasks with Macros

Objective

Learn to record macros to automate various Excel tasks.

Prerequisite Skills

Course Description

Do you frequently perform the same tasks in Excel? Learn various ways to save time and steps by recording macros.

Attend this course if you want to:

  • Learn various ways that macros can be used.

  • Enable macro security in Excel.

  • Record a macro.

  • Understand absolute vs. relative recording.

  • Save a workbook that contains macros.

  • Open workbooks containing macros.

  • Run a macro from the Macros dialog box or from a shortcut key.

  • View and modify macros.

  • Work with the Personal Macro Workbook.

  • Assign existing macros to shortcut keys or to the Quick Access toolbar.

  • Assign a macro to an object on the worksheet.

  • Delete macros.

  • Create a macro that runs when you open a workbook.

Class Length

90 minutes

Delivery Options

  • Virtual classroom - public
    ($70 per student; check times and register here)

  • Virtual classroom - private (up to ten people from the same organization)
    ($480 per class; contact us for more details)

  • On-site instructor-led
    (Contact us for details)

 

   

   

   Print this page without top and side navigation

View a virtual classroom demo