Microsoft Office 2000 training videos are available to faculty, staff and students for viewing at the International Media Center located in AICV219 / B wing.

To view a tapes table of contents click on the corresponding link below

Exploring the Word 2000 Environment

• Using keyboard shortcut
• Using the Overtype mode
• Selecting / deselecting test
• Formatting / saving a document
• Using the Font dialog box
• Creating a new document
• Using templates
• Setting margins/page orientation
• Adjusting tab
• Inserting Date & Time/Auto Tex
• Using the spelling & grammar feature
• Printing

Getting started in Word 2000

• Inserting page breaks/ symbols/tab stops
• Adjusting margins
• Adding / modifying page numbers
• Creating / formatting headers & footers
• Applying a page border
• Creating an outline
• Saving HTML files
• Keying / editing text In columns
• Creating / formatting tables
• Merging cells
• Adding graphics
• Drawing / modifying lines
• Adding a 3-D effect
• Preparing charts
• Importing data
• Using the Mail Merge Helper
• Sorting / merging records
• Printing envelopes & labels

Beginning / Excel 2000
(1 hour 36 minutes)

Intermediate / Excel 2000
(1 hour 35 minutes)

Advanced / Excel 2000
(1 hour 26 minutes)

Exploring the Excel workspace

• Examining a worksheet
• Entering text & numbers
• Modifying the size of columns /  rows
• Using AutoFit
• Creating a new workbook
• Working with series (AutoFill)
• Editing cell content
• Merging cells
• Applying Font styles
• Entering formulas in a cell
• Using the Formula bar
• Entering a function
• Using AutoSum
• Clearing cell content / formatting
• Printing an entire workbook
• Previewing a worksheet
• Setting page margins / centering
• Setting up headers / footers
• Setting ; clearing a Print Area

Changing Zoom Settings

• Splitting a worksheet
• Freezing Columns and rows
• Inserting / deleting selected cells
• Inserting columns & rows
• Moving Selected Cells
• Utilizing the office clipboard
• Adding / selecting named ranges
•  Inserting rows in a named range
• Preparing formulas
• Revising formulas
• Applying boarders / shading
• Hiding / displaying gridlines
• Changing indents
• Defining / applying styles
• Applying auto formats
• Creating templates
• Customizing an invoice
• Applying / editing templates
• Applying date formats

• Discussing grouping
• Outlining a worksheet
• Previewing a worksheet
• Changing page orientation
• Setting print titles & options
• Inserting / removing a page bread
• Opening multiple workbooks
• Creating / saving a customized workspace
• Consolidating data from multiple workbooks
• Creating a link to source data
• Viewing an Excel list
• Using data forms
• Adding a new record to a list
• Finding records using a data form
• Performing single / multi-level sorts
• Applying data filters
• Exporting to other applications
• Importing from Text files
• Adjusting the decimal place
• Importing a table from an HTML line

Introduction

• The Access Desktop
• Opening an Existing Database
• The Database Window
• A Preview of the Database  Components
• Getting Help & the Assistant
• Working with an Existing Database
• Viewing & Navigating Table Data
• Editing Table Data
• Adding Records to a Table
• Selecting Records to a Table
• Selecting Records
• Deleting Records
• Find & Replace
• 2.8  Modifying the Appearance of an Datasheet
• Spell-check an Auto-correct
• Designing Your Own Database
• Planning Your Database
• Specifications
• Normalization
• Data Integrity
• Field Types
• The Database Wizard
• Creating Your Won Tables
• The table Wizard
• Creating a Table Without a Wizard
• Setting a Primary Key
• Form Basics
• Using an Existing Form
• Filter By Form
• Creating a Form with the Form Wizard
• Query Basics
• Creating a Query with a Wizard
• Creating a Query without a Wizard
• Adding Fields to the Query Grid
• Entering Selection Criteria & Sorting query Output
• Removing Fields from the Query Grid
• Report Basics
• Creating a Report with the Report Wizard
• Report Brands
• Sorting & Grouping
• Page Setup
• Printing a Report

Advanced Table Techniques

