Office 2007 Training Materials



	ITS Home


	Our Departments


		Applications


		Operations


		Networking


		Learning Technologies



		Distance Learning



		Computer Based Testing



		Help Desk



		Software Training



		ZipLine



		Computer Store



		Telecommunications

Office 2007 Training Materials

Office 2007 Training

During the Summer 2007 term, the 2007 version of Microsoft® Office will be available to the campus. At that time, it will be a voluntary installation. There is a significant difference between Office 2003 and Office 2007, so training is recommended. To familiarize yourself with the differences, take the Office 2007 Overview class.

The Office 2007 Overview class is web-based and self-paced. This class may be taken without loading Office 2007 on your computer. This class is a prerequisite for all the other Office 2007 classes.

Faculty, Staff, and Students: More tutorials on Office 2007 are available via Atomic Learning. To access Atomic Learning log in to ZipLine and then click the Atomic Learning link on the Faculty/Staff (or Student) tab.

Documentation/Tutorials:

Office 2007 Overview
Outlook 2007
Word 2007
Excel 2007
PowerPoint - Coming Soon
Publisher - Coming Soon
Access 2007

Office 2007 Overview

Microsoft has modified the Office 2007 programs to make it easier to locate the commands for the work that you want to accomplish. These changes in the interface will require adjustments to the way you do things. This course will allow you to review some of the major changes in Office 2007 and to experiment with the new screen elements.

The most noticeable change is the absence of the familiar menus and toolbars, which are replaced by a new element called the Ribbon.

View the following lessons to guide you through the change. You do not need Office 2007 to do these lessons. Each of the four lessons is in PDF format for viewing and printing. Lesson 1 has two videos that are accessed within the lesson and highlight the main tasks in the lesson. There are also two interactive Activities that may be done at any time, though it is recommended that you do these after Lesson 4.

Overview Tutorials

Title	Date	Comments
Lesson 1: Introduction to the New Interface (PDF - includes links to tutorials) Lesson 1: Exercise 1 - 3 Tutorial Lesson 1: Exercise 4 - 6 Tutorial	5/22/2007	Lesson 1 consists of the following six exercises: - Exercise 1: The New Elements - Exercise 2: Use the Office button and Quick Access toolbar - Exercise 3: Use the Ribbon - Exercise 4: View Tools and Zoom Slider - Exercise 5: Mini Toolbar and Help - Exercise 6: Preview the User Interface in Each Office Program.
Lesson 2: Prepare to Work with Office2007	5/22/2007	Lesson 2 consists of the following four exercises: - Exercise 1: New File Formats - Exercise 2: New Commands - Exercise 3: Keyboard Shortcuts - Exercise 4: System Requirements
Lesson 3: Preview New Features of Office 2007 Programs	5/22/2007	Lesson 3 consists of the following five exercises: - Exercise 1: Word - Exercise 2: Excel - Exercise 3: Outlook - Exercise 4: PowerPoint - Exercise 5: Access
Lesson 4: To Begin - Customize Office	5/22/2007	Lesson 4 consists of the following two exercises: - Exercise 1: Customizations that Affect All the Office Programs - Exercise 2: Customizations that Affect Only the Active Office Program
Activity 1 Activity 2	5/22/2007	The Activities are available to provide additional practice with Office 2007. Each activity is 5 minutes in length. *Office 2007 is not needed to complete the activities.*

Outlook 2007

Title	Date	Comments
Outlook 2007 for Experienced Users manual	03/25/2008	51 pages. This course is for current Outlook 2003 users and will introduce some of the changes from Outlook 2003 to Outlook 2007. Topics reviewed are the Outlook 2007 mail interface, creating new messages, distribution lists, opening messages, Outlook 2007 calendar interface, sharing, events, appointments, meetings, Outlook 2007 Contacts, and Outlook 2007 Tasks.
Outlook Mail 2007 for New Users manual	03/12/2008	112 pages. This course is for new Outlook users and will cover the following topics: mail interface, viewing mail, creating messages, opening messages, distribution lists, creating rules, maintenance, delegates, contacts, and tasks.
Outlook 2007 via the Web - manual	3/25/2008	7 pages. This document provides step-by-step instruction on accessing your Outlook e-mail via the Internet.
Outlook 2007 Mail Maintenance	03/12/2008	27 pages. This manual is an excerpt from the full Outlook 2007 Mail for New Users manual. This manual covers mail processes that are helpful in overall maintenance of Outlook 2007. The following topics are covered: mailbox cleanup, deleting mail, removing attachments, creating spam filters, creating personal folders, and backing up personal folders.
Outlook Calendar 2007 for New Users manual	04/01/2008	63 pages. This course is for new Outlook calendar users. The following topics are covered: the calendar interface, events, appointments, meetings, sharing your calendar, creating calendar items from email messages, and accessing the calendar from the web.

