Course Description:
Learn Excel from the comfort of your office or home.
This three-hour LIVE Instructor-led course will introduce you to macro creation. Many repetitive tasks can be simplified by creating a macro. This course will give you the tools to automate repetitive tasks. We will use the macro recorder to simplify keystrokes. We will also introduce how to use the Visual Basic Editor to modify a macro, declare variables, add remarks, and prompt users for input.
Prerequisites
Basic knowledge of Excel is recommended
Course Outline:
- Display Developer Ribbon & Customize Quick Access Toolbar
- Create and Use Personal Macros
- Record a Personal Macro
- Add Personal Macro to Quick Access Toolbar
- Modify a Personal Macro in the Visual Basic Editor
- Explore Differences in Absolute and Relative Reference Macros
- Create a Relative Macro
- Create an Absolute Macro
- Create and Use Workbook Macros
- Record Workbook Macros
- Add a Macro Button to Current Workbook’s Quick Access Toolbar
- Create Macro Buttons on Current Worksheet
- Use the Visual Basic Editor to Declare Variables, Add Remarks and Prompt for User Input
- Create an If..then..else statement in the Visual Basic Editor