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