The Fastest, Easiest Way to Learn Excel 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Includes Beginner, Intermediate & Advanced Topics
• Chapters are organized into specific learning objectives - easily available from the main menu.
• Learning objectives guide you to success.
• Colorful graphics and clear instructions keep you interested.
• Professional voice narration assists retention.

The Most Interactive Training Available
• Self-paced, interactive lessons allow you to practice in a realistic simulation of the software.
• Accurate screen presentations, menus, and buttons provide an easy transition to the real application.
• Step-by-step interactive exercises help you achieve high retention rates.
• Practical exercises and examples make learning easy.
• Introductions, summaries and end-of-chapter quiz questions all reinforce learning.

Realistic, Interactive & Complete Training!
Realistic simulations provide an accurate learning environment so your transition to the application is fast and easy. More than just videos, you'll interact to perform the correct action during each exercise for better learning and retention. Hundreds of learning topics and beginner through advanced subjects are included.

No Other Training is More Complete!
• Hundreds of Learning Topics
• 5 to 10 Hours of Training per Course
• Beginner to Advanced Topics
• Self-Paced Learning Objectives
• Introductions and Summaries
• Interactive Exercises
• Professional Voice Narration
• Realistic Simulation of Software
• End-of-Chapter Quiz Questions
• Checkmarks for Completed Topics
• Glossary, Index and Search
• Professor Answers for Instant Training

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook

Chapter 3: Entering Text, Numbers, and Dates
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data

Chapter 4: What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas

Chapter 5: Using Statistical Functions
• Using Financial Functions
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations

Chapter 6: Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

Chapter 7: Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

Chapter 8: Creating a Chart
• Enhancing a Chart
• Modifying Chart Data
• Changing Chart Types
• Drawing Shapes
• Inserting Pictures
• Creating SmartArt

Chapter 9: Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet
• Printing Selected Data

Chapter 10: Arranging Multiple Workbooks
• Adding Hyperlinks
• Working with Comments
• Saving Workbooks in Different Formats
• Saving a Workbook as a Web Page
• Creating Folders
• E-Mailing a Workbook

The Fastest, Easiest Way to Learn Word 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Includes Beginner, Intermediate & Advanced Topics
• Chapters are organized into specific learning objectives - easily available from the main menu.
• Learning objectives guide you to success.
• Colorful graphics and clear instructions keep you interested.
• Professional voice narration assists retention.

The Most Interactive Training Available
• Self-paced, interactive lessons allow you to practice in a realistic simulation of the software.
• Accurate screen presentations, menus, and buttons provide an easy transition to the real application.
• Step-by-step interactive exercises help you achieve high retention rates.
• Practical exercises and examples make learning easy.
• Introductions, summaries and end-of-chapter quiz questions all reinforce learning.

Realistic, Interactive & Complete Training!
Realistic simulations provide an accurate learning environment so your transition to the application is fast and easy. More than just videos, you'll interact to perform the correct action during each exercise for better learning and retention. Hundreds of learning topics and beginner through advanced subjects are included.

No Other Training is More Complete!
• Hundreds of Learning Topics
• 5 to 10 Hours of Training per Course
• Beginner to Advanced Topics
• Self-Paced Learning Objectives
• Introductions and Summaries
• Interactive Exercises
• Professional Voice Narration
• Realistic Simulation of Software
• End-of-Chapter Quiz Questions
• Checkmarks for Completed Topics
• Glossary, Index and Search
• Professor Answers for Instant Training

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: What is Word?
• How to Open a Document
• Changing Views
• Navigating Documents
• How to Create Documents
• Using Templates
• Saving Documents
• How to Close Documents

Chapter 3: Entering Text
• How to Select Text
• Moving and Copying Text
• Using Repeat, Undo, and Redo
• Using AutoCorrect
• Inserting Symbols
• Inserting Fields

Chapter 4: Introduction to Formats and Styles
• Applying Font Formats
• Text Alignment
• Changing Indents and Spacing
• Working with Tabs
• Applying Styles
• Modifying Styles
• Revealing and Clearing Formats
• Using the Format Painter

Chapter 5: Exploring Page Layout Options
• Changing Margins
• Adding Sections and Page Breaks
• Creating Columns
• Adding Bullets and Numbering
• Applying Borders and Shading

Chapter 6: Inserting Pictures
• Resizing and Moving Pictures
• Inserting Shapes
• Using WordArt
• Adding Text Boxes
• Creating Charts
• Inserting SmartArt

Chapter 7: Creating a Table
• Converting Text to a Table
• Formatting a Table
• Modifying the Table Layout
• Using Table Templates

