Excel Advanced - Protecting and Automating Worksheets

Save time - automate as much as possible and protect what you have created. Learn ways to protect cells, comments or entire worksheets. Combine protection with the use of templates to create on-line forms. Learn to record macros to perform frequent routines. Customize options, toolbars and menus for greater efficiency.

Participants should use Excel regularly on an intermediate level.

Module 1: Protecting Worksheets

• Protecting cells
• Protecting comments
• Protecting sheets
• Passwords
  

Module 2: Creating Templates

• Building a template
• Editing and saving a template
• Adding protection to templates

Module 3: On-line Forms

• Using templates
• Changing templates

Module 4: Recording Macros

• Recording macros
• Saving macros
• Running macros
• Creating macro buttons

Module 5: Customizing Excel for More Efficiency

• Changing Defaults
• Options available to users
• Customizing Toolbars
• Customizing Menus