Course Code: 5601

50476 - Excel Amazing Macros

Class Dates:
1/9/2019
3/12/2019
Length:
1 Days
Cost:
$295.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • 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
  • Aimed at information workers who need to learn more in-depth on the techniques of creating time saving Microsoft Excel® macros.

Prerequisites

Course Details

  • 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
  • Module 1: Using Macros
  • Opening a Workbook Containing Macros
  • Running a Macro
  • Using a Shortcut Key
  • Using the Visual Basic Toolbar
  • Opening the Visual Basic Application Window
  • Using the Visual Basic Application Window
  • Module 2: Recording Macros
  • Recording a Macro
  • Assigning a Shortcut Key
  • Using Relative References
  • Deleting a Macro
  • Module 3: Editng Macros
  • Writing a New Macro
  • Entering Macro Comments
  • Copying Macro Commands
  • Editing Macro Commands
  • Typing Macro Commands
  • Running a Macro from the Code Window
  • Using the Debugger
  • Module 4: Custom Button In Quick Access Toolbar
  • Create a custom button
  • Adding a button to Quick Access Toolbar
  • Change a button image
  • Delete a custom button
  • Module 5: Adding Form Controls To A Worksheet
  • Create a Macro button
  • Copy a Macro button
  • Assign Macro to Pasted Macro
  • Format a Macro button
  • Rename a Macro button
  • Moving/Sizing a Macro button
  • Deleting a Macro button