Microsoft Excel 2003, 2002, 2000 Level 3

1 Day Training Class

Performance-based objectives of this Microsoft Excel training class:

• Customize toolbars and create styles and templates.
• Create decision-making functions.
• Analyze worksheet data by creating pivot tables.
• Compare and contrast workbook files and file links.
• Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.
• Create and work with interactive Web documents.

Training Course Content:

Lesson 1: Customizing the Work Area

• Working with Built-in Toolbars
• Using Custom Toolbars
• Creating and Using Styles
• Using Templates

Lesson 2: Advanced Formula Construction

• Using Names
• Using the IF Function
• Using the VLOOKUP Function
• Using IS Functions and the Auditing Features

Lesson 3: Using Pivot Tables

• Creating Pivot Tables
• Modifying Pivot Tables
• Grouping and Summarizing Data in a Pivot Table
• Creating Interactive Pivot Tables for the Web

Lesson 4: Working with Multiple Worksheets

• Working with Workbooks
• Linking Cells in Different Workbooks
• Workbook Versus Links and Workspaces
• Sharing and Merging Workbooks

Lesson 5: Consolidating and Analyzing Data

• Consolidating Data from More Than One Worksheet
• Using the Goal Seek and Solver Utilities
• Using Scenario Manager to View a Worksheet with Different Input Values

Lesson 6: Using Protection and Display Options

• Using Comments
• Protecting Workbooks
• Using Custom Views

Lesson 7: Introduction to Macros

• Running Macros
• Recording a Macro
• Viewing and Editing VBA Code

Lesson 8: Working with Interactive Excel Web Documents

• Saving Excel Worksheets as Web Documents
• Spreadsheet Web Components

Microsoft Excel classes. Training the Nashville and Murfreesboro areas.