Microsoft Office XP Step by Step

by Microsoft Corporation

• ISBN13: 9780735612945
• ISBN10: 0735612943
• Edition: 1st
• Format: Paperback
• Copyright: 2001-07-11
• Publisher: Microsoft Press

Summary

Microsoft Office XP Step By Step offers self-paced instruction to the beginning-to-advanced user who wants to get the most out of Office XP-and prepare for Microsoft Office User (MOUS) certification. This friendly, straightforward training system offers e

Author Biography

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Table of Contents

What's New in Microsoft Office XP	xi
Getting Help	xiv
Getting Help with This Book and Its CD-ROM	xiv
Getting Help with Microsoft Office XP	xiv
Using the Book's CD-ROM	xv
Minimum System Requirements	xv
Installing the Practice Files	xvi
Using the Practice Files	xvii
Uninstalling the Practice Files	xx
Conventions and Features	xxii
I Microsoft Word	1	(92)
Creating a Document	2	(24)
Getting Started with Word	4	(4)
Creating a Document	8	(4)
Working with an Existing Document	12	(4)
Editing a Document	16	(5)
Replacing Text in a Document	21	(5)
Changing the Look of Your Document	26	(32)
Changing the Appearance of Text	28	(5)
Changing the Appearance of a Paragraph	33	(7)
Creating and Modifying a List	40	(3)
Changing the Way Each Page Appears in a Document	43	(8)
Changing the Look of a Document with Styles	51	(7)
Presenting Information in Tables and Columns	58	(22)
Presenting Text in a Table	60	(6)
Formatting Text in a Table	66	(4)
Working with Data in a Table	70	(5)
Presenting Text in Columns	75	(5)
Proofreading and Printing a Document	80	(13)
Checking the Spelling and Grammar in a Document	81	(6)
Previewing and Printing a Document	87	(6)
II Microsoft Excel	93	(92)
Getting to Know Excel	94	(24)
Introducing Excel	96	(2)
Working with an Existing Data List	98	(2)
Zeroing In on Data in a List	100	(6)
Creating a Workbook	106	(7)
Checking and Correcting Data	113	(5)
Making Changes to Your Workbook	118	(32)
Making Workbooks Easier to Work With	120	(7)
Making Data Easier to Read	127	(3)
Changing the Appearance of Data	130	(5)
Applying an Existing Format to Data	135	(3)
Making Numbers Easier to Read	138	(6)
Changing Data's Appearance Based on Its Value	144	(6)
Performing Calculations on Data	150	(16)
Naming Groups of Data	151	(4)
Creating Formulas to Calculate Values	155	(8)
Finding and Correcting Errors in Calculations	163	(3)
Focusing on Specific Data Using Filters	166	(19)
Limiting the Data That Appears on the Screen	167	(7)
Performing Calculations on Filtered Data	174	(4)
Defining a Valid Set of Values for a Range of Cells	178	(7)
III Microsoft Access	185	(108)
Getting to Know Access	186	(24)
What Is a Database?	188	(1)
What's Special About Access?	188	(2)
Opening an Existing Database	190	(2)
Exploring Tables	192	(5)
Exploring Queries	197	(3)
Exploring Forms	200	(4)
Exploring Reports	204	(3)
Exploring Other Access Objects	207	(3)
Creating a New Database	210	(24)
Creating a Database Structure the Simple Way	212	(4)
Checking the Work of a Wizard	216	(4)
Creating Tables the Simple Way	220	(3)
Refining How Data Is Displayed	223	(7)
Manipulating Table Columns and Rows	230	(4)
Simplifying Data Entry with Forms	234	(32)
Creating a Form Using a Wizard	236	(2)
Refining Form Properties	238	(6)
Refining Form Layout	244	(3)
Adding Controls to a Form	247	(5)
Using VBA to Enter Data in a Form	252	(4)
Creating a Form Using AutoForm	256	(2)
Adding a Subform to a Form	258	(8)
Locating Specific Information	266	(27)
Sorting Information	268	(2)
Filtering Information in a Table	270	(3)
Filtering By Form	273	(2)
Locating Information with the Advanced Filter/Sort Command	275	(3)
Creating a Query in Design View	278	(9)
Creating a Query with a Wizard	287	(2)
Performing Calculations in a Query	289	(4)
IV Microsoft PowerPoint	293	(82)
Creating a Presentation	294	(20)
Getting Started with PowerPoint	296	(3)
Choosing the Best Method to Start a Presentation	299	(1)
Creating a Presentation Using Suggested Content	300	(3)
Browsing Through a Presentation	303	(3)
Editing Text in a Presentation	306	(4)
Viewing a Presentation	310	(4)
Working with a Presentation	314	(20)
Creating a Presentation Using a Design Template	316	(3)
Entering Text in a Slide	319	(2)
Creating a New Slide	321	(3)
Inserting Slides from Other Presentations	324	(2)
Rearranging Slides in a Presentation	326	(1)
Entering Speaker Notes	327	(3)
Creating a Folder to Store a Presentation	330	(4)
Adding and Modifying Slide Text	334	(22)
Adding and Moving Text on Slides	335	(6)
Changing Text Alignment and Spacing	341	(4)
Finding and Replacing Text and Fonts	345	(2)
Correcting Text While Typing	347	(3)
Checking Spelling and Presentation Styles	350	(6)
Printing a Presentation	356	(19)
Working with an Existing Presentation	358	(3)
Adding a Header and a Footer	361	(1)
Choosing the Right Print Settings	362	(3)
Previewing a Presentation	365	(3)
Printing a Presentation	368	(7)
V Microsoft FrontPage	375	(128)
Understanding How FrontPage Works	376	(26)
Exploring an Existing Web Site	378	(5)
Exploring an Existing Web Page	383	(6)
Looking at a Web Site in Various Ways	389	(5)
Looking Around in FrontPage 2002	394	(5)
Understanding FrontPage Concepts	399	(3)
Creating a Web Site to Promote Yourself or Your Company	402	(28)
Creating a New Web Site Using a Template	404	(5)
Creating a New Web Site Using a Wizard	409	(3)
Working with the Tasks List	412	(1)
Inserting and Editing Text	413	(3)
Inserting Existing Text	416	(5)
Formatting Text	421	(4)
Inserting Hyperlinks	425	(1)
Seeing Your Web Pages as Visitors Will	426	(3)
Deleting a Web Site	429	(1)
Presenting Information in Lists and Tables	430	(22)
Creating a List	432	(4)
Creating a Table	436	(4)
Entering and Editing Information in a Table	440	(2)
Editing the Structure of a Table	442	(3)
Formatting a Table	445	(5)
Creating a Table Within a Table	450	(2)
Enhancing Your Web Site with Graphics	452	(30)
Adding Clip Art	454	(3)
Adding a Picture	457	(2)
Editing and Formatting Pictures	459	(5)
Creating and Displaying Thumbnails	464	(1)
Adding a Line, Shape, or Drawing	465	(9)
Creating a Photo Gallery	474	(4)
Adding Fancy Text	478	(4)
Publishing Your Web Site	482	(21)
Finding a Suitable Host for Your Web Site	484	(3)
Configuring Your Own Computer to Host a Web Site	487	(8)
Publishing a Web Site to a Local Folder	495	(3)
Publishing a Web Site to a Web Server	498	(5)
VI Microsoft Publisher	503	(42)
Creating a Document	504	(22)
Creating a Publication for the First Time	505	(5)
Creating a Publication Using the Publication Wizard	510	(3)
Creating a Business Card Using the Publication Design Set	513	(4)
Saving a Publication as a Template	517	(1)
Creating a Publication from a Template	518	(2)
Creating a Publication from a Blank Page	520	(6)
Printing Your Documents	526	(19)
Determining Your Printer's Nonprintable Region	527	(2)
Printing a Document to a Standard Printer	529	(4)
Printing a Range of Pages to a Standard Printer	533	(1)
Printing a Single Page to a Standard Printer	534	(1)
Canceling a Print Job on a Standard Printer	534	(1)
Preparing a Document for a Commercial Printer	535	(2)
Setting Up a Publication for Spot-Color Printing	537	(1)
Changing Colors in a Spot-Color Document	538	(4)
Setting Up a Publication for Process-Color Printing	542	(3)
VII Microsoft Outlook	545	(132)
Working with E-Mail	546	(30)
Starting Outlook for the First Time	548	(2)
Reading Messages and Opening Attachments	550	(4)
Responding to Messages	554	(2)
Creating New Messages	556	(4)
Using a Address Book	560	(5)
Attaching Files to Messages	565	(1)
Adding Signatures to Messages	566	(4)
Sending and Receiving Messages	570	(2)
Printing Messages	572	(4)
Managing E-Mail Messages	576	(24)
Customizing How You View Messages	577	(6)
Organizing Messages in Folders	583	(5)
Managing Messages with Color	588	(1)
Finding Messages	589	(4)
Storing and Archiving Messages	593	(7)
Customizing and Organizing E-Mail Messages	600	(30)
Formatting Messages	601	(7)
Changing Messages Settings and Delivery Options	608	(5)
Filtering Messages	613	(7)
Using Personal Folders and Address Books	620	(10)
Managing Your Calendar	630	(28)
Managing and Organizing Appointments	638	(4)
Changing the Way the Calendar Looks	642	(10)
Printing Your Calendar	652	(6)
Scheduling and Managing Meetings	658	(19)
Scheduling Meetings	659	(7)
Responding to Meeting Requests	666	(4)
Updating and Canceling Meeting Requests	670	(4)
Scheduling Online Meetings Using NetMeeting	674	(3)
Quick Reference	677	(44)
Creating a Document	677	(1)
Changing the Look of Your Document	678	(1)
Presenting Information in Tables and Columns	679	(1)
Proofreading and Printing a Document	680	(1)
Getting to Know Excel	681	(2)
Making Changes to Your Workbook	683	(3)
Performing Calculations on Data	686	(1)
Focusing on Specific Data Using Filters	687	(2)
Getting to Know Access	689	(1)
Creating a New Database	690	(1)
Simplifying Data Entry with Forms	691	(2)
Locating Specific Information	693	(2)
Creating a Presentation	695	(1)
Working with a Presentation	696	(1)
Adding and Modifying Slide Text	696	(2)
Printing a Presentation	698	(1)
Understanding How FrontPage Works	699	(1)
Creating a Web Site to Promote Yourself or Your Company	700	(2)
Presenting Information in Lists and Tables	702	(3)
Enhancing Your Web Site with Graphics	705	(2)
Publishing Your Web Site	707	(2)
Creating a Document	709	(2)
Printing Your Documents	711	(2)
Working with E-Mail	713	(3)
Managing E-Mail Messages	716	(1)
Customizing and Organizing E-Mail Messages	717	(1)
Managing Your Calendar	718	(1)
Scheduling and Managing Meetings	719	(2)
Glossary	721	(14)
Index	735