Chapter 8: Exploring the Research Task Pane
• Using the Thesaurus
• How to Find and Replace Text
• Correcting Spelling and Grammar
• Using Word Count
• Working with Document Properties
• Adding a Hyperlink

Chapter 9: Adding Comments
• Comments, Adding
• Tracking Document Changes
• Reviewing Tracked Changes
• E-Mailing Documents for Review
• Combining Reviewed Documents
• Using the Document Inspector
• Creating Folders

Chapter 10: Using Print Preview
• How to Print Documents
• Printing Envelopes and Labels
• How to Save Documents in Different Formats
• Saving Documents as Web Pages
• How to Convert Word 97-2003 Documents

The Fastest, Easiest Way to Learn Outlook 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Includes Beginner, Intermediate & Advanced Topics
• Chapters are organized into specific learning objectives - easily available from the main menu.
• Learning objectives guide you to success.
• Colorful graphics and clear instructions keep you interested.
• Professional voice narration assists retention.

The Most Interactive Training Available
• Self-paced, interactive lessons allow you to practice in a realistic simulation of the software.
• Accurate screen presentations, menus, and buttons provide an easy transition to the real application.
• Step-by-step interactive exercises help you achieve high retention rates.
• Practical exercises and examples make learning easy.
• Introductions, summaries and end-of-chapter quiz questions all reinforce learning.

Realistic, Interactive & Complete Training!
Realistic simulations provide an accurate learning environment so your transition to the application is fast and easy. More than just videos, you'll interact to perform the correct action during each exercise for better learning and retention. Hundreds of learning topics and beginner through advanced subjects are included.

No Other Training is More Complete!
• Hundreds of Learning Topics
• 5 to 10 Hours of Training per Course
• Beginner to Advanced Topics
• Self-Paced Learning Objectives
• Introductions and Summaries
• Interactive Exercises
• Professional Voice Narration
• Realistic Simulation of Software
• End-of-Chapter Quiz Questions
• Checkmarks for Completed Topics
• Glossary, Index and Search
• Professor Answers for Instant Training

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Getting Help

Chapter 2: What is Outlook?
• Using the Navigation Pane
• Working with Folders
• Exploring the Inbox
• Reading Your EMail
• Replying to an EMail Message
• Forwarding a Message
• Sending a New Message
• Adding an Attachment
• Viewing Sent Items

Chapter 3: Flagging Messages for Follow Up
• Using Multiple EMail Accounts
• Adding a Signature
• Formatting Messages
• Setting Message Priorities
• Setting Delivery Options
• Using the Rules Wizard
• Printing Your EMail
• Saving Messages

Chapter 4: Adding Contacts
• Viewing Contact Information
• Modifying and Deleting Contacts
• Creating a Distribution List
• Sending a Message to a Contact
• Using Outlook to Call a Contact
• Tracking Contact Activities
• Printing Contact Information
• Exporting Contact Information

Chapter 5: Viewing Calendar Information
• Scheduling Appointments
• Adding Recurring Appointments
• Exploring Calendar Settings
• Planning a Meeting
• Scheduling a Meeting
• Responding to Meeting Requests
• Publishing Your Calendar

Chapter 6: Creating Tasks
• Using the Task Form
• Viewing Tasks
• Assigning Tasks to Others
• Responding to Task Requests
• Delegating Tasks to Others
• Using the Journal
• Manually Recording Journal Entries
• Viewing Journal Entries

Chapter 7: Keeping Notes
• Managing Folders
• Copying Items among Folders
• Locating Items
• Creating Categories
• Arranging Items
• Organizing Folders
• Designing Custom Views

The Fastest, Easiest Way to Learn Access 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Includes Beginner, Intermediate & Advanced Topics
• Chapters are organized into specific learning objectives - easily available from the main menu.
• Learning objectives guide you to success.
• Colorful graphics and clear instructions keep you interested.
• Professional voice narration assists retention.

The Most Interactive Training Available
• Self-paced, interactive lessons allow you to practice in a realistic simulation of the software.
• Accurate screen presentations, menus, and buttons provide an easy transition to the real application.
• Step-by-step interactive exercises help you achieve high retention rates.
• Practical exercises and examples make learning easy.
• Introductions, summaries and end-of-chapter quiz questions all reinforce learning.

Realistic, Interactive & Complete Training!
Realistic simulations provide an accurate learning environment so your transition to the application is fast and easy. More than just videos, you'll interact to perform the correct action during each exercise for better learning and retention. Hundreds of learning topics and beginner through advanced subjects are included.

