Home >> Courses >> Computer Application Training Courses >> Database & Collaboration Tools Training
Please note: All classes run from 9:00 AM to 4:30 pm unless otherwise specified.

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. (More Details Below)
Choose a Course Date:  
Price per seat $375.00
Qty
Seats Available: 0

  
  • Additional Course Details
    • 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:
      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.

      Course Overview:
      The Lesson objectives are designed to 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.

      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 (Intermediate)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches intermediate-level features and functions of Excel 2003. (More Details Below)
$225.00
   
EX2K3L3 - Excel 2003 Training (Advanced)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, covers advanced-level features and functions of Excel 2003. (More Details Below)
$225.00
   
EX2K3L1 - Excel 2003 Training (Basic)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Excel 2003. (More Details Below)
$179.00
   
EX2K3STWF - Excel 2003: Saving Time with Functions (1/2 Day Course)
Students will learn to use a variety of functions and time-saving techniques.
$225.00
   
EX2K7L1 - Excel 2007 (Basic)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Excel 2007. (More Details Below)
$225.00
   
EX2K7L2 - Excel 2007 (Intermediate)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2007: Basic. (More Details Below)
$225.00
   
EX2K7L3 - Excel 2007 (Advanced)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2007: Intermediate. (More Details Below)

Customer Reviews


Write A Review