Here are Four Free Training Resources for Learning How to Use PowerPoint 2007. The first one is an online course that will help you learn how to use the new Office 2007 Ribbon, do typical tasks to create a presentation, use the interactive galleries, and use the new XML file format. The second one is a tutorial article that helps you understand how to use the new user interface and find familiar features in PowerPoint 2007. The third one is a Powerpoint 2007 tutorial that shows you how to create and use the new presentation templates. The fourth a spreadsheet that maps all PowerPoint 2003 menu and toobar items to PowerPoint 2007's ribbon interface.


1) Free PowerPoint 2007 Online Course: Up to Speed with PowerPoint 2007

After completing this course you will be able to:

• Approach the new user interface with confidence and an understanding of how it works.
• Do the things you typically do to create and prepare a presentation.
• Use the new file format in PowerPoint in the way that's best for you.

This course includes:

• Three self-paced lessons and two practice sessions for hands-on experience. Practices require PowerPoint 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

PowerPoint 2007 Course Contents:

Get your Bearings: What's Changed and Why

• The Ribbon
• The tabs: Devoted to main tasks
• Display the galleries
• Use advanced options
• The Quick Access Toolbar
• Changing views
• Keyboard shortcuts
• Practice
• Test yourself

Get to Work in PowerPoint

• Start a new presentation
• Choose a theme
• Tailor the theme
• Add slides, pick layouts
• Insert a picture
• Insert a text box caption
• Insert an org chart
• Apply a simple animation
• Set up the show, check spelling, review
• Print, distribute, and set program options
• Practice
• Test yourself

A New File Format

• Benefits of the new format
• What the new file format looks like
• Opening a PowerPoint 2007 presentation in an earlier PowerPoint version
• Opening and saving existing presentations
• Saving in the old format
• Automatic upgrades in older presentations
• The Convert command for quick conversion
• Test yourself
• Feedback

Quick Reference Card


2) Reference: Locations of PowerPoint 2003 Commands in PowerPoint 2007

Learn about the elements of the new Microsoft Office Fluent user interface in Microsoft Office PowerPoint 2007. This also shows you PowerPoint 2003 commands that perform the same tasks in PowerPoint 2007.

• Introducing the new interface
• Adding commands to the Quick Access Toolbar
• New locations of familiar commands

3) PowerPoint 2007: Get Started with New Templates

This tutorial presents some of the improvements in PowerPoint 2007, and specifically takes you through creating and using New Templates, SmartArt, New Layouts, and Charts.

Pages 2 and 3:

1. PowerPoint 2007: Get Started with New Templates
2. SmartArt, New Layouts and Charts, and More

4) PowerPoint 2007 Ribbon Mapping Workbook

This spreadsheet maps all of the menu and toolbar features and options in PowerPoint 2003 to the equivalent in PowerPoint 2007 for each of the following:

• File menu
• Edit menu
• View menu
• Insert menu
• Format menu
• Tools menu
• Slide Show menu
• Window menu
• Help menu
• Standard toolbar
• Formatting toolbar
• Picture toolbar
• Reviewing toolbar
• Web toolbar
• Organization Chart toolbar
• Slide Master View toolbar
• Diagram toolbar
• Drawing toolbar
• Tables and Borders toolbar
• 3-D Settings toolbar
• Print Preview toolbar
• WordArt toolbar
• Drawing Canvas toolbar
• Shadow Settings toolbar
• Control Toolbox toolbar
• Visual Basic toolbar
• Outlining toolbar
• Slide Sorter
• Handout Master View
• Grayscale View
• Ink Drawing and Writing
• Ink Annotations
• Rehearsal
• System
• Online Meeting

Microsoft has made many modifications to the user interface for all Office 2007 applications, and that means relearning how to use most Excel features in Excel 2007. All menus and toolbars have been replaced with a new "Ribbon" interface and Tabs. These Ribbon and Tabs are located horizontally across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Excel 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Excel 2003 commands in Excel 2007. The third learning resource is a 3 page Excel 2007 Charting tutorial. The fourth document is a spreadsheet that maps all Excel 2003 menu and toobar items to Excel 2007's ribbon interface.


1) Free Excel 2007 Online Course: Up to Speed with Excel 2007

Learn how to use the new user interface of Microsoft Excel 2007, and find out how to do the everyday tasks that you normally do in Excel.

Length: 30–40 minutes

Course Goals:

• Get a handle on the new look of Excel.
• Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum.
• Save workbooks in the new Excel file formats.

This course includes:

• Three self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

Excel 2007 Course Contents:

Overview

What's changed, and why

• What's on the Ribbon?
• More commands, but only when you need them
• More options, if you need them
• Put commands on your own toolbar
• What about my favorite keyboard shortcuts?
• A new view
• Different screen resolutions can change what you see
• Practice
• Test yourself

