Office 2003 Training Tutorials and Documentation



	ITS Home


	Our Departments


		Applications


		Operations


		Networking


		Learning Technologies



		Distance Learning



		Computer Based Testing



		Help Desk



		Software Training



		ZipLine



		Computer Store



		Telecommunications

SOFTWARE TRAINING AND TECHNOLOGICAL SERVICES

OFFICE 2003 TRAINING MATERIALS

Office 2003 Documentation

The following manuals are all available in Adobe Acrobat .PDF format. Once you click on a manual, use the browser's BACK button to return to this page.

If you are going to print a manual, please set your printer to double-sided (if possible).

For assistance with an Office 2003 topic not listed in any of the manuals provided, please contact PStrain@uakron.edu

NOTE: For information on training for the Microsoft Office Specialist (MOS) training offered by Software Training Services, please visit our MOS Training Web Page.

Office 2003 General
Outlook 2003
Word 2003
Excel 2003
PowerPoint 2003
Access 2003

Office 2003 General

Name	Last Revised	Comments
Office 2003 Upgrade Overview	03/09/2005	25 Pages. This document provides a summary of the changes from Office XP to Office 2003. Important information is provided on configuring Excel in order to download from PeopleSoft Financials into Microsoft Excel.

Outlook 2003

Name	Last Revised	Comments
Accessing Outlook 2003 from the Web	10/17/2005	15 pages. Effective August 14, 2005, The University of Akron has a new mail server for Outlook which will affect appearances in the Web Access view (when mail is accessed away from the user’s local computer via the Internet). This manual identifies known changes in the Web Access view or which may allow user changes at the local computer.
Outlook 2003 Update	04/05/2005	95 pages. The Outlook 2003 Update manual provides an overview of the changes to the application with regard to its appearance, sending, receiving, and managing e-mail, and the new features available in Calendar.
Outlook 2003 Mail - Full Manual	10/17/2005	147 pages. The following topics are covered in this manual: contacts, distribution lists, global address lists, personal folders, creating, addressing and sending messages, receiving messages and attachments, organizing e-mail, accessing e-mail from the Web, and e-mail quotas.
Out-of-Office Assistant	3/18/2005	3 pages. Learn how to set up the out-of-office assistant to notify senders when you are not in the office and unable to receive and answer e-mail.
Personal Folders	11/02/2006	4 pages. Learn how to create Personal Folders.
Automatically Backing Up Your Outlook Mail Personal Folders	11/03/2006	10 pages. Step-by-step instructions on using an automatic backup for Personal Folders (PST files).
Exporting Excel Data into Contacts	5/5/2005	13 pages. Learn how to create a separate Contact folder, export selected Excel data into this folder, and create a specialized Distribution List for these contacts.
Exporting Contacts from Outlook to Excel	5/5/2005	4 pages. Learn how to take Contacts from Outlook and create an Excel spreadsheet file.
Outlook Calendar 2003	04/01/2005	66 pages. The Outlook Calendar 2003 manual introduces basic navigation and focuses on the different methods of scheduling time and resources.
Turning Off Cached Mode	7/21/2006	4 pages. Step-by-step instructions on how to turn OFF cached mode in Outlook 2003.

Word 2003

