Amazing Macros (Microsoft Excel 2007 & 2010)

50476: Amazing Macros (Microsoft Excel 2007 & 2010) (1 Day)

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 activate the macros.

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

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

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

Lab : Recording Macros

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

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 : Editing Macros

After completing this module, students will be able to:

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

Module 4: Custom Button in Quick Access Toolbar

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 : Custom Button in Quick Access Toolbar

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

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 : Adding Forms Controls to a Worksheet

After completing this module, students will be able to:

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

Before attending this course, students must have:

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