Get to work in Excel

• Open your file
• Insert a column
• Format and edit data
• Enter a formula
• Add headers and footers
• Print
• The New Workbook window
• Practice
• Test yourself

A new file format

• How do I work with people who don't have Excel 2007 yet?
• Benefits of the new format
• New file formats, new options when you save
• Test yourself

Feedback

Quick Reference Card


2) Reference: Locations of Excel 2003 commands in Excel 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Excel 2007. It also shows you commands which you may already know how to use in Microsoft Excel 2003, and explains how to do the same tasks or features in Excel 2007.

• Introducing the new interface
• Adding commands to the Quick Access Toolbar
• New locations of familiar commands

3) Excel 2007 Tips for Creating Functional and Attractive Charts

This article explains the Top Ten Tips and Tricks for Excel 2007 Charts. Excel charts have been given a makeover in Excel 2007 and the Chart Wizard of earlier versions is now gone. Find out how to create functional and attractive charts using Excel 2007.

Excel Charting Tips - Pages 2 and 3:

• Top Ten Tips and Tricks for Excel 2007 Charts
• More Tips and Tricks for Creating Excel 2007 Charts

4) Excel 2007 Ribbon Mapping from Excel 2003

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Excel 2003 to the equivalent in Excel 2007 for each of the following:

• Standard toolbar
• Formatting toolbar
• PivotTable toolbar
• Chart Toolbar toolbar
• Reviewing
• Forms
• Stop Recording
• External Data
• Formula Auditing
• Circular Reference
• Visual Basic
• Web
• Control Toolbox
• Exit Design Mode
• Watch Window
• Borders
• Protection
• Text to Speech
• List
• Compare Side by Side
• Drawing toolbar
• WordArt
• Pictures
• Organization Chart
• Diagram
• Ink Drawing and Writing
• Ink Annotations
• Shadow Settings
• 3D Settings
• File Menu
• Edit Menu
• View Menu
• Insert Menu
• Format Menu
• Tools Menu
• Data Menu
• Chart Menu
• Windows Menu
• Help Menu

Microsoft has made huge changes to the user interface for all of the applications in Office 2007, including Word 2007. It has replaced all menus and toolbars with a new "Ribbon" interface, along with Tabs. The Ribbon and Tabs are positioned across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Word 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Word 2003 commands in Word 2007. The third learning resource is a 3 page Word 2007 tutorial article that reviews Word's new features and user interface. The fourth document is a spreadsheet that maps all of Word 2003 menu and toobar items to the Word 2007 ribbon or interface.


1) Free Word 2007 Online Course: Up to Speed with Word 2007

Course length: 30–40 minutes

After completing this course you will be able to:

• Work with the Ribbon — the new feature that makes Word easier than ever before.
• Find everyday, common commands you need to do your job.
• Use the new file format for Word in the way that's best for you.

This course includes:

• Three self-paced lessons and two practice sessions for hands-on experience. Practices require Word 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course. 

Course Contents:

Overview

Get to Know the Ribbon

• The Ribbon in action
• What's on the Ribbon?
• Dialog box launchers in groups
• Additional tabs appear
• The Mini toolbar
• The Quick Access Toolbar
• Temporarily hide the Ribbon
• Use the keyboard
• Practice
• Test yourself

Find Everyday Commands

• Start with the Microsoft Office Button
• Bullets, numbers, and more
• What about styles?
• The Format Painter
• Insert pictures, hyperlinks, headers and footers
• Zoom
• Check your spelling and grammar
• Ready to print?
• Yes, ready to print
• Behind the scenes
• Practice
• Test yourself

A New File Format

• Why the change? XML
• Why the change? New features
• How do I know I'm using the new format?
• There's more than one file format?
• What about the documents I already have?
• Compatibility mode
• Converting your old files
• Share documents between versions by using a converter
• Sharing documents between versions by saving with an older format
• Test yourself

Feedback

Quick Reference Card

2) Reference: Locations of Word 2003 Commands in Word 2007

This tutorial article explains and demonstrates elements of the new Microsoft Office Fluent user interface in Microsoft Word 2007. It also provides lists of commands that you may already be familiar with in Word 2003, showing you how to perform the same feature or function in Word 2007.

• Introducing the new interface
• Adding commands to the Quick Access Toolbar
• New locations of familiar commands

3) New Features in Word 2007

Word New Features - Pages 2 and 3:

1. New Features in Word 2007
2. Radically New Look for Word 2007

4) Word 2007 Ribbon Mapping from Word 2003

This is an spreadsheet (.xls) that will help you become familiar with the menu and toolbar options in Word 2007. It maps all of the menu and toolbar features and options in Word 2003 to the equivalent in Word 2007 for each of the following:

