Course Overview
Target audiences
- Aimed at information workers who need to learn more in-depth on the techniques of creating time saving Microsoft Excel® macros.
Schedule Dates
Curriculum
-
Module 1: Using Macros
This module explains how to run a Microsoft Excel® macros. Topics such as how to set macro security, running a macro with shortcut keys and using the visual basic toolbar to run the macro is discussed.
-
Module 2: Recording Macros
This module explains how to create Macros through usage of recording.
-
Module 3: Editing Macros
This module explains how to edit macro in the Visual Basic for Application Editor.
-
Module 4: Custom Button In Quick Access Toolbar
This module explains how to assign custom button in QAT.
-
Module 5: Adding Form Controls To A Worksheet
This module explains how to add and work with form controls to worksheet.