Attention: this is very old content, revived mostly for historical interest. Many of the pages on this site are still useful, but please bear in mind that they may be out of date. (Especially, do not try to use contact information, phone numbers, etc. found on these pages unless you couldn't find anything more recent.)
See here for more information.

MS OFFICE 97 QUICK REFERENCE GUIDE

The MS Office 97 Quick Reference Guide, written by an experienced instructor in MS Office, provides an alphabetical, comprehensive, step-by-step summary of features for the following MS Office software programs:

• Windows 95 (or Windows 98)
  
• Access 97
  
• Excel 97
  
• PowerPoint 97
  
• Word 97 (Sample) (requires Word 6.0 or higher)
  

(Note: Quick Reference Guides are also available for Office 95.) The cost for the complete Quick Reference Guide is $16.95 (S&H and tax included). (Contact us at 250 727-2700 for information on volume discounts for orders over 25.)

The contents for each section is as follows:

WINDOWS 95 Top of Page

• Access Programs on Taskbar
  
• Activate Window
  
• Add File or Folder to Start Menu
  
• Add Printer
  
• Add Program to Desktop
  
• Add Program to Start Menu
  
• Arrange Icons
  
• Automatically Run Program
  
• Cancel All Print Jobs
  
• Cancel Print Job
  
• Cascade Multiple Windows
  
• Clear Document Menu
  
• Close Window
  
• Copy Disk
  
• Copy File/Folder
  
• Create Control Panel Feature Shortcut
  
• Create Control Panel Shortcut
  
• Create File Shortcut
  
• Create Folder
  
• Create Printer Shortcut
  
• Cycle Through Open Applications
  
• Date and Time
  
• Define Dialog Box Options
  
• Defragment Disk
  
• Delete File/Folder
  
• Desktop Colors
  
• Desktop Patterns
  
• Desktop Wallpaper
  
• Disk Properties
  
• Display Contents of Disk
  
• Display Contents of Folder
  
• Display Contents of My Computer
  
• Display File Type Icons
  
• Display Print Jobs
  
• Display Toolbar
  
• Double-click Speed
  
• Empty Recycle Bin
  
• File Properties
  
• Find File/Folder
  
• Format Disk
  
• Help-Contents
  
• Help-Context Sensitive
  
• Help-Exit
  
• Help-Find
  
• Help-Index
  
• List Disk Contents
  
• Maximize Window
  
• Menus-Keyboard
  
• Minimize All Windows
  
• Minimize Window
  
• Mouse Pointer Speed
  
• Move File/Folder
  
• Move Window
  
• Open Associated File
  
• Open Previously Used Documents
  
• Open Unassociated File
  
• Open Window
  
• Pop-Up Menus
  
• Refresh Display
  
• Remove Program from Desktop
  
• Remove Program from Start Menu
  
• Remove Program from Startup Menu
  
• Remove Shortcut
  
• Rename File/Folder
  
• Restore Window
  
• Run a Program
  
• Run DOS
  
• Run Program on Desktop
  
• Run Shortcut
  
• Sample of Fonts
  
• Screen Saver
  
• Screen Saver Password
  
• Select Files
  
• Set Default Printer
  
• Shut Down Windows 95
  
• Size Window
  
• Sort Files
  
• Start Application
  
• Switch Mouse Buttons
  
• Taskbar Options
  
• Tile Multiple Windows
  
• Undelete File/Folder
  

ACCESS 97 Top of Page

• Add Field-Table
  
• Align Control Boxes
  
• Align Text in Control
  
• Allow Zero Length
  
• AutoForm
  
• AutoForm Wizards
  
• AutoNumber Field
  
• AutoReport
  
• Caption
  
• Close Database
  
• Close Table
  
• Column Width
  
• Command Button
  
• Command Button-Delete
  
• Control Border
  
• Control Color-Text/Fill
  
• Control Font
  
• Copy Data
  
• Copy Database
  
• Copy Table
  
• Create Database
  
• Create Query
  
• Create Table
  
• Currency Field
  
• Data Type
  
• Date/Time Field
  
• Date-Report
  
• Decimal Places
  
• Default Value
  
• Delete Control-Form/Report
  
• Delete Database
  
• Delete Field-Table
  
• Delete Form
  
• Delete Query
  
• Delete Report
  
• Delete Table
  
• Display Database Information
  
• Display Datasheet
  
• Display Form Design
  
• Display Record
  
• Display Report Design
  
• Display Table Design
  
• Edit Cell Contents
  
• Edit Query
  
• Enter Data
  
• Exit Access
  
• Exit Windows95/98
  
• Expand/Compress Text Box
  
• Field Description
  
• Field Name
  
• Field Properties
  
• Field Size
  
• Filter by Form
  
• Filter by Selection
  
• Find Data
  
• Find Record
  
• Form Background Color
  
• Form Wizard
  
• Format Data
  
• Freeze Columns
  
• Header/Footer-Datasheet
  
• Header/Footer-Form/Report
  
• Help-Index
  
• Help-Office Assistant
  
• Hide Columns
  
• Indexed Option
  
• Input Mask
  
• Keep Record Together-Form/Report
  
• Label Name-Form/Report
  
• Labels
  
• Memo Field
  
• Move Columns
  
• Move Control-Form/Report
  
• Move Data
  
• Move Field-Table
  
• Number Field
  
• OLE Object Field
  
• Open Database
  
• Open Form
  
• Open Table
  
• Page Margins
  
• Page Number-Report
  
• Paper Orientation-Report
  
• Paper Size/Orientation-Table
  
• Parameter Value
  
• Print Preview
  
• Print-Datasheet
  
• Print-Form/Report
  
• Print Query Results
  
• Query Wizard
  
• Quick Report
  
• Redisplay All Records
  
• Rename Column
  
• Rename Database
  
• Rename Query
  
• Replace Cell Contents
  
• Replace Data
  
• Report Wizard
  
• Required Text
  
• Resize Control-Form/Report
  
• Row Height
  
• Run Access
  
• Run Query
  
• Save Filter as Query
  
• Save Design Changes
  
• Select Controls
  
• Sort Data-Datasheet
  
• Sort Data-Report
  
• Tab Order-Form
  
• Text Field
  
• Undelete Table
  
• Unfreeze Columns
  
• Unhide Columns
  
• Validation Rule
  
• Yes/No Field
  

EXCEL 97 Top of Page

• Absolute Cell Reference
  
• Adjust Print
  
• Align Center
  
• Align Left
  
• Align Right
  
• AutoFill
  
• AutoFormat
  
• Automatic Backup
  
• AutoSum
  
• Bold
  
• Border
  
• Cascade Open Workbooks
  
• Cell Movement Keys
  
• Center Across Columns
  
• Center Pages
  
• Chart
  
• Chart-Change Chart Type
  
• Chart-Change Data Range
  
• Chart-Change Data Series
  
• Chart-Colors
  
• Chart-Data Labels/Values
  
• Chart-Delete
  
• Chart-Grid Lines
  
• Chart-Legend
  
• Chart-Move
  
• Chart-Rotate Axis Text
  
• Chart-Show Data Table
  
• Chart-Size
  
• Chart-Titles
  
• Clear Cell Contents
  
• Clear Cell Formatting
  
• Close Workbook
  
• Color Text
  
• Column Width
  
• Column Width-Standard Width
  
• Copy and Insert Data
  
• Copy Data (Overwrite destination)
  
• Copy Cell Formatting
  
• Copy Worksheet
  
• Create New Workbook
  
• Create New Worksheet
  
• Create Range Name
  
• Currency
  
• Currency Style
  
• Custom Lists
  
• Decimal Places
  
• Delete Column(s)/Row(s)
  
• Delete Workbook
  
• Delete Worksheet
  
• Display/Access Open Workbooks
  
• Display Formula Bar
  
• Display Formulas
  
• Display Toolbars
  
• Double Underline
  
• Edit Contents of Cell
  
• Enter Data
  
• Enter Data-Multiple Worksheets
  
• Enter Dates
  
• Erase Contents of Cell
  
• Erase Selected Cells
  
• Exit Excel 97
  
• Exit Windows 95/98
  
• Fill Cell with Same Characters
  
• Fill Cells with New Data
  
• Fill Patterns
  
• Fill Series-Date
  
• Fill Series-Growth
  
• Fill Series-Linear
  
• Fit to Specified Pages
  
• Font/Font Size
  
• Format Date
  
• Format Numbers
  
• Format Time
  
• Formulas
  
• Fractions
  
• Freeze Column(s)/Row(s)
  
• Function Wizard
  
• Functions
  
• Go To
  
• Go To Range Name
  
• Grid Lines
  
• Headers/Footers
  
• Headers/Footers-Top/Bottom Margins
  
• Help-Contents
  
• Help-Index
  
• Help-Office Assistant
  
• Hide Column(s)/Row(s)
  
• Insert Blank Column(s)/Row(s)
  
• Insert Blank Worksheet
  
• Italic
  
• Justify Text
  
• Justify-Horizontal/Vertical
  
• Margins
  
• Merge Cells
  
• Move and Insert Data
  
• Move Data (overwrite destination)
  
• Move Worksheet
  
• Number Style
  
• Numeric Text
  
• Open Workbook
  
• Page Break
  
• Paper Orientation
  
• Paper Size
  
• Percent
  
• Percent Style
  
• Print One Copy of Worksheet
  
• Print Preview
  
• Print Row and Column Titles
  
• Print Worksheet
  
• Rename Worksheet
  
• Replace Contents of Cell
  
• Replace File
  
• Reset Menus and Toolbars
  
• Rotate Data
  
• Row and Column Headings
  
• Run Excel 97
  
• Save Workbook
  
• Save Workspace
  
• Select Cells/Columns/Rows
  
• Select to End of Worksheet
  
• Select Worksheet
  
• Shade/Color
  
• Shrink to Fit
  
• Spelling
  
• Strikethrough
  
• Superscript/Subscript
  
• System Default Drive
  
• Tile Open Workbooks
  
• Underline
  
• Undo
  
• Unfreeze Column(s)/Row(s)
  
• Unhide Column(s)/Row(s)
  
• Vertical Row Alignment
  
• Wrap Text
  

POWERPOINT 97 Top of Page

• Action Buttons
  
• Add Slide
  
• Add Slide-Same Layout
  
• Animation-Customized
  
• Animation-Preview
  
• Automatic Spell Checking
  
• Background Color
  
• Background Fill/Pattern/Texture
  
• Background Picture
  
• Bold
  
• Border Lines
  
• Build Bullets
  
• Bullets-Add/Remove
  
• Bullets-Change
  
• Bullets-Demote/Promote
  
• Cascade Open Documents
  
• Change Case
  
• ClipArt
  
• ClipArt-Border Lines
  
• ClipArt-Brightness
  
• ClipArt-Contrast
  
• ClipArt-Crop
  
• ClipArt-Delete
  
• ClipArt-Fill
  
• ClipArt-Move
  
• ClipArt-Recolor
  
• ClipArt-Resize
  
• ClipArt-Restore Image
  
• ClipArt-Watermark
  
• Close Document Window
  
• Color Scheme-Add
  
• Color Scheme-Copy
  
• Copy Slide
  
• Copy Text
  
• Create New File
  
• Date/Time
  
• Delete Slide
  
• Delete Text
  
• Display Different Slide
  
• Display Formatting Toolbar
  
• Display Standard Toolbar
  
• Emboss Text
  
• Exit PowerPoint
  
• Exit Windows 95/98
  
• Fill Color
  
• Font
  
• Font Size
  
• Footer
  
• Handouts-Page Numbers, Date, Time
  
• Handouts-Print
  
• Help-Context Sensitive
  
• Help-Index
  
• Indent-Add/Remove
  
• Italic
  
• Line Spacing
  
• Lines-Add
  
• Lines-Arrowheads
  
• Lines-Arrowheads Added
  
• Lines-Color
  
• Lines-Copy
  
• Lines-Delete
  
• Lines-Dashed
  
• Lines-Move
  
• Lines-Thickness
  
• Load PowerPoint 97
  
• Move Slide-Outline View
  
• Move Slide-Slide Sorter
  
• Move Text
  
• Notes Page View
  
• Object-Add Text
  
• Object-Align
  
• Object-Border
  
• Object-Copy
  
• Object-Create AutoShape
  
• Object-Create Oval/Circle
  
• Object-Create Rectangle/Square
  
• Object-Delete
  
• Object-Fill
  
• Object-Group Objects
  
• Object-Move
  
• Object-Resize
  
• Object-Rotate
  
• Office Assistant
  
• Open Presentation
  
• Org Chart
  
• Org Chart-Add Boxes
  
• Org Chart-Background
  
• Org Chart-Box Border
  
• Org Chart-Box Fill
  
• Org Chart-Delete
  
• Org Chart-Delete Box
  
• Org Chart-Edit
  
• Org Chart-Edit Text
  
• Org Chart-Exit
  
• Org Chart-Move Box
  
• Org Chart-Select Boxes
  
• Org Chart-Style
  
• Org Chart-Text Align
  
• Org Chart-Text Color
  
• Org Chart-Text Font
  
• Outline View
  
• Overwrite File
  
• Page Numbering
  
• Page Orientation
  
• Presentation-Copy
  
• Presentation-Unpack
  
• Print All Slides
  
• Print Current Slide
  
• Print Slides
  
• Renumber Slides
  
• Reset Menu Bar
  
• Save Presentation
  
• Select Slides
  
• Select Text
  
• Select View
  
• Slide Layout
  
• Slide Master
  
• Slide Show-Automatic
  
• Slide Show-Run
  
• Slide Sorter View
  
• Slide View
  
• Speaker Notes
  
• Speaker Notes-Move Box
  
• Speaker Notes-Page Numbers
  
• Speaker Notes-Print
  
• Speaker Notes-Resize Image/Text Box
  
• Speller
  
• Stacking Order
  
• Superscript/Subscript
  
• System Default Drive
  
• Tabs-Delete
  
• Tabs-Move
  
• Tabs-Set
  
• Template
  
• Text Alignment
  
• Text Box-Delete
  
• Text Box-Move
  
• Text Box-Resize
  
• Text Color
  
• Text Shadow
  
• Text Tool-Add Text
  
• Tile Open Documents
  
• Transition
  
• Underline
  
• Undo
  
• Video Clip-Add
  
• WordArt
  
• Zoom
  

WORD 97 Top of Page
Sample (requires Word 6.0 or higher)

• Accented Character
  
• All Caps
  
• Animate Text
  
• Automatic Backup
  
• Bold
  
• Bullet List
  
• Bullet List-Remove Bullets
  
• Center Pages Vertically
  
• Change Case
  
• Change System Default Drive
  
• Character Formatting
  
• Close All Document Windows
  
• Close Document Window
  
• Color Text
  
• Copy File
  
• Copy Formatting
  
• Copy Text
  
• Date
  
• Delete File
  
• Delete Text
  
• Display Formatting
  
• Display Formatting Toolbar
  
• Display Hidden Text
  
• Display Nonprinting Characters
  
• Display Open Windows
  
• Display Ruler
  
• Display Standard Toolbar
  
• Display Status Bar
  
• Dotted Underline
  
• Double Underline
  
• Drop Cap
  
• Exit Windows 95/98
  
• Exit Word for Windows 97
  
• Find Text
  
• Font
  
• Font Size
  
• Force Paragraph to New Page
  
• Go To
  
• Hanging Indent
  
• Hanging Indent-Remove
  
• Help-Contents
  
• Help-Context Sensitive
  
• Help-Index
  
• Hidden Text
  
• Highlight Text
  
• Hyphenation
  
• Hyphen-Nonbreaking
  
• Hyphen-Optional
  
• Indent
  
• Indent-Remove
  
• Insert File
  
• Insertion Movement Keys
  
• Italic
  
• Keep Paragraphs Together
  
• Keep Single Paragraph Together
  
• Line Spacing
  
• List Open Files
  
• Load Word for Windows 97
  
• Manual Page Break
  
• Margins
  
• Move File
  
• Move Text
  
• New Document
  
• Nonbreaking Space
  
• Normal View
  
• Numbered List
  
• Numbered List-Remove Numbers
  
• Office Assistant
  
• Open File
  
• Page Layout
  
• Page Numbering-Add
  
• Page Numbering-Change Style
  
• Page Numbering-Remove
  
• Paper Size/Orientation
  
• Paragraph Alignment
  
• Preview Page
  
• Print Current Page
  
• Print Entire Document
  
• Print Multiple Pages
  
• Printer-Select
  
• Remove Character Formatting
  
• Remove Paragraph Formatting
  
• Rename File
  
• Repeat Typing
  
• Replace File
  
• Replace Text
  
• Restore Menu Bar
  
• Save Document
  
• Section Break
  
• Select Text
  
• Select Text-Cancel
  
• Select Text-Mouse
  
• Small Caps
  
• Spelling
  
• Strikethrough
  
• Subscript
  
• Superscript
  
• Symbols
  
• Tab Stops
  
• Tab Stops-Clear
  
• Tab Stops-Move
  
• Thesaurus
  
• Turn Off Character Format
  
• Underline
  
• Undo
  
• View Modes
  
• WingDings
  

For more information on the MS Office Quick Reference Guide, please call/fax [250] 727-2700.