Course 50476-B: Amazing Macros (Microsoft Excel 2007 & 2010)

Microsoft

Course 50476-B: Amazing Macros (Microsoft Excel 2007 & 2010)

Share This Learning Path

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.

Prerequisites

Course outline

Module 1: Using Macros

Module Overview

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 Sessions

Using Macros

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand how to execute Macros.

Module 2: Recording Macros

Module Overview

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
Deleting a Macro

Lab Sessions

Recording Macros

Lab Lessons

Recording a Macro
Deleting Macro

After completing this module, students will be able to:

Record Macros.
Assign Shortcut Key to Macro.
Using Relative Reference in Macro Recording.

Module 3: Editing Macros

Module Overview

This module explains how to start editing simple commands within the Visual Basic Editor.

Lessons

Writing a New Macro
Entering Macro Comments
Copying Macro Commands
Editing Macro Commands
Typing Macro Commands
Create Message box
Running Macro from the Code Window
Using the Debugger

Lab Sessions

Editing Macros

Lab Lessons

Editing Macro Commands

After completing this module, students will be able to:

Write simple Macro commands.
Create message box.
Insert comments.

Module Overview

This module demonstrate how to create custom buttons in the Quick Access Toolbar.

Lessons

Creating a custom button
Adding a button to Quick Access Toolbar
Assigning a Macro to a button
Changing a button image
Deleting a custom button

Lab Sessions

Custom Button in Quick Access Toolbar

Lab Lessons

Adding custom Button in QAT

After completing this module, students will be able to:

Use custom button in Quick Access Toolbar.
Assign Macro to custom button.
Delete custom button.

Module 5: Adding Forms Controls to a Worksheet

Module Overview

This module explains how to create forms control onto a worksheet.

Lessons

Creating a Macro Button
Copying a Macro Button
Formatting a Macro Button
Moving/Sizing a Macro Button
Deleting a Macro Button

Lab Sessions

Adding Forms Controls to a Worksheet

Lab Lessons

Create a Macro button

After completing this module, students will be able to:

Create forms control for a Macro.
Format Macro button.
Delete Macro button.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center