Show Me Microsoft Office 2003

by Johnson, Steve; Perspection Inc.

• ISBN13: 9780789730077
• ISBN10: 0789730073
• Edition: 1st
• Format: Paperback
• Copyright: 2003-09-13
• Publisher: Que Publishing

Summary

Microsoft Office 2003 provides a powerful integrated suite of programs with which to create and share documents and presentations, communicate, and analyze business information. It takes advantage of the latest technologies such as XML and Microsoft SharePoint to extend desktop productivity and workspace collaboration over an intranet or the Internet. This visual book covers these changes and all other important features of the Office system in a format that is easy for new users to get working quickly and upgrading users to learn what's different in this version. Other features of the book include a "Troubleshooting Guide" to help solve common problems, a "Project Guide" with a listing of real-world projects by feature, and a "MOS Exam Guide" with a complete listing of MOS objectives. This provides a definite advantage over the competition, since no other visual book offers this feature. Topics covered in this book are Word, Excel, PowerPoint, Access, Outlook, Publisher, creating web pages with Office, sharing information within Office Docs, collaboration with Office, and InfoPath 2003.

Author Biography

Steve Johnson has written more than 20 books on a variety of computer software, including Microsoft Office XP, Windows XP, and Macromedia Director MX and Fireworks. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc. Perspection, Inc. is a software training company committed to providing performance-based training to help people effectively and efficiently use computer technology. Perspection writes and produces software training books, and develops Web-based training for Windows and Macintosh personal computers. Since 1991 they have written more than 60 computer books and sold over 4.5 million copies.

Table of Contents

