Excel 2003 Level 3

1 Day Course
Hands On
Code DEX03L3

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Streamlining Workflow (7 topics)

  • 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 (7 topics)

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Adjust Macro Settings
  • Administer Digital Signatures

Auditing Worksheets (6 topics)

  • 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 (6 topics)

  • 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 (4 topics)

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data (3 topics)

  • Export to Microsoft Word
  • Import a Word Table
  • Import Text Files

Structuring XML Workbooks (4 topics)

  • Develop XML Maps
  • Import, Add, and Export XML Data
  • Manage XML Workbooks
  • Apply XML View Options

Prerequisites

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Sections