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:
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
Single-level sorting
Multiple-level sorting
Sorting options
Design considerations
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list
Creating a chart sheet
Creating an embedded chart
Comparing chart sheets with embedded charts
Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items
Formatting chart text
Formatting labels
Formatting the chart
Printing a chart sheet
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts
Creating a diagram
Database functions
External databases and queries
Excel Web pages and the Internet or an intranet
New Features