Microsoft Office Online Training and Demos for the 2007 Microsoft Office release

Training: Queries I: Get started with queries

Learn what Access 2007 queries are, what goes into them, and how to use them.

Watch this: Format numbers as percentages

See how to format numbers in Excel 2007as percentages and how to calculate those percentages first, if needed.

Watch this: Transpose data in Excel 2007

Watch this demo to see how Excel 2007 makes it easy to transpose data from rows to columns, and vice versa.

Training: Build relationships for a new Access 2007 database

Learn how to create relationships in Access 2007 to bring the data in your tables together.

Training: Create queries for a new Access 2007 database

Learn how to create queries in Access 2007 to extract data from your database, and to provide data for forms and reports.

Training: Create forms for a new Access 2007 database

Learn how to create forms in Access 2007 to help you enter data more accurately, provide a window into your data, and make your database look polished and professional.

Watch this: Delay sending e-mail messages

See how to delay the delivery of individual e-mail messages in Outlook 2007.

Watch this: Scroll to a task quickly

Watch this video to learn how to quickly scroll to a task in Project 2007.

Training: Office Open XML I: Exploring the Office Open XML Formats

Get an introduction to the XML structure behind your documents in the new Office Open XML Formats.

Watch this: Configure the Bug Database template

Keep track of bugs or other issues by using the Access 2007 Bugs Database template.

Watch this: Use the Bug Database template

See how to use some of the features of the Access 2007 Bugs Database template.

Training: Reduce spam! Get your Junk E-mail Filter in top condition

Learn how to use the Junk E-mail Filter in Outlook 2007 so that you have less junk e-mail and spend less time managing it.

Demo: Manage random information with OneNote Side Notes

Consider going without paper sticky notes! Side Notes in OneNote 2007 are electronic sticky notes that you can use for reminders, to-do lists, and other quick notes.

Demo: Set up a OneNote notebook

Learn how to set up a OneNote 2007 notebook divided into sections of as many pages as you need, and on each page you can type notes, copy files, record audio notes, paste screen clippings, and add hyperlinks

Demo: Take OneNote to class

OneNote makes it easy to take notes in class and do research on the Internet — all in one electronic notebook.

Watch this: Sort text or a list in Word 2007

Watch this video to see how to sort a list of items in Word 2007.

Training: PerformancePoint Monitoring and Analytics: Dashboard basics I

Curious about PerformancePoint Server? Learn some basics so that you can use a dashboard to monitor and analyze business performance, right from your company's SharePoint site.

Training: PerformancePoint Monitoring and Analytics: Dashboard basics II

Learn more PerformancePoint Server basics. See how to work with a dashboard so that you can use one to monitor and analyze the area of the business that's important to you.