Office XP Documentation/Manuals



	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 XP 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 XP topic not listed in any of the manuals please contact PStrain@uakron.edu

Office XP - General
Word XP
Word XP Tutorials
Excel XP
Access XP
PowerPoint XP

Office XP General

Name	Last Revised	Comments
Differences between Office 2000 and Office XP	9/19/2003	7 pages. This document provides a brief overview of the major changes from Office 2000 to Office XP. Changes are idenitifed for each of the products in the suite: Word, Excel, Access, PowerPoint, and Outlook. Please check back frequently for updates - the "Last Revised" column will be updated.

Word XP

Name	Last Revised	Comments
Word XP Step 1: Beginning Word	11/19/2003	57 pages. This manual covers the following topics: navigation, toolbars and menus, entering text, using the clipboard, find and replace command, checking spelling and grammar, fonts, point sizes, aligning text, margins, adjusting print settings, and printing.
Word XP Step 2: Intermediate Word	12/17/2003	40 pages. This manual covers the following topics: headers and footers, bullets, tables, and graphics.
Word XP Step 3: Advanced Word	12/17/2003	38 pages. This manual covers the following topics: wizards and templates, styles, columns, sections, preparing and printing envelopes, and working with labels.
Word XP Mail Merge	9/23/2003	37 Pages. This manual provides step-by-step instructions on using the Mail Merge Function in Word XP. Instructions are provided on producing labels, envelopes, and letters via a Mail Merge. NOTE: User should have equivalent knowledge of Word Steps 1, 2 and 3 to utilize and understand this material.
Mail Merge Problems and Solutions	10/29/2003	7 pages. This document 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 recipients are repeating.
Tables in Word XP	10/28/2003	This manual provides instructions on creating/maintaining tables in Microsoft Word. The following topics are covered: table alignment and distribution, properties, sorting data in tables, and calculations in tables. NOTE: User should have equivalent knowledge of Word Steps 1, 2 and 3 to utilize and understand this material.
Desktop Publishing in Word XP	11/5/2003	43 pages. This manual provides detailed instructions on using Microsoft Word for desktop publishing. The following topics are covered: drawing toolbar, clipart, text boxes, pull quotes, drop capital letters, and printing thumbnails. NOTE: User should have equivalent knowledge of Word Steps 1, 2 and 3 to utilize and understand this material.
Alignment in Word XP	10/28/2003	30 pages. The following topics are covered in this manual: tabs, line spacing, line breaks, page breaks, working with indents, and alignment. NOTE: User should have equivalent knowledge of Word Steps 1, 2 and 3 to utilize and understand this material.

Word XP Tutorials

Name	Last Revised	Comments
Word Mail Merge Tutorial Word Mail Merge Quick Reference Job aid	6/29/2004	The tutorial takes approximately 10 minutes to complete and walks through the process of creating mailing labels. The Quick Reference Guide provides a one-page job aid to assist with creating a Mail Merge in Word XP.

Excel XP

Name	Last Revised	Comments
Excel XP Step 1: Utilizing Successful Worksheet Strategies	1/21/2004	25 Pages. This manual covers the following topics: entering and editing data; sorting, maintaining, and manipulating lists; and importing PeopleSoft query data.
Excel Step 2: Implementing Formulas and Functions	11/4/2003	20 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	10/28/2003	35 pages. This manual covers the following topics: formatting the worksheet, utilizing special effects, headers and footers, and managing the print function.
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/04/2004	2 pages. This is a quick reference guide for working with formulas and functions in Excel.

Access XP

Name	Last Revised	Comments
Access Step 1: Overview and Tables	10/27/2003	43 pages. This manual provides an overview of databases and database terminology, objects, working with records in tables, creating a new database, designing and editing tables, and lookup and input mask field properties.
Access Step 2: Forms and Basic Queries	11/6/2003	28 pages. This manual provides information on the following topics: creating forms, entering and editing data using forms, finding, sorting and filtering data in forms, creating a select query, and copying and deleting Access objects.
Access Step 3: More Queries	11/10/2003	27 pages. This manual provides information on the following topics: use of criteria in a query, joining tables, update queries, make table queries, and append queries.
Access Step 4: Reports and Sharing Data	11/17/2003	39 pages. This manual provides information on the following topics: Creating a basic report, modifying the query to change report results, mailing labels, importing data from Excel, exporting data to Excel, and exporting data to Word.

PowerPoint XP

Name	Last Revised	Comments
PowerPoint Step 1: Creating and Editing a Presentation	2/17/2004	17 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	11/05/2003	17 pages. The following topics are covered in this manual: clip art, data charts, organization charts, and transitions.