Home >> Courses >> Application Training Courses

Excel 2003: Charting and Organizing Data

Course ID #: EX2K3CODAT
Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2003.
Choose a Course Date:  
Price per seat $375.00
Qty
Seats Available: 0

  
  • Additional Course Details
    • Excel 2003: Charting and Organizing Data

      Course specifications

      Course number: 074 221

      Software version number: 2003

      Course length: 1 day

      Hardware/software required to run this course

      A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.

      A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.

      128 MB of RAM.

      A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.

      A 3 GB hard disk or larger if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.

      A floppy disk drive.

      A mouse or other pointing device.

      An 800 x 600 resolution monitor.

      Network cards and cabling for local network access.

      A printer (optional).

      A projection system to display the instructor’s computer screen.

      Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.

      Microsoft Office Professional Enterprise Edition 2003.

      Course description

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

      Prerequisites: To ensure students’ success with this course, we recommend that they first take the following

      Element K Content courses or have equivalent knowledge:

      • Excel 2003: Worksheets

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

      Excel 2003: Charting and Organizing Data

      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:

      Sort information in a list by using the Data, Sort command.

      Locate and manage information in a list that meets specified conditions by using the Advanced Filter feature.

      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.


      Excel 2003: Charting and Organizing Data

      Course content

      Lesson 1: Sorting data

      Single-level sorting

      Multiple-level sorting

      Sorting options

      Design considerations

      Lesson 2: Filtering data

      Filtering a list

      Custom criteria

      Multiple-condition criteria

      Managing a filtered list

      Lesson 3: Creating charts

      Creating a chart sheet

      Creating an embedded chart

      Comparing chart sheets with embedded charts

      Lesson 4: Modifying charts

      Chart types

      Modifying embedded charts

      Adding and deleting chart items

      Moving and sizing chart items

      Lesson 5: Formatting a chart

      Formatting chart text

      Formatting labels

      Formatting the chart

      Printing a chart sheet

      Lesson 6: Using graphic objects

      Adding graphic objects

      Formatting graphic objects

      Using graphic objects to enhance worksheets and charts

      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

      New Features

Other courses that may be of interest:
Click the "Details" button to check availability or special pricing options.

$225.00
   
EX2K3L2 - Excel 2003 Training (Level 2)
In this course, you will use Microsoft Excel 2003 to manage, edit, and print data. (See full description below)
$225.00
   
EX2K3L3 - Excel 2003 Training (Level 3)
In this course, you will use Microsoft Excel 2003 to manage, edit, and print data. (See full description below)
$225.00
   
EX2K3L1 - Excel 2003 Training (Level 1)
In this course, you will use Microsoft Excel 2003 to manage, edit, and print data. (See full description below)
$179.00
   
EX2K3STWF - Excel 2003: Saving Time with Functions (1/2 Day Course)
Students will use a variety of functions and time-saving techniques.
$225.00
   
EX2K7L1 - Excel 2007 Level 1
In this course, you will use Microsoft Excel 2007 to manage, edit, and print data. (See full description below)
$225.00
   
EX2K7L2 - Excel 2007 Level 2
In this course, you will use Microsoft Excel 2007 to manage, edit, and print data. (See full description below)
$225.00
   
EX2K7L3 - Excel 2007 Level 3
In this course, you will use Microsoft Excel 2007 to manage, edit, and print data. (See full description below)

Customer Reviews


Write A Review