Office 2000 Premium
Interactive Instructor Based Video Training Courses

Trainer Outline Specials Buy Options

Access 2000: Beginner Level

1.0 Introduction to Access 2000

1.1 Starting Access
1.2 Opening an Existing Database
1.3 The Access Desktop
1.4 The Database Window
1.5 A Preview of the Database Components

2.0 Working with an Existing Database

2.1 Viewing and Navigating Table Data
2.2 Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting and Deleting Records
2.5 Find and Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check and Auto-correct

3.0 Form Basics

3.1 Moving from Record to Record
3.2 Finding
3.3 Sorting
3.4 Filtering
3.5 AutoForms
3.6 Using a Form Wizard
3.7 Conditional Formatting

4.0 Report Basics

4.1 Moving from Page to Page
4.2 Zooming In and Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports and the Report Wizard
4.6 Page Setup

5.0 Printing Database Objects

5.1 Printing Table Datasheets
5.2 Printing Queries
5.3 Printing Forms
5.4 Printing Reports

6.0 Getting Help

6.1 The Office Assistant and Index Searching
6.2 Context-Sensitive Help and Printing Help Topics

7.0 Database Maintenance and Shortcuts

7.1 Backing Up and Restoring a Database
7.2 Compacting and Repairing a Database
7.3 Converting a Database to a Previous Version
7.4 Organizing Database Objects into Groups
Access 2000: Intermediate Level

1.0 Planning and Designing a Database

1.1 Evaluating Inputs and Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch

2.0 Building and Modifying Tables

2.1 Creating Tables Using a Wizard
2.2 Creating Tables from Scratch and Data Types
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes

3.0 Working with Relationships

3.1 Introduction to Relationships
3.2 Benefits of Relationships
3.3 Types of Relationships
3.4 Referential Integrity
3.5 Indexes and Relationships
3.6 Printing Relationships

4.0 Designing Simple Queries

4.1 Selecting Fields and Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables
Access 2000: Advanced Level

1.0 Building and Modifying Forms

1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving, Sizing and Deleting Controls
1.4 Aligning Controls
1.5 Changing Control Properties
1.6 Changing the Tab Order Controls
1.7 Form Properties
1.8 Working with Combo Boxes and List Boxes

2.0 Building and Modifying Reports

2.1 Understanding Report Bands
2.2 Working with Controls
2.3 Creating Groups and Totals Reports
2.4 Working with Report Properties
2.5 Modifying Selection Criteria

3.0 Database Startup Options

3.1 Setting the Application, Icon, and Startup Form
3.2 Designing other Startup Information

4.0 Importing, Exporting and Linking

4.1 Exporting to Another Database
4.2 Exporting to an Excel Spreadsheet
4.3 Exporting to ASCII
4.4 Exporting to HTML
4.5 Importing from Another Access Database
4.6 Importing Spreadsheet Data
4.7 Importing ASCII Data
4.8 Importing from HTML
4.9 Linking to Another Access Database
4.10 Linking to Another Type of Database
4.11 The Linked Table Manager
Access 2000: Expert Topics

1.0 Advanced Query Design Techniques

1.1 Calculated Fields
1.2 Summarizing Data
1.3 Excluding Fields
1.4 Parameter Queries
1.5 Make Table, Append, Update, and Delete Queries
1.6 The Find Duplicates Wizard
1.7 The Find Unmatched Wizard
1.8 Inner & Outer Joins
1.9 Self & Union

2.0 Advanced Form Design Techniques

2.1 Working with Built-in Tab Control
2.2 Working with Headers, Footers and Combo Boxes
2.3 Creating Multi-Table Forms and Subforms
2.4 Adding OLE Objects to Forms
2.5 Using a Bitmap as a Form Background
2.6 Adding Calculated Controls to a Form
2.7 Other Important Form Control Properties
2.8 Creating a Switchboard
2.9 Saving a Form as HTML

3.0 Advanced Report Design Techniques

3.1 Building Reports with Sub-Reports
3.2 Setting Section Properties
3.3 Adding Graphics to a Report
3.4 Adding / Modifying Calculations
Access 2000: Web Security

1.0 Access and the Web

1.1 Creating Data Access Pages
1.2 Modifying Data Access Page Properties
1.3 Modifying Record Navigating Control Properties
1.4 Grouping and Sorting Data within Data Access Pages

2.0 Charting Table Data

