excel.jpg (1173 bytes)
EXCEL FOR WINDOWS

Level 2 - Charts and Databases

COURSE OUTLINE

•Creating a Chart

•Creating a chart sheet

•Creating an embedded chart

•Comparing chart sheets and embedded charts

•Modifying a Chart Sheet

•Chart types

•Adding and deleting chart items

•Moving and sizing chart items

•Modifying an Embedded Chart

•Selecting and editing embedded charts

•Moving and sizing embedded charts

•Printing an embedded chart

•Formatting a Chart

•Formatting chart text

•Formatting numbers

•Formatting the chart

•Printing a chart sheet

•AutoFormats

•Built-in AutoFormats

•User-defined AutoFormats

•Graphic Objects

•Working with graphic objects

•Using graphics objects to enhance worksheets and charts

•Advanced Charting Topics

•Experimenting with series

•Changing the scale

•Adding a trendline and creating an overlay chart

•Protecting charts

•Sorting data

•Single-level sorting

•Multiple-level sorting

•Sorting options

•Using the Data, Subtotals command

•Design considerations

•AutoFilter

•Filter a list

•Custom criteria

•Managing a filtered list

•Advanced Filter

•Multiple condition criteria

•Copying filtered data

•Data Form

•Maintaining a list by using the data form