Here are two PowerPoint Tutorials for PowerPoint Basics on Creating a Slide Presentation, one each for the 2002 (XP) and 2000 versions. Also included here is an Intermediate PowerPoint Tutorial giving you several tips and tricks you can use to make PowerPoint work better and smoother for you. These are provided by California State University, Northridge.


PowerPoint 2002 Basics

This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint XP. Features covered in this tutorial and the one below for Powerpoint 2000 include the following: Startup Choices, The PowerPoint Window, Creating Slides, Layout Choices, Positioning and Resizing a Text Box or Image, Bulleted Items, Adding Clip Art, Charts and Graphs, Tables, Organization Charts, Normal View, Slide Sorter View, Slide Show View, Changing the Look and Feel of Your Presentation, Building Transitions and Effects on Your Slides, Effects, and Using Master Pages to Make Global Changes.

1. Some PowerPoint Definitions
2. Opening PowerPoint
   • Startup Choices
   • The PowerPoint Window
3. Creating Slides - New Layouts
   • Layout Choices
   • Positioning or Resizing a Text Box or Image
   • Changing Bulleted Items
   • Adding Clip Art
   • Charts and Graphs
     • Creating and Editing a Graph
     • Displaying Your Data with a Different Graph
   • Tables
   • Organization Charts
4. The Many Views of Your PowerPoint Presentation
   • Normal View
   • Slide Sorter View
   • Slide Show View
5. Changing the Look and Feel of Your PowerPoint Presentation
6. Building Transitions and Effects on Your Slides
   • Transitions
     • Adding Timing and/or Sound
   • Effects
   • Viewing Your Transitions and Effects
7. Using Master Pages to Make Global Changes
8. How to Learn More: PowerPoint's Help Options

PowerPoint 2000 Basics

This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint 2000.

1. Some PowerPoint Definitions
2. Opening PowerPoint
   • Startup Choices
   • The PowerPoint Window
3. Creating Slides - New Layouts
   • Layout Choices
   • Positioning or Resizing a Text Box or Image
   • Changing Bulleted Items
   • Adding Clip Art
   • Charts and Graphs
     • Entering Data
     • Seeing How It Looks
     • Displaying Your Data with a Different Graph
   • Tables
   • Organization Charts
   • Editing the Org Chart
   • Adding a New Box, Changing a Link Style, or Modifying the Look of a Box
   • Viewing the Org Chart
4. The Many Views of Your PowerPoint Presentation
   • Normal View
   • Outline View
   • Slide View
   • Sorter View
   • Slide Show View
5. Changing the Look and Feel of Your PowerPoint Presentation
6. Building Transitions and Effects on Your Slides
   • Transitions
   • Adding Timing and/or Sound
   • Effects
   • Viewing All Your Effects
7. Making Global Changes to Your PowerPoint Presentation Using the Master Pages Feature
8. How to Learn More

PowerPoint 2003 - Intermediate Guide - Tips and Tricks
(12 pages, 270kb, pdf format)

The following PowerPoint features and functionality are taught and demonstrated by this tutorials: Recoloring Clip Art, Cropping Clip Art and Images, Ungrouping Clip Art, the Picture Toolbar, Custom Backgrounds, Color Schemes, Modifying a Design Template, Customizing Design Templates, Saving a Template, Applying Animation and Additional Effects, Adding Interactivity, Inserting a Movie or Sound, Putting Your Presentation on the Web. 

Table of Contents:

1. Course Description
2. Recoloring Clip Art
3. Cropping Clip Art and Images
4. Ungrouping Clip Art
5. Using the Picture Toolbar
6. Creating a Custom Background
7. Change Color Scheme
8. Modifying a Presentation Design Template
9. Create a Customized Presentation Design Template
10. To Save a Template for Future Use
11. Applying Animation Effects  Additional effects
12. Adding Interactivity
13. Insert a Movie and/or Sound Clip
14. Insert WordArt
15. Putting Your PowerPoint 2003 Presentation on the Web

