Excel 2003 - Level 3

You Will Learn To

Apply advanced data analysis and manipulation techniques; automate spreadsheets using macros

Who Should Attend

Excel users already familiar with editing and formatting data in Excel.

Course Content

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

Collaborating with Others

• Protect Files

• Share a Workbook

• Set Revision Tracking

• Review Tracked Revisions

• Merge Workbooks

• Adjust Macro Settings

• Administer Digital Signatures

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

Analyzing Data

• Create a Trendline

• Create Scenarios

• Perform What-If Analysis

• Develop a PivotTable© Report

• Develop a PivotChart© Report

• Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

• Create a Workspace

• Consolidate Data

• Link Cells in Different Workbooks

• Edit Links

Importing and Exporting Data

• Export to Microsoft Word

• Import a Word Table

• Import Text Files

Structuring XML Workbooks

• Develop XML Maps

• Import, Add, and Export XML Data

• Manage XML Workbooks

• Apply XML View Options