Quick Course in Microsoft Office XP - Training Edition

PUBLISHED BY Online Training Solutions, Inc. PO Box 2224
Redmond, WA 98073
Phone: [phone]
Fax: [phone]
E-mail: [e-mail]
Web site: www.otsi.com

Copyright 2003 by Online Training Solutions, Inc.

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Publisher s Cataloging-in-Publication (Provided by Quality Books, Inc.) Quick course in Microsoft Office XP : fast-track training for busy people / Online Training Solutions, Inc. --Training ed. p. cm. -- (Quick course) Includes index. Library of Congress Control Number: 2002094326 ISBN: 1-58278-075-7

1. Microsoft Office 2. Microsoft Word. 3. Microsoft Excel for Windows. 4. Microsoft PowerPoint (Computer file) 5. Microsoft Access. 6. Microsoft Outlook. 7. Business--Computer programs. 8. Word processing. 9. Electronic spreadsheets. 10. Business presentations--Graphic methods --Computer programs 11. Time management-Computer programs. 12. Personal information management--Computer programs. Electronic spreadsheets. I. Online Training Solutions (Firm) II. Title: Office XP III. Series: Quick course books.

HF5548.4.M525C69 2003 005.369

2002 115701

CIP

Printed and bound in the United States of America

1 2 3 4 5 6 7 8 9 O F F 3 2 1 0

Quick Course and Fast-Track Training are registered trademarks of Online Training Solutions, Inc. Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries . Other product and company names mentioned herein may be the trademarks of their respective owners .

All names used in this book are fictitious. Any resemblance to an actual company or product name is coincidental and unintentional.

Content Overview

Introduction

Chapter 1 Carrying Out Basic Office Tasks

You write a letter in Word while learning how to perform tasks that are common to all the Office XP programs. You enter, select, edit, and format text; give instructions using the mouse and keyboard; create, open , save, print, and close documents; and get help from within a program.

Chapter 2 Editing and Organizing Word Documents

You learn how to simplify text entry by using AutoText and AutoCorrect. You also learn Word-specific editing techniques and how to organize documents in Outline view. Then you search for and replace text and check your document s spelling and grammar.

Chapter 3 Formatting Eye-Catching Word Documents

You explore Word s built-in templates for creating common business documents, and then you combine two documents and experiment with some of Word s formatting capabilities, including styles. Finally, you create and format a table.

Chapter 4 Setting Up Excel Worksheets

You build a simple worksheet as you learn how to enter, edit, and format different types of information. Then you construct formulas that perform simple calculations, set up a calculation area, and experiment with more complex formulas. Finally, you preview and print the worksheet.

Chapter 5 Performing Calculations and Graphing Excel Data

You work with multiple workbooks and explore more advanced features, such as the IF function and data consolidation. You also set up a worksheet with links to data on a different worksheet. Then you create, format, and print a graph.

Chapter 6 Developing Simple PowerPoint Presentations

You use the AutoContent Wizard to create a slide show presentation and investigate ways of refining the text the wizard provides. Then you use a design template to create another presentation from scratch. You work with your presentation in various views. Finally, you combine your two presentations and reorder the slides.

Chapter 7 Adding Graphics, Graphs, and Special Effects to Slides

You add clip art to your presentation and learn how to import graphics from other sources. You add and customize a graph. Then you add special effects to your electronic slide show and learn how to present it.

Chapter 8 Developing Access Database Tables

You create a new database and data table, and enter records in the table in both data and form views. Then you learn how to change the table s structure by setting its field properties, and how to control the data in the table. Finally, you find, move, and sort records.

Chapter 9 Making Access Data Easily Available

You create a copy of a table and establish relationships between different tables. Then you design a form to enter data and construct queries to extract information. You share your data with others by printing reports and creating and modifying data access pages for online viewing.

Chapter 10 Managing E-mail and Contacts with Outlook

You learn how to access your e-mail account through Outlook. You use the Inbox to create, send, receive, and respond to e-mail, and learn methods for managing your e-mail messages. Then you learn how to use Outlook Contacts to manage information about people in your life, and to streamline your online communications.

Chapter 11 Managing Schedules and Task Lists

You learn how to use Outlook s Calendar and Tasks components to manage your time effectively. You schedule and track appointments and meetings, send meeting requests to colleagues, create, manage, and organize a to-do list, and delegate tasks to other Outlook users.

Chapter 12 Integrating the Office Programs

You display and manipulate the Office shortcut bar, which provides easy access to programs and files. You learn ways of using documents created in one program in other programs. Finally, you take a look at Office s web publishing capabilities.

Index