Course Catalog

Excel 2003: Charting and Organizing Data

Students will probably get the most out of this course if they want to learn the skills and concepts necessary to begin using the charting and list-management capabilities of Microsoft® Office Excel 2003 or if they need to create charts to graphically represent worksheet data or to maintain and manage lists at their workplace. Students should have a basic knowledge of the concepts involved in using Microsoft® Office Excel 2003 worksheets. For example, they should be familiar with data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.

Topics

  • Course Content
  • Lesson 1: Sorting data
  • Topic 1A: Single-level sorting
  • Topic 1B: Multiple-level sorting
  • Topic 1C: Sorting options
  • Topic 1D: Design considerations
  • Lesson 2: Filtering data
  • Topic 2A: Filtering a list
  • Topic 2B: Custom criteria
  • Topic 2C: Multiple-condition criteria
  • Topic 2D: Managing a filtered list
  • Lesson 3: Creating charts
  • Topic 3A: Creating a chart sheet
  • Topic 3B: Creating an embedded chart
  • Topic 3C: Comparing chart sheets with embedded charts
  • Lesson 4: Modifying charts
  • Topic 4A: Chart types
  • Topic 4B: Modifying embedded charts
  • Topic 4C: Adding and deleting chart items
  • Topic 4D: Moving and sizing chart items
  • Lesson 5: Formatting a chart
  • Topic 5A: Formatting chart text
  • Topic 5B: Formatting labels
  • Topic 5C: Formatting the chart
  • Topic 5D: Printing a chart sheet
  • Lesson 6: Using graphic objects
  • Topic 6A: Adding graphic objects
  • Topic 6B: Formatting graphic objects
  • Topic 6C: Using graphic objects to enhance worksheets and charts
  • Topic 6D: Creating a diagram
  • Appendix A: Additional topics
  • Database functions
  • External databases and queries
  • Excel Web pages and the Internet or an intranet
  • Appendix B: New Features in Office 2003

Course Length

1

For More Information

Contact sales@intech.com if you have questions regarding this or any other course.

Earlier versions of courses may be available upon request.
Print this page

Other Excel 2003 Courses:

Intermediate Excel 2003

Introduction to Excel 2003

Excel 2003: Charting and Organ...

Microsoft Office Excel 2003: I...