Getting Acquainted with Access
1. The Access Screen
2. Overview of a Database
3. Working with Database Objects
4. Opening and Closing Databases
5. Database Objects

Creating Relational Database Tables
1. Creating New Databases
2. Flow Overview of a Database
3. The "Flat-File" Model of Data Storage
4. The Relational Model of Data Storage
5. Tips for Creating a Relational Database
6. Creating Relational Database Tables
7. Assigning a Primary Key to a Table

Using Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields

Field Properties
1. Setting Field Properties
2. The 'Field Size' Property
3. The 'Format' Property for Date/Time Fields
4. The 'Format' Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries

Joining Tables in a Database
1. Using the Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields

Indexing Tables
1. Indexes
2. Creating Indexes
3. Designing a Multi-field Primary Key
4. Deleting Indexes

Queries
1. What Does a Query Do?
2. Using the Simple Query Wizard
3. Designing Queries
4. Joining Tables in a Query
5. Adding Criteria to the QBE Grid
6. Running A Query
7. How is Using the QBE Grid Writing SQL Code?
8. Sorting Query Results
9. Hiding Fields in a Query
10. Using Comparison Operators
11. Using 'AND' and 'OR' Conditions

Advanced Queries
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries

Advanced Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query

Creating Forms
1. What Are Forms For?
2. The Form Wizard
3. Creating AutoForms
4. Using AutoForms
5. Designing Basic Forms
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The 'Snap to Grid' Feature
9. Creating a Form in Design View

Form & Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls 'To Fit'
5. 'Nudging' Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties

The Control Toolbox
1. The Control Toolbox
2. Adding Label Controls
3. Adding Image Controls
4. Adding Line Controls
5. Adding Rectangle Controls
6. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order

Subforms
1. Creating Subforms
2. Displaying Subform Data

Reports
1. Using the Report Wizard
2. Creating AutoReports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields

Subreports
1. Creating Subreports

Charting Data
1. Creating Charts
2. Editing Charts

Macros
1. Creating and Using Macros
2. Macro Actions
3. Assigning Macros to a Command Button
4. Conditional Macros and Option Groups
5. Using Group Names in Macros
6. Creating Autoexec Macros

Switchboard Forms
1. Creating a Switchboard Form
2. Controlling Startup Behavior

Customizing Toolbars
1. Setting Toolbar and Menu Options
2. Creating Custom Toolbars
3. Creating Custom Popup Menus

Advanced Features
1. Linking Tables
2. Importing External Data
3. Setting a Database Password
4. Using the Help Files

Back to Top

Getting Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. The Ribbon
7. The Microsoft Office Button
8. The Quick Access Toolbar
9. Scroll Bars
10. The Formula Bar
11. The Workbook Window
12. The Status Bar
13. The Task Pane
14. The Mini Toolbar

Creating Basic Spreadsheets
1. Creating a New Workbook
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Selecting Cells
6. Entering Text Into Cells
7. Entering Numbers Into Cells
8. AutoComplete
9. Pick From List
10. Using the "Window" Command Group
11. Zooming the Spreadsheet
12. Managing Multiple Workbooks
13. Renaming Workbooks
14. Working with Excel File Formats

Using Ranges
1. Using Ranges
2. Selecting Ranges
3. Selecting Multiple Non-Adjacent Ranges
4. Entering Information Into a Range
5. Using AutoFill

Creating Formulas
1. Using Formulas
2. Formula Functions
3. Using AutoSum
4. Inserting Functions
5. Editing a Range
6. Using the Formula Palette
7. Using the Paste Function
8. Editing a Range
9. Formula AutoCorrect
10. AutoCalculate

Copying & Pasting Formulas
1. Absolute References and Relative References
2. Cutting, Copying & Pasting
3. AutoFilling Cells
4. Drag & Drop Cutting, Copying & Pasting
5. Using Undo
6. Using Redo

Columns & Rows
1. Selecting Columns & Rows
2. Changing Column Width & Row Height
3. AutoFitting Columns & Rows
4. Hiding/Unhiding Columns & Rows
5. Inserting & Deleting Columns & Rows