2.1 Using the Chart Wizard
2.2 Linking a Chart to a Record

3.0 Security Basics

3.1 Establishing a Database Password
3.2 Modifying a Database Password
3.3 Encrypting and Decrypting a Database

4.0 Replication Basics

4.1 Introduction to Replication
4.2 Converting a Database to a Design Master
4.3 Creating Additional Replicas
4.4 Synchronizing Changes
4.5 Managing Conflicts

5.0 Developing Apps with Macros

5.1 Creating a Macro
5.2 Running a Macro
5.3 Adding Macro Names
5.4 Modifying an Existing Macro
5.5 Adding Conditions to a Macro

6.0 Special Topics

6.1 Optimizing Data Types Usage
6.2 Establishing One-to-One Relationships
6.3 Using Add-ins
6.4 Report and Form Section Properties
Excel 2000: Beginner Level

1.0 The Excel Screen

1.1 The Excel Workbook and Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus

2.0 Entering Data into a Worksheet

2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
2.4 Auto Complete

3.0 Entering Formulas

3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction

4.0 Basic Functions

4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages

5.0 Formatting

5.1 The Formatting Toolbar
5.2 Adjusting Column-width and Row-height
5.3 Numeric Formatting

6.0 Saving, Opening & Closing Files

6.1 File Save or File Save As
6.2 Opening a File
6.3 Closing a File
6.4 Creating a New Workbook
Excel 2000: Intermediate Level

1.0 Changing Worksheet Layout

1.1 Inserting Columns, Rows and Cells
1.2 Deleting Columns, Rows and Cells
1.3 Moving Cells
1.4 Copying Cells

2.0 Additional Formatting

2.1 Formatting Cell Attributes and Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text Across Columns
2.5 Hiding & Unhiding Columns & Rows

3.0 Printing

3.1 Using Print Preview and Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview

4.0 Using Cell References

4.1 Absolute References
4.2 Mixed References

5.0 Tools Options Command

5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently Used Files List
5.4 Sheets in New Workbook
5.5 Default Settings
Excel 2000: Advanced Level

1.0 Adjusting Worksheet Views

1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split Screen

2.0 Auditing Techniques

2.1 Using the Auditing Toolbar
2.2 Tracing Dependent Cells
2.3 Tracing Precedent Cells

3.0 Using Functions

3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the Use of Standard Functions

4.0 Logical Functions

4.1 IF Functions and Relational Operators
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic Operators
4.4 Using Logical Operators with the IF Function
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function

5.0 Date & Time Functions

5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time Entry Techniques

6.0 Multi-Sheet Workbooks

6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving, Copying and Grouping Sheets
6.4 Formulas Across Multiple Sheets
Excel 2000: Charts

1.0 Creating a Chart

1.1 Data Selection
1.2 Single-click Chart creation
1.3 Chart Wizard
1.4 Copying a Chart

2.0 The Charting Toolbar

2.1 Features of the Charting Toolbar

3.0 Printing a Chart

3.1 Printing a Chart Located on a Separate Sheet
3.2 Printing a Chart Located on a Worksheet

4.0 Shortcuts

4.1 Creating a Shortcut on the Worksheet with Two Clicks
4.2 Add and Remove Data from an Embedded Chart
4.3 Change Row/Column Orientation

5.0 Chart Types

5.1 Line Charts
5.2 Column Charts
5.3 Cone, Pyramid, and Cylinder
5.4 Pie Charts
5.5 Other Chart Types

6.0 Formatting the X and Y Axis

6.1 Adjusting the Scale on Column Charts
6.2 Adjusting the Scale on Line Charts

7.0 Annotation Features

7.1 Adding Text and Arrows
Excel 2000: Special Topics

1.0 Naming Ranges

1.1 Naming a Single Cell
1.2 Naming Multiple Cells
1.3 Using Existing Names
1.4 Paste a List of Range Names in a Worksheet
1.5 Deleting Range Names

2.0 Conditional Formatting

2.1 Formatting Based on Values & Multiple Conditions
2.2 Avoiding Overlapping Conditions
2.3 Using a Formula to Control Formatting

3.0 Cell Protection Techniques

3.1 Unlocking Selected Cells Changes
3.2 Protecting the Worksheet To Restrict Entry to Unlocked Cells
3.3 Unprotecting the Worksheet

4.0 Annotating a Worksheet with Comments and Drawing Tools

