Excel Amazing Macros

Course Objectives

• 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
• Use custom toolbars and buttons
• Create a custom toolbar
• Add a button to a toolbar
• Add a custom button
• Assign a macro to a button
• Change a button image
• Display button text and images
• Attach a custom toolbar
• Delete a custom toolbar
• Create a macro button
• Use a macro button
• Create a macro button
• Copy a macro button

Target Audience

This course is intended for information workers who need to learn more in-depth techniques for creating time saving Excel macros

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and
practical exercise

Course Modules

Module 1 – Using Macros
Module 2 – Recording Macros
Module 3 – Editing Macros
Module 4 – Custom Button In Quick Access Toolbar
Module 5 – Adding Custom Controls to a Worksheet