Video Training Tapes 

• Video training tapes providing step-by-step training on the Microsoft Office 2000 suite applications.
  
  
• Beginning Intermediate and Advanced training videos for Microsoft Office 2000 are available for loan from the Albin O. Kuhn Library Reserves Des

BeginningWord 2000
(2 Hrs 10 Minutes)

1.0 Getting Started (8 Minutes)

• Starting word 2000
• Touring the Word Window

2.0 Creating New Documents (22 minutes)

• Entering Text
• Saving Your work
• Printing & Closing a Document
• Working with a Template
• Using a Wizard

3.0 Revising Documents (18 minutes)

• Opening a Document
• Moving in a Document
• Basic Editing
• Adding a Date
• Click and Type
• Envelopes & Labels
• Multiple Page Documents

4.0 Getting Help (10 minutes)

• Office Assistant
• Help Window
• Context Sensitive Help

5.0 Essential Skills (25 minutes)

• Selecting Text
• Copying & Moving Text
• The Office Clipboard
• Undo, Redo, Repeat & AutoCorrect
• AutoComplete

6.0 Character Formatting (21 minutes)

• Changing font Formatting
• The Formatting Toolbar
• Symbols & Special Characters
• AutoFormat As Your type
• Paragraph Formatting
• Paragraph Alignment
• Line Spacing

8.0 Document Formatting

• Margins & Paper size
• Controlling Page Breaks
• Proofing Documents (10 minutes)
• Spelling & Grammar
• Thesaurus

9.0 Previewing & Printing (5 minutes)

• Previewing a Document
• Printing a document

10.0 Shortcuts (8 minutes)

• Shortcut Menus
• Keyboard Shortcuts
• Exiting out of Word
  

• Document Views
  
• Working with Multiple Document Windows
  
• File Management

• Find & Replace
  
• AutoText
  
• Format Painter

• Toolbars
• Personalized Menus
• Defaults
• Options

• Tabs
• Indents
• Bullets
• Special Spacing
• Sorting Text
• Borders & Shading
• Page Numbers
• Numbering Pages
• Headers & Footers

• Using Sections
  
• Newspaper Columns

• Basics
  

1.0 Tables (25 Mins)

• Creating a Table
• Navigating & Modifying a Table
• Formatting a Table

2.0 Automatic Formatting & Styles (12 Mins)

• Applying Styles
• Creating Your Own Styles
• Modifying Existing Styles

3.0 Document Templates (13 Mins)

• Personalizing Word's Templates
• Creating Your Own Templates
• Automating with Field Codes

4.0 Long Documents & Reports (36 Mins)

• Cross-references & Bookmarks
• Footnotes
• Tables of Contents
• Indexes
• Outlines
• Document Map

5.0 Sharing Documents (14 Mins)

• Comments
• Tracking Changes
• Protecting Documents
• Saving Different Versions

6.0 Macros (19 Mins)

• Creating & Running Macros
• Editing Macros
• Automatic Macros

• The Excel Workbook & Worksheets
• Title Bar & Menu Bar
• Toolbars
• Formula Bar
• Columns & Rows
• Navigation
• Sheet Names & the Status Bar
• Mouse Pointers & Shortcut Menus

• Data Entry Techniques
• Auto Complete
• Three Methods of Entering Formulas
• Repeating a Formula
• Formulas Beyond Addition & Subtraction

• Summation
• Recalculating Effects
• Averages

• The Formatting Toolbar

• File Save or File Save as
• Opening a File
• Closing a File
• Creating a new Workbook

• Inserting Columns
• Deleting Columns
• Moving Cells
• Copying Cells

• Formatting Cell Attributes & Alignment
•  Borders
• Numeric Formatting
• Center Text across Columns
• Hiding & Unhiding Columns & Rows

• Using Print Preview & Page Setup
• Printing Controls
• Using Page Break Preview

• Absolute References

• Show/Hide Gridlines
• Show/Hide Formulas
• Recently used Files List
• Sheets in New Workbook
• Default Settings

1.0 Adjusting Worksheet Views (13 Mins)

• Freeze/Unfreeze Panes
• Horizontal & Vertical Split screen

2.0 Auditing Techniques (12 Mins)

• Using the Auditing Toolbar
• Tracing Dependant Cells
• Tracing Precedent Cells

 3.0 Using Functions (18 Mins)

• Paste Function
• The PMT Function
• Expanding the use of standard functions

 4.0 Logical Functions (30 Mins)

• IF Functions & Relational Operators
• Using Words in IF Functions
• Using IF Functions with Arithmetic Operators (* / + -)
• Using Logical Operators (AND & OR) with the IF Function
• Nested IF Functions
• Using the VLOOKUP Function to overcome Limitations of the IF Functions

5.0 Date & Time Functions (21 Mins)

• Using Dates as Values
• Entering a Series of Dates
• Date/Time entry Techniques

