Training: Excel – The macro recorder and introduction to VBA

Module 1: The Macro Recorder

• Displaying the Developer tab
• Creating a macro through the macro recorder
• Running recorded macros
• Saving macros in the personal macro folder

Module 2: The Visual Basic Editor

• Using the Visual Basic Editor in Excel
• Using relative references
• Deleting macros

Module 3: Using your macros

• Creating a new ribbon
• Adding a Macro to a Ribbon
• Adding a macro to the Quick Access Toolbar
• Assigning a macro to an object, a button or a control