PowerPoint 97 Basics

Here are three well written Word Training Guides hosted by California State University, Northridge. Two of these training tutorials are for those getting started with Word and one is a tutorial on Mail Merge Using Word and Excel. Basic Word features demonstrated by these training guides are: Creating a Document, Basic Editing, Correcting Errors, Restoring a Deletion, Adding and Moving Text, Correcting Spelling and Grammatical Errors, Saving a Document, Printing a Document, Text Formatting, Paragraph Formatting, Document Formatting, Page Setup, Headers and Footers, Automatic Page Numbering, and File Management.


Beginner's Guide to Word 2002

1. Getting Started
   • Starting the Program
   • The Word Startup Window
2. Bare Bones Basics
• Creating a Document
• Basic Editing Features
• Correcting Errors
  • Erasing Mistakes as You Type
  • Deleting Text
• Restoring a Deletion
• Adding Text
• Moving Text
• Correcting Spelling and Grammatical Errors
• Saving a Document
• Saving a Document for the First Time
• Saving a Previously Saved Document
• Printing a Document
• Closing a Document Window
• Opening an Existing Document
• Ending a Word Session
3. Text Formatting Features
   • Bolding, Italicizing or Underlining Text
   • Changing Font Typeface and Size
4. Paragraph Formatting Features
• Aligning a Paragraph
• Paragraph Indents
• Line Spacing
• Setting Tab Stops
5. Document Formatting Features
• Page Setup
• Headers and Footers
• Automatic Page Numbering
6. File Management
7. How to Learn More
8. Appendix A: Glossary
9. Appendix B: Features Table

Beginner's Guide to Word 2000

This training guide presents an introduction to selected features in the word processing program Word 2000. Please note that the document is not intended to cover all ways in which the basic features can be used or accessed.

1. Getting Started
2. Bare Bones Basics
   
• Creating a Document
• Basic Editing Features
• Making Corrections
• Restoring a Deletion
• Adding Text
• Moving Text
• Correcting Spelling and Grammatical Errors
• Saving a Document
• Printing a Document
• Closing a Document Window
• Opening an Existing Document
• Ending a Word Session
3. Formatting Features
• Text Formatting
• Bolding, Italicizing or Underlining Text
• Changing Font Typeface and Size
• Paragraph Formatting
• Aligning a Paragraph
• Paragraph Indents
• Line Spacing
• Setting Tab Stops
• Document Formatting
• Page Setup
• Headers and Footers
• Automatic Page Numbering
4. File Management
• Saving Files
• Deleting Documents
• File Management QuickTips
5. How to Learn More
• Word Help Options
• Computer Based Training (CBT)
• Printed Material
6. Appendix A: Glossary
7. Appendix B: Word 2000 Features Table  

Mail Merge Using Word and Excel

Using Word's Mail Merge function gives you the ability to generate personalized documents by merging together a main document and a data source.

There are three steps to any mail merge project:

Step 1: Create a data source document in Excel with the information, such as name and addresses, that will vary with each letter or label.
Step 2: Create a main document in Word, such as a form letter, mailing labels, envelopes, etc.
Step 3: Merge the main document from step 2 with the data source from step 1.

Mail Merge Table of Contents

  1 Creating and Sorting a Data Source Document

• Creating a Data Source Document in Excel
• Sorting the Excel Data
• Creating a Data Source Document in Word

  2 Generating Individually Addressed Form Letters

• Creating the Main Document in Word
• Merging Form Letters

  3 Generating Mailing Labels

• Creating the Main Document in Word
• Merging Labels
• Saving the Main Document and Merging Again Later

  4 Generating Individually Addressed Envelopes

• Creating the Main Document in Word
• Merging Envelopes
• Saving the Main Document and Merging Again Later

  5 Generating a List (or Catalog)

• Creating the Main Document in Word
• Merging a Catalog

  6 How to Merge and Print Selected Records

  7 How to Learn More