4.1 Inserting, Displaying, Hiding, and Editing Comments
4.2 Options for Printing Comments
4.3 Show/Hide Comments with the Tools Options Command
4.4 Using the Drawing Toolbar

5.0 Multiple Workbooks

5.1 Opening and Displaying Multiple Workbooks
5.2 Moving and Copying Sheets Across Workbooks
5.3 Linking Formulas Across Workbooks
5.4 Locating and Maintaining Links

6.0 Customizing Toolbars

6.1 Adding & Removing Buttons
6.2 Economizing Buttons and Resetting Toolbars
6.3 Creating New Toolbars

7.0 Find and Replace

7.1 Matching Entire Cells, Case, and Wildcard Characters

8.0 Using Goal Seek

8.1 Features of Goal Seek

9.0 Numeric Formatting

9.1 The Custom Category
9.2 The Special Category
9.3 Formatting with IMPLIED-IF
Excel 2000: Databases

1.0 Data Form

1.1 Setting Up a Single Record with Formulas
1.2 Adding Records to a Database
1.3 Finding Records & Avoiding Cells Below

2.0 Data Validation

2.1 Establishing Data Entry Criteria
2.2 Using Data Validation on Existing Data

3.0 Data Sort

3.1 Sorting from the Menu
3.2 Sorting from the Toolbar
3.3 Multiple-Key Sorting
3.4 Sorting with Custom Lists

4.0 Data Subtotals

4.1 Single Level Subtotals
4.2 Multiple Level Subtotals

5.0 Data Filter

5.1 Criteria
5.2 Top-ten
5.3 Advanced Filter

6.0 Data Functions

6.1 Sumif, Countif
6.2 Array Functions & Formulas
Excel 2000: Tips, Tricks, & Shortcuts

1.0 Navigaton Shortcuts

1.1 Navigating Around a Worksheet
1.2 Navigating Multiple Workbooks
1.3 Some Useful Keyboard Shortcuts
1.4 Navigating to the Bottom of a Column

2.0 Selection Shortcuts

2.1 Selecting a Range
2.2 Selecting an Entire Worksheet
2.3 Selecting Non-contiguous Ranges & Go to Special

3.0 Data Entry Shortcuts

3.1 Entering System Date & Time
3.2 Copying Formulas & Results
3.3 Entering Data in a Range of Cells, Auto Complete & Data Validation
3.4 Multi-line Entries

4.0 Formula Shortcuts

4.1 Displaying Formulas
4.2 Dependent & Precedent Cells
4.3 VLookup

5.0 Formatting Shortcuts

5.1 Numerical Formatting
5.2 Numerical Keyboard Shortcuts
5.3 Dealing with Large Numbers

6.0 Operational Shortcuts

6.1 Undoing and Repeating
6.2 File Management Shortcuts
6.3 Inserting, Deleting, & Hiding Shortcuts

7.0 Data Expansion Shortcuts

7.1 Numerical Series
7.2 Dates

8.0 Drag & Drop

8.1 Moving, Copying & Inserting
8.2 Moving, Copying & Inserting to a Different Sheet
8.3 Moving, Copying & Inserting Using the Mouse

9.0 Display Shortcuts

9.1 Split Screens

10.0 Listing Unique Entries

10.1 Data Filter Advanced
10.2 Capturing a Picture
Excel 2000: Pivot Tables

1.0 Background

1.1 An Example

2.0 Creating a Pivot Table

2.1 Using the Pivot Table and Pivot Chart Wizard
2.2 Viewing Pivot Tables and Pivot Charts

3.0 Manipulating the Layout

3.1 Interchanging Fields
3.2 Adding and Removing Fields
3.3 Page Axis

4.0 Content & Formatting

4.1 Numeric Formatting
4.2 Selecting Specific Information & AutoFormat

5.0 The Refresh Button

5.1 Changing Original Data
5.2 Changing Field Names

6.0 Pivot Table Chart Sources

6.1 Selecting & Manipulating Chart Data
6.2 The Pivot Chart & Pivot Table Relationship
6.3 Pivot Chart Formatting
6.4 Creating a Pivot Chart & Table Together from the Original Data

7.0 Sorting Items

7.1 Sorting by Field Order & Numeric Information

8.0 Hiding & Revealing Data

8.1 Drop Arrows
8.2 Hiding Inner Fields

9.0 Grouping & Ungrouping

9.1 Grouping Data
9.2 Grouping by Date

