Excel Macros

Prerequisites:Students Looking to take this course should have taken an introduction to computers class, Excel Level 1-3 or the equivelant knowledge.

Customizing Excel
 · Setting Options
 · Customizing Toolbars
 · Customizing Menus and Toolbars
 · Creating Custom Toolbars
 · Toolbar Buttons
 · Resetting Toolbars
 · Saving Workspaces

Customizing Startup
 · Opening Workbooks at Startup
 · Workspaces at Startup

Collaborating
 · Creating Templates
 · Editing Templates
 · Creating AutoTemplates
 · Workbook Properties
 · Shared Workbook
 · Viewing Tracked Changes
 · Accepting and Rejecting Changes

Using AutoFormats
 · Built-in AutoFormats
 · AutoFormats and Worksheets
 · AutoFormats and Charts
 · Custom Chart Formats

Macros
 · Recording Macros
 · Controlling Macro Cell References
 · Absolute Cell Referencing
 · Relative Cell Referencing
 · Saving Macros for Selective Use
 · Personal Macro Workbook
 · Saving Macros in a New Workbook

Editing Macros
 · Visual Basic Environment
 · Inserting Procedures
 · Finding and Replacing Code
 · Adding Comments

Running Macros
 · From the Menu Bar
 · Assigning to Toolbar Buttons
 · Assigning to Built-in Buttons
 · Assigning to Custom Buttons
 · Macros to Worksheet Buttons
 · Changing Assigned Macros

Making Macros Interactive
 · Displaying Dialog Boxes in Macros
 · Displaying Message Boxes in Macros

Stepping Through Macros
 · Stepping Over Procedure
 · Stepping into Procedures



Close this Window

SiliconBay Training
4847 Hopyard Rd Suite #4165
Pleasanton, CA 94588
Phone: (925) 462-3277