Course Length: 1 day
Prerequisites: Basic knowledge of Excel 2000
Certification: MOUS 2000
Product code: EXCL2KUP4LG

This one day instructor-led course presents the customization and macro features of Excel 2000. You will be introduced to Excel features and the steps required to use the features correctly. The Learning Guide includes an exercise CD containing the exercise files used in class.

What’s in Excel 2000:Customizing Excel and Using Macros?

This course teaches you how to customize Excel workspaces and startup, collaborate with Workgroups, use AutoFormat in worksheets and charts, control and edit macros, run macros from menus and buttons, make macros interactive, use break mode, and step through macros.

Why do I need Excel 2000:Customizing Excel and Using Macros?

• • Provides skills necessary to become MOUS certified.
  • Provides students with an overview of Excel 2000 features.
  • Provides hands-on experience using Excel 2000.

 

Lesson 1: Customizing Excel Workspaces

Setting Options
Customizing Toolbars
Arranging and Saving Workspaces

Lesson 2: Customizing Startup

Opening Workbooks at Startup
Opening Custom Worspaces at Startup
Creating Desktop Icons

Lesson 3: Collaborating with Workgroups

Creating Templates
Editing Templates
Creating AutoTemplates
Collaborating with Workgroups

Lesson 4: Using AutoFormats in Worksheets and Charts

Using Built-in AutoFormats
Creating Custom Chart Formats

Lesson 5: Controlling Macros

Controlling Macro Cell references
Saving Macros for Selective Use

 

 

 

Lesson 6: Editing Macros

Opening the Visual Basic Environment
Inserting Procedures
Finding and Replacing Code
Deleting and Copying Code
Adding Comments

Lesson 7: Running Macros from Menus and Buttons

Assigning Macros to the Menu Bar
Assigning Macros to Toolbar Buttons
Assigning Macros to Worksheet Buttons
Changing Assigned Macros

Lesson 8: Making Macros Interactive

Displaying Dialog Boxes in Macros
Displaying Message Boxes in Macros

Lesson 9: Using Break Mode

Inserting Breakpoints
Inserting Stop Statements

Lesson 10: Stepping Through Macros

Stepping over Procedures
Stepping into Procedures