Course 50476-B: 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 activate the macros.

Audience profile

This course is intended for Information workers who have an understanding of Microsoft Office Excel 2003/2007/2010.

Job role: Developer

Skills gained

  • Use Macros
  • Record Macros
  • Editing simple commands
  • Customizing Quick Access Toolbar and buttons
  • Adding Forms Controls to a Worksheet

Prerequisites

Before attending this course, students must have:

  • This course assumes that students have some familiarity with Excel.

Course outline

Module 1: Using Macros

This module gives the introduction of how to execute Macros.

Lessons

  • 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

Lab : Using Macros

After completing this module, students will be able to:

  • Understand how to execute Macros.

Module 2: Recording Macros

This module explains how to create Macros through usage of recording.

Lessons

  • Using the Developer Tab
  • Recording a Macro
  • Assigning a Shortcut Key
  • Using Relative References
  • Delet...