|
SYNOPSIS:
This course covers basic worksheet enhancements. It includes tasks to
create and edit charts, and draw objects. The student will also learn
how to use advanced AutoShapes and manage data and files.
PREREQUISITES:
Users familiar with the basics of Excel 97 who want to enhance worksheets
using charts and graphics.
OBJECTIVES:
l Creating
Charts
l Editing Charts
l Drawing Objects
l Using Advanced AutoShapes
l Managing Data
DURATION:
Half Day
|
THIS MODULE INCLUDES:
Creating Charts
Using, creating, moving, resizing, printing, and deleting charts; identifying
and formatting chart objects; moving the chart toolbar; changing the chart
type, the plot direction, the text orientation, and the chart range; adding
and removing the legend; adding a data table.
Editing Charts
Editing charts; changing the chart type/sub-type, the data source, chart
options, and the chart location; adding chart titles; moving the legend;
printing a chart sheet.
Drawing an Object
Working with drawing objects; displaying the drawing toolbar; drawing
a rectangle; selecting, moving, adding text to, selecting text in, and
resizing an object; changing the fill, font, and line colour; adding a
shadow and a 3-D effect; applying a 3-D setting.
Drawing Additional Objects
Drawing a line, an oval, a text box, and an arrow; changing the line and
arrow style; changing to a dash style; removing object fill; editing text
in a text box; deleting an object.
Using Advanced AutoShapes
Using advanced AutoShapes; drawing stars and banners, a callout, a basic
shape, a connector, a curved line, a flowchart shape, and a block arrow.
Managing Data
Sorting lists, sorting in ascending and descending order, finding and
replacing data.
|