10.0 Totals

10.1 Displaying Totals
10.2 Adding & Removing Totals
Excel 2000: Functions

1.0 Statistical Functions

1.1 Median & Rank
1.2 Small & Large
1.3 Count, Counta, & Mode
1.4 Using Functions in a Range
1.5 Average, Averagea, & True

2.0 Analysis ToolPak

2.1 Accessing more Functions

3.0 Financial Functions

3.1 PMT & FV
3.2 PV & Rate

4.0 Math Functions

4.1 Round, Roundup, Rounddown
4.2 Ceiling & Floor

4.3 Odd & Even
4.4 Fact, Power, Product, & Int
4.5 Mod
4.6 Rand & Randbetween
4.7 Roman

5.0 Text Functions

5.1 Find & Mid
5.2 Left & Concatenation
5.3 Len & Right
5.4 An Example, Replace, & Substitute
5.5 Upper, Lower, & Proper
5.6 Trim

6.0 The Indirect Function

6.1 The Indirect Function
Excel 2000: Files & Reports

1.0 Workbook Management

1.1 Workspaces
1.2 Assigning Passwords
1.3 Hiding Workbooks

2.0 Formatting Workbooks

2.1 AutoFormat
2.2 Styles

3.0 Outlining

3.1 Group and Outlining Capabilities

4.0 Templates

4.1 Creating a Default Workbook Template
4.2 Creating a Custom Template

5.0 Report Manager

5.1 Printing and Views

6.0 Scenario Manager

6.1 Creating Scenarios
6.2 Solver

7.0 The Drawing Toolbar

7.1 WordArt
7.2 Shapes, Lines & Arrows
7.3 Coloring Objects & Adding Text
7.4 ClipArt

8.0 Using Excel with Other Applications

8.1 Text Files
8.2 Access
8.3 Word

9.0 Hyperlinks

9.1 Types of Links
FrontPage 2000: Beginner Level

1.0 Welcome to FrontPage 2000

1.1 Looking Around
1.2 Building Your First Web

2.0 Page Editor

2.1 Text Formatting
2.2 Other Formatting Features
2.3 Paragraph Formatting
2.4 Saving your Changes
2.5 Normal View
2.6 HTML View
2.7 Preview
2.8 Summary of Topics

3.0 Navigation View

3.1 Introduction to Navigation View
3.2 Viewing Your Site
3.3 Opening a Page
3.4 Adding a Page
3.5 Moving a Page
3.6 Renaming a Page
3.7 Deleting a Page
3.8 Summary of Topics

4.0 Appendix - Installing FrontPage 2000

4.1 Introduction to Installing
4.2 What You Will Need
4.3 Launching Setup
4.4 Configuring Options
4.5 Summary of Topics
FrontPage 2000: Intermediate Level

1.0 Folder View

1.1 Viewing Your Site
1.2 Sorting by Column
1.3 Opening a Page
1.4 Adding & Moving a Page
1.5 Deleting a Page
1.6 Adding a Folder

2.0 Themes

2.1 What are Themes and Selecting a Theme
2.2 Theme Options
2.3 Customizing a Theme
2.4 Summary of Topics

3.0 Hyperlinks

3.1 What is a Hyperlink?
3.2 Defining a Hot Spot
3.3 Defining an Action
3.4 Summary of Topics

4.0 The Task View

4.1 What is a Task?
4.2 Completing a Task
4.3 Defining a New Task
4.4 Reassigning a Task

5.0 Security

5.1 Web Server
5.2 User Accounts
5.3 Browse, Author, Administer Access
FrontPage 2000: Advanced Level

1.0 Tables

1.1 What is a Table?
1.2 Inserting a Table
1.3 Table Properties

2.0 Forms

2.1 What is a Form?
2.2 Building a Form
2.3 Retrieving Form Results

3.0 Cascading Style Sheets

3.1 What is a Style?
3.2 Styles in FrontPage 2000
3.3 Creating & Linking a Style Sheet

4.0 Frames

4.1 What is a Frame and Building a Framed Page
4.2 Frame Properties

5.0 Special Effects

5.1 Dynamic HTML
5.2 Page Transitions
5.3 Browser Compatibility

6.0 Publishing Your Web

6.1 Open Existing Web
6.2 Publish to Web Server
6.3 Verifying Your Web Site
Outlook 2000: Beginner Level

1.0 Getting Started

