CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX202 - Microsoft Excel 2000 Charting and Organizing Data

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 learn the skills and concepts necessary to begin using the charting and list-management capabilities of Excel 2000.

Prerequisites

Excel Level 1 or equivalent knowledge

Detailed Class Syllabus

Creating Charts

Creating a Chart Sheet

Creating an Embedded Chart

Comparing Chart Sheets with Embedded Charts

Modifying Charts

Chart Types

Modifying Embedded Charts

Adding and Deleting Chart Items

Moving and Sizing Chart Items

Formatting a Chart

Formatting Chart Text

Formatting Labels

Formatting the Chart

Printing a Chart Sheet

Using Graphic Objects

Adding Graphic Objects

Formatting Graphic Objects

Using Graphic Objects to Enhance Worksheets and Charts

Sorting Data

Single-level Sorting

Multiple-level Sorting

Sorting Options

Importing Data

Design Considerations

Filtering Data

Filtering a List

Custom Criteria

Multiple-condition Criteria

Managing a Filtered List