Formatting Spreadsheets
1. Using the Formatting Toolbar
2. Using the Format Cells Dialog Box
3. The Number Tab
4. The Alignment Tab
5. The Font Tab
6. The Border Tab
7. The Patterns Tab
8. Clearing All Formatting from Cells
9. Copying All Formatting from Cells to Another Area

Conditional Formatting & AutoFormatting
1. Conditional Formatting
2. AutoFormatting

Setting Spreadsheet Layout
1. Working with Page Breaks
2. Viewing the Header and Footer
3. The Page Setup Dialog Box

Printing Spreadsheets
1. Using Print Preview View
2. Printing Your Spreadsheet

Helping Yourself
1. Using Screen Tips
2. Using the Office Assistant
3. Using the Help Pane

Creating 3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References

Named Ranges
1. Naming Ranges
2. Moving to a Named Range
3. Using Named Ranges in Formulas
4. Creating Names from Headings
5. Deleting Range Names

Spreadsheet Tools
1. Moving between Spreadsheets
2. Selecting Multiple Spreadsheets
3. Inserting and Deleting Spreadsheets
4. Renaming Spreadsheets
5. Coloring Spreadsheet Tabs
6. Switching to Full Screen View
7. Splitting the Screen
8. Freezing Panes
9. Copying and Moving Entire Worksheets
10. Cutting, Copying and Pasting Data between Spreadsheets
11. Printing Multiple Spreadsheets
12. Hiding Spreadsheets

Using Workspaces
1. Creating Workspaces
2. Opening and Closing Workspaces
3. Selecting Workbooks in a Workspace
4. Organizing a Workspace

Paste Special
1. Paste Special Options
2. Pasting Linked Formulas

Sharing and Reviewing Workbooks
1. Sharing Workbooks
2. Highlighting Changes
3. Reviewing Changes
4. The Reviewing Toolbar
5. Inserting Comments
6. Managing Comments
7. Reviewing Comments
8. Printing Comments
9. Sending Spreadsheets for Review
10. Compare and Merge Workbooks

Auditing Spreadsheets
1. Auditing Spreadsheets
2. The Formula Auditing Toolbar
3. Tracing Precedent and Dependent Cells
4. Tracing Errors
5. Error Checking
6. Using the Watch Window
7. Cell Validation

Outlining Spreadsheets
1. Using Outlines
2. Applying and Removing Outlines

Consolidating Spreadsheets
1. Using Data Consolidation
2. Consolidation Types

Creating Spreadsheet Charts
1. Creating Charts
2. Moving and Resizing Charts
3. The Chart Toolbar
4. Formatting Chart Objects
5. Changing the Chart Type
6. Showing and Hiding the Legend
7. Showing and Hiding the Data Table
8. Shifting the Data Series
9. Angling Chart Text
10. Choosing a Chart Layout
11. Choosing a Chart Style
12. Printing Charts
13. Deleting Charts

Editing and Formatting Charts
1. Changing Chart Sub-types
2. Changing the Data Range
3. Changing Chart Titles
4. Repositioning the Legend
5. Adding Data Labels
6. Adding Free-standing Text
7. Time-Scale Data Plotting
8. Formatting a Data Series
9. Changing the Data Series Plot Order
10. Chart Axis Formatting
11. Formatting Data Markers
12. Adjusting Perspective in 3D Charts
13. Custom Chart Types

PivotTables
1. Creating PivotTables
2. Manipulating a PivotTable
3. Using the PivotTable Toolbar
4. Changing Data Field Properties
5. AutoFormatting PivotTables
6. Displaying a PivotChart
7. Setting PivotTable Options
8. Page Display Options
9. Adding Subtotals to PivotTables
10. Sorting and Filtering Fields

Lists
1. Creating a List
2. Adding and Editing Records
3. Inserting Records and Fields
4. Deleting Records and Fields

The Data Form
1. Using the Data Form
2. Adding and Deleting Records in the Data Form
3. Finding Records in the Data Form

Sorting Data
1. Sorting Data
2. Custom Sort Orders
3. Sorting Options

AutoFiltering Data
1. AutoFilter
2. Using the Top 10 AutoFilter
3. Using the Custom AutoFilter
4. Turning Off the AutoFilter

