Excel 2000: Charting And Organizing Data (Windows)

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

Prerequisites

Windows 98: Introduction and Excel 2000: Worksheets, or equivalent knowledge.

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. 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.

What's next

Excel 2000: Advanced is the third course in this series. Students can take Excel 2000: Advanced to learn advanced features.

Delivery Method

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

Certification

The combined content of the Excel 2000: Worksheets and Excel 2000: Charting and Organizing Data courses satisfies the requirements for the Certified Microsoft Office User for Excel 2000 at the Proficient level.

Benefits

Students will learn how to represent data graphically and maintain and manage lists.

Course duration

1 Day(s) Course outline

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

Hardware/software Requirements

You will need 32 megabytes (MB) of Random Access Memory (RAM) if you are using Excel 2000. See your reference manual for hardware considerations that apply to your specific hardware setup.

In addition, you will need printers if you want to print the charts and filtered lists created in the course. This book was written using the Windows 98 platform; however, this course has been tested and runs on Windows 95, Windows 98, and Windows NT 4.0.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.