• The field Size Property
• The Caption Property
• Establishing Default Values
• Entering Field-Level Validations
• Entering Table –Level Validations
• Designating a Field as Required
• Formatting Field Data
• Using Input Masks
• The Lookup Wizard
• Adding Table Indexes
• Working with Hyperlink Data
• Establishing Relationships
• Referential Integrity
• 2.2  Cascading Update & Delete
• Modifying Table Design While in 2.4  the Relationships Window
• Advanced Selection Queries
• Entering Complex Criteria
• Building Multi-table Queries
• Adding Calculated Fields
• Parameter Queries
• Totals Queries
• Top Value Queries
• Displaying Unique Values
• Cross tab Queries
• Advanced Form Design
• Adding Controls
• Selecting Controls
• Moving Controls
• Deleting & Aligning Controls
• Sizing Controls
• Changing Control Properties
• Form Properties
• Advanced Report Design
• Creating Groups & Totals Reports
• Working with control Properties

Database Window Tricks

• List Types
• Renaming Objects
• Hide Objects
• Drag & Drop to Create Desktop Shortcuts
• Drag & Drop Between Applications
• Importing Exporting and Linking
• Exporting to Another Database
• Exporting to an Excel Spreadsheet
• Exporting to ASCII
• Exporting to HTML
• Importing from Another Access Database
• Importing Spreadsheet Data
• Importing ASCII Data
• Importing from HTML
• Linking to Another Access Database
• Linking to Another Type of Database
• The Linked Table Manager
• Action Queries
• Make Table queries
• Append Queries
• Update Queries
• Delete Queries
• Power Query Techniques
• The Find Duplicates Wizard
• The Find Unmatched Wizard
• Inner & Outer Joins
• Self-Joins
• Union Queries
• Power Form Techniques
• Working with Built-in Tab Control
• Working with Form Headers and Footers
• Creating Multi-table Forms
• Adding OLE Objects to Forms
• Using a Bitmap as a Form Background
• Other Important Form & Control 5.7  Properties
• Saving a Form as HTML
• Power Report Techniques
• Building Reports With Sub-Reports
• Advanced Brand Techniques
• Adding / Modifying Calculations

Using a Template

• Discussing toolbars
• Editing slides
• Inserting headers/footers
• Using the AutoContent wizard
• Demoting / promoting items
• Expanding / collapsing slides
• Working with text
• Inserting ClipArt
• Scaling objects / adding slides
• Inserting charts / editing datasheets
• Adding transition effects
• Applying sound / animating text
• Changing chart types
• Editing data series
• Setting up a slide show
• Adding speaker notes
• Customizing handouts
• Printing notes / handouts

PowerPoint Editing

• Indents, Alignment, & Spacing
• Inserting a Text Object
• Setting & Removing Tab Stops
• Working with bullets
• Changing Text Case
• The Format Painter
• Formatting Text Objects
• Power Slide Development
• Creating Summary Slides
• Reducing Slide Clutter – The expand Slide Feature
• Enhancing Your Slides with Comments
• Adding a Slide Header & Footer
• The slide Finder
• The Style Checker
• Slide Miniatures & Black & White View
• Working with Masters
• Creating Your Own Templates
• Enhancing Your Presentations with ClipArt
• Adding ClipArt
• Auto ClipArt
• Using the Picture Toolbar to   Enhance Your Pictures
• Say It With Impact – Word Art
• Adding a Word Art
• Using the Word Art Toolbar
• Charting
• Inserting a Chart
• Entering Chart Data
• Excluding Chart Data
• Adding Data From a Spreadsheet
• Changing the Chart Type
• Adding Pizzazz to Your Charts
• Inserting Organization Charts
• Inserting an Organizational Chart
• Adding & Deleting Relationships
• Changing the Chart Style
• Inserting Tables & Spreadsheets
• Inserting & Enhancing Word Tables
• Inserting Spreadsheets

Identifying Components

• Inserting / formatting a Word table
• Importing text
• Creating / modifying tables
• Adding / formatting bullets
• Copying slides / altering slide layout
• Building organizational charts
• Setting tabs
• Adding shapes
• Rotating / filling objects
• Aligning / distributing objects
• Drawing objects
• Adjusting color & position of objects
• Customizing ClipArt
• Creating summary slides
• Adding video clips
• Creating an action button
• Applying animation effects
• Creating an Agenda Slide
• Inserting an Excel chart
• Placing text inside shapes