Roger's Computer Service, Inc.

Excel 97 Charting & Organizing Data
   

Prerequisites:This course is designed for students who has limited experience with computers and Internet and needs to learn the basic features of Excel 97. We recommend you first take a Windows class and Excel 97 Worksheets before Excel 97 Charting and Organizing Data or equivalent knowledge.

Lesson 1: Creating Charts

  • Creating a Chart Sheet
  • Creating an Embedded Chart
  • Comparing Chart Sheets with Embedded Charts

Lesson 2: Modifying Chart

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

  • Filtering a List
  • Custom Criteria
  • Multiple-Condition Criteria
  • Managing a Filtered List
Home Page
   
Contractor's Accounting System
   
Computer Training
   
Computer Hardware
   
Software
   
Web Design
   
Support
   
Contact Us