Community Course

Amazing Macros (Microsoft Excel 2007/2010)

50476BC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Amazing Macros (Microsoft Excel 2007/2010)
This one-day course introduces Microsoft Excel 2007/2010 users to the features in creating and managing Excel macro. Participants will learn how to record macro, execute macros in variety of different methods, editing macro and creating a control buttons to activiate the macros.
Please contact your Learning Partner in order to take this course
Author: COMAT Training Services

Course Duration: 1 Days

SATV: No

About This Course

This one-day course introduces Microsoft Excel 2007/2010 users to the features in creating and managing Excel macro. Participants will learn how to record macro, execute macros in variety of different methods, editing macro and creating a control buttons to activiate the macros.

Audience Profile

Aimed at information workers who need to learn more in-depth on the techniques of creating time saving Microsoft Excel® macros.

At Course Completion

  • Open a Workbook Containing Macros
  • Run a Macro
  • Use a Shortcut Key
  • Open the Visual Basic for Application Editor Window
  • Record a Macro
  • Assign a Shortcut Key
  • Use Relative References
  • Writing New Macro
  • Assign a Custom Button to QAT
  • Delete a Custom Button from QAT
  • Delete a Macro
  • Assign a Macro to a Button
  • Create a Macro Button
  • Use a Macro Button
  • Create a Macro Button
  • Copy a Macro Button
  • Format a Macro Button
  • Using Form Control