Introduction	xix
1 Getting Started with Office	1	(26)
Starting an Office Program	2	(1)
Using Task Panes	3	(1)
Choosing Menu and Dialog Box Options	4	(2)
Working with Toolbars	6	(2)
Creating a New File	8	(2)
Saving a File	10	(2)
Saving a File with Different Formats	12	(2)
Opening an Existing File	14	(1)
Finding a File or Text in a File	15	(1)
Arranging Windows	16	(2)
Getting Help in an Office Program	18	(2)
Getting Help from the Office Assistant	20	(2)
Closing a File	22	(1)
Upgrade Getting Office Updates on the Web	23	(1)
Repairing and Recovering Office Programs	24	(2)
Quitting an Office Program	26	(1)
2 Using Shared Office Tools	27	(28)
Editing Text	28	(2)
Working with the Clipboard	30	(2)
Finding and Replacing Text	32	(2)
Using Multiple Languages	34	(2)
Correcting Text Automatically	36	(2)
Inserting Information the Smart Way	38	(2)
Making Corrections	40	(1)
Inserting Comments	41	(1)
Using Track Changes	42	(1)
Comparing and Merging Documents	43	(1)
Inserting Research Material	44	(2)
Controlling Programs with Your Voice	46	(2)
Executing Voice Commands	48	(1)
Dictating Text	49	(1)
Recognizing Handwriting	50	(2)
Automating Your Work with Macros	52	(2)
Modifying a Macro	54	(1)
3 Adding Art to Office Documents	55	(22)
Selecting, Moving, and Resizing Objects	56	(2)
Drawing and Enhancing Objects	58	(2)
Adding WordArt	60	(2)
Inserting ClipArt	62	(2)
Inserting a Picture	64	(1)
Inserting a Picture from a Scanner or Camera	65	(1)
Modifying Pictures	66	(2)
Creating an Organization Chart	68	(2)
Creating a Diagram	70	(1)
Creating a Graph Chart	71	(1)
Modifying a Graph Chart	72	(2)
Managing Pictures	74	(2)
Sharing Pictures Using E-mail	76	(1)
4 Creating a Document with Word	77	(22)
Viewing the Word Window	78	(1)
Creating a Document	79	(1)
Changing Document Views	80	(2)
Reading a Document	82	(2)
Working with Multiple Documents	84	(2)
Moving Around in a Document	86	(1)
Setting Up the Page	87	(1)
Setting Up the Page Margins	88	(2)
Creating an Outline	90	(1)
Selecting Text	91	(1)
Inserting Symbols and AutoText	92	(2)
Checking Spelling and Grammar	94	(2)
Finding the Right Words	96	(1)
Preview a Document	97	(1)
Printing a Document	98	(1)
5 Formatting a Document with word	99	(28)
Formatting Text for Emphasis	100	(2)
Formatting Text with Special Effects	102	(1)
Revealing Formatting	103	(1)
Finding and Replacing Formatting	104	(2)
Changing Paragraph Alignment	106	(1)
Changing Line Spacing	107	(1)
Displaying Rulers	108	(1)
Setting Paragraph Tabs	109	(1)
Setting Paragraph Indents	110	(2)
Changing Character Spacing	112	(1)
Applying a Style	113	(1)
Creating and Modifying Styles	114	(2)
Creating Bulleted and Numbered Lists	116	(2)
Inserting New Pages and Sections	118	(2)
Adding Headers and Footers	120	(2)
Inserting Page Numbers and the Date and Time	122	(2)
Working with Templates	124	(2)
Hiding Text	126	(1)
6 Enhancing a Document with Word	127	(22)
Adding Desktop Publishing Effects	128	(2)
Arranging Text in Columns	130	(2)
Creating a Table	132	(1)
Entering Text in a Table	133	(1)
Modifying a Table	134	(2)
Adjusting Table Cells	136	(2)
Formatting a Table	138	(2)
Creating a Form Letter	140	(2)
Creating Labels	142	(2)
Addressing Envelopes and Labels	144	(1)
Inserting a Table of Contents	145	(1)
Creating Multiple Document Versions	146	(1)
Modifying the Document Summary	147	(1)
Protecting a Document	148	(1)
7 Creating a worksheet with Excel	149	(24)
Viewing the Excel Window	150	(1)
Selecting Cells	151	(1)
Moving Around Cells	152	(2)
Entering Text and Numbers	154	(2)
Making Label Entries	156	(2)
Editing Cell Contents	158	(1)
Clearing Cell Contents	159	(1)
Inserting and Deleting Cells	160	(1)
Selecting a Column or Row	161	(1)
Inserting and Deleting Columns or Rows	162	(1)
Hiding and Unhiding a Column or Row	163	(1)
Adjusting Column Width and Row Height	164	(2)
Selecting and Naming a Worksheet	166	(1)
Inserting and Deleting a Worksheet	167	(1)
Moving and Copying a Worksheet	168	(2)
Hiding and Unhiding Worksheets and Workbooks	170	(1)
Splitting a Worksheet in Panes	171	(1)
Freezing Panes	172	(1)
8 Building a Worksheet with Excel	173	(28)
Creating a Simple Formula	174	(1)
Editing and Copying a Formula	175	(1)
Naming a Range	176	(1)
Simplifying a Formula with Ranges	177	(1)
Understanding Cell Referencing	178	(1)
Using Absolute Cell References	179	(1)
Performing Calculations Using Functions	180	(2)
Calculating Results	182	(2)
Correcting Calculation Errors	184	(2)
Creating a Chart	186	(2)
Selecting and Editing a Chart	188	(1)
Changing a Chart	189	(1)
Adding and Deleting a Data Series	190	(2)
Enhancing a Data Series	192	(1)
Formatting a Chart	193	(1)
Enhancing a Chart	194	(1)
Understanding Lists	195	(3)
Creating a List 196 New
Sorting Data in a List	198	(2)
Working with Lists	200	(1)
9 Designing a Worksheet with Excel	201	(20)
Formatting Text and Numbers	202	(2)
Changing Data Alignment	204	(1)
Changing Data Font and Color	205	(1)
Designing Conditional Formatting	206	(1)
Adding Color and Patterns to Cells	207	(1)
Adding Borders to Cells	208	(1)
Formatting Data with AutoFormat	209	(1)
Creating and Applying Styles to Cells	210	(2)
Formatting Tabs and the Background	212	(1)
Inserting Page Breaks	213	(1)
Setting Up the Page	214	(1)
Adding Headers and Footers	215	(1)
Customizing Worksheet Printing	216	(2)
Setting a Print Area	218	(1)
Previewing a Worksheet	219	(1)
Printing a Worksheet	220	(1)
10 Creating a Presentation with PowerPoint	221	(32)
Creating a Presentation Using the AutoContent Wizard	222	(2)
Applying a Design Template	224	(1)
Viewing the PowerPoint Window	225	(1)
Understanding the PowerPoint Views	226	(2)
Creating Consistent Slides	228	(2)
Entering and Deleting Text	230	(2)
Aligning and Spacing Text	232	(1)
Modifying Page Setup	233	(1)
Developing an Outline	234	(2)
Rearranging Slides	236	(2)
Controlling Slide Appearance with Masters	238	(2)
Working with Color Schemes	240	(2)
Applying Color and Effects to an Object	242	(2)
Working with Objects	244	(2)
Aligning and Arranging Objects	246	(2)
Creating a Text Box	248	(1)
Inserting Slides from Other Presentations	249	(1)
Inserting a Table	250	(1)
Inserting and Playing Media	251	(1)
Checking Style and Spelling	252	(1)
11 Delivering a Presentation with PowerPoint	253	(24)
Adding Action Buttons	254	(2)
Creating Slide Transitions	256	(2)
Adding Animation	258	(2)
Using Specialized Animations	260	(2)
Timing a Presentation	262	(1)
Setting Up a Slide Show	263	(1)
Creating a Custom Slide Show	264	(2)
Starting a Slide Show	266	(1)
Navigating a Slide Show	267	(1)
Annotating a Slide Show	268	(1)
Adding a Header and a Footer	269	(1)
Preparing Speaker Notes and Handouts	270	(2)
Previewing and Printing a Presentation	272	(2)
Broadcasting a Presentation	274	(2)
Packaging a Presentation on CD	276	(1)
12 Creating a Database with Access	277	(28)
Understanding How Databases Store Data	278	(2)
Creating a Database	280	(2)
Stepping Through a Database Wizard	282	(1)
Viewing the Access Window	283	(1)
Viewing Database Objects	284	(2)
Working with Database Objects	286	(2)
Planning Tables	288	(1)
Creating a Table by Entering Data	289	(1)
Creating a Table Using a Wizard	290	(2)
Working with a Table	292	(2)
Importing Data into Tables	294	(1)
Working with a Table in Design View	295	(1)
Specifying Data Types and Field Properties	296	(1)
Changing Field Properties	297	(1)
Creating Input Masks	298	(1)
Creating a Lookup Field	299	(1)
Planning Tables Relationships	300	(2)
Defining Table Relationships	302	(2)
Ensuring Referential Integrity	304	(1)
13 Locating and Managing Data with Access	305	(18)
Sorting Records	306	(1)
Filtering Out Records	307	(1)
Creating Complex Filters Using Forms	308	(1)
Understanding the Different Types of Queries	309	(1)
Creating a Query Using a Wizard	310	(2)
Creating a Query in Design View	312	(1)
Getting Information with a Query	313	(1)
Modifying a Query in Design View	314	(1)
Performing Calculations in Queries	315	(1)
Summarizing Values with a Crosstab Query	316	(2)
Creating a Parameter Query	318	(1)
Finding Duplicate Fields	319	(1)
Identifying Object Dependencies	320	(1)
Backing Up a Database	321	(1)
Compacting and Repairing a Database	322	(1)
14 Presenting Data with Access	323	(24)
Creating a Form Using a Wizard	324	(2)
Working with a Form in Design View	326	(1)
Entering and Editing Data in a Form	327	(1)
Modifying a Form in Design View	328	(2)
Creating a Report Using a Wizard	330	(2)
Modifying a Report in Design View	332	(2)
Performing Calculations in Reports	334	(2)
Formatting a Form or Report	336	(2)
Aligning and Grouping Controls	338	(2)
Creating a Data Access Page Using a Wizard	340	(1)
Working with a Data Access Page in Design View	341	(1)
Formatting a Datasheet	342	(1)
Changing the Page Setup	343	(1)
Previewing and Printing Information	344	(2)
Creating Mailing Labels	346	(1)
15 Communicating with Outlook	347	(40)
Preparing for Outlook	348	(1)
Using Outlook for the First Time	349	(1)
Viewing the Outlook Window	350	(1)
Using Outlook Today	351	(1)
Using the Navigation Pane	352	(1)
Viewing Items and Folders	353	(1)
Creating a Contact	354	(2)
Sorting Contacts	356	(1)
Creating a Distribution List	357	(1)
Creating and Addressing an E-Mail Message	358	(2)
Formatting Message Text	360	(1)
Attaching a File or Item to a Message	361	(1)
Using Stationery	362	(1)
Creating a Signature	363	(1)
Working with a Signature	364	(1)
Sending Messages	365	(1)
Receiving and Reading Messages	366	(1)
Flagging Messages	367	(1)
Replying to and Forwarding a Message	368	(2)
Finding and Filtering Messages	370	(2)
Organizing Messages in Folders	372	(2)
Managing Messages with Colors and Rules	374	(2)
Using Search Folders	376	(2)
Reducing Junk E-Mail and Spam	378	(1)
Archiving Messages	379	(1)
Setting Up Instant Messaging	380	(1)
Starting Windows Messenger	381	(1)
Adding Contacts	382	(1)
Enabling Instant Messaging	383	(1)
Sending and Receiving Instant Messages	384	(2)
Sending a File During an Instant Message	386	(1)
16 Managing information with Outlook	387	(26)
Viewing the Calendar	388	(1)
Customizing the Calendar	389	(1)
Scheduling an Appointment and Event	390	(2)
Scheduling Meetings	392
Scheduling Meeting Resources	383	(11)
Responding to Meeting Requests	394	(2)
Updating and Canceling Meeting Requests	396
Scheduling Online Meetings	387	(11)
Creating and Updating Tasks	398
Organizing Tasks	388	(12)
Assigning Tasks to Others	400	(1)
Monitoring Task Progress	401	(1)
Managing Tasks	402	(1)
Tracking Activities with Contacts	403	(1)
Recording Items in the Journal	404	(2)
Opening and Modifying Journal Entries	406	(1)
Organizing Items by Categories	407	(1)
Customizing How You View Items	408	(2)
Creating and Modifying Notes	410	(1)
Previewing Items from Outlook	411	(1)
Printing Items from Outlook	412	(1)
17 Creating a Publication with Publisher	413	(18)
Viewing the Publisher Window	414	(1)
Creating e Quick Publication	415	(3)
Creating a New Publication	418
Creating a Blank Publication	417	(1)
Changing Your View	418	(1)
Inserting and Deleting Pages	419	(1)
Inserting and Editing Text	420	(2)
Creating a Web Site	422	(2)
Adding a Hot Spot Hyperlink	424	(1)
Applying Color	425	(1)
Adding Design Gallery Elements	426	(1)
Checking Your Design	427	(1)
Setting Up the Page	428	(1)
Using Commercial Printing Tools	429	(1)
Printing Publications	430	(1)
18 Designing a Publication with Publisher	431	(20)
Setting Up Layout Guides	432	(1)
Creating a Frame	433	(1)
Working with Text	434	(2)
Connecting Text Frames	436	(2)
Creating a Consistent Look	438	(2)
Creating Tables	440	(2)
Working with Pictures and Shapes	442	(2)
Wrapping Text Around an Object	444	(2)
Layering Objects	446	(1)
Grouping Objects Together	447	(1)
Aligning with Precision	448	(2)
Rotating and Flipping Objects	450	(1)
19 Creating Web Pages with Office Programs	451	(20)
Designing Web Pages	452	(1)
Opening Web Pages	453	(1)
Inserting Hyperlinks	454	(2)
Using and Removing Hyperlinks	456	(2)
Enhancing Web Pages	458	(1)
Previewing Web Pages	459	(1)
Saving Documents as Web Pages	460	(2)
Saving Documents as Single File Web Pages	462	(1)
Saving Slides as Web Graphics	463	(1)
Publishing Web Pages	464	(2)
Holding an Online Meeting	466	(2)
Sending Documents by E-Mail	468	(2)
Getting Documents from the Web	470	(1)
20 Working Together on Office Documents	471	(16)
Viewing Share PointTeam Services	472	(2)
Administering Share PointTeam Services	474	(2)
Storing Documents in the Library	476	(1)
Viewing Team Members	477	(1)
Setting Up Alerts	478	(1)
Assigning ProjectTasks	479	(1)
Creating an Event	480	(2)
Creating Contacts	482	(2)
Holding Web Discussions	484	(1)
Working with Shared Workspace	485	(1)
Installing Windows 2003 and SharePoint Server 2003	486	(1)
21 Sharing Information Between Programs	487	(18)
Sharing Information Between Programs	488	(2)
Exporting and Importing Files	490	(2)
Embedding and Linking Information	492	(2)
Creating an XML Document	494	(2)
Creating a Word Document with Excel Data	496	(2)
Copying a WebTable to an Excel Worksheet	498	(1)
Analyzing Access Data in an Excel Workbook	499	(1)
Creating a Presentation with WordText	500	(2)
Using an Access Database to Create Word Documents	502	(2)
Creating a Word Outline from a Presentation	504	(1)
Microsoft Office Specialist	505	(8)
Troubleshooting	513	(8)
Index	521