Amazing Macros in Excel

One Day • Instructor Led

This one-day course introduces Microsoft Excel users to the features in creating and managing Excel macros. Participants will learn how to record macros, execute macros using various methods, edit macros and create control buttons to activate the macros.

Prerequisites

To ensure your success, we recommend you first take Microsoft Excel Level 1 and Microsoft Excel Level 2 or have equivalent knowledge to be an intermediate level user of Excel.

Course Outline

Lesson 1: Using Macros

  • Defining Macros
  • Opening a Workbook Containing Macros
  • Enabling Macro via Trust Center Setting
  • Using Developer Tab
  • Running a Macro

Lesson 2: Recording Macros

  • Recording a Macro
  • Assigning a Shortcut Key
  • Deleting a Macro

Lesson 3: Editing Macros

  • Writing a new Macro
  • Entering Macro Comments
  • Copying Macro Commands
  • Typing Macro Commands

Lesson 4: Custom Button in Quick Access Toolbar

  • Create a Custom Button
  • Assign a Macro Button to Quick Access Toolbar
  • Change a Button Image
  • Delete Custom Button

Lesson 5: Adding Form Controls to a Worksheet

  • Using Forms Controls
  • Create Macro Button
  • Formatting a Macro Button
  • Rename a Macro Button
  • Deleting a Macro Button
  • Create Scroll Bar Control

View all upcoming classes