1.1 Setting Up a Profile
1.2 Personal folders vs. Exchange Server
1.3 The Welcome Dialog and the Office Assistant
1.4 Getting Comfortable with Outlook
1.5 The Outlook Bar
1.6 Viewing Drive Letters and Folders
1.7 Creating Outlook Bar Shortcuts
1.8 Browsing Web Sites & Using Favorites
1.9 Getting Help
1.10 Changing Outlook Profiles
1.11 The Outlook Today View

2.0 Sending & Receiving Messages

2.1 The Outlook Messaging Window
2.2 Reading & Replying to Messages
2.3 Sorting Messages
2.4 Forwarding a Message
2.5 Organizing your Messages Into Folders
2.6 Printing Messages & Print Options
2.7 Address Books
2.8 Composing & Sending New Messages
2.9 Deleting Messages
2.10 The Office 2000 Clipboard

3.0 The Outlook Calendar

3.1 Working Within a Separate Calendar Window
3.2 Displaying your Schedule
3.3 Appointments & Events
3.4 Editing an Appointment or Event
3.5 Copying, Moving, & Deleting
3.6 Scheduling Multi-day Events
3.7 Recurring Appointments & Events
3.8 Turning an Email Message into an Appointment
3.9 Customizing the Calendar
3.10 Customizing Menu & Tool Bars
3.11 Printing & Setting Print Options
3.12 Saving as a Web Page
3.13 Setting Meetings & Calendar Options

4.0 Working with Contacts

4.1 Modifying and Creating Contacts
4.2 Categorizing Contacts
4.3 Deleting a Contact
4.4 Contact Information via Email & Printing Contact Information
4.5 Manually Recording in a Journal
4.6 Linking, Following up on, & Sorting Contacts
4.7 Having Outlook Dial the Phone
4.8 Dragging and Dropping
4.9 Contacts & other Office 2000 Programs
4.10 Customizing the Menu Bar and Task Bar
Outlook 2000: Intermediate Level

1.0 Enhanced Messaging Techniques

1.1 Customizing Outlook Today
1.2 Formatting Messages
1.3 Microsoft Word as Your E-mail Editor
1.4 WordMail Templates (Themes) & Custom Signatures
1.5 Resending Messages
1.6 Recalling a Message
1.7 Distribution Lists
1.8 Personal Address Books
1.9 File Attachments
1.10 The Find & Advanced Find Features

2.0 Working with the Task List

2.1 One-Time Tasks
2.2 Assigning Tasks to Others
2.3 Accepting, Declining & Tracking the Progress of Tasks
2.4 Assigning Delegate Access
2.5 Recurring Tasks
2.6 Changing Task Views
2.7 Organizing Tasks
2.8 Creating Tasks from E-mail Messages
2.9 New Appts, Events, & E-mail Messages
2.10 Customizing the Task Bar

3.0 Outlook Notes

3.1 Working with Outlook Notes

4.0 Using the Outlook Journal

4.1 Custom Options & Recording Tasks
4.2 Journal Entries

5.0 Faxing with Outlook

5.1 Installing Microsoft Fax
5.2 Adding & Configuring the Fax Service
5.3 Sending & Customize Faxes
5.4 Receiving a Fax

6.0 Working with Newsgroups in Outlook

6.1 Newsreader Features
6.2 Newsgroup Postings

7.0 Customizing Outlook

7.1 Setting General Preferences
7.2 Customizing the Menu Bar & the Task Bar
7.3 Time Zone Settings
Outlook 2000: Advanced Level

1.0 Advanced Information Services

1.1 Multiple Personal Folder Files
1.2 Working Offline
1.3 Quick Synchronization Group

2.0 Advanced Messaging Features

2.1 Dial-up Networking & Remote Mail
2.2 Using Stationery to Create HTML Messages
2.3 Email Signatures
2.4 Adding a Vcard to a Message
2.5 Using Public Folders Offline
2.6 Exchange Server
5.5 Undelete
2.7 The Rules Wizard
2.8 Granting Folder Permission to Others
2.9 Assigning Delegates
2.10 Handling Junk Email
2.11 Office 2000 Documents
2.12 Mail Merge with Word

3.0 Advanced Messaging Options

3.1 Custom Views
3.2 Flagging Specific Messages
3.3 Conducting a Vote
3.4 Delivery Date & Other Options
3.5 Archive Mail Messages
3.6 Importing & Exporting Data to Other E-mail Programs

