Amazing Macros (50476)
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 1 day
Objectives :
This one-day course introduces Microsoft Excel 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.
Course Details :
Les stagiaires seront à même d'effectuer les tâches suivantes :
Requirements:
Before attending this course, students must have:
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 1 day
Objectives :
This one-day course introduces Microsoft Excel 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.
Course Details :
Les stagiaires seront à même d'effectuer les tâches suivantes :
- Understand how to execute Macros
- Record Macros.
- Assign Shortcut Key to Macro.
- Using Relative Reference in Macro Recording
- Write simple Macro commands.
- Create message box.
- Insert comments
- Use custom button in Quick Access Toolbar.
- Assign Macro to custom button.
- Delete custom button
- Create forms control for a Macro.
- Format Macro button.
- Delete Macro button.
Requirements:
Before attending this course, students must have:
- Intermediate Excel experience