The eLearning Center for Gatlin Education Services

The new Office package is changing the old interface with new features on an interface now known as the Ribbon. How do you find the commands you already know? What new commands are available in Word, Excel, Outlook, PowerPoint, and Access? Take a look at the changes in Office 2007 and learn how to make the most of them.

Navigating the New Interface
Time: 2.0 hour(s)
Summary:
This course provides information about the new user interface designed for the Microsoft Office 2007 applications.
Objectives:
* List and describe the features of the new Office 2007 user interface.
* Change application settings in Office 2007 products.
* Use the Live Preview feature.
Topics:
* Why the big change?
* The Ribbon: Command tabs and contextual tabs
* The Ribbon: The Office menu
* Galleries and live preview
* Other new interface features

What''s New in Word
Time: 3.0 hour(s)
Summary:
This course provides an overview of the new features in Microsoft Office Word 2007.
Objectives:
* 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.
Topics:
* The new look of Word 2007
* Building blocks
* Inserting elements
* Working with themes
* Adding references
* Viewing documents
* Comparing documents
* Completing documents

What's New in Excel
Time: 3.0 hour(s)
Summary:
This course provides an overview of the new features in Microsoft Office Excel 2007.
Objectives:
* 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.
Topics:
* 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

What's New in PowerPoint
Time: 2.0 hour(s)
Summary:
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.
Objectives:
* Create diagrams, tables, and charts.
* Apply themes to your presentations.
* Set presentation options.
* Use the Slide Library.
* Finalize a presentation.
Topics:
* The new look
* Diagrams, tables, and charts
* Themes
* Effects
* Presentation options
* The Slide Library
* Finalizing a presentation

What's New in Access
Time: 2.0 hour(s)
Summary:
This course provides an overview of the new features in Microsoft Office Access 2007.
Objectives:
* 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.
Topics:
* The new look
* Creating a database
* Importing data
* Filtering data
* Creating reports
* Upsizing and moving data

What's New in Outlook
Time: 2.0 hour(s)
Summary:
This course provides an overview of the new features in Microsoft Office Outlook 2007.
Objectives:
* 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.
Topics:
* 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

Common Tasks
Time: 3.0 hour(s)
Summary:
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.
Objectives:
* 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.
Topics:
* Creating documents
* Saving, opening and closing documents
* Printing documents
* Preparing documents
* Sending and publishing documents
* Basic editing tasks
* Checking spelling and grammar
* Getting help