4.0 Group Collaboration Features

4.1 Public Folders
4.2 Net Folders
4.3 Using the iCalendar Feature
4.4 Importing & Exporting Data
PowerPoint 2000: Beginner Level

3.0 Advanced Messaging Options

3.1 Custom Views
3.2 Flagging Specific Messages
3.3 Conducting a Vote
3.4 Delivery Date & Other Options
3.5 Archive Mail Messages
3.6 Importing & Exporting Data to Other E-mail Programs

4.0 Group Collaboration Features

4.1 Public Folders
4.2 Net Folders
4.3 Using the iCalendar Feature
4.4 Importing & Exporting Data

4.0 Working with Text

4.1 Spell Check & Promotion and Demotion
4.2 Aligning Text
4.3 Adding a Text Box
4.4 Fonts
4.5 Office Clipboard

5.0 Working with Visual Elements

5.1 Adding Clip Art
5.2 Adding Shapes & Word Art
5.3 Grouping
5.4 Fill Features
5.5 Adding Tables
5.6 Tips for Beginners
PowerPoint 2000: Intermediate Level

1.0 Customizing a Presentation

1.1 Bullets and Numbering
1.2 Animating Text
1.3 Slide Transitions
1.4 Speaker Notes

2.0 Creating Output

2.1 Previewing Presentations in Black and White
2.2 Printing Slides
2.3 Printing Handouts
2.4 Printing Speaker Notes
2.5 Printing the Outline View

3.0 Delivering a Presentation

3.1 Starting a Slide Show
3.2 Using the On-Screen Navigation Tools
3.3 The Pen Tool
3.4 Printing Overhead Transparencies

4.0 Managing Files

4.1 Saving Presentations
4.2 Publishing to the Web
4.3 Hyperlinks
4.4 The Office Assistant

5.0 Advanced Features

5.1 Automatically Create a Summary Slide
5.2 Automatically Create an Agenda Slide
5.3 Creating our own Design Template
5.4 Auto Content Wizard

6.0 Modifying a Presentation

6.1 Applying animation effects
6.2 Inserting animated GIF's
6.3 Adding an Action Button
6.4 Customizing a Color Scheme
6.5 Creating a Custom Background
6.6 Changing Tab Formatting
6.7 Hiding Slides
6.8 Adding a Presentation within a Presentation
6.9 Setting automatic Slide Timings
PowerPoint 2000: Advanced Level

1.0 Working Visual Elements

1.1 Adding Textured Backgrounds
1.2 Applying Diagonal Borders to a Table

2.0 Using Data from Other Sources

2.1 Exporting an Outline to Word
2.2 Importing an Outline from Word
2.3 Adding a Table from Word
2.4 Inserting an Excel Chart
2.5 Adding Sound
2.6 Adding Video

3.0 Creating Output

3.1 Saving a Slide as a Graphic
3.2 Generate Meeting Notes
3.3 Changing the Output Format ( Page Setup )
3.4 Export to 35mm Slides

4.0 Delivering a Presentation

