Course description: Learn advanced formulas and work with various tools to analyze data in spreadsheets specifically using Macros.
Category: Productivity & Software
Price: $130.00
Target audience: All Faculty, Managers and Staff who are interested in learning skills to create and modify Excel workbooks.
By the end of the workshop participants will:
Working with Macros
- The Record Macro Window
- Rules for Macro Names
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Executing a Macro
- Creating a Macro Button
- Working with Macro Buttons
Configuring Excel for Macros
- The Developer Tab
- Macro Security
- Trust Center
- Saving Files
Running Macros
- Running a Macro from the Developer Tab
- Running a Macro Using a Shortcut Key
- Running a Macro from a Button
Creating Dynamic Macros
- Absolute versus Relative References