Excel 2000: Charting and Organizing Data
Course length: 1 day
Course
description
Overview: Students will build on the
skills developed in Excel 2000: Level 1,
learning the skills and concepts necessary to create charts and to use the
list-management capabilities of Excel 2000.
Certification:
The combined
content of the 
Software Training courses - Excel 2000: Worksheets and Excel 2000: Charting and Organizing Data,
satisfies the requirements for the Certified Microsoft Office User (M.O.U.S.)
for Excel 2000 at the Proficient level.
Prerequisites: To ensure your success, you
must have first completed the Software Training course,
Excel 2002: Level
1 and have a strong working knowledge
of the Windows environment. For example, you should know how to launch an
application, create and save files, and copy files from CDs and other media.
The Software Training courses
Windows 98: Introduction, Windows ME: Introduction, Windows 2000: Introduction and Windows XP: Introduction teach these skills.
Delivery
method:
Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to
represent data graphically and maintain and manage lists.
Target
student:
Students enrolling in this course should understand data types (text, numbers,
and formulas) and the use of the menu system for copying data and for opening
and saving files.
What's
next:
Excel 2000: Advanced is the third course
in this series. Students can take the
Software Training course, Excel 2000: Advanced to learn about the
more advanced features of Excel.
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:
- 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.
- Sort information in a list by using the Data, Sort command.
- Locate information quickly in a list that meets specified conditions
by using the Advanced filter feature.
Course
content
Lesson
1: Creating charts
Creating
a chart sheet
Creating
an embedded chart
Comparing
chart sheets with embedded charts
Lesson
2: Modifying charts
Chart
types
Modifying
embedded charts
Adding
and deleting chart items
Moving
and sizing chart items
Lesson
3: Formatting a chart
Formatting
chart text
Formatting
labels
Formatting
the chart
Printing
a chart sheet
Lesson
4: Using graphic objects
Adding
graphic objects
Formatting
graphic objects
Using
graphic objects to enhance worksheets and charts
Lesson
5: Sorting data
Single-level
sorting
Multiple-level
sorting
Sorting
options
Design
considerations
Lesson
6: Filtering data
Filtering
a list
Custom
criteria
Multiple-condition
criteria
Managing
a filtered list
Appendix
A: Querying data
Database
functions
External
databases and queries
Excel
2000 and the Internet