Excel 2003 : Level 3

Excel 2003: Level 3

Course Description

Overview: Students will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Prerequisites: Windows 2000 or Windows XP; Excel 2003: Level 1; Excel 2003: Level 2; or equivalent knowledge.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

customize workbooks.
collaborate with others using workbooks.
audit worksheets.
analyze data.
work with multiple workbooks.
import and export data.
structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

Create a Macro

Edit a Macro

Customize Access to Excel Commands

Apply Conditional Formatting

Add Data Validation Criteria

Update a Workbook's Properties

Modify Excel's Default Settings

Lesson 2: Collaborating with Others

Protect Files

Share a Workbook

Set Revision Tracking

Review Tracked Revisions

Merge Workbooks

Adjust Macro Settings

Administer Digital Signatures

Lesson 3: Auditing Worksheets

Trace Cell Precedents

Trace Cell Dependents

Locate Errors in Formulas

Locate Invalid Data and Formulas

Watch and Evaluate Formulas

Group and Outline Data

Lesson 4: Analyzing Data

Create a Trendline

Create Scenarios

Perform What-If Analysis

Develop a PivotTable© Report

Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

Create a Workspace

Consolidate Data

Link Cells in Different Workbooks

Edit Links

Lesson 6: Importing and Exporting Data

Export to Microsoft Word

Import a Word Table

Import Text Files

Lesson 7: Structuring XML Workbooks

Develop XML Maps

Import, Add, and Export XML Data

Manage XML Workbooks

Apply XML View Options