Name	Last Revised	Comments
Word 2003 Intro PDF	9/27/2005	The manual is 23 pages in length and provides an overview of Microsoft Word, including how to use the menus and toolbars, task panes, essential Word terminology, and navigation within Word. The manual also covers most options found under the File menu. The documentation includes, for each topic, new terminology, reasons to use the option, step by step instructions, as well as alternative methods to completing the task.
Mail Merge PDF Mail Merge Labels Tutorial Mail Merge Letter Tutorial	3/14/2005	on using the Mail Merge function in Word 2003. Instructions are provided for producing labels, envelopes, and letters via a Mail Merge. In addition, instructions for conducting a Mail Merge to Outlook email are provided. The Appendix provides solutions to common mail merge problems including: formatting problems (currency, percentages, phone numbers, etc.), using a mail merge document from Word 2000, and problems associated with previewing labels or letters (appears there are too many labels or letters or that recipeints are repeating). Each of the tutorials takes approximately 10 minutes to complete.
Word 2003 File Menu PDF	9/27/2005	The manual is 20 pages in length and provides an overview of the File menu in Word 2003.
Word 2003 Edit Menu PDF	9/27/2005	The manual is 16 pages in length and provides an overview of the Edit menu.
Word 2003 Format Menu PDF	9/27/2005	The manual is 44 pages in length and provides an overview of the Format menu.
Word 2003 Insert Menu PDF	9/27/2005	The manual is 62 pages in length and provides an overview of the Insert menu.
Word 2003 Table Menu PDF	9/27/2005	The manual is 37 pages in length and provides an overview of the Table menu.
Word 2003 Tools Menu PDF	9/27/2005	The manual is 40 pages in length and provides an overview of the Tools menu.
Word 2003 View Menu PDF	9/27/2005	The manual is 40 pages in length and provides an overview of the View menu.
Word 2003 Window Menu PDF	9/27/2005	The manual is 40 pages in length and provides an overview of the Window menu.
Word 2003 Revision Tools PDF	6/26/2006	The manual is 35 pages in length. Topics include: Saving Versions of the Document, Comments, Tracking Changes, and Comparing Documents.

Excel 2003

Name	Last Revised	Comments
Excel Step 1: Utilizing Successful Worksheet Strategies	3/09/2005	45 pages. This manual covers the following topics: entering and editing data; creating a list using the new Create List command; sorting, maintaining, and manipulating lists; and importing PeopleSoft query data results.
Excel Step 2: Implementing Formulas and Functions	3/11/2005	24 pages. This manual covers the following topics: creating formulas, logic statements, using multiple worksheets, and exchanging data between Word and Excel.
Excel Step 3: Creating Professional Looking Worksheets	3/11/2005	35 pages. This manual covers the following topics: formatting the worksheet, utlizing special effects, headers and footers, and managing the print function.
Excel Step 4: Advanced Design	3/11/2005	34 pages. This manual provides step-by-step instructions on the following topics: Named Ranges, Page Breaks, Comments, Tracking Changes, Protecting, and Sharing.
Using and Printing Large Worksheets in Excel - Quick Guide	4/14/2004	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.
Using Excel Formulas and Functions - Quick Guide	5/4/2004	2 pages. This is a quick reference guide for working with formulas and functions in Excel.

PowerPoint 2003

Name	Last Revised	Comments
PowerPoint Step 1: Creating and Editing a Presentation	5/17/2005	26 pages. The following topics are covered in this manual: panes and views, auto content wizard, design templates, arranging slides, slide masters, handouts, and speaker notes.
PowerPoint Step 2: Incorporating Visual Elements and Transitions	5/17/2005	19 pages. The following topics are covered in this manual: clip art, data charts, organization charts, and transitions.
PowerPoint for Students	10/10/2005	40 pages. This manual contains step-by-step instructions to assist students with creating PowerPoint presentations for class assignments. Topics include creating and editing a presentation, adding clip art and data charts, adding transitions, annd printing handouts and speaker notes.
PowerPoint Packaging to CD	1/20/2006	6 pages. Step-by-step instructions to package a PowerPoint presentation with all fonts and files (including video or audio clips) for transfer to a CD or other storage medium. Instructions on how to run the packaged presentation using PowerPoint Viewer or to open the presentation with PowerPoint on another computer are included.

Access 2003

Name	Last Revised	Comments
Access Step 1: Overview and Tables	4/05/2005	63 pages. The following topics are covered: Designing and editing related tables; entering, filtering and locating data in the tables.
Access Step 2: Forms and Basic Queries	3/30/2005	41 pages. The following topics are covered: Creating forms for existing tables; entering and editing data through the form; creating, running, deleting, and changing select queries.
Access Step 3: More Queries	4/12/2005	33 pages. The following topics are covered: Using criteria and wildcards in a query; joining tables;other types of queries (update, append, make table, parameter).
Access Step 4: Reports and Sharing Data with Other Applications	5/02/2005	43 pages. The following topics are covered: Creating and modifying basic reports; mailing labels; exporting to Excel; merging with a Word document; and importing data from an Excel spreadsheet.
Access Step 5: Advanced Queries	5/06/2005	47 pages. The following topics are covered: Calculating in a query; concatenating fields (like LastName, FirstName); cross Tab queries; inner and outer joins; and complex criteria.