Advanced Filtering of Data
1. Creating Advanced Filters
2. Using 'And' and 'Or" Conditions in Criteria
3. Using Wildcard Characters in Criteria
4. Copying Filter Results to a New Location
5. Using Database Functions

Data Tables
1. Data Tables
2. The Formula Reference Table
3. Structuring a Single-variable Data Table
4. Structuring a Double-variable Data Table
5. Creating the Data Table

Lookup and Logical Functions
1. Lookup and Logical Functions
2. Lookup Functions
3. Logical Functions
4. Nesting Logical Functions
5. Masking Error Display in Worksheets
6. Using the AND and OR Functions

Scenarios
1. Creating and Displaying Scenarios
2. Editing and Deleting Scenarios
3. Merging Scenarios
4. Creating Scenario Reports
5. Using Goal Seek

Security Features
1. Unlocking Cells
2. Worksheet Protection
3. Workbook Protection
4. Password Protecting Excel Files

Making Macros
1. Recording Macros
2. Running Macros
3. Deleting Macros
4. The Personal Macro Workbook

Customizing Toolbars
1. Setting Toolbar and Menu Bar Options
2. Creating Custom Toolbars
3. Adding Buttons to Toolbars
4. Adding Macro Buttons to Toolbars
5. Adding Button Dividers to Toolbars
6. Removing Toolbar Buttons
7. Resetting and Deleting Toolbars

Back to Top

Getting Acquainted with Outlook
1. The Outlook Environment
2. The Title Bar
3. The Menu Bar
4. Using Toolbars
5. The Standard Toolbar
6. The Ribbon
7. The Microsoft Office Button
8. The Quick Access Toolbar
9. The Formatting Toolbar
10. The Navigating Pane and Reading Pane & To Do Bar
11. The Outlook Bar
12. The Scroll Bars
13. The Shortcut Keys
14. The Preview Pane

Making Contacts
1. What are Contacts?
2. The Contacts Folder
3. Changing the View
4. Creating Contacts
5. Editing Contacts
6. Selecting Contacts
7. Deleting Contacts
8. Printing Contacts
9. Grouping Contacts
10. Assigning Contacts to Categories
11. Searching for Contacts
12. Writing letters to Contacts
13. Calling Contacts
14. Finding a Contact's Address

E-Mail
1. What is e-mail?
2. Using the Inbox
3. Message Statuses
4. Reading Messages
5. Printing Messages
6. Deleting Messages
7. Sorting the Inbox
8. Changing the Inbox View
9. Message Flags
10. Finding Messages
11. Sending Messages
12. Selecting Recipients
13. Checking Message Spelling
14. Setting Message Options
15. Formatting Messages
16. Replying to Messages
17. Forwarding Messages
18. Sending Attachments
19. Opening Attachments

The Sent Items Folder
1. The Sent Items Folder
2. Resending Messages
3. Recalling Messages

The Outbox Folder
1. Using the Outbox Folder

Using the Calendar
1. The Calendar Window
2. Switching the Calendar View
3. Navigating the Calendar
4. Appointments, Meetings and Events
5. Selecting Calendar Objects
6. Setting an Appointment
7. Scheduling a Meeting
8. Checking Meeting Attendance Status
9. Responding to Meeting Requests
10. Scheduling an Event
11. Setting Recurrence
12. Printing the Calendar

Tasks
1. What are Tasks?
2. The Tasks Window
3. Changing the Tasks View
4. Printing the Tasks
5. Sorting the Tasks
6. Creating a Task
7. Setting Task Recurrence
8. Creating a Task Request
9. Responding to Task Requests
10. Sending Status Reports
11. Tracking Tasks
12. Managing Tasks
13. Deleting Tasks

Deleted Items
1. The Deleted Items Folder
2. Permanently Deleting Items
3. Recovering Deleted Items
4. Automatically Deleting Items

Using the Journal
1. The Journal Folder
2. Switching the Journal View
3. Recording Journal Items Automatically
4. Opening a Journal Entry
5. Opening the Journal Entry Document
7. Deleting Journal Entries

Public Folders
1. Creating Public Folders
2. Setting Permissions
3. Administering Public Folders
4. Folder Rules
5. Copying Public Folders
6. Adding a Public Folder Shortcut to the Outlook Bar