Word 2007

Title	Date	Comments
Word 2007 for Experienced Users manual	06/11/2007	82 pages. This course is for current users of Word 2007 and will introduce some of the changes from Word 2003 to Word 2007. Topics reviewed are new documents, open, save, customizing, character formatting, quick styles, numbers and bullets, cut, copy, paste, spelling and grammar, thesaurus, headers and footers, alignments, paragraph and line spacing, page layout, indents and tabs, printing, envelopes and labels, clip art, and building blocks. PREREQUISITE: Overview of Microsoft Office 2007
Creating a PDF File in Word 2007	06/14/2007	5 pages. Instructions for saving Word data in PDF so it can be viewed in Adobe Reader.
Find a Command in Word 2007 - A Job Aid	06/19/2007	3 pages. Use this job aid to lookup the Word 2003 command and have it translated to the Word 2007 command.
Word 2007 Mail Merge (PDF)	05/21/2008	44 pages. This course is for current users of Word 2007 that need instructions on how to complete a Mail Merge. Topics reviewed are Mail Merge Overview, Opening the Mail Merge Wizard, Creating Mail Merge Labels & Envelopes, Creating a Mail Merge Letter, and Merging with Outlook Mail. PREREQUISITE: Overview of Microsoft Office 2007.
Themes in Word 2007	06/14/2007	3 pages. Instructions for using the NEW Word 2007 feature, Themes.
SmartArt in Word 2007	06/14/2007	4 pages. Instructions for using the NEW Word 2007 feature, SmartArt.
New Defaults in Word 2007	10/09/2007	1 page. Quick reference sheet which compares the five new defaults between Word 2003 and 2007. The document also provides instructions on changing the defaults.
Creating Documents 101 in Word 2007	5/14/2008	90 pages. The following topics are covered: opening and saving documents; character formatting; cut, copy and paste; spacing; numbers and bullets; proofing; headers and footers; printing; and creating PDF files.
Creating Documents 102 in Word 2007	5/15/2008	57 pages. The following topics are covered: properties; spacing; columns; breaks; styles; table of contents; borders; shading; find and replace; building blocks; protecting documents; sending a document using Outlook; comparing and combining documents; and envelopes and labels.

Excel 2007

Title	Date	Comments
Excel 2007 For Experienced Users manual (PDF) Course Files: Lesson 1 - List file Lesson 2 - Tables File Lesson 3 - Formulas File	05/07/2007	51 pages. This course is for current users of Excel 2003 and will introduce some of the changes from Excel 2003 to Excel 2007. Topics reviewed are basic navigation and editing, creating tables (formerly called lists), entering formulas, formatting cells and creating headers and footers. Download the three Excel files used in the lessons. PREREQUISITE: Overview of Microsoft Office 2007
Creating a PDF File in Excel 2007	6/01/2007	7 pages. Instructions for saving Excel data in PDF so it can be viewed in Adobe Reader.
Printing and Using Large Worksheets in Excel 2007 - A Quick Reference Guide	6/01/2007	2 pages. This is a quick reference guide for working with large Excel spreadsheets. The following topics are included: freezing columns, deleting columns, changing the width of all columns, sorting data in lists, filtering a list, formatting multiple worksheets, printing gridlines, printing over and then down, printing field names as a Header row, printing row and column headings, and page numbering.
Find a Command in Excel 2007 - Job Aid	6/01/2007	4 pages. Use this job aid to lookup the Excel 2003 command and have it translated to the Excel 2007 command.
Common Functions in Excel 2007 - Job Aid	5/19/2008	2 pages. This quick guide shows the common functions, formulas, and sum function in Excel 2007.

Access 2007

Title	Date	Comments
Access 2007 for Experienced Users Course Files: Committees2007.accdb LearnUsa.accdb Import.xlsx	08/07/2007	This course is for current users of Access 2003 and will introduce some of the changes from Access 2003 to Access 2007. Topics reviewed are the new interface; the new format; working with database objects; creating databases, tables, forms, queries and reports; and security. Download the two Access databases and one Excel file that are used in the lessons. These class files require Access 2007 and Excel 2007. PREREQUISITE: Overview of Microsoft Office 2007