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