Excel 97: Charting and Organizing Data

Course length: 1 day

Course description

Overview: Students will build upon the skills learned in Excel 97: Worksheets to learn the methods and concepts necessary to create charts and to use the list-management capabilities of Excel 97. This course meets the Microsoft Proficiency Guidelines for Excel at the Expert level.

Prerequisites: To ensure your continued success, students must first take the Software Training course, Excel 97: Worksheets, and have a good working knowledge of the Windows 98 environment.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to represent data graphically and maintain and manage lists.

Target student: Students enrolling in this course should understand data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.

What's next: Excel 97: Charting and Organizing Data is the second course in this series. Students can take the Software Training course Excel 97: Advanced to learn advanced features.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• Create charts that graphically represent worksheet data.
• Modify charts.
• Customize charts by applying formatting.
• Enhance worksheets and charts by using the drawing tools to add graphic objects.
• Sort information in a list by using the Data, Sort command.
• Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.

Course content

Lesson 1: Creating charts

Creating a chart sheet

Creating an embedded chart

Comparing chart sheets with embedded charts

Lesson 2: Modifying charts

Chart types

Modifying embedded charts

Adding and deleting chart items

Moving and sizing chart items

Lesson 3: Formatting a chart

Formatting chart text

Formatting numbers

Formatting the chart

Printing a chart sheet

Lesson 4: Using graphic objects

Adding graphic objects

Formatting graphic objects

Using graphic objects to enhance worksheets and charts

Lesson 5: Sorting data

Single-level sorting

Multiple-level sorting

Sorting options

Design considerations

Lesson 6: Filtering data

Filtering a list

Custom criteria

Multiple-condition criteria

Managing a filtered list

Appendix A: Querying data

Database functions

External databases and queries

Excel 97 and the Internet