Personal and Private Folders
1. Creating a Personal Folder
2. Setting AutoArchiving for Folders
3. Creating Private Folders
4. Setting Folder Permissions
5. Administering a Private Folder
6. E-mailing a Shortcut to a Private Folder

Notes
1. Creating Notes
2. Forwarding Notes
3. Adding Date/Time Stamps
4. Changing Note Colors
5. Changing Note Fonts

Advanced Mailbox Options
1. Creating Mailbox Rules
2. Color Coding Messages
3. Creating Custom Mailbox Views
4. Handling Junk and Adult E-mail
5. Categorizing Items
6. Finding Items
7. Grouping Folder Items
8. Using Filters

Outlook Options
1. Using Outlook as a Desktop
2. Using Outlook as a Web Browser
3. Adding Additional Profiles
4. Adding Additional Services
5. Outlook Options
6. Using Shortcuts

Delegates
1. Creating a Delegate
2. Acting as a Delegate
3. Deleting a Delegate

Helping Yourself
1. Screen Tips
2. The Office Assistant
3. Using the Contents and Index
4. Using the Help Pane

Back to Top

Getting Acquainted with PowerPoint
1. The PowerPoint Environment
2. The Title Bar
3. The Menu Bar
4. The Ribbon
5. The Microsoft Office Button
6. The Quick Access Toolbar
7. Using Toolbars
8. The Standard Toolbar
9. The Formatting Toolbar
10. The Scroll Bars
11. Shortcut Keys
12. The Task Pane
13. Changing the Presentation View
14. The Mini Toolbar

Creating a Presentation
1. Creating a New Presentation
2. The AutoContent Wizard
3. Using the Template Option
4. Applying a Slide Layout
5. Using the Blank Presentation Option
6. Working with PowerPoint Formats

Opening, Closing, and Saving a Presentation
1. Saving a Presentation
2. Closing a Presentation
3. Opening a Presentation
4. Using Pack and Go / Package for CD
5. Saving Your Presentation as a Web Page

Introducing Presentation Views
1. Normal View
2. Outline View
3. Slide View
4. Slide Sorter View
5. Notes Page View
6. Slide Show View

Normal View (Slide View in 97)
1. Using the Ruler
2. Using the Guides for Layout
3. Setting the Slide Header and Footer
4. Inserting New Slides
5. Zooming a Presentation

Modifying Text Placeholders
1. Object Mode vs. Edit Text Mode
2. Text Placeholders vs. Text Boxes
3. Inserting a Text Box
4. Re-sizing Text Boxes and Placeholders
5. Deleting Text Boxes and Placeholders
6. Moving Text Boxes and Placeholders
7. Bulleting Text Boxes and Placeholders
8. Aligning Text in Text Boxes and Placeholders
9. Setting Line Spacing in Text Boxes and Placeholders
10. Changing Text Casing
11. Formatting Fonts for Text Boxes and Placeholders
12. Formatting Fill Color and Lines for Text Boxes and Placeholders
13. Setting Default Properties for All New Text Boxes and Placeholders

Modifying Text in a Text Box or Placeholder
1. Bolding Text
2. Italicizing Text
3. Underlining Text
4. Applying Shadows to Text
5. Adding Other Text Enhancements
6. Aligning Text within a Text Box or Placeholder
7. Changing the Font for Selected Text Only
8. Copying and Pasting Text
9. Using Undo and Redo
10. Formatting Bullets and Numbering
11. Showing and Hiding the Rulers
12. Adding Tab Stops

Text Tools
1. Setting the Spelling Options
2. Using the Spelling Checker
3. Using the Style Checker (97 only)
4. Setting Style Options
5. Inserting Comments

Using Clip Art
1. Inserting Clip Art
2. Re-sizing Clip Art
3. Adding Fill Color and Lines to Clip Art
4. Moving Clip Art
5. Cutting, Copying, and Pasting Clip Art
6. Deleting Clip Art
7. The Picture Toolbar
8. Cropping Clip Art
9. Changing Clip Art’s Color, Contrast and Brightness
10. Re-coloring Clip Art
11. Inserting Auto Clip Art (97 only)
12. Compressing Pictures
13. Adding Clips to the ClipArt Gallery
14. Finding Clips Online
15. Using the Clip Organizer

