CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX033 - Microsoft Office Excel 2003 Level 3

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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.

Click here for a printer-friendly version of this page

Prerequisites

Course APEX032: Microsoft Office Excel 2003 Level 2 or equivalent knowledge

Detailed Class Syllabus

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

Develop a PivotChart 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