No Other Training is More Complete!
• Hundreds of Learning Topics
• 5 to 10 Hours of Training per Course
• Beginner to Advanced Topics
• Self-Paced Learning Objectives
• Introductions and Summaries
• Interactive Exercises
• Professional Voice Narration
• Realistic Simulation of Software
• End-of-Chapter Quiz Questions
• Checkmarks for Completed Topics
• Glossary, Index and Search
• Professor Answers for Instant Training

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: What is an Access Database
• Opening a Database File
• Exploring Database Objects
• Creating a Database
• Changing Views
• Printing Database Objects
• Saving and Closing a Database File

Chapter 3: What is a Table?
• Working with Datasheets
• Moving Among Records
• Updating Records
• Adding Records to a Table
• Selecting Rows and Columns
• Finding Records
• Sorting Records
• Filtering Records
• Using the PivotChart View
• Saving and Closing a Table

Chapter 4: Adding a Table to a Database
• Adding Fields to a Table
• Adding a Lookup Field
• Setting a Primary Key
• Using the Input Mask Wizard
• Saving Design Changes
• Importing Data
• Exporting Data
• Performing Database Maintenance

Chapter 5: What is a Query?
• Creating a Query
• Working with Queries
• Saving and Running a Query
• Creating Calculated Fields
• Using Agregate Functions
• Understanding Query Properties
• Creating Multi-Table Select Queries
• Joining Tables
• Enforcing Referential Integrity

Chapter 6: What is a Form?
• Using the Form Tool
• Creating a Form with the Form Wizard
• Working in Design View
• Changing the Form Layout
• Using Calculated Controls
• Working with Records on a Form

Chapter 7: What is a Report?
• What is a Report Tool
• Previewing and Printing a Report
• Saving a Report
• Designing a Report
• Changing a Report Layout
• Understanding Controls
• Using a Calculated Control
• Analyzing Dependencies
• Creating Mailing Labels

The Fastest, Easiest Way to Learn PowerPoint 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Includes Beginner, Intermediate & Advanced Topics
• Chapters are organized into specific learning objectives - easily available from the main menu.
• Learning objectives guide you to success.
• Colorful graphics and clear instructions keep you interested.
• Professional voice narration assists retention.

The Most Interactive Training Available
• Self-paced, interactive lessons allow you to practice in a realistic simulation of the software.
• Accurate screen presentations, menus, and buttons provide an easy transition to the real application.
• Step-by-step interactive exercises help you achieve high retention rates.
• Practical exercises and examples make learning easy.
• Introductions, summaries and end-of-chapter quiz questions all reinforce learning.

Realistic, Interactive & Complete Training!
Realistic simulations provide an accurate learning environment so your transition to the application is fast and easy. More than just videos, you'll interact to perform the correct action during each exercise for better learning and retention. Hundreds of learning topics and beginner through advanced subjects are included.

No Other Training is More Complete!
• Hundreds of Learning Topics
• 5 to 10 Hours of Training per Course
• Beginner to Advanced Topics
• Self-Paced Learning Objectives
• Introductions and Summaries
• Interactive Exercises
• Professional Voice Narration
• Realistic Simulation of Software
• End-of-Chapter Quiz Questions
• Checkmarks for Completed Topics
• Glossary, Index and Search
• Professor Answers for Instant Training

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: What is PowerPoint?
• Opening a Presentation
• Changing Views
• Using Grids and Guides
• Saving and Closing a Presentation
• Managing Files and Folders

Chapter 3: Creating a New Presentation
• Entering Text on a Slide
• Changing Text Formats
• Using the Format Painter
• Formatting Bullets
• Aligning Text
• Working with Tabs

Chapter 4: Using Templates
• Adding a Slide
• Changing a Slide Layout
• Adding a Picture
• Customizing Templates
• Using the Slide Master
• Adding Headers and Footers
• Adding Speaker Notes
• Arranging Slides

Chapter 5: Introduction to Drawing Tools
• Inserting Shapes
• Adding Text to Shapes
• Formatting Shapes
• Inserting and Formatting Picture Files
• Arranging Objects
• Adding an Action Button

Chapter 6: Adding a Table
• Adding a Chart
• Adding SmartArt
• Adding a Hyperlink
• Adding Transition Effects
• Adding Animation Effects
• Adding a Sound Clip

Chapter 7: Working in Outline View
• Importing an Outline from Word
• Finding and Replacing Text
• Using Proofing Tools
• Using AutoCorrect
• Printing Your Presentation

Chapter 8: Creating a Custom Show
• Rehearsing a Slide Show
• Collaborating on Presentations
• Packaging a Presentation
• Running a Slide Show
• Publishing a Presentation to the Web