XL-ENT
Access 97-1
Access 97-2
Excel 97-1
Excel 97-2
Excel Advanced
Office 97
QuickBooks-1
Quickbooks-2
Quicken
PowerPoint 97-1
PowerPoint 97-2
Windows 95-1
Word 97-1
Word 97-2
Word 97 Advanced

Excel 97: Charting and Organizing Data (Level 2)

Course specifications

Course number: 52-221

Software version number: 97

Course length: 1 day

Certification

The combined content of the Excel 97: Worksheets and Excel 97: Charting and Organizing Data courses satisfies the requirements for the Certified Microsoft Office User for Excel 97 at the Proficient level.

Course description

Overview: Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 97.

Prerequisites: Windows 95: Introduction and Excel 97: Worksheets (Windows 95), or equivalent knowledge.

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 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