Excel 97 Outline
Home
Courses
ACT Description
ACT 3
ACT 4
ACT 2000
ACT 6
Excel Description
Excel 95
Excel 97
Excel XP
Word Description
Word 95
Word 97
Word 2000
Word XP
Works Description
Works 4
Windows Description
Windows 95
Windows 98
Windows XP
Thank you for wanting to learn more about this course. Unfortunately, we no longer offer this course because a newer version of the software is available. However, you can still purchase the training manual by filling out the
book order form
.
Introduction
Adding data to an existing chart
Features of Excel
Customizing charts
Toolbar buttons explained
Printing spreadsheets & charts
Parts of the spreadsheet window
Using cell & pop up notes
Modifying default options
Protecting cells & workbooks
Creating & using custom workspaces
Adding Passwords
Using the Picklist feature
Using the View Manager
Using Auto Complete
Using the Report Manager
Creating & using scraps
Using Help
Spell Check
Sorting data
Using Add-Ins
Filtering data
Selecting cells, rows & columns
Number formats
Advanced
Centering & wrapping text
Creating Pivot tables
Adding borders
Creating reports
Using Auto Format & Auto Fill
Using the Report Outlining tool
Copying & Deleting cells
Creating Consolidated reports
Range names
Using Goal Seek
Freezing columns & rows
Working with Data Tables
Moving & Deleting sheets
Using the Scenario Manager
Moving & Copying between workbooks
Creating a Summary report
Importing custom lists
Linking data
Using the Undo & Repeat commands
Updating links
Renaming & Inserting sheets
Sharing lists
Inserting media clips & video files
Intermediate
Working with Styles
Creating formulas
Creating & using templates
Using the Fill Right command
Creating macros
Using Auto Sum
Customizing a toolbar
Using the Function Wizard
Creating a new toolbar
Using Functions
Hiding & Restoring rows & columns
Adding a background
Inserting graphics
Creating charts
Home
|
Tech Room
|
Nonprofit Central
|
Forum
|
Courses
|
Help Center
Copyright © 1999-2007 ITAV, Inc. All Rights Reserved.
All trademarks are the property of their respective owners.
Revised: 12/22/02