This course provides information about the new user interface designed for the Microsoft Office 2007 applications.

• List and describe the features of the new Office 2007 user interface
• Change application settings in Office 2007 products
• Use the Live Preview feature

• Why the big change?
• The Ribbon: Command tabs and contextual tabs
• The Ribbon: The Office menu
• Galleries and live preview
• Other new interface features

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of the new features in Microsoft Office Word 2007.

• Identify features of the new Word 2007 user interface
• Insert building blocks, references, and other elements into a Word 2007 document
• Use the features of the Page Layout tab
• Compare documents using the new tri-pane review panel
• Finalize a Word 2007 document

• The new look of Word 2007
• Building blocks
• Inserting elements
• Working with themes
• Adding references
• Viewing documents
• Comparing documents
• Completing documents

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of the new features in Microsoft Office Excel 2007.

• Identify features of the new Excel 2007 user interface
• Convert Excel data into table format
• Use Excel 2007's Formula AutoComplete feature
• Analyze data in Excel 2007 using conditional formatting
• Create professional looking reports
• Insert and format charts
• Work with PivotTables and PivotCharts

• The new look of Excel 2007
• Using the workbook
• Creating and formatting tables
• Formula features
• Analyzing data using conditional formatting
• Creating reports
• Creating charts
• Creating PivotTables and PivotCharts

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of the new features in Microsoft Office PowerPoint 2007. It shows you how to create tables and charts, apply themes and effects, set presentation options, and finalize a presentation.

• Create diagrams, tables, and charts
• Apply themes to your presentations
• Set presentation options
• Use the Slide Library
• Finalize a presentation

• The new look
• Diagrams, tables, and charts
• Themes
• Effects
• Presentation options
• The Slide Library
• Finalizing a presentation

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of the new features in Microsoft Office Access 2007.

• Navigate Access using the Ribbon, Office Menu, and Navigation Pane
• Create a database
• Create new forms
• Filter the data in a table
• Generate reports from a table
• Migrate database objects to SQL Server and Windows SharePoint Services

• The new look
• Creating a database
• Importing data
• Filtering data
• Creating reports
• Upsizing and moving data

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of the new features in Microsoft Office Outlook 2007.

• Navigate Outlook using the To-Do Bar, a tabbed messaging window, and the Office menu
• Set up an e-mail account
• Search mail messages, calendars, and contacts
• Use color categories and flags to organize and prioritize messages and contacts
• Subscribe to RSS feeds
• Set e-mail security options

• The new look
• Setting up e-mail accounts
• Instant Search
• Setting up color categories
• Adding RSS feeds
• Defining messages as tasks
• Using the calendar
• Protecting yourself

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

This course provides an overview of common tasks in Microsoft Office 2007. After taking this course, learners will be able to perform basic document management, publishing, and editing tasks.

• Create, save, open and close documents
• Print documents
• Prepare documents
• Send and publish documents
• Perform basic editing tasks and check spelling and grammar
• Search for help in Office 2007

• Creating documents
• Saving, opening and closing documents
• Printing documents
• Preparing documents
• Sending and publishing documents
• Basic editing tasks
• Checking spelling and grammar
• Getting help

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.