• File menu
• Edit menu
• View menu
• Insert menu
• Format menu
• Tools menu
• Table menu
• Window menu
• Help menu
• Standard toolbar
• Formatting toolbar
• AutoText toolbar
• Control Toolbox toolbar
• Database toolbar
• Drawing toolbar
• E-mail toolbar
• Extended Formatting toolbar
• Forms toolbar
• Frames toolbar
• Function Key Display toolbar
• Ink Annotations
• Ink Drawing and Writing toolbar
• Mail Merge toolbar
• Outlining toolbar
• Picture toolbar
• Reviewing toolbar
• Tables and Borders toolbar
• Visual Basic toolbar
• Web toolbar
• Web Tools toolbar
• Word Count toolbar
• WordArt toolbar
• 3-D Settings toolbar
• Shadow Settings toolbar
• Drawing Canvas toolbar
• Organization Chart toolbar
• Diagram toolbar
• Header and Footer toolbar
• Full Screen toolbar
• Stop Recording toolbar
• Microsoft toolbar
• Print Preview toolbar
• AutoSummarize toolbar
• Exit Design Mode toolbar
• Text Box toolbar
• Refresh toolbar
• Reading Layout toolbar
• Compare Side by Side toolbar
• System toolbar
• Online Meeting toolbar

Here is a PowerPoint 2000 Tutorial from the Community College of Rhode Island, describing step-by-step how to perform the following PowerPoint functionality: Basic Presentation Skills, Using the Outline Pane, Editing Presentation Text, Printing, Sending, and Publishing, Graphic Images and Tables, and the Slide Show View. These tutorial lessons can also be used to learn most of the PowerPoint features in PowerPoint XP and PowerPoint 2003.


Contents of PowerPoint Tutorial Lessons:

Lesson 1 - Exploring PowerPoint

• Starting PowerPoint 
• Creating a Blank Presentation 
• Selecting an AutoLayout 
• Using PowerPoint Windows 
• Using Menu Commands 
• Displaying and Hiding Toolbars 
• Displaying Hidden Toolbar Buttons 
• Moving and Resizing Toolbars 
• Changing Menu and Toolbar Options 
• Exiting PowerPoint 
• Exercise 
• Exploring PowerPoint 

Lesson 2 - Using Basic Presentation Skills

• Entering Text into a Presentation 
• Saving a New Presentation 
• Closing a Presentation 
• Opening an Existing Presentation 
• Adding a New Slide 
• Renaming an Existing Presentation 
• Creating a New Presentation 
• Selecting a Design Template 
• Using Content Templates 
• Navigating Slides 
• Switching Views 
• Using Normal View 
• Changing the Magnification 
• Changing the Slide Layout 
• Changing the Design Template 
• Using the AutoContent Wizard 
• Exercise 
• Using Basic Presentation Skills 

Lesson 3 - Using the Outline Pane

• Working with the Outline Pane 
• Creating a Bulleted List 
• Collapsing and Expanding Slides 
• Demoting and Promoting Text Lines 
• Moving Text Lines 
• Adding Slides in the Outline Pane 
• Deleting Slides from the Outline Pane 
• Rearranging Slides in the Outline Pane 
• Creating a Summary Slide 
• Exercise 
• Using the Outline Pane 

Lesson 4 - Enhancing Presentation Text

• Changing the Font 
• Changing the Font Size 
• Changing Font Style and Effect 
• Changing Text Alignment 
• Adding and Removing Bullets 
• Creating a Numbered List 
• Modifying Bullets and Numbers 
• Modifying Paragraph Spacing 
• Exercise 
• Enhancing Presentation Text 

Lesson 5 - Printing, Sending, and Publishing

• Printing Presentations 
• Selecting Page Setup Options 
• Printing Slides 
• Printing Outlines 
• Printing Speaker Notes 
• Printing Handouts 
• Sending a Presentation via E-mail 
• Publishing a Presentation to the Web 
• Exercise 
• Printing, Sending, and Publishing 

Lesson 6 - Using Graphic Images and Tables

• Working with Graphics 
• Using the Clip Gallery 
• Inserting Clip Art Images 
• Using Clip Art Keywords 
• Inserting a Picture 
• Cropping a Picture 
• Moving a Graphic 
• Resizing a Graphic 
• Formatting a Graphic 
• Recoloring Clip Art Images 
• Creating a Table 
• Exercise 
• Using Graphic Images and Tables 

Lesson 7 - Using Slide Show View

• Running a Slide Show 
• Navigating a Slide Show 
• Setting Slide Transitions 
• Animating Text and Objects 
• Adding a Note to a Slide 
• Adding Speaker Notes 
• Using the Pen Tool to Annotate 
• Changing the Pen Tool Color 
• Adding Action Items 
• Exercise 
• Using Slide Show View

