Course Details
Course Code: 50476; Instructor-led
Audience
This course is intended for information workers who need to learn more in-depth techniques for creating time saving Excel macros
Prerequisites
Before attending this course, students must have:
- At least one-year intermediate experience using Excel 2000 or 2002
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussions, and practical exercise
Course Objectives
Upon completion of this program, participants should be able to:
- Open a workbook containing macros
- Run a macro
- Use a shortcut key
- Use the Microsoft Visual Basic toolbar
- Open the Visual Basic Editor window
- Use the Visual Basic Editor window
- Record a macro
- Assign a shortcut key
- Use relative references
- Assign a macro to a menu
- Delete a macro from a menu
- Delete a macro
Outlines
Module 1: Using Macros
- This module explains how to run Excel macros. Topics such as how to set macro security, run a macro with shortcut keys, and use the Visual Basic toolbar to run the macros are discussed
Lessons
- Automate Tasks with Macros
- Set Macro Security
- Run a Macro
- Run a Macro Using a Shortcut Key
- Use the Visual Basic Toolbar
After completing this module, students will be able to:
- Configure the proper macro security settings to run a macro in Excel
Module 2: Recording Macros
This module explains how to create a macro easily using the record macro feature. Students learn how to set a shortcut key and record a macro using relative reference. Students are also shown how to delete a macro from a file or in the Personal Macro Workbook
Lessons
- Record a Macro
- Assign a Shortcut Key
- Record a Macro that Uses Relative Referencing
- Delete a Macro
- Delete a Macro Stored in a Personal Macro Workbook
After completing this module, students will be able to:
- Record and delete a macro in a file or Personal Macro Workbook
- Assign a shortcut key and switch to relative referencing when recording a macro
Module 3: Editing Macros
This module explains how to use the Visual Basic window in editing a macro. Students will learn how to edit current macros, copy macro commands, and write a new macro. Students will also learn how to run a macro from the code window
Lessons
- Open the Visual Basic Window
- Use Visual Basic Editor
- Edit Macro Commands
- Copy Macro Commands
- Write a New Macro
- Run a Macro from the Code Window
After completing this module, students will be able to:
- Describe the Visual Basic window to edit and write new macros
Module 4: Using Custom Toolbars and Menus
This module explains how to create a custom toolbar with custom buttons to run your macro. Students will also learn how to create a custom menu with custom menu items to execute the macros
Lessons
- Create a Custom Toolbar
- Add Toolbar Buttons
- Assign a Macro to a Custom Button
- Change a Button Image
- Display Button Text and Image
- Attach a Custom Toolbar to a Workbook
- Delete a Custom Toolbar
- Create a Custom Menu
- Add Custom Menu Commands
After completing this module, students will be able to:
- Describe two valuable ways of executing macros by customizing toolbars and menus
Module 5: Adding Custom Controls to a Worksheet
This module explains how to create custom controls such as combo boxes, scrollbars, and option buttons to enhance your spreadsheet
Lessons
- Add Custom Controls to a Worksheet
- Work with Macro Buttons
- Create a Combo Box Control
- Use a Spinner Control
- Create a Scroll Bar Control
- Create an Option Buttons Control
After completing this module, students will be able to:
- Create custom controls that help automate tasks in your spreadsheet