Using SmartArt
1. Inserting and Manipulating SmartArt
2. Formatting SmartArt

Using Diagrams (XP only)
1. Inserting Diagrams
2. Using the Diagram Toolbar

Inserting Movies and Sound
1. Inserting Movies
2. Inserting Audio
3. Animating Multimedia Playback
4. Recording a Sound

Using Slide Sorter View
1. Using Slide Sorter View
2. Inserting Slides from External
Presentations

Creating Custom Shows
1. Creating and Managing Custom Shows

Using Slide Show View
1. Running a Slide Show
2. Setting Pointer Options
3. Adding Speaker Notes
4. Using the Meeting Minder

Printing Your Presentation
1. Using Page Setup
2. Printing Presentations
3. Using Print Preview
4. Printing Handouts

Helping Yourself
1. Using Screen Tips
2. Using the Office Assistant
3. Using the Contents
4. Using the Index
5. Using Detect and Repair
6. Using the Help Pane

Adding Slide Transition Animation
1. Adding Slide Transition Animation
2. Adding Transition Animation Speed and Sounds
3. Setting Manual or Automatic Slide Advancing
4. Adding Slide Animation
5. Adding Transition Animation Speed
6. Adding Animation Timing
7. Adding Transition Animation Sound
8. Setting Transition Animation for Single and Multiple Slides

Animating Slide Objects
1. Using Preset Animation
2. Adding Custom Animation
3. Previewing Your Animation Settings
4. Applying Animation Schemes

Drawing Objects
1. Inserting AutoShapes
2. Inserting Lines and Arrows
3. Editing Line Points
4. Inserting Rectangles and Ovals
5. Inserting WordArt
6. Applying & Changing Fill Colors
7. Applying & Changing Line Colors
8. Applying & Changing Font Colors
9. Applying & Changing Shadow Effects
10. Applying & Changing 3D Effects
11. The Draw Button
12. Inserting Text Into a Shape

Manipulating Drawing Objects
1. Grouping Objects
2. Ordering Objects
3. Aligning & Distributing Objects
4. Rotating & Flipping Objects

Using Outline View
1. Using the Outlining Toolbar
2. Promoting & Demoting Text
3. Expanding & Collapsing Slides
4. Adding & Deleting Slides
5. Creating Summary Slides

Using Notes Page View
1. Using Notes Page View
2. Formatting Notes Page View
3. Setting the Header and Footer for Notes and Handouts

Creating Customized Presentation Templates
1. Switching Color Schemes for your Presentation
2. Creating a Custom Color Scheme
3. Changing a Custom Color Scheme to a Standard Scheme
4. Customizing the Slide Background for your Presentation
5. Saving a Customized Template

Using Presentation Masters
1. Slide Master
2. Title Master
3. Notes Master
4. Handout Master

Setting Up the Presentation
1. Set Up Show
2. Recording Narration
3. Rehearsing Timings
4. Using Two Screens (97 only)

Using Macros
1. Recording Macros
2. Editing Macros
3. Running Macros

Action Buttons
1. Inserting Action Buttons
2. Setting Button Actions

Inserting Tables, Charts, and Other Objects
1. Inserting Charts
2. Editing Chart Data
3. Inserting Tables
4. Formatting Tables
5. Inserting External Objects

Customizing Toolbars
1. Creating New Toolbars
2. Customizing Toolbars
3. Setting Toolbar and Menu Bar Options

Setting PowerPoint Options
1. Setting Default PowerPoint Options
2. Setting AutoCorrect Options

Back to Top

Getting Started and Exploring
1. Starting Publisher
2. The Publisher Screen
3. Viewing the Catalog (2000)
4. Using Wizards (2000)
5. Viewing the New Publication Task Pane (XP & 2003)
6. Creating a Blank Publication (2000)
7. Creating a Blank Publication (XP & 2003)
8. Displaying the Full Menus (2000)
9. Displaying the Full Menus (XP & 2003)
10. Editing Personal Information
11. Using the Options Dialog Box
12. Saving Your Publication
13. Closing Your Publication
14. Exiting Publisher