• Word Help Options
• Printed Material

Here are three excellent Access Training Guides provided by California State University, Northridge. These Access training tutorials cover the fundamentals for both Access 2000 and 2003, and intermediate and advanced topics for Access 2003. Areas of functionality and features taught by these training guides are as follows: Getting Started, Starting Access 2003, Creating a New Database, Naming Conventions, The Leszynski Naming Convention, Object Naming Conventions, Designing a Table in Design View, Starting a New Table, Data Types, Defining Data Fields, Entering Data in Datasheet View, Creating a Query, Designing an Input Form, Producing a Report, Relationships, Using Operators in Queries, Designing Advanced Queries, and Creating Action Queries.

The Microsoft Access database model consists of data, fields, records, and tables of records, with each table being a flat file database. However this is not all -- in addition, in Access, the user can create and run queries, and produce reports from the the fields, records, and tables. This functionality, along with the ability to work with many tables having common elements, makes Access a database management system (DBMS) and a basic relational database.


Access 2003 - Basics & Beyond
(21 pages, 484kb, pdf format)

Contents:

• Introduction
• What is a database?
• The Access Database Management System
• Getting Started
• Starting Access 2003
• Creating a New Database
• Naming Conventions
• The Leszynski Naming Convention
• Object Naming Conventions
• Designing a Table in Design View
• Starting a New Table
• Data Types
• Defining Data Fields
• Entering Data in Datasheet View
• Creating a Query
• Designing an Input Form
• Producing a Report
• How To Learn More
• Access Help Options
• Printed Material
• Closing a Database and Exiting Access

Access 2003 Intermediate Training Guide
(19 pages, 262kb, pdf format)

Contents:

• Relationships
• Using Related Tables
• Creating a Relationship
• Setting Referential Integrity
• Using Operators in Queries
• Using Comparison Operators
• Using an AND Condition
• Using an OR Condition
• Using the BETWEEN AND Operator
• Using the Expression Builder
• Using a Wildcard Character
• Designing Advanced Queries
• Setting Top Values in a Query
• Creating a Calculated Field
• Formatting a Calculated Field
• Creating a Function Query
• Creating a Parameter Query
• Creating a Concatenation in a Query
• Filtering a Query
• Creating Action Queries
• Creating a Make Table Query
• Creating an Update Query
• Creating an Append Query
• Creating a Delete Query

Beginner's Guide to Access 2000

This training guide is intended to acquaint you with the fundamentals of Microsoft Access 2000. At the completion of this series of documents, you will have a basic understanding of database functions and capabilities, and the tools necessary to begin your own exploration and experimentation with Access 2000.

  1. Introduction

• What is a Database?
• The Access Database Management System

  2. Getting Started

• Starting Access
• Creating a New Database

  3. Naming Conventions

• The Leszynski Naming Convention
• Object Naming Conventions

  4. Designing a Table in Design View

• Starting a New Table
• Data Types
• Defining Data Fields

  5. Entering Data in Datasheet View 

  6. Creating a Query 

  7. Designing an Input Form 

  8. Producing a Report 

  9. How to Learn More

• Access Help Options
• The Office Assistant
• Microsoft Office Help
• What's This?
• Office on the Web
• Printed Material

  10. Closing a Database and Exiting Access

Here are 24 Microsoft Access Tutorials offered by Towson University. These Access tutorials demonstrate and convey how to perform many basic and advanced Access features and functions, including the following: Creating new databases, Data Entry, Forms, Tables, Relationships, Exporting and Importing Data, Sorting and Filtering Tables, Queries, Reports, Labels, and Lookup Lists. These Access tutorials will help you learn these topics and add to your Access knowledge and skillset. All documents are in pdf format, except the first 3 tutorials, which are videos with sound. 


Access 2003 Video Tutorial: Relationships
Take a tutorial on what relationships are and how to set them up in Access. - with sound

Access 2003 Video Tutorial: Tables
Take a tutorial on the basics of Access tables. - with sound

Access 2003 Video Tutorial: Forms
Take a tutorial on creating forms in Access. - with sound

Access 2003: Basic Workshop Learn how to create a complete new basic database following this step-by-step guide.

Access 2003: Understanding Databases This is a short reference to the basic functions of Access software and understanding the parts of a database.

Access 2003: Creating a New Database Learn how to create a new database using the built in templates. Also, start a blank database and learn how to use table wizards to help build your database.

Access 2003: Data Entry and Forms Learn how to build forms in Access to enter your data into tables without having to go into the Design View.

Access 2003: Exporting and Linking Data Learn how to export your data from Access to Excel, XML or HTML formats.  Also, learn how to link to other data outside of your database.

Access 2003: Importing Data Learn how to import data from Excel, other text files or another Access database.

Access 2003: Sorting and Filtering Tables Learn how to sort and filter the data within your Access tables.

Access 2003: Queries Learn how to run queries and use criteria to help you pull data from your database.

Access 2003: Reports Learn how to make professional looking reports using the Access Reports wizard and modify the results with basic and advanced techniques

Access 2003: Inserting Graphics Learn how to insert a graphic or an object to your tables and forms.

Access 2003: Advanced Tables Design View Learn advanced table features using Design View in Access 2003.

Access 2003: Advanced Forms: Sub-Forms Learn how to use sub-forms in Access 2003.

Access 2003: Advanced Queries: Design View Learn how to use Design View to run advanced queries in Access 2003.

Access 2003: Advanced Reports: Calculations Learn how to make calculations in reports in Access 2003.

Access 97: Converting to Access 2003
This document offers some tips on converting Access 97 databases to Access 2003.

Access: Getting Data from PeopleSoft 
Learn how to connect to PeopleSoft Data through an ODBC to make tables that you can manipulate in Access.

Access 2003: Understanding Relationships
This document offers some tips on understanding and creating relationships in Access 2003.

Access 2003: Creating Labels 
Learn how to create labels by using the information in your Access database.

Access 2003: Creating Switchboards
Learn how to create a switchboard so that when editors open the database they go right to the form screen.

Access 2003: Understanding Tables 
Tables are a key feature in Access, this document will help you better understand them.

Access 2003: Creating a Lookup List
Learn how to create a Lookup List to populate field data and to ensure consistency.

This is a comprehensive linked list of 160 Excel Tutorials and How Tos teaching how to use Macros and code using VBA in Excel. VBA is an abbreviation for Visual Basic for Applications, its the Microsoft Office scripting language used to customize the applications. These learning materials include instructions for performing the demonstrated tasks and are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

Excel VBA Tutorials with Instructions

Excel Macros Excel VBA Macros Add a Module with VBA Add Row while copying and manipulating data Add the Path to your Worksheet Footer when Printing Add today's entries to the next empty row on a master sheet Adding and Deleting with VBA Animation in Excel Application Events Application-Level Names (Hidden Name Space) Arrays - CSEs - in Excel Visual Basic Audio - Playing Sounds in Excel Automate a tedious process with VBA Macros Bypass Delete Confirmation Change Name Box List width Change macro to import text file in next available row instead of using A1 Change the worksheet tab name to reflect the value in cell A1 Changing a cell's background color Changing Tab Color Color - Counting based on Interior or Font Color Color - Counting by and Summing By Color Color - Highlight Duplicate Entries Color - Highlighting an Active Cell Color - RGB Values Convert Text to Lower Case Converting Measurements To and From Copy a Macro to Another Workbook Automatically Copy Sheet, Preserving all Formatting Copy the Previous row into the Next Blank Row Counting cells by interior color using VBA Create 78 Unique Sheet Names with Identical Data Create a TOC (Table of Contents) for your workbook Create a unique record number Create a Word Document from a Row of Data Create and name a new worksheet with VBA Creating multiple lines of text in a messagebox Creating Page Breaks in Excel-automaticaly Custom Document Properties Custom Functions Custom Menus in the Visual Basic Editor(VBE) Daily Import Automation with Unique Sheet IDs Data Validation - Use a Defined Name to validate with data on another worksheet Dates - Day of the Week with VBA Dates - Find with VBA Declaring a Variable in VBA Declaring an Object Default Properties of a Class Delete a worksheet in a macro without having to see the "This worksheet will be permanently deleted" Deleting VBA Display Screensaver in Excel Displaying AutoFilter criteria Document Properties Downloading Files using Excel Duplicate Entries - Replace Eliminate "/" from File Names when Saving with a Macro Email a Worksheet From Within Excel Emulate Lotus' Print Suppression Excel Crash on Mouse-over of object Exit a worksheet with or without saving Export VBA Code to a Text File Exporting to Text Fill Next Row with Previous Row's Data Find the last row of data in a range First Monday of the Year Formatting Time Values FTP within Excel Headers and Footers - with VBA Headers and Footers in Excel Hidden Name Space - Application-Level Names Hiding a range depending upon user selections Highlight Active Cell Location Highlight Cells with Today's Date Highlight the active cell How do I get rid of a Macro? Importing - Text Files to Excel Increment a Counter everytime a Userform is opened Inputbox to accept specific data Link back to original workbook Maximized view on open Mailing Labels in Excel with VBA Utility Module-What is it?

No Blank Rows No Duplicate Rows OnTime Method Open Other Applications from Excel Opening Chm (or HTML Type Help) files Optimize Your Code! Phone Calls within Excel Phone Numbers - Splitting(Parsing) Play a MIDI File when Value Exceeds Set Limit Printing - Cell Comments Printing - Cell Formulas Programming a messagebox for user responses PROPER - Converting Text Case Proper Text Protecting specified data using VBA Quicken and Excel: Streamline Categories on Copied Reports Range - Bringing a Range Center Screen with VBA Range - Referring to Cells in Another Range Range - Reverse a Range with VBA Range - Reverse Cell Order Range - Select the Current Named Range Ranges - VBA for Named Ranges Record/Playback a WAV file in Excel Record a Macro using Relative References (TechTV) Recycle Bin Removing a set number of characters from a cell Removing hyperlinks from a worsheet Removing text-string characters Reset Application.ScreenUpdating for forward compatibility with Excel XP RGB Colors Run a Macro Automatically When the Workbook Opens Run a Macro Following Cell Value Change Run a Macro from a Command Button Run a Macro from a Cell Save - Save and Return to Selection Save a Workbook with Cell A1's Data Scheduled Procedure - Using OnTime Select Current Array Selecting files within VBA Selection Change to Highlight Current Row and Column Setting a font name with VBA Sorting - Worksheets Stopping an Endless Loop Testing Anti Virus Applications using Excel Text - Converting to Upper or Lower Case Text to Columns using VBA Time - Working with Time Zones Time: Military Time with No Colon Timers UDF(User Defined Function)-Use a Calculated Range in a Standard Function Unselect a Cell or Area Upper Case - Converting To/From Use Cells(Row, Column) instead of Range() when looping through several columns Use Cells(Row, Column).Name = "MyRange" to Simplify Naming a Range Use Set to create an Object Variable instead of a regular variable when referencing cells Use Workbook_Open to open a Userform when a workbook is opened Userforms - Modeless Userforms in Excel '97 and beyond Using Inputboxes Variable - Declare VBA How to: Macros on the Web VBA How To: Record and Customize your own macros WAV Files in Excel What is a Code Module? What is a Module? Workbook - Close All Workbook - Returning Properties Workbook - Save All Workbook Object - Document Properties Working with Functions in a Macro Working with Userform controls Worksheet - Call a Macro from a Worksheet Worksheet - Returning Sheet Name Worksheet Protection after Sorting Worksheets - Referencing from a Formula Worksheets - Sorting Zoom - To a Range Oracle Data in Excel