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
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.
Module 2: Recording Macros
:: Course 50476A ::
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
:: Course 50476A ::
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.