4.1 Save Presentation for Use on Another Computer ( Pack N' Go )

5.0 Managing Files

5.1 Saving Embedded Fonts in a Presentation
5.2 Saving HTML to a Specific Target Browser

6.0 Toolbars

6.1 Customizing the Toolbar
6.2 Creating a Toolbar

7.0 Working with Charts & Graphs

7.1 Building and Modifying a Chart or Graph
7.2 Building an Organization Chart
7.3 Animating an Organization Chart

8.0 Collaborating with Workgroups

8.1 Broadcasting Overview
8.2 Setting Up the Presentation for Broadcasting
8.3 Viewing a Presentation on the Web
8.4 Using Net Meeting to Schedule a Broadcast
Publisher 2000: Beginner Level

1.0 Getting Started

1.1 Creating a New Publication
1.2 Exploring the Publisher Desktop
1.3 Navigating about a Publication
1.4 Zooming In and Out
1.5 Saving Your Work
1.6 The Save Reminder
1.7 Closing and Opening a Publication

2.0 Using the Objects Toolbar

2.1 Changing the Placement of the Objects Toolbar
2.2 Inserting Text Frames
2.3 Introduction to Word Art
2.4 Adding Pictures

3.0 Working with a Publication

3.1 Entering Text
3.2 Formatting Text
3.3 Additional Formatting
3.4 Moving, Copying, and Deleting Text
3.5 Inserting and Deleting Pages

3.6 Selecting Objects
3.7 Moving and Sizing Objects
3.8 Deleting Objects
3.9 Layering Objects
3.10 Working with Guides and Rulers
3.11 Modifying the Page Setup
3.12 Working with the Publication Background

4.0 Getting Help

4.1 The Assistant
4.2 Using the Help Index & Printing Help
4.3 Getting Help Over the Internet & Customizing the Assistant

5.0 Printing a Publication

5.1 Checking the Printer Setup
5.2 Selecting Printer Options & Sending Your Work to the Printer
5.3 Troubleshooting Printing
Publisher 2000: Intermediate Level

1.0 Wizards & Design Sets

1.1 Using Wizards
1.2 Customizing a Wizard Document
1.3 Working with Design Sets
1.4 Using Special Paper
1.5 The Design Gallery Object

2.0 Advanced Text Techniques

2.1 Connecting and Disconnecting Frames
2.2 Importing Text
2.3 Editing Articles in Word
2.4 Search and Replace
2.5 The Spell Checker and AutoCorrect
2.6 Indents, Bullets, Numbered Lists, and Tabs
2.7 Other Cool Text Techniques
2.8 Wrapping Text Around Other Objects
2.9 Working with Styles

3.0 Advanced Page Techniques

3.1 Different Backgrounds for Left-Hand and Right-Hand Pages
3.2 Accommodating Unique Pages
3.3 Adding Page Numbers
3.4 Changing the Starting Page Number
3.5 Continued On and Continued From
3.6 Creating Multi-column Text Frames
3.7 Wrapping Text Around Other Elements

4.0 Advanced Object Techniques

4.1 Inserting Drawing Objects
4.2 Grouping Objects
4.3 Aligning Objects
4.4 Rotating Objects
Publisher 2000: Advanced Level

1.0 Advanced Graphic Techniques

1.1 Cropping a Picture
1.2 Inserting Pictures From the Web
1.3 Finding Clips with Keywords
1.4 Scaling Pictures
1.5 Re-Coloring Pictures
1.6 Rotating Pictures
1.7 Adding Borders and Shadows
1.8 Customizing the Clip Art Gallery

2.0 Border Art

2.1 Creating Border Art
2.2 Customizing Border Art

3.0 Word Art

3.1 Creating a Word Art Object
3.2 Changing Text Formatting
3.3 Character Spacing
3.4 Special Effects, Shading, Shadowing & Borders
3.5 Editing a Word Art Object

4.0 Miscellaneous Cool Advanced Features

4.1 Personal Information
4.2 The Design Checker
4.3 Sound
4.4 Video

5.0 Tables

5.1 Adding a Table & Creating a Header
5.2 Entering Data into the Table
5.3 Selecting Cells, Rows and Columns
5.4 Inserting and Deleting Rows and Columns
5.5 Formatting Tables Data

6.0 Advanced Printing Techniques

6.1 Working with an Outside Printer
6.2 Specialized Printing Techniques

7.0 OLE

7.1 Inserting and Updating an OLE Object
Publisher 2000: Internet & Business Applications

1.0 Using Mail Merge

1.1 Creating & Merging Address Lists
1.2 Customizing an Address List
1.3 Filtering or Sorting an Address List
1.4 Merging with a Source not Created in Publisher

2.0 Creating a Web Site

2.1 Working with the Web Site Wizard
2.2 Adding your Information on the Web Pages
2.3 Viewing the Web Site in a Browser
2.4 Customizing the Web Site
2.5 Defining Hyperlinks
2.6 Publishing to the Web
2.7 Creating a Business Web Page
2.8 Creating a Personal Web Page

3.0 Customizing Publisher

3.1 General Options
3.2 Edit Options
3.3 User Assistance Options
3.4 Print Options

4.0 The Design Process

4.1 Planning
4.2 Selecting a Printer
4.3 Page Size and Orientation
4.4 Setting Up a Grid
4.5 Selecting a Color Scheme
4.6 Designing the Background
4.7 Positioning Text and Pictures
4.8 Fine-Tuning
Word 2000: Beginner Level

1.0 Getting Started

1.1 Starting Word 2000
1.2 Touring the Word Window

2.0 Creating New Documents

2.1 Entering Text
2.2 Saving Your Work
2.3 Printing & Closing a Document
2.4 Working with a Template
2.5 Using a Wizard

3.0 Revising Documents

3.1 Opening a Document
3.2 Moving in a Document
3.3 Basic Editing
3.4 Adding a Date
3.5 Click and Type
3.6 Envelopes & Labels
3.7 Multiple Page Documents

4.0 Getting Help

4.1 Office Assistant
4.2 Help Window
4.3 Context Sensitive Help

5.0 Essential Skills

5.1 Selecting Text
5.2 Copying & Moving Text
5.3 The Office Clipboard
5.4 Undo, Redo, Repeat, & AutoCorrect
5.5 AutoComplete

6.0 Character Formatting

6.1 Changing Font Formatting
6.2 The Formatting Toolbar
6.3 Symbols & Special Characters
6.4 AutoFormat As You Type

7.0 Paragraph Formatting

7.1 Paragraph Alignment
7.2 Line Spacing

8.0 Document Formatting

8.1 Margins & Paper Size
8.2 Controlling Page Breaks

9.0 Proofing Documents

9.1 Spelling & Grammar
9.2 Thesaurus

10.0 Previewing & Printing a Document

10.1 Previewing a Document
10.2 Printing a Document

11.0 Shortcuts

11.1 Shortcut Menus
11.2 Keyboard Shortcuts
11.3 Exiting Out of Word
Word 2000: Intermediate Level

1.0 Document Management

1.1 Document Views
1.2 Working with Multiple Document Windows
1.3 File Management

2.0 Additional Editing Tools

2.1 Find & Replace
2.2 AutoText
2.3 Format Painter

3.0 Customizing Word

3.1 Toolbars
3.2 Personalized Menus
3.3 Defaults
3.4 Options

4.0 More Paragraph Formatting

4.1 Tabs
4.2 Indents
4.3 Bullets, Numbering, & Line Breaks
4.4 Special Spacing
4.5 Sorting Text
4.6 Borders & Shading

5.0 Page Numbers, Headers & Footers

5.1 Numbering Pages
5.2 Headers & Footers

6.0 Section Formatting

6.1 Using Sections
6.2 Newspaper Columns

7.0 Introduction to Graphics

7.1 Basics
Word 2000: Advanced Level

1.0 Tables

1.1 Creating a Table
1.2 Navigating and Modifying a Table
1.3 Formatting a Table

2.0 Automatic Formatting and Styles

2.1 Applying Styles
2.2 Creating Your Own Styles
2.3 Modifying Existing Styles

3.0 Document Templates

3.1 Personalizing Word's Templates
3.2 Creating Your Own Styles
3.3 Automating with Field Codes

4.0 Long Documents & Reports

4.1 Cross-references & Bookmarks
4.2 Footnotes
4.3 Tables of Contents
4.4 Indexes
4.5 Outlines
4.6 Document Map

5.0 Sharing Documents

5.1 Comments
5.2 Tracking Changes
5.3 Protecting Documents
5.4 Saving Different Versions

6.0 Macros

6.1 Creating & Running Macros
6.2 Editing Macros
6.3 Automatic Macros
Word 2000: Mail Merge

1.0 Mail Merge Basics

1.1 Using the Mail Merge Helper
1.2 Creating a New Data Source
1.3 Completing the Main Document
1.4 Running the Merge
1.5 Editing a Data Source
1.6 Understanding and Creating a Data Table

2.0 More Mail Merge

2.1 Envelopes
2.2 Labels
2.3 Catalogs
2.4 Using Data from Other Sources

3.0 Customizing a Merge

3.1 Mail Merge Options
3.2 Sorting Data Records
3.3 Selecting Records to Merge
3.4 Special Merge Fields
Word 2000: Desktop Publishing

1.0 Columns

1.1 Adding Columns
1.2 Column & Section Breaks

2.0 Formatting Text

2.1 Fonts Styles & Paragraph Formatting
2.2 Styles
2.3 Letter & Line Spacing
2.4 Inserting Symbols
2.5 Drop Cap
2.6 Borders & Shading
2.7 Special Effects
2.8 Creating Templates

3.0 Working With Graphics

3.1 Clip Art Gallery
3.2 Formatting Graphics
3.3 Searching Online For Graphics
3.4 WordArt
3.5 Creating & Modifying Charts

4.0 Drawing Tools

4.1 Basic Drawing Objects
4.2 AutoShapes & Text Boxes

5.0 Page Formatting
5.2 Watermarks

5.1 Page Borders