Working With Publications
1. Opening an Existing Publication
2. Saving a Publication with a New Name
3. Adjusting Page Setup Options (2000)
4. Adjusting Print Setup Options (2000)
5. Adjusting Page and Print Setup Options (XP & 2003)

Basic Skills
1. Zooming the Publication
2. Adding Text to a Frame
3. Inserting Pages
4. Navigating Through Pages
5. Moving and Nudging Objects
6. Resizing Objects
7. Rotating and Flipping Objects (2000)
8. Rotating and Flipping Objects (XP & 2003)
9. Deleting Objects and Frames
10. Resetting the Design

Working With Text
1. Changing the Font
2. Changing the Font Size
3. Changing the Font Style and Effect
4. Changing the Font Color
5. Changing Text Alignment
6. Adding and Removing Bullets and Numbers
7. Creating Custom Bullets and Modifying Numbering
8. Paragraph and Line Spacing
9. AutoFitting Text
10. Modifying Character Spacing
11. Using Find & Replace
12. Using AutoCorrect

Working With Drawing Objects
1. Using the Objects Toolbar
2. Drawing Lines, Arrows, Ovals & Rectangles
3. Inserting AutoShapes and Custom Shapes
4. Inserting Text Boxes
5. Drawing Freeform Objects (2000)
6. Drawing Freeform Objects (XP & 2003)

Formatting Objects
1. Changing Fill Colors
2. Changing Line Colors
3. Formatting Lines and Borders
4. Using Additional Line and Border Formatting
5. Working With Layers
6. Selecting Multiple Objects
7. Ordering and Grouping Objects
8. Ungrouping Objects for Editing
9. The Undo Button
10. The Redo Button

Working With Graphics
1. Setting Picture Display Options
2. Inserting Pictures
3. Inserting Clip Art (2000)
4. Inserting Clip Art (XP & 2003)
5. Using the Picture Toolbar (XP & 2003)
6. Using WordArt (2000)
7. Using WordArt (XP & 2003)

Working With Tables
1. Inserting Tables and Choosing a Preset Format
2. Changing the Color Scheme (2000)
3. Changing the Color Scheme (XP & 2003)
4. Inserting Text Into Tables
5. Formatting Cell Text
6. Copying a Table From Microsoft Word
7. Adjusting Row Height and Column Width

Customizing Layouts and Designs
1. Applying Backgrounds (2000)
2. Applying Backgrounds (XP & 2003)
3. Using the Design Gallery
4. Saving Your Own Designs
5. Using the Layout Guides
6. Using the Design Checker
7. Using Special Paper View

Preparing Publications for the Web
1. Converting a Publication to a Web Page
2. Working With Form Controls
3. Inserting Hyperlinks (2000)
4. Inserting Hyperlinks (XP & 2003)
5. Inserting Hot Spots
6. Applying Background Schemes (2000)
7. Applying Background Schemes (XP & 2003)
8. Setting Web Properties (2000)
9. Setting Web Properties (XP)
10. Setting Web Properties (2003)
11. Working With Navigation Bars (2000 & XP)
12. Working With Navigation Bars (2003)

Mail Merge
1. What is a Data Source?
2. Creating a Data Source (2000)
3. Creating a Data Source (XP)
4. Creating a Data Source (2003)
5. Customizing a Data Source
6. Editing a Data Source (2000)
7. Editing a Data Source (XP & 2003)
8. Using a Label or Envelope Wizard
9. Attaching a Data Source (2000)
10. Inserting Data Fields (2000)
11. Merging and Printing Data (2000)
12. Merging Data With a Publication (XP)
13. Merging Data With a Publication (2003)

Commercial Printing
1. Color Printing Options
2. Setting the Color Printing Options
3. Setting the Trapping Options
4. Choosing Fonts
5. Using Pack & Go
6. Saving Your Publication as a PostScript File

Additional Features
1. Showing Special Characters
2. Snapping to Guides, Rulers and Objects
3. Inserting Date and Time Stamps
4. Inserting Page Numbers
5. Previewing Your Publication (XP & 2003)
6. Printing Your Publication
7. Using the Two-Page Spread View
8. Tools on the Web

