Access XP: Beginner Level
- 1.0 Introduction
- 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 & Navigating Table Data
- 2.2 Editing Table Data
- 2.3 Adding Records to a Table
- 2.4 Selecting & Deleting Records
- 2.5 Find & Replace
- 2.6 Modifying the Appearance of a Datasheet
- 2.7 Spell-Check & 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 & Out
- 4.3 Viewing Multiple Pages
- 4.4 Printing
- 4.5 AutoReports & the Report Wizard
- 4.6 Printing Database Objects
Access XP: Intermediate Level
- 1.0 Planning & Designing a Database
- 1.1 Evaluating Inputs & Outputs
- 1.2 Normalization
- 1.3 Creating a Database Using a Wizard
- 1.4 Creating a Database from Scratch
- 2.0 Building & Modifying Tables
- 2.1 Creating Tables Using a Wizard
- 2.2 Creating Tables without the Use of a Wizard
- 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 Types of Relationships
- 3.3 Referential Integrity
- 3.4 Indexes & Relationships
- 3.5 Printing Relationships
Access XP: Advanced Level
- 1.0 Designing Simple Queries
- 1.1 Selecting Fields
- 1.2 Ordering the Query Result & Refining Queries with Criteria
- 1.3 Updatability of Query Results
- 1.4 Queries Based on Multiple Tables
- 2.0 Building & Modifying Forms
- 2.1 Adding Controls
- 2.2 Selecting Controls
- 2.3 Moving, Sizing, & Deleting Controls
- 2.4 Aligning Controls
- 2.5 Changing Control Properties
- 2.6 Changing the Tab Order Controls
- 2.7 Form Properties
- 2.8 Working with Combo Boxes & List Boxes
- 3.0 Building & Modifying Reports
- 3.1 Understanding Report Bands
- 3.2 Working with Controls
- 3.3 Creating Groups & Total Reports
- 3.4 Working with Report Properties
- 3.5 Modifying Selection Criteria
Excel XP: Beginner Level
- 1.0 The Excel Screen
- 1.1 Overview
- 1.2 Screen Elements
- 2.0 Entering Data
- 2.1 Data Entry Techniques
- 2.2 AutoFill Entry Techniques
- 2.3 Erasing Data
- 2.4 AutoComplete
- 2.5 Undo and Re-do
- 3.0 Entering Formulas
- 3.1 Three Methods of Entering Formulas
- 3.2 Repeating a Formula in Adjacent Cells
- 3.3 Formulas Beyond Addition & Subtraction
- 4.0 Basic Excel Functions
- 4.1 Summation
- 4.2 Recalculating Effects & Hierarchy of Operations
- 4.3 Other Functions
- 5.0 Formatting
- 5.1 The Formatting Toolbar
- 5.2 Adjusting Widths and Row Heights
- 5.3 Numeric Formatting
- 6.0 Saving, Opening and Closing Files
- 6.1 File Save and File Save As
- 6.2 Opening a File
- 6.3 Creating a New Workbook
- 7.0 The Help System
- 7.1 Using the Help System
- Excel XP: Intermediate Level
- 1.0 Changing Worksheet Layout
- 1.1 Inserting Columns, Rows, & Cells
- 1.2 Deleting Columns, Rows, & Cells
- 1.3 Moving Cells
- 1.4 Copying Cells
- 2.0 Additional Formatting
- 2.1 Formatting Cell Attributes & Alignment
- 2.2 Borders
- 2.3 Numeric Formatting
- 2.4 Centering Text Across Columns
- 2.5 Hiding & Unhiding Columns & Rows
- 3.0 Printing
- 3.1 Using Print Preview & 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 The Tools Options Command
- 5.1 Show/Hide Gridlines & Formulas
- 5.2 Recently Used File List
- 5.3 Sheets in New Workbook
- 5.4 Default Settings
Excel XP: Advanced Level
- 1.0 Adjusting Worksheet Views
- 1.1 Freeze/Unfreeze Panes
- 1.2 Horizontal and Vertical Split Screens
- 2.0 Auditing Techniques
- 2.1 Using the Formula Auditing Toolbar
- 2.2 Tracing Dependent Cells
- 2.3 Tracing Precedent Cells
- 3.0 The IF and VLOOKUP Functions
- 3.1 The IF Functions & Relational Operators
- 3.2 Using Words in IF Functions
- 3.3 Using Logical Operators (AND & OR) with the IF Function
- 3.4 Nested IF Functions
- 3.5 Getting Data from the Table with a VLOOKUP Function
- 4.0 Date & Time Functions
- 4.1 Using Dates as Values
- 4.2 Entering a Series of Dates
- 4.3 Date/Time Entry Techniques
- 5.0 Multi-Sheet Workbooks
- 5.1 Renaming & Reordering Sheets
- 5.2 Inserting & Deleting Sheets
- 5.3 Moving, Copying, & Grouping Sheets
- 5.4 Formulas Across Multiple Sheets
Outlook XP: Beginner Level
- 1.0 Introducing Outlook
- 1.1 Starting Outlook
- 1.2 Discovering Outlook Components & Identifying Main Window
- 2.0 Exploring Outlook
- 2.1 Using the Outlook Bar
- 2.2 Using the Folder List Box
- 2.3 Using a Toolbar
- 2.4 Viewing Outlook Today
- 3.0 Reading & Sending Mail
- 3.1 Displaying Mail Icons
- 3.2 Attachments
- 3.3 Creating & Sending a New Mail Message
- 3.4 Adding an Attachment to a Message
- 3.5 Formatting a Message
- 3.6 Saving a Message in the Drafts Folder
- 4.0 Replying to & Forwarding Messages
- 4.1 Forwarding a Message
- 4.2 Forwarding Responses Automatically
- 4.3 Additional Message Options
- 5.0 Using Address Books
- 5.1 Adding & Editing a Contact
- 5.2 Adding an Address from a Message
- 5.3 Sending a Message from the Address Book
- 5.4 Creating & Using Distribution Lists
- 5.5 Exporting Addresses
- 5.6 Importing an Address Book
- 5.7 Displaying Contacts in Various Views
- 6.0 Printing in Outlook
- 6.1 Printing Items in Outlook
- 6.2 Print Options
- 7.0 Deleting in Outlook
- 7.1 Deleting Items
- 7.2 Emptying Deleted Items
Outlook XP: Intermediate Level
- 1.0 Using the Calendar
- 1.1 Creating an Appointment
- 1.2 Creating a Recurring Appointment
- 1.3 Editing an Appointment
- 1.4 Setting Appointment Reminder Options
- 1.5 Responding to a Reminder
- 2.0 Changing Calendar View & Display Options
- 2.1 Switching Between View Options
- 2.2 Additional Display Settings
- 3.0 Planning Meetings & Appointments
- 3.1 Creating & Sending a Meeting Request
- 3.2 Responding to a Meeting Request
- 3.3 Finding an Appointment
- 3.4 Setting up Your Work Schedule
- 4.0 Creating & Responding to Tasks
- 4.1 Creating a Task
- 4.2 Creating a Recurring Task
- 4.3 Creating a Task Request
- 4.4 Responding to a Task Request
- 4.5 Scheduling Time for a Task
- 4.6 Setting Tasks Default Options
- 5.0 Journal Entries
- 5.1 Creating a Journal Entry
- 5.2 Creating Automatic Journal Entries
- 5.3 Editing a Journal Entry
- 5.4 Journal Entry Views
- 6.0 Using Notes
- 6.1 Creating & Using Notes
- 6.2 Editing, Sorting, & Viewing Notes
- 7.0 Organizing, Recalling, & Resending Messages
- 7.1 Creating Folders
- 7.2 Moving a Message to Another Folder
- 7.3 Automating Your Mailbox
- 7.4 Recalling a Message
- 8.0 Customizing Toolbars
- 8.1 Di8splaying Toolbars
- 8.2 Customizing Toolbars
- 8.3 Creating a New Toolbar Button
Outlook XP: Advanced Level
- 1.0 Advanced Mail Message Options
- 1.1 Automatic Spell Checking
- 1.2 Creating a Signature in Outlook
- 1.3 Setting the Default Message
- 1.4 Setting the Default Stationary
- 2.0 Filtering, Finding & Flagging
- 2.1 Filtering Unwanted Messages
- 2.2 Finding Mail Messages
- 2.3 Flagging Messages
- 2.4 Flagging a Message from a Particular Sender
- 2.5 Completing & Clearing a Flag
- 3.0 Advanced Contact Options
- 3.1 Finding Contact Information from an E-mail
- 3.2 Contact-Related Activities
- 4.0 Archiving Outlook Data
- 4.1 Running the Manual Archive
- 4.2 Retrieving Archived Items
- 4.3 Enabling & Disabling AutoArchive
- 4.4 Setting Archive Properties for Items
- 5.0 Public Folders
- 5.1 Creating a Public Folder
- 5.2 Public Folder Permissions
- 5.3 Public Folder Conversations
- 5.4 Posting Documents to Public Folder
- 6.0 Multiple E-Mail Accounts
- 6.1 Creating Multiple E-mail Accounts
- 6.2 Sending Mail from Multiple Accounts
- 7.0 Speech Input
- 7.1 Setting Up Voice Recognition
- 7.2 Voice Commands
- 7.3 Dictation
- 8.0 Mailbox Cleanup
- 8.1 Mailbox Cleanup Feature
PowerPoint XP: Beginner Level
- 1.0 Getting Started
- 1.1 What is PowerPoint?
- 1.2 Starting PowerPoint XP
- 1.3 Touring the PowerPoint Window
- 2.0 Creating a New Presentation
- 2.1 New Presentation Task Pane
- 2.2 AutoContent Wizard
- 2.3 Saving & Closing Your Work
- 2.4 Creating from a Design Template
- 2.5 Creating a Blank Presentation
- 3.0 Revising Presentations
- 3.1 Opening an Existing Presentation
- 3.2 Navigating in a Presentation
- 4.0 Editing Text
- 4.1 Viewing a Presentation
- 4.2 Creating a New Slide
- 5.0 Getting Help
- 5.1 Ask A Question Box
- 5.2 Office Assistant
- 5.3 PowerPoint Help Window
- 5.4 Context-Sensitive Help
- 6.0 Outlining
- 6.1 Entering Text in an Outline
- 6.2 Inserting an Outline from Microsoft Word
- 7.0 Modifying Slides, Paragraphs, & Text
- 7.1 Exporting an Outline
- 8.0 Adding & Modifying Slide Text
- 8.1 Adding & Moving Text
- 8.2 Formatting Text & Symbols
- 8.3 Changing Text Box Properties
- 8.4 AutoCorrect & AutoFormat
- 8.5 Outline vs. Slide
- 9.0 Preparing Presentations
- 9.1 Checking Spelling
- 9.2 Checking Presentation Styles
- 9.3 Speaker Notes
- 9.4 Adding a Header & Footer
- 10.0 Printing Presentations
- 10.1 Page Setup & Preview
- 10.2 Printing a Presentation
h4. PowerPoint XP: Intermediate Level
- 1.0 Developing Content
- 1.1 Planning & Communicating Effectively
- 2.0 Managing Presentations
- 2.1 Inserting Slides from Other Presentations
- 2.2 File & Folder Management
- 2.3 Search Task Pane
- 2.4 Find & Replace
- 2.5 Keyboard Shortcuts
- 3.0 Changing Design & Layout
- 3.1 Applying a Design Template
- 3.2 Changing the Layout of a Slide
- 4.0 Working with Masters
- 4.1 Modifying the Slide Master
- 4.2 Formatting Bullets
- 4.3 Handout & Notes Masters
- 5.0 Graphics & Pictures
- 5.1 Inserting Clip Art
- 5.2 Inserting Pictures
- 5.3 The Clip Organizer
- 5.4 Modifying Images
- 6.0 Creating & Formatting Objects
- 6.1 Adding & Editing an Object
- 6.2 Formatting Objects
- 6.3 Object Placement, Orientation, & Grouping
- 6.4 Enhancing Text with WordArt
PowerPoint XP: Advanced Level
- 1.0 Working with Tables
- 1.1 Creating Tables
- 1.2 Modifying & Formatting Tables
- 2.0 Working with Graphs & Charts
- 2.1 Inserting & Formatting a Graph
- 2.2 Creating an Organization Chart
- 3.0 Organizing Your Presentation
- 3.1 Rearranging & Summarizing Slides
- 3.2 Hiding, Duplicating, & Deleting Slides
- 4.0 Customizing PowerPoint
- 4.1 Menus & Toolbars
- 4.2 Customizing the Workspace
- 4.3 Changing User Options
- 5.0 Viewing & Changing Presentation Colors
- 5.1 Viewing & Choosing a Color Scheme
- 5.2 Creating a New Color Scheme
- 5.3 Adding & Modifying a Slide Background
- 6.0 Creating a Custom Design Template
- 6.1 Creating Multiple Master Slides
- 6.2 Adding a Custom Background
- 6.3 Saving & Applying a Custom Template
- 7.0 Preparing & Delivering a Slide Show
- 7.1 Adding Transitions
- 7.2 Applying Other Animation
- 7.3 Presenting a Slide Show
Word XP: Beginner Level
- 1.0 Getting Started
- 1.1 Starting Word 2002
- 1.2 Touring the Word Window
- 2.0 Creating New Documents
- 2.1 Starting a New Document
- 2.2 Entering Text
- 2.3 Saving Your Work
- 2.4 Printing & Closing a Document
- 2.5 Using a Template
- 2.6 Using a Wizard
- 2.7 Exiting Out of Word
- 3.0 Revising Documents
- 3.1 Opening a document
- 3.2 Navigating in a Document
- 3.3 Basic Editing
- 3.4 Click & Type
- 3.5 Smart Tags
- 3.6 Adding a Date
- 3.7 Adding an Envelope
- 3.8 Multiple Page Documents
- 4.0 Getting Help
- 4.1 Ask a Question
- 4.2 Office Assistant
- 4.3 Word Help Window
- 4.4 Context Sensitive
- 5.0 Shortcuts
- 5.1 Shortcut Menus
- 5.2 Keyboard Shortcuts
- 5.3 Work the Way You Want
- 6.0 Essential Skills
- 6.1 Selecting Text
- 6.2 Copying & Moving Text
- 6.3 Clipboard Task Pane
- 6.4 Undo, Redo, & Repeat
- 6.5 AutoCorrect
- 6.7 AutoComplete
- 7.0 Formatting Text & Paragraphs
- 7.1 Working with Fonts
- 7.2 Symbols & Special Characters
- 7.3 Paragraph Alignment & Line Spacing
- 8.0 Proofreading & Printing Documents
- 8.1 Spelling & Grammar
- 8.2 Thesaurus & Word Count
- 8.3 Previewing & Printing
Word XP: Intermediate Level
- 1.0 Managing Documents
- 1.1 Document Views
- 1.2 Working with Multiple Documents
- 1.3 File & Folder Management
- 1.4 Search Task Pane
- 2.0 Additional Editing Tools
- 2.1 AutoText
- 2.2 Find & Replace
- 2.3 Format Painter
- 3.0 Page Layout
- 3.1 Margins & Page Setup
- 3.2 Page Breaks
- 4.0 Customizing Word
- 4.1 Menus & Toolbars
- 4.2 Changing Defaults
- 4.3 User Options
- 5.0 Understanding Formatting in Word
- 5.1 Formatting Choices
- 5.2 Reveal Formatting Task Pane
- 6.0 Paragraph Formatting
- 6.1 Tabs
- 6.2 Indents
- 6.3 Bullets & Numbering
- 6.4 Line Breaks
- 6.5 Spacing Before & After
- 6.6 Styles & Formatting Task Pane
- 6.7 Sorting Text
- 6.8 Borders & Shading
- 7.0 Document Formatting
- 7.1 Numbering Pages
- 7.2 Headers & Footers
- 8.0 Mail Merge Basics
- 8.1 Understanding Mail Merge
- 8.2 Form Letters
- 8.3 Labels
- 9.0 Introduction to Graphics
- 9.1 Inserting Clip Art
- 9.2 Drawing & Modifying Shapes
Word XP: Advanced Level
- 1.0 Tables
- 1.1 Inserting Tables
- 1.2 Navigating in a Table
- 1.3 Modifying Tables
- 1.4 Formatting Tables
- 2.0 Formatting with Styles & Themes
- 2.1 Applying Styles
- 2.2 Styles & Formatting Task Pane
- 2.3 Creating & Modifying Styles
- 2.4 Applying a Theme
- 3.0 Document Templates
- 3.1 Personalizing Words Templates
- 3.2 Automating & Sharing a Template
- 4.0 Formatting
- 4.1 Section Formatting
- 4.2 Working with Columns
- 5.0 Long or Complex Documents
- 5.1 Bookmarks
- 5.2 Document Maps
- 5.3 Footnotes
- 5.4 Tables of Contents & Indexes
- 5.5 Outlines
- 5.6 Master Documents
- 6.0 Creating & Using Macros
- 6.1 Creating & Running Macros
- 6.2 Editing Macros
- 6.3 Automatic Macros