Here is a step-by-step Outlook 2000 Tutorial  from the Community College of Rhode Island, describing how to perform these activities in Outlook: Outlook Basics, Using Outlook Messaging, Managing Messages, Components and Office, Outlook Messaging Features, Scheduling with the Calendar, Managing Contacts, Working with Tasks, The  Journal, Notes, and Organizing Outlook Items. These tutorial lessons can also be used to learn many of these Outlook features in Outlook XP and Outlook 2003.


Contents of Outlook Tutorial Lessons:

Lesson 1 - Working with Outlook Basics

• Starting Outlook 
• Using the Outlook Interface 
• Displaying or Hiding a Toolbar 
• Using the Outlook Bar 
• Using the Outlook Today Page 
• Using the Folder List 
• Exiting Outlook 

Lesson 2 - Working with The Office Assistant

• Using the Office Assistant 
• Finding an Answer 
• Hiding/Displaying the Office Assistant 
• Changing Office Assistant Options 

Lesson 3 - Using Outlook Messaging

• Using Outlook's E-mail Features 
• Sending a Message 
• Using the Address Book - Message Window 
• Changing Mail Folder Views 
• Opening a Message in the Inbox Folder 
• Sending and Receiving Messages 
• Viewing Sent Messages 
• Replying to a Message 
• Forwarding a Message 
• Printing from the Information Viewer 
• Printing from the Message Window 

Lesson 4 - Managing Messages

• Saving a Draft Version of a Message 
• Flagging a Message for Follow Up 
• Navigating through Open Messages 
• Changing the Read Status of a Message 
• Sorting Mail Messages 
• Deleting a Message 
• Moving a Message to a Different Folder 
• Emptying the Deleted Items Folder 
• Archiving a Folder 

Lesson 5 - Working with Components and Office

• Creating an AutoSignature 
• Selecting a Default AutoSignature 
• Inserting an AutoSignature 
• Inserting a File into a Message 
• Saving a File Attachment 
• Opening a File Attachment 
• Inserting a Hyperlink into a Message 
• Creating and using Office Documents 
• Using the Office Clipboard 

Lesson 6 - Using Outlook Messaging Features

• Setting Message Tracking Options 
• Viewing the Message Delivery Status 
• Recalling a Message 
• Creating a Message with Voting Buttons 
• Responding to a Voting Message 
• Tracking Votes 
• Creating a Template 
• Creating a New Message from a Template 
• Deleting a Template 
• Using Remote Mail 

Lesson 7 - Scheduling with the Calendar

• Opening the Calendar
• Navigating the Calendar
• Scheduling a New Appointment
• Using AutoDate
• Scheduling an Event
• Scheduling a Meeting
• Responding to a Meeting
• Checking Meeting Responses
• Adding a Task to the TaskPad
• Editing Calendar Items
• Setting a Calendar Item as Recurring
• Changing the Calendar View
• Moving Calendar Items
• Printing Calendar Information
• Saving a Calendar as a Web Page
• Deleting Calendar Items

Lesson 8 - Managing Contacts

• Opening the Contacts Folder 
• Adding a Contact 
• Adding Same Company Contacts 
• Changing the Contacts View 
• Editing a Contact 
• Flagging a Contact for Follow-up 
• Dialing Contacts 
• Sending a New Message to a Contact 
• Organizing Contacts Meetings 
• Exploring a Contact's Web Page 
• Assigning a Task to a Contact 
• Printing Contacts Information 
• Deleting a Contact 

Lesson 9 - Working with Tasks

• Opening the Tasks Folder 
• Adding a Task 
• Creating a Recurring Task 
• Editing a Task 
• Marking a Task Complete 
• Sorting and Reordering Tasks 
• Assigning a Task to Another Outlook User 
• Accepting/Declining Tasks 
• Indicating the Progress of a Task 
• Sending a Status Report 
• Changing the Tasks View 
• Printing Tasks Information 
• Deleting a Task 

Lesson 10 - Using Journal

• Opening the Journal Folder 
• Adding a Journal Entry 
• Viewing Journal Entries 
• Changing the Journal View 
• Opening a Journal Entry 
• Printing a Journal Entry 
• Deleting a Journal Entry 

Lesson 11 - Using Notes

• Opening the Notes Folder 
• Creating a Note 
• Assigning a Color to a Note 
• Changing the Notes View 
• Opening a Note 
• Printing a Note 
• Deleting a Note 

Lesson 12 - Organizing Outlook Items

• Assigning an Outlook Item to a Category 
• Modifying the Master Category List 
• Creating a New Folder 
• Deleting a Folder 
• Using a Simple Find 
• Using an Advanced Find 
• Using the Ways to Organize Pane 
• Using AutoCreate 
• Inserting an Outlook Item into a Message