Helping Yourself
1. Publisher Help
2. Using the Contents
3. Using the Answer Wizard
4. Using the Index
5. Using the Office Assistant
6. Using the Help Pane (2003)

Back to Top

File Management
1. Searching for a File or Folder
2. Selecting Files
3. Opening a File
4. Opening a Recently Accessed File
5. Customizing File and Folder Views
6. Creating a New Folder
7. Folder Options
8. Sorting Items
9. Arranging Items
10. Auto Arranging Items
11. Renaming Files
12. Cutting, Copying & Pasting Files and Folders
13. Copying a File to a Floppy Disc
14. Saving Files to CD
15. Deleting Files
16. The Recycle Bin
17. Burning a CD or DVD

Using the Internet
1. Using the Internet
2. Using a Web Browser
3. Searching the Internet for Information
4. Downloading Items From the Internet
5. Internet Security
6. Antivirus Software
7. Firewalls
8. Windows Firewall (Service Pack 2)
9. E-mail
10. Setting up an E-mail Account
11. Web Based E-mail
12. Spam Filters
13. Connecting to the Internet
14. Dial-Up
15. Broadband
16. Using Internet Explorer

Printing Information
1. Selecting a Printer
2. General Printing Options
3. Printing from the Internet
4. Viewing Print Jobs
5. Canceling Print Jobs

Just For Fun
1. Playing Music
2. Watching Movies
3. Games in Windows
4. Games from the Internet
5. Great Sites on the Internet

Back to Top

Getting Acquainted with Word
1. The Word Environment
2. Title Bar
3. The Menu Bar
4. The Ribbon
5. The Microsoft Office Button
6. The Quick Access Toolbar
7. The Standard Toolbar
8. The Formatting Toolbar
9. The Tab Button
10. Rulers
11. The Scroll Bars
12. The Document View Buttons
13. The Next, Previous, and Select Browse Object Button Group
14. The Status Bar
15. The Task Pane
16. The Mini Toolbar

Creating Basic Documents
1. Opening Documents
2. Closing Documents
3. Creating a New Document
4. Saving Documents
5. Entering Text Into a Document
6. Moving Through Text
7. Selecting Text
8. Non-Printing Characters
9. Zooming in the Document
10. Full Screen Mode
11. Managing Multiple Documents
12. Overtype Mode
13. Renaming Documents
14. Working with Word File Formats

Basic Editing Skills
1. Deleting and Replacing Text
2. Cutting, Copying and Pasting
3. The Undo Button
4. The Redo Button
5. The Repeat Command

Using Text Tools
1. The Spelling and Grammar Tool
2. Setting Spelling and Grammar Options
3. Using AutoCorrect

Formatting Text
1. Formatting Text
2. The Formatting Toolbar
3. The Font Dialog Box
4. Changing Character Case
5. Copying and Pasting Text Formatting

Formatting Paragraphs
1. Paragraph Alignment
2. Indenting Paragraphs
3. Indenting Paragraphs with the Horizontal Ruler
4. Line Spacing and Paragraph Spacing
5. Copying Paragraph Formatting Only

Setting Document Layout
1. Working with Page and Section Breaks
2. Inserting Page and Section Breaks
3. Viewing the Header and Footer
4. Inserting Header and Footer Information
5. Creating Alternate Headers and Footers
6. Creating Different First Page Headers and Footers
7. Using Page Setup

Using Wizards and Templates
1. Using Templates
2. Using Wizards

Printing Documents
1. Using Print Preview
2. Printing Your Documents

Helping Yourself
1. Screen Tips
2. The Office Assistant
3. Contents, Answer Wizard and Index
4. Using the Help Pane

Working With Tabs
1. Using Tab Stops
2. Removing and Clearing Tabs
3. Adding Leader Tabs

Using AutoText
1. Using AutoText
2. Inserting and Deleting AutoText
3. Creating and Auto Text Entry

Using Clip Art
1. Using Clip Art
2. Inserting Clip Art
3. Inserting Other Graphics
4. The Picture Toolbar
5. The Format Picture Dialog Box
6. The Colors and Lines Tab
7. The Size Tab
8. The Layout Tab
9. The Picture Tab

