Excel 5 Intmd

Excel 5.0 Charting and Data Management - Intermediate

Course description

Overview: Students will learn the skills and concepts necessary for charting and data-management.

Prerequisites: Students enrolling in this course should understand the basic concepts involved in using Excel 5.0 for Windows worksheets and the use of the menu system for copying data and for opening and saving files

Benefits: Students will learn how to create charts to graphically represent worksheet data, and how to maintain and manage lists.

Objectives

Upon successful completion of this course, students will be able to:

Create charts that graphically represent worksheet data
Investigate some of the advanced charting features
Modify existing charts
Sort information in a list by using the Data Sort command
Modify existing embedded charts
Quickly locate information in a list that meets your specific conditions by using the AutoFilter feature
Customize charts by applying formatting
Locate and manage information in a list that meets more complex conditions by using the Advanced Filter feature
Use the Auto-Format feature to enhance charts
Easily manage a list by using the Data form
Enhance worksheets and charts with graphic objects by using the drawing tools

Course content

Creating charts
Modifying a chart sheet
Modifying an embedded chart
Formatting a chart
Autoformats
Using graphic objects
Advanced charting topics
Sorting data
AutoFilter
Advanced filter
Data form