6.0 Multi-Sheet Workbooks (22 Mins)

• Re-Naming & Re-Ordering Sheets
• Inserting & Deleting Sheets
• Moving
• Formulas across multiple sheets

• The PowerPoint Screen

• Types of Slides & Work Views
• Creating a Presentation with a template & or Wizard
• Creating a Presentation from Existing Slides
• Deleting Slides in different Views
• Inserting Headers & Footers
• Sending a Presentation Via e-mail
• Sending a Presentation with a Routing Recipient

• Changing the Order of the Slides
• Changing the Layout of one or more Slides
• Using the Slide Master
• Using a Design Template

• Spell Check & Promotion & Demotion
• Aligning Text
• Adding a Text Box
• Fonts
• Office Clipboard

• Adding Clip Art
• Adding Shapes & Word Art
• Grouping
• Fill Features
• Adding Tables
• Tips for Beginners

• Bullets & Numbering
• Animating Text
• Slide Transitions
• Speaker Notes

• Previewing Presentations in Black & White
• Printing Slides
• Printing Handouts
• Printing Speaker Notes
• Printing the Outline View

• Starting a Slide Show
• Using the On-Screen Navigation Tools
• The Pen Tool
• Printing Overhead Transparencies

• Saving Presentations
• Publishing to the Web
• Hyperlinks
• The Office Assistant

• Automatically Create a Summary Slide
• Automatically Create an Agenda Slide
• Creating our own Design Template
• Auto Content Wizard

• Applying animation effects
• Inserting animated GIF's
• Adding an Action Button
• Customizing a Color Scheme
• Creating a Custom Background
• Changing Tab Formatting
• Hiding Slides
• Adding a Presentation within a Presentation
• Setting automatic Slide Timings

• Adding Textured Backgrounds
• Applying Diagonal Borders to a Table

• Exporting an Outline to Word
• Importing an Outline from Word
• Adding a Table from Word
• Inserting an Excel Chart
• Adding Sound
• Adding Video

• Saving a Slide as a Graphic
• Changing the output format ( Page Setup )
• Export to 35 mm Slides

• Save Presentation for use on another computer ( Pack N' Go)

• Saving Embedded Fonts in a Presentation
• Saving HTML to a Specific target Browser

• Customizing the Toolbar
• Creating a Toolbar

• Building & Modifying a Chart or a Graph
• Building an Organization Chart
• Animating an Organization Chart

• Broadcasting Overview
• Setting Up the Presentation for Broadcasting
• Viewing a Presentation on the Web
• Using Net Meeting to Schedule a Broadcas

• Starting Access
• Opening an Existing Database
• The Access Desktop
• The Database Window
• A Preview of the Database Components

• Viewing & Navigating Table Data
• Editing Table Data
• Adding Records to a Table
• Selecting & Deleting Records
• Find & Replace
• Modifying the Appearance of a Datasheet
• Spell-Check & Auto-correct

• Moving from Record to Record
• Finding
• Sorting
• Filtering
• AutoForms
• Using a Form Wizard
• Conditional Formatting

• Moving form Page to Page
• Zooming In & Out
• Viewing Multiple Pages
• Printing
• AutoReports & the Report Wizard
• Page Setup

• Printing Table Datasheets
• Printing Queries
• Printing Forms
• Printing Reports

• The Office Assistant & Index Searching
• Context-Sensitive Help & Printing Help Topics

• Backing Up & Restoring a Database
• Compacting & Repairing a Database
• Converting a Database to a Previous Version
• Organizing Database Objects into Groups

• Evaluating Inputs & Outputs
• Normalization
• Creating a Database Using a Wizard
• Creating a Database from Scratch

• Creating Tables Using a Wizard
• Creating Tables from Scratch & Data Types
• Setting Primary Keys
• Field Properties
• Input Masks
• The Lookup Wizard
• Indexes

• Introduction to Relationships
• Benefits of Relationships
• Types of Relationships
• Referential Integrity
• Indexes & Relationships
• Printing Relationships

• Selecting Fields & Ordering the Query Result
• Refining Queries with Criteria
• Updatability of Query Results
• Queries Based on Multiple Tables

• Adding Controls
• Selecting Controls
• Moving
• Aligning Controls
• Changing Control Properties
• Changing the Tab Order Controls
• Form Properties
• Working with Combo Boxes & List Boxes

• Understanding Report Bands
• Working with Controls
• Creating Groups & Totals Reports
• Working with Report Properties
• Modifying Selection Criteria

• Setting the Application
• Designing other Startup Information

• Exporting to another Database
• Exporting to an Excel Spreadsheet
• Exporting to ASCII
• Exporting to HTML
• Importing from anther Access Database
• Importing Spreadsheet Data
• Importing ASCII Data
• Importing from HTML
• Linking to Anther Access Database
• Linking to anther types of Database
• The Linked Table Manager