Drawing Objects
1. Inserting AutoShapes
2. Inserting Lines, Arrows, Rectangles and Ovals
3. Inserting WordArt
4. Applying Fill Color
5. Applying Line Color
6. Applying Font Color
7. Applying Line Style, Dash Style and Arrow Style
8. Applying Shadows
9. Applying 3D Effects
10. Rotating Objects
11. Using the Draw Button
12. Inserting Text Into a Shape
13. Inserting Text Boxes

Using Building Blocks
1. Using Building Blocks

Adding Bullets and Numbering to Lists
1. Applying Bullets and Numbering
2. Modifying Bullets and Numbering

Creating and Modifying Tables
1. Using Tables
2. Creating Tables
3. Selecting Table Objects
4. Adding and Deleting Columns and Rows
5. Merging and Splitting Cells
6. Adjusting Column Width and Row Height
7. Converting a Table Into Text

Table Tools
1. The Tables and Borders Toolbar
2. Drawing and Erasing Tables
3. Distributing Rows and Columns Evenly
4. Aligning Text in Table Cells
5. Sorting Tables

Table Formulas
1. Table Formulas
2. Inserting Formulas
3. Recalculating Formulas
4. Viewing Formulas vs. Formula Results

Creating a Mail Merge Document
1. Beginning a Mail Merge
2. Using the Mail Merge Wizard
3. Using the Mail Merge Helper

Creating and Modifying a Data Source
1. Creating a Data Source
2. Entering and Deleting Records in a Data Form
3. Finding Records in a Data Form
4. Filtering and Sorting Data Source Entries
5. Customizing the Data Source

Modifying the Merge Document
1. Modifying the Merge Document
2. Checking for Errors in Your Document
3. Inserting and Removing Merge Fields
4. Formatting Merge Fields
5. Detaching the Data Source From the Merge Document

Merging Envelopes
1. Merging Envelopes

Merging Labels
1. Merging Labels (2003/XP)
2. Merging Labels (2000/97)

Merging Directories or Catalogs
1. Merging Directories
2. Merging Catalogs

Querying and Sorting the Data Source
1. Selecting a Data Range for Merging
2. Querying Records for Merging
3. Sorting Records for Merging
4. Clearing Merge Criteria

Creating a Table of Contents
1. Creating a Table of Contents
2. Customizing a Table of Contents
3. Displaying Field Codes
4. Updating a Table of Contents

Creating an Index
1. Creating an Index
2. Customizing and Index
3. Displaying Field Codes
4. Updating an Index's Contents

Creating a Form Template
1. Creating a Form Template
2. Changing Field Options
3. Adding Help Text to a Field
4. Removing Field Shading and Protecting the Document
5. Saving the Document as a Template
6. Displaying the Developer Tab

Making Macros
1. What are Macros?
2. Creating Macros
3. Running a Macro
4. Assigning a Shortcut Key to a Macro

Customizing Toolbars
1. Changing Toolbar and Menu Bar Options
2. Adding Buttons to Toolbars
3. Adding Macro Buttons to Toolbars
4. Adding Button Dividers to Toolbars
5. Removing Buttons from Toolbars
6. Creating, Resetting and Deleting Custom Toolbars

Changing Word's Options
1. Setting the Default Document File Location
2. Setting the Default Save Options
3. Setting the Default Page Setup Options
4. Setting the Default Font

Back to Top

The best Microsoft Office tutorial available.

• Designed by software training professionals.
• Learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in classroom trainings.
• Training includes the same fifteen classroom manuals our students receive (in PDF), along with practice exercises & keyboard shortcuts!
• Customize your training with the easy-to-use menu.
• Clear, easy-to-follow, step-by-step instruction.
• Watch the training sessions as many times as you want while you practice in Microsoft Office.
• No messy set-up, no internet connections needed.
• The best way to learn Microsoft Office on your own.
• The confidence in knowing your Microsoft Office tutorial was created by software training professionals.

Back to Top

All Products | Samples | FAQs | About Us | Contact Us

© TeachUcomp, Inc. All Rights Reserved.