One of the most powerful programs ever built for creating documents, Microsoft Word is an important reason why Office is the worlds most popular office productivity suite. In this course, you learn about the new features that most of us will use everyday at work and at home.

1.0 Getting Started
1.1 Starting Word 2003
1.2 Touring the Word Window
1.3 Help in Word 2003

2.0 Creating New Documents
2.1 Starting a New Document
2.2 Entering Text, Delete Keys and Capital Letters
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 Your Documents
3.1 Opening Documents
3.2 Navigating Documents
3.3 Basic Editing Skills, Click and Type
3.4 Smart Tags
3.5 Adding a Date
3.6 Adding an Envelope
3.7 Multiple Page Documents

4.0 Shortcuts
4.1 Shortcut Menus/Customizing Toolbars
4.2 Keyboard Shortcuts

5.0 Essential Skills
5.1 Selecting Text
5.2 Copying & Moving Text
5.3 Clipboard Task Pane
5.4 Undo, Redo & Repeat
5.5 AutoCorrect
5.6 AutoComplete

6.0 Formatting Text & Paragraphs
6.1 Working with Fonts
6.2 Symbols & Special Characters
6.3 Document Layout and Page Setup

7.0 Proofreading & Printing Documents
7.1 Spelling & Grammar
7.2 Thesaurus & Word Count
7.3 Previewing & Printing a Document

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 Find & Replace
2.2 AutoText
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
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

10.0 Organizing Content
10.1 Use automated tools for document navigation

1.0 Tables
1.1 Creating Tables
1.2 Navigating in a Table
1.3 Modifying Tables
1.4 Formatting Tables
1.5 Perform calculations in 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 Word's Templates
3.2 Automating & Sharing a Template
3.3 Create and Modify diagrams and charts using data from other sources

4.0 Section Formatting
4.1 Formatting a Section
4.2 Working with Columns

5.0 Long or Complex Documents
5.1 Bookmarks & Cross-references
5.2 Document Map
5.3 Footnotes
5.4 Table of Contents & Index
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
6.4 XML

7.0 Collaborating
7.1 Modify track changes options
7.2 Publish and edit Web documents
7.3 Manage document versions
7.4 Protect and restrict forms and documents
7.5 Attach digital signatures to documents
7.6 Customize document properties

This course will help familiarize you and your team with the fundamentals of Excel XP. Learn cell referencing, auditing techniques, VLOOKUP functions, and much more.

Excel is a powerful, yet easy-to-use spreadsheet software package that is part of the Microsoft Office 2003 suite of products. In this course, you will learn the fundamentals of Excel 2003, such as cell referencing, auditing techniques, VLOOKUP functions, and much more.

1.0 The Excel Screen
1.1 Overview – Loading Microsoft Excel 2003
1.2 Screen Elements – Menu and Button Bars
1.3 Screen Elements – Workbook and Spreadsheet Properties

2 .0 Creating Data and Content
2.1 Enter and edit cell content
2.2 Navigate to specific cell content
2.3 Locate, select and insert supporting information
2.4 Insert, position and size graphics
2.5 Saving, closing and opening files

3.0 Analyzing Data
3.1 Filter lists using AutoFilter
3.2 Sort lists
3.3 Insert and modify formulas
3.4 Create, modify, and position diagrams and charts based on worksheet data

4.0 Formatting Data and Content
4.1 Apply and modify cell formats
4.2 Apply and modify cell styles
4.3 Modify row and column formats
4.4 Format worksheets using AutoFormat

1.0 Collaborating
1.1 Insert, view and edit comments

2.0 Managing Worksheets
2.1 Create new workbooks from templates
2.2 Insert, delete and move cells
2.3 Create and modify hyperlinks
2.4 Organize worksheets
2.5 Preview data in other views
2.6 Customize window layout
2.7 Setup pages for printing
2.8 Print data
2.9 Organize workbooks using file folders
2.10 Save data in appropriate formats for different uses

3.0 Organizing and Analyzing Data
3.1 Use subtotals
3.2 Define and apply advanced filters

3.3 Group and outline data
3.4 Use data validation
3.5 Create and modify list ranges
3.6 Using statistical, date and time, financial, and logical functions
3.7 Add, show, close, edit, merge and summarize scenarios
3.8 Perform data analysis using automated tools
3.9 Create PivotTable and PivotChart reports
3.10 Use Lookup and Reference functions
3.11 Use Database functions
3.12 Trace formula precedents, dependents and errors
3.13 Locate invalid data and formulas
3.14 Watch and evaluate formulas
3.15 Define, modify and use named ranges
3.16 Structure workbooks using XML

1.0 Formatting Data and Content
1.1 Create and modify custom data formats
1.2 Use conditional formatting
1.3 Format and resize graphics
1.4 Format charts and diagrams

