Meet Varies , Your Instructor for This Course:
This set contains more than one instructor, please see the individual tape sections for instructor details.
|
Word 2000 Session 1
Section A: The Word Window
- Opening Word & the Word Window
- Opening Past Documents
- Learning to Get Around in Your Work
Section B: Selecting
- Select & Do
- The Undo Command
- Selecting More Efficiently
Section C: Commands & Shortcuts
- Deleting, Moving & Copying Text
- Menus, Buttons & Shortcuts
- Personalized Menus & Toolbars
- More Toolbars
- Shortcuts
- The Right Click
Section D: Maintaining Your Sanity
- Saving Your Work
- Fixing Mistakes
- Saving & Salvaging Your Work
- Help
Section E: Templates
- Page Setup Templates
- Customizing Your Default Text Format
- Template Options
- Creating Templates
- Finding & Altering Templates
Section F: Creating Content
- Typing Basics
- Word's Helpful Hints
- Accents & Signs
- AutoCorrect & Autoformat
- AutoCorrect & It's Functions
Section G: Formatting
- Using the Right Click
- Shortcuts
- Viewing Fonts Correctly
- The Paragraph Command
Section H. Printing
- Print Preview
- Printing Options
|
Word 2000 Session 2
Section A: Copy, Paste & Paste Special
- Open Dialog Box
- Select, Copy & Paste
- Paste Special
- The Clipboard
- Collect & Paste
Section B: Automating Content Creation
- Templates
- AutoCorrect & AutoComplete
- AutoText
- Review
Section C: Lists
- Bulleted Lists
- Picture Bullets
- Numbered Lists
- Outline Numbered Lists
- Customizing Outline Numbered Lists
Section D: Format Techniques
- Paragraph Command & Formatting Shortcuts
- Click & type
- Font Command
- Borders & Shading Command
- Format Painter & Repeat Command
Section E: Styles Section F: Understanding Tables
- What should be in a Table?
Section G: Creating Tables
- Adding a Table
- Formatting a Table
- Automating Table Creation
Section H: Managing Tables
- Table Selection Shortcuts
- Table Properties Command
- Adding & Deleting Columns
- Splitting & Merging Cells
- Tables & Borders Toolbar
Section I: Tabs
- Types of Tab Stops
- Creating, Moving & Deleting Tab Stops
- Decimal & Leader Tab Stops
Section J: Saving & Sending Documents
- "Save As" & "Send To" Commands
- Web Page Preview & Save as Web Page
- Creating Folders from "Save As"
|
Word 2000 Session 3
Section A: Thesaurus & Find/ Replace
- Thesaurus, Find & Replace
- "More Option" of the Replace Command
Section B: Using Graphics
- Adding & Positioning Clip Art
- Formatting Clip Art
- Inserting & Formatting a Picture
- Inserting & Formatting WordArt
- Drawing Toolbar
Section C: Text Flow
- Inserting Page Flow
- Line & Page Breaks
Section D: Navigating Long Documents
- Heading Styles & Go To
- Bookmarks & Keyboard Shortcuts
- Hyperlinks
Section E: Sections
- Inserting a Section Book
- Page Orientation
- Borders & Shading Tab
- Vertical Alignment
Section F: Columns
- Reformatting Text into Multiple Columns
- Adding Text into Multiple Columns
- Column Break Command
Section G: Headers & Footers
- Page Numbers
- Headers & Footers Toolbar
Section H: Complex Headers & Footers
- Modifying First Page Headers & Footers
- Modifying Section Headers & Footers
Section I: Letters, Envelopes & Labels
- Letter Wizard
- Creating Letter Templates
- Adding a Date & Saving the Template
- Envelopes & Labels
Section J: Mail Merge
- Creating a Data Source for Mail Merge
- Inserting Merge Fields
- Merging & Review
Section K: Complex Mail Merge
- Creating Data Sources in Excel
- Creating Mailing Labels
- Sorting & Filtering
|
Excel 2000 Session 1
Section A: Introduction
- Uses for a Spreadsheet
- Understanding the Excel Workspace
- Selecting a Range of Cells
Section B: Entering Values
- Entering Text, Numbers & Dates
- Formatting Dates & Editing Values
- Sorting a List
Section C: Managing Workbooks
- Saving a Workbook
- Opening & Closing Workbooks
- Workbook Add, Delete, Rename & Move
Section D: Creating a From or Document
- Creating a From or Document
- Changing Fonts, Color & Alignment
- Formatting Dates
- Resizing Columns & Rows
- Creating Backgrounds & Borders
- Inserting Columns
- Merging Cells
Section E: Summarizing Numbers
- Using Auto Fill
- Using Tab to Enter Values
- Creating Totals Automatically
- Understanding the SUM Function
- Creating & Validating Formulas
Section F: Formatting Numbers
- Currency Style
- Auto Formatting Regions & Moving Cells
Section G: Creating Charts
- Adding a Chart
- Adding New Values to a Chart
- Creating a Custom Chart
- Using the Chart Toolbar & Menu
- Chart Location
Section H: Printing
- Print Preview & page Setup Options
- Preview Color in Black & White
- Selecting Multiple Sheets
- Printing
Section I: Customizing Excel
- Changing Workbook Options
- Using Adaptive Menus & Toolbars
- Context Sensitive Toolbars
Section J: Discovering More
- Screen Tips
- Use Help in Dialogue Boxes
- Using the Office Assistant
- Help Context
|
Excel 2000 Session 2
Section A: Managing References
- Relative References
- Using Auditing Toolbar
- Mixed & Absolute References
- Saving Workbooks
Section B: Names Ranges
- Naming Cells
- Naming Ranges
- Applying Names
Section C: Manipulating Ranges
- Importing Files
- Special Formatting Features
- Find/Replace
Section D: Basic Functions
- Summarizing Functions
- 3-D Formulas
- Logical Functions
- Date Functions
Section E: Look-up Functions
- Types of Look-ups
- Vertical Look-up
- Applying Names to Vertical Look-up
Section F: Financial Functions
- Types of Financial Functions
- Calculating Payments
Section G: Considering Alternatives
- Using Scenarios
- Report Manager
- Using Goal Seek
- Using the Solver
Section H: Enhanced Formatting
- Formatting Numbers
- Formatting Text
- Applying Styles
Section I: Dynamic Formatting
- Applying Conditional Formats
- Using Data Validation
Section J: Graphical Objects
- Using the Drawing Toolbar
- Adding Comments
- Inserting Pictures
|
Excel 2000 Session 3
Section A: Managing Workbooks
- Introduction
- Adding a File Password
- Protecting a Worksheet
- Freezing Row & Column Headers
- Changing Page Breaks
- Printing Portions of a Worksheet
- Setting Workbook Properties Certification
- Creating a Workspace
- Tips for the Exam
Section B: Using Templates
- Overview
- Saving & Editing a Template
- Changing the Default Template
- Changing the Default Worksheet Template
- Section C: Sharing a Workbook
- Sharing a Workbook
- Editing a Shared Workbook
- Tracking Changes to a Shared Workbook
- Merging Workbooks
Section D: Query a Database
- Retrieving Data from a Database
- Filtering the Data using Microsoft Query
Section E: Working with Lists
- Sorting Lists
- Using a From to View/Search a List
- Using AutoFilter
- Using the Advanced Filter
- Adding Subtotals to a List
- Tracing Errors
Section F: Working with PivotTables
- Creating A PivotTable
- Formatting a PivotTable
- Creating a PivotChart
Section G: Excel and the Internet
- Saving a Workbook as HTML
- Saving HTML with Interactivity
- Saving an Interactive PivotTable as HTML
- Importing Values from a Web Site
- Creating Hyperlinks in a Worksheet
- Using the Office Clipboard
- Round Tripping to HTML & Back Again
Section H: Creating Macros
- Creating & Running a Macro
- Looking at a Macro's Code
- Creating Another Macro
- Editing the Macro
- Creating a Button to Run a Macro
- Printing Portions of a Worksheet
Section I: Preparing for Certification
- The Testing Method
- Tips for the Exam
|
Access 2000 Session 1
Section A: Introduction
- Uses for a Database
- Access & other Office Applications
- Understanding & Comparing Tables
- Creating a New Database
Section B: Creating an Attribute Table
- Datasheet View
- Design View
- Entering Values
- Datasheet Features
- Print Preview
- Access vs. Excel
- Saving Design Changes
Section C: Creating a Lookup Table
- Creating a New Table
- Creating a Primary Key
- Creating a Relationship Between Tables
- Cascade Update & Deletes
- Entering Data in a Sub-form
- Creating a Lookup to a Text Key
Section D: Creating Queries
- Sorting & Filtering
- Save as Query
- Editing a Query in Design View
- Using the Query Wizard to Join Tables
- Changing Values in a Query
Section E: Creating Forms
- Create an AutoForm
- Columnar, Datasheet & Tabular Forms
- Printing a Form
Section F: Creating a Measures Table
- Designing a Measures Table
- Using Automatic & Primary Keys
- Specifying Column Data Types
- Crating a Lookup
- Preventing Duplicate Keys
- Relating Tables
Section G: Creating Summary Queries
- Creating Summary Queries
- Crosstab Queries
Section H: Creating Reports
- Create a Tabular Report
- Using the Report Wizard
- Editing the Report
Section I: Discovering More
- Customize Access
- Using the Office Assistant & Help Window
|
Access 2000 Session 2
Section A: Designing a Database
- Introduction
- Field Names
- Keys
Section B: Importing & Exporting Tables
- Importing From Access
- Exporting
- Copying to & from Excel
Section C: Customizing Field Definitions
- Field Features
- Order Detail table
Section D: Extending Queries
- Making a New Query
- Filters & Criteria
- Add a Field
Section E: Creating Action Queries
- Create New Query
- Modify Query
- Update Action Query
- Delete Query
Section F: Managing a Database
- Suggestions
- Database Security
- Synchronization
- Linking Databases
Section G: Improving Database Design
- Table Indexes
- Relationships
- Splitting Tables
|
Access 2000 Session 3
Section A: Creating Report Details
- Creating Forms & Reports
- Queries in Design View
- Creating Reports in Design View
- Linking Reports to Queries
- Altering Labels
- Adding Fields
- Converting Text Boxes to Labels
- Refining Label Location
Section B: Creating Report Groupings
- Sorting & Grouping
- Creating Extended Price
- Adding Text Boxes
- Forcing New Pages
- Formatting Reports
Section C: Enhancing the layout of a Report
- Creating a Page Header
- Adding Logos & Images
- Header & Cover Page Options
Section D: Creating Form Details
- Form & Report Differences
- Copying Controls & labels
- Headers & Footers
- Linking Data
- Changing Unit Price
- Altering Form List
- Locking & Enabling from Changes
- Changing Product Name
- Adding a Calculated Field
Section E: Creating Form Grouping
- Renaming & Creating Forms
- Adding & Arranging Controls
- Adding Subforms
Section F: Enhancing the layout of a Form
- Controlling the Form & Subform Display
Section G: Displaying Data in a Chart Section H: Automating Access
- Adding Form Controls
- Adding a Graphic Image
- Using the Macro Builder
- Creating a Switchboard
- Splitting the Database
Section I: Integrating with the Internet
- Creating a Hyperlink
- Exporting Queries to HTML Documents
- Creating a Data-access Page
Section J: Tips for the Certification Test |
PowerPoint 2000 Session 1
Section A: Introduction Section B: The Microsoft Method
- Introduction to the Microsoft Method
- Creating Outlines
- Inserting New Slides
- Introducing Different Types of Slides
- Outline View
- Organizing Slides
Section C: Preparing a Presentation
- Help
- Templates
- Page Layout
Section D: Building a Presentation
- Creating a New Presentation
- Adding Content
- Saving
Section E: Working with Objects
- Prepare the Workspace
- Creating Objects
- Manipulating Objects
Section F: Formatting Objects
- Fill Colors
- Fill Effects
- Lines
- Other Options
Section G: Working with Multiple Objects
- Selecting Multiple Objects
- Aligning Objects
- Zoom
- Order
- Customer Toolbar
- Semi-transparent
- Grouping
- Align & Distribute
- Clipboard
- Rotate & Flip
- Changing Format
|
PowerPoint 2000 Session 2
Section A: AutoShapes
- Control Handles
- Lines
- Free Hand Tool
- Connectors
- Making Designs
Section B: Text Boxes
- Creating & Manipulating Text Boxes
- Formatting
- Justification & Bullet Points
Section C: More Text Boxes
- Find & Replace
- Paragraph Formatting
- Turning AutoShapes in Text Boxes
Section D: Pictures
- Formatting Pictures
- Brightness
- Framing
Section E: Slide Master
- Logos
- Title & Bullets
- Bars
- Background
- Color Scheme
- Title Master
- Saving as a Template
- Applying Design
Section F: WordArt Section G: Tables
- Building Tables
- Formatting Tables
- Word Tables
Section H: Graphs
- Building a Graph
- Graph Type
- Integrating Excel
Section I: Organization Charts Section J: Basic Presentation
- Inserting Slides
- Header & Footer
- Handouts & Notes
- Presenting
|
PowerPoint 2000 Session 3
Section A: Finalizing Presentations
- Slide Transitions
- Text Animation
- Object Animation
- Navigation Buttons
- Save as a Web Page
Section B: Advanced Customization
- Change Presentation
- Sounds
- Video
- Animated GIF's
- Run Custom Shows
- Hyperlinks
Section C: Finishing Up
- Rehearse Timings
- Record Narration
- Set Up Show
Section D: Working with Other Programs
- Import Outlines
- Save Outlines
- Summary Slide
- Save a Graphic
- Genigraphics
Section E: Delivering Presentations
- Broadcast Configuration
- Broadcast a Presentation
- Review
|
Outlook 2000 Session 1
Section A: Introduction
- Interface
- Outlook Defined
- Email Interface
- Personal Information
Section B: Email Basics
- Make a New Email
- Sending Options
Section C: Customizing Email
- Stationary
- Email in Word
- Create New Stationary
Section D: Receiving Email
- Preview & Icons
- Attachments
- Reply
- Forwarding
- Sorting the Inbox
- Finding
- Printing
- Recalling
Section E: Organizing Outlook Section F: Advanced Email
- Folders
- Colors
- Views
- Junk Email
- Controlling Email
|
Outlook 2000 Session 2
Section A: Contact Basics
- Add New Contact
- Phone Number in Outlook
- Categories
- All Fields
- Your Own Field
- Contact Follow Up
- Delete Contact
- Send Email to Contact
- Adding Contact through Email
Section B: More Contacts
- V Card Option
- Add V Card to Contacts
- Distribution List
- Organization Function
- Using News
- Create New Group
- Create Personal Address Book
Section C: Calendars
- Calendar Functions
- Options
- Appoint Management Event
- Events
Section D: Share Calendars
- Printing
- Putting it on the Web
- Sharing Your Calendar
- Sharing any Folder
- Editing a Share
- NetMeeting
- NetShow
Section E: Tasks
- Setting Up a Task
- Assigning a Task
- Accepting a Task
- Updating a Task
- Organizing
|
Outlook 2000 Session 3
Section A: Journal
- Journal Options
- Journal View
- Making & Reviewing Entries
Section B: Notes
- Creating a Note
- Configuring Notes
- Forwarding Notes
Section C: Outlook Today
- Customizing Outlook
- Customizing Toolbars
- Adaptive Menus
- Help
Section D: Working with Office
- Emailing a Word Document
- Emailing an Excel Document
- Working within Outlook
- Import & Export
- Cut & Paste
Section E: Mail Merge
- Contact Dialog Box
- Inserting Fields & Performing a Merge
Section F: Newsgroups
- Internet Connection Wizard
- Subscribing to a Newsgroup
- Reading Messages
Section G: Forms Section H: Out of Office
- Setting Up Remote Access
- Synchronization
- Offline Folders
- Performing Synchronization
- Out of Office Assistant
- Delegate Access
- Tracking Options
Section I: Archive
- AutoArchive
- Archiving Right Now
Section J: Fax Services
- Compose New Fax
- Fax Properties
- Cover Page
- Receiving Faxes
- Favorites
|