Amazing Macros (50476)
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 1 jour
Objectifs du cours :
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.
Compétences acquises :
Les stagiaires seront à même d'effectuer les tâches suivantes :
Connaissances requises :
Before attending this course, students must have:
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 1 jour
Objectifs du cours :
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.
Compétences acquises :
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.
Connaissances requises :
Before attending this course, students must have:
- Intermediate Excel experience