2.0 Collaborating
2.1 Protect cells, worksheets, and workbooks
2.2 Apply workbook security settings
2.3 Share workbooks
2.4 Merge workbooks

3.0 Managing Data and Workbooks
3.1 Import data to Excel
3.2 Export data from Excel
3.3 Publish and edit Web Worksheets and workbooks
3.4 Create and edit templates
3.5 Consolidate data
3.6 Define and modify workbook properties

4.0 Customizing Excel
4.1 Customize toolbars and menus

PowerPoint is a powerful, yet easy-to-use presentation software package that is part of the Microsoft Office 2003 suite of products. Use PowerPoint to create presentations for a wide variety of audiences and for a wide variety of purposes. In this course, you learn about the new features and learn many of the skills necessary to become a PowerPoint professional.

1.0 Getting started
1.1 What is PowerPoint?
1.2 Starting PowerPoint
1.3 Touring the PowerPoint Window

2.0 Creating a New Presentation
2.1 New Presentation Task Pane
2.2 Creating a Blank Presentation, New Slides, and Slide Types
2.3 Saving and Closing
2.4 Opening an existing presentation
2.5 Creating a presentation using Design Templates
2.6 Creating a presentation using Auto Content Wizard

3.0 Revising Presentations
3.1 Navigating in a presentation

4.0 Getting Help
4.1 Ask a Question Box
4.2 Office Assistant
4.3 PowerPoint Help Window

5.0 Outline View
5.1 Entering Text in an Outline
5.2 Formatting Text

6.0 Inserting and Editing Text Based Content
6.1 Speaker Notes

7.0 Inserting Tables and Diagrams
7.1 Inserting Tables
7.2 Inserting Diagrams

8.0 Inserting Pictures, Shapes and WordArt
8.1 Inserting Pictures
8.2 Inserting Shapes
8.3 Inserting WordArt

9.0 Previewing a Presentation
9.1 Previewing a Presentation

1.0 Formatting Text Based Content
1.1 Formatting Text Based Content

2.0 Formatting Pictures, Shapes and Graphics
2.1 Clip Art, Photographs, and Animations

3.0 Formatting Slides
3.1 Color, Texture, and Templates

4.0 Applying Animation Schemes
4.1 Applying Animation Schemes

5.0 Applying Slide Transitions
5.1 Applying Slide Transitions

6.0 Working with Slide Masters
6.1 Slide Masters

7.0 Tracking, Accepting and Rejecting Changes
7.1 Tracking, Accepting and Rejecting Changes

8.0 Adding, Editing and Deleting Comments
8.1 Adding, Editing and Deleting Comments

9.0 Comparing and Merging Presentations
9.1 Comparing and Merging Presentations

1.0 Organizing a Presentation
1.1 Setting up the slide show for delivery
1.2 Rehearsing Timings

2.0 Delivering a Presentation
2.1 Delivering a Presentation

3.0 Preparing Presentations for Remote Delivery
3.1 Preparing Presentations for Remote Delivery

4.0 Saving and Publishing Presentations
4.1 Copying to a CD

5.0 Printing Slides, Handouts and Speaker Notes
5.1 Printing Slides, Handouts and Speaker Notes

6.0 Exporting a Presentation to Another Microsoft Program
6.1 Exporting a Presentation to Another Microsoft Program

This course will teach you how to use the email features of Outlook in the new 2003 environment. Learn to work with contacts, schedule appointments using the calendar, customize your toolbar and more.

1.0 What's New for 2003
1.1 A tour of Outlook 2003
1.2 Editing the Outlook 2003 Toolbars, Task Panes and Mail Views

2.0 Introduction to MS Outlook
2.1 Creating a message
2.2 Replying to and Forwarding messages
2.3 Deleting messages and emptying the Deleted Items folder
2.4 Using Word as the message editor

3.0 Messaging
3.1 Organizing
3.2 Attaching files
3.3 Create and modify a personal signature
3.4 Modify e-mail message settings and delivery options
3.5 Create and edit contacts
3.6 Creating Personal Folders
3.7 Personal Distribution Lists
3.8 Accept, decline, and delegate tasks

1.0 Scheduling
1 .1 Create and modify appointments, meetings, and events
1.2 Update, cancel, and respond to meeting requests
1.3 Customize Calendar settings
1.4 Create, modify, and assign tasks

1.0 Organizing
1 .1 Create and modify distribution lists
1.2 Link contacts to other items
1.3 Create and modify notes
1.4 Organize items
1.5 Search for items
1.6 Save items in different file formats
1.7 Assign items to categories
1.8 Preview and print items

1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database – Fields, Properties, and Datasheet View
1.5 Copying Databases

2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and 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

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

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

4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 View Objects and Object Data in Other Views
4.3 Import Data to Access
4.4 Export data from Access
4.5 Create and Modify Calculated Fields and Aggregate Functions
4.6 Create a Data Access Page
4.7 Back up a database
4.8 Compact and repair databases