Go BackExcel 97: Using Excel Tools

Synopsis
Excel 97: Using Excel Tools shows how to enhance the presentation of data by presenting it in graphic form.

Audience
This course is for intermediate level Microsoft Excel for Windows users.

Time
4 hours

Product Code: XCLC03
After completing Excel 97: Using Excel Tools, the user should be able to:

 
Create and print many types of charts
Format and modify charts
Draw on a chart or worksheet
Use outlining to summarize information in a list
Create worksheets for use on the Internet or a company intranet

Creating Charts
Creating a column chart
Adding text to a chart
Changing the chart type and format
Printing a chart sheet

Formatting Chart Objects
Customizing a chart legend
Formatting chart text
Changing chart appearance

Modifying Charts
Adding unattached text
Editing chart text
Creating multiple charts from one worksheet

Using Drawing Tools
Adding graphic objects to charts
Adding graphic objects to worksheets

Using Outlining to Group Data
Creating subtotals for a list
Examining a subtotaled list
Charting subtotal data

Creating Spreadsheets for the Internet
Accessing the Internet through a browser
Inserting a hyperlink into a worksheet
Saving a worksheet as an HTML file
This course is distributed with

 
Exercises, with supplied files, that allow users to practice in Excel 97
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the Excel 97 product
A Excel 97 Glossary


 

Go Back