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.
Prerequisites
Before attending this course, students must have:
This course assumes that students have some familiarity with Excel.
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
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.
:: Course 50476A ::
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.
:: Course 50476A ::
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.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.