Consists of 15 CD Videos:
Microsoft XP Excel - Beginner, Intermediate & Advance
Microsoft XP Access - Beginner, Intermediate & Advance
Microsoft XP Powerpoint - Beginner, Intermediate & Advance
Microsoft XP Word - Beginner, Intermediate & Advance
Microsoft XP Outlook - Beginner, Intermediate & Advance

Excel XP Beginning
	1.0	Introduction to Excel
		1.1 Orientation 1.2 Tools 1.3 The Worksheet 1.4 Using the Keyboard to Navigate
	2.0	Data Entry
		2.1 Text 2.2 Selecting Cells 2.3 Values 2.4 Entering Formulas 2.5 Auto-Sum for Totals 2.6 The Average Function
	3.0	Changing Worksheet Appearance
		3.1 Simple Formatting 3.2 Fill & Font Colors 3.3 Undo 3.4 Borders
	4.0	File Management
		4.1 Saving Your Work 4.2 Opening a File 4.3 Creating a New Workbook 4.4 Closing a File
	5.0	Additional Formulas
		5.1 Cumulative Totals 5.2 % Change 5.3 Formula Symbols 5.4 Editing Formulas 5.5 Auto Calculate Feature
	6.0	Formatting Features
		6.1 Changing the Font Type & Size 6.2 Inserting Rows & Columns 6.3 Copying & Moving Data in a Worksheet
	7.0	Printing Worksheets
		7.1 Print Review 7.2 Printing Selections 7.3 The Print Button & Exiting Out of Excel
	Excel XP Intermediate
	1.0	Build In Functions
		1.1 PMT Financial Function 1.2 Paste Function Tool
	2.0	Dates & Times
		2.1 Date Functions 2.2 Changing Date Displays 2.3 Time Functions
	3.0	Setting Defaults
		3.1 Tools Options
	4.0	Multi-Sheet Workbooks
		4.1 Inserting & Re-naming Sheets 4.2 Copying Worksheets 4.3 Formulas that Work Across Worksheets 4.4 Grouping Worksheets
	5.0	Cell Reference
		5.1 Absolute Reference 5.2 Mixed Reference
	6.0	Format Cells Command
		6.1 Changing Text Appearance 6.2 Adding Borders 6.3 Adding Color
	7.0	Charts
		7.1 Creating a Chart 7.2 Placing & Modifying Your Chart 7.3 Formatting a Chart 7.4 Shortcuts & Tricks 7.5 Pie Charts
	Excel XP Advanced
	1.0	Logical Function
		1.1 If Statement 1.2 Modifying the If Statement 1.3 Vertical Lookup 1.4 Horizontal Lookup
	2.0	Split Screen Techniques
		2.1 Horizontal Split 2.2 Freeze Panes 2.3 Vertical Slit 2.4 Creating a Double Freeze
	3.0	AutoFill Techniques
		3.1 AutoFill 3.2 Dates Using AutoFill 3.3 Series Extension
	4.0	Data Validation Techniques
		4.1 Validating Data 4.2 The Auditing Toolbar & Keyboard Shortcuts
	5.0	Excel Databases
		5.1 Sorting Data 5.2 Sorting From the Toolbar 5.3 Data Sort Command 5.4 Creating Subtotals 5.5 Filtering
	6.0	Range Names
		6.1 Naming Cells
	7.0	Additional Charting Capabilities
		7.1 Formatting the X & Y Axis 7.2 Changing the Chart Style 7.3 FChanging Line Attributes 7.4 Utilizing Drawing Tools

Microsoft Office XP Training Video - Access

Access XP Beginning
	1.0	Introduction
		1.1 Getting Started 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 Existing Tables
		2.1 Viewing & Navigating Table Data 2.2 Adding Records to a Table 2.3 Selecting and Deleting Records 2.4 Editing Table Data
	3.0	Find and Replace Commands
		3.1 Finding a Replacing Table Data
	4.0	Customizing the Datasheet & Using Spell Check Functions
		4.1 Modifying the Appearance of a Datasheet 4.2 Spell Check & Auto Correct
	5.0	Form Basics
		5.1 Moving from Record to Record 5.2 Adding & Editing a Record 5.3 Filtering 5.4 Sorting
	6.0	Creating Forms
		6.1 Auto Forms 6.2 Using a Form Wizard 6.3 Conditional Formatting
	7.0	Report Basics
		7.1 Moving from Page to Page 7.2 Zooming In & Out 7.3 Viewing Multiple Pages
	8.0	Creating Reports
		8.1 Creating Simple Reports 8.2 Using Auto Reports 8.3 Using the Report Wizard
	9.0	Printing Database Objects
		9.1 Print Preview 9.2 Printing Table Data Sheets 9.3 Printing Queries 9.4 Printing Forms 9.5 Printing Reports
	10.0	Getting Help
		10.1 Using the Help Toolbar 10.2 Using Help Content, Answer Wizard & the Index
	11.0	Database Maintenance
		11.1 Backing Up & Restoring Databases 11.2 Compacting & Repairing a Database 11.3 Converting a Database to a Previous Version
	12.0	Database Organization
		12.1 Organizing Database Objects into Groups
	Access XP Intermediate
	1.0	Planning & Designing a Database
		1.1 Inputs & Outputs 1.2 Normalization
	2.0	Creating a Database Using the Wizard
	3.0	Creating a Database from Scratch
	4.0	Building & Modifying Tables
		4.1 Creating Tables Using the Wizard 4.2 Creating Tables from Scratch
	5.0	Understanding Primary Keys & Using Lookup Wizard
		5.1 Setting Primary Keys 5.2 The Lookup Wizard
	6.0	Understanding Field Properties
		6.1 Field Properties 6.2 Input Masks
	7.0	Understanding the Indexed Field Properties
		7.1 An Explanation of Indexing 7.2 Changing the Indexed Field Property
	8.0	Understanding Access Relationships
		8.1 Introduction to Relationships 8.2 Benefits of Relationships 8.3 Types of Relationships