Amazing Macros (Microsoft Excel 2007 & 2010)
Course Specifications
Course number:50476
Course length:1.0 day(s)
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.