Introduction |
|
1 | (1) |
|
|
2 | (1) |
|
How This Book Is Organized |
|
|
3 | (1) |
|
Conventions Used in This Book |
|
|
4 | (5) |
|
|
4 | (1) |
|
|
5 | (4) |
|
I. Common Tasks and Feature |
|
|
|
Getting Started with Office 2003 |
|
|
9 | (20) |
|
What Is Office Student and Teacher Edition 2003? |
|
|
10 | (1) |
|
Office 2003 Student and Teacher Edition, Piece by Piece |
|
|
11 | (3) |
|
|
11 | (1) |
|
|
12 | (1) |
|
|
12 | (1) |
|
|
13 | (1) |
|
|
14 | (1) |
|
|
14 | (3) |
|
Activating Your Copy of Office |
|
|
15 | (1) |
|
Installing Updates and Service Packs |
|
|
16 | (1) |
|
Customizing Your Office Installation |
|
|
17 | (3) |
|
|
20 | (1) |
|
Using Setup in Maintenance Mode |
|
|
20 | (2) |
|
Adding and Removing Office Features |
|
|
21 | (1) |
|
Repairing an Office Installation |
|
|
21 | (1) |
|
|
22 | (1) |
|
|
22 | (7) |
|
|
25 | (2) |
|
Using the Office Assistant |
|
|
27 | (2) |
|
Making Office 2003 Work Your Way |
|
|
29 | (32) |
|
|
30 | (1) |
|
Making Menus and Toolbars Consistent |
|
|
30 | (3) |
|
How Personalized Toolbars and Menus Work |
|
|
31 | (1) |
|
Disabling On-the-Fly Interface Changes |
|
|
32 | (1) |
|
Restoring Default Menus and Toolbars |
|
|
33 | (1) |
|
|
33 | (6) |
|
Showing, Hiding, and Arranging Toolbars |
|
|
34 | (2) |
|
Adding and Removing Buttons |
|
|
36 | (3) |
|
|
39 | (4) |
|
Customizing the Appearance of Toolbar Buttons |
|
|
40 | (1) |
|
Editing a Toolbar Button's Icon and Label |
|
|
41 | (1) |
|
Assigning a Hyperlink to a Toolbar Button |
|
|
42 | (1) |
|
Customizing Built-In Menus |
|
|
43 | (3) |
|
Rearranging Pull-Down Menus |
|
|
43 | (1) |
|
|
44 | (1) |
|
|
44 | (2) |
|
Bypassing Menus with Keyboard Shortcuts |
|
|
46 | (1) |
|
Configuring Common Office Features |
|
|
47 | (7) |
|
|
48 | (1) |
|
|
48 | (2) |
|
Setting Up Spell-Checking Options |
|
|
50 | (3) |
|
Configuring the Research Task Pane |
|
|
53 | (1) |
|
|
54 | (2) |
|
Saving and Restoring Personal Settings |
|
|
56 | (1) |
|
|
57 | (1) |
|
Extra Credit: Custom Toolbars for Quick Highlighting |
|
|
58 | (3) |
|
Keeping Track of Your Files and Settings |
|
|
61 | (26) |
|
Getting Organized (and Staying That Way) |
|
|
62 | (1) |
|
Where Should You Keep Your Files? |
|
|
62 | (4) |
|
Opening and Saving Files over a Network |
|
|
65 | (1) |
|
Storing Files on the Web or an Intranet |
|
|
65 | (1) |
|
|
66 | (2) |
|
|
68 | (1) |
|
Using and Customizing Common Dialog Boxes |
|
|
69 | (5) |
|
Customizing Common Dialog Boxes |
|
|
72 | (1) |
|
Using Alternative File Formats |
|
|
73 | (1) |
|
Storing Extra Details About Your Documents |
|
|
74 | (5) |
|
Default Document Properties |
|
|
77 | (1) |
|
Using Custom Properties to Organize Files |
|
|
77 | (1) |
|
Using Windows Explorer to View File Properties |
|
|
78 | (1) |
|
Searching for Office Files |
|
|
79 | (4) |
|
Finding Files or Messages by Content |
|
|
82 | (1) |
|
Using Document Properties to Locate Files |
|
|
82 | (1) |
|
Working with Multiple Files |
|
|
83 | (1) |
|
Setting Up Automatic Backup and Recovery Options |
|
|
84 | (1) |
|
|
85 | (1) |
|
Extra Credit: Find Files Faster with Desktop Search Tools |
|
|
86 | (1) |
|
Entering, Editing, and Formatting Text |
|
|
87 | (26) |
|
Entering Text: More Than Just Typing |
|
|
88 | (4) |
|
Inserting Symbols and Special Characters |
|
|
88 | (2) |
|
Entering Accented and International Characters |
|
|
90 | (1) |
|
Entering Text in Another Language |
|
|
90 | (2) |
|
|
92 | (1) |
|
Finding and Replacing Text |
|
|
93 | (2) |
|
Converting Scanned Documents to Text |
|
|
95 | (3) |
|
Using AutoCorrect to Type Faster |
|
|
98 | (7) |
|
|
99 | (1) |
|
Setting AutoCorrect Options |
|
|
100 | (1) |
|
Customizing the AutoCorrect Lists |
|
|
101 | (3) |
|
Advanced AutoCorrect Techniques |
|
|
104 | (1) |
|
AutoCorrect Do's and Don'ts |
|
|
104 | (1) |
|
|
105 | (1) |
|
Common Formatting Options |
|
|
106 | (3) |
|
Changing Character Attributes |
|
|
106 | (2) |
|
Using Bullets and Numbers to Set Off Lists |
|
|
108 | (1) |
|
Undoing and Redoing Changes |
|
|
109 | (1) |
|
Can You Really Enter Text by Speaking? |
|
|
110 | (1) |
|
|
111 | (1) |
|
Extra Credit: Using AutoCorrect to Add a Scanned Signature to Word Documents |
|
|
112 | (1) |
|
Using Pictures and Drawings |
|
|
113 | (32) |
|
|
114 | (1) |
|
Using Office Drawing Tools |
|
|
114 | (12) |
|
Working with the Drawing Layer |
|
|
114 | (2) |
|
Working with a Drawing Canvas |
|
|
116 | (1) |
|
|
117 | (1) |
|
|
118 | (1) |
|
|
119 | (2) |
|
Changing Background Colors and Line Formats |
|
|
121 | (1) |
|
Adding Shadows and 3D Effects |
|
|
122 | (1) |
|
|
123 | (1) |
|
Aligning and Grouping Graphic Elements |
|
|
124 | (1) |
|
Wrapping, Layout, and Stacking |
|
|
125 | (1) |
|
Adding Pictures to Office Documents |
|
|
126 | (2) |
|
Choosing Embedding or Linking |
|
|
127 | (1) |
|
Working with Scanned Images |
|
|
128 | (1) |
|
Viewing, Editing, and Managing Pictures |
|
|
129 | (6) |
|
Resizing and Cropping Pictures |
|
|
131 | (1) |
|
|
132 | (2) |
|
Compressing Graphics for Web Pages and Presentations |
|
|
134 | (1) |
|
Using Advanced Picture Effects |
|
|
135 | (1) |
|
Creating Graphics from Text |
|
|
135 | (3) |
|
Using Text Boxes to Create Pull Quotes |
|
|
136 | (1) |
|
|
137 | (1) |
|
|
138 | (4) |
|
Creating and Editing Charts and Diagrams |
|
|
142 | (1) |
|
|
142 | (1) |
|
|
142 | (1) |
|
|
143 | (1) |
|
|
143 | (1) |
|
Extra Credit: A Professional Flowchart |
|
|
144 | (1) |
|
Using Office Programs Together |
|
|
145 | (20) |
|
Sharing Data Between Office Programs |
|
|
146 | (1) |
|
Using the Office Clipboard |
|
|
146 | (3) |
|
Customizing the Office Clipboard |
|
|
149 | (1) |
|
Converting Clipboard Data into Alternative Formats |
|
|
149 | (2) |
|
Dragging and Dropping Data |
|
|
151 | (2) |
|
Converting and Importing Files Between Office Programs |
|
|
153 | (1) |
|
Combining Two or More Data Types in One Document |
|
|
154 | (6) |
|
|
154 | (2) |
|
Creating and Editing Embedded Objects |
|
|
156 | (2) |
|
Creating and Editing Linked Objects |
|
|
158 | (1) |
|
Managing Links Between Documents and Objects |
|
|
159 | (1) |
|
|
160 | (1) |
|
Extra Credit: Side by Side with Office |
|
|
160 | (5) |
|
|
|
Getting Started with Outlook |
|
|
165 | (44) |
|
The Five Faces of Outlook |
|
|
166 | (1) |
|
Using and Customizing the Outlook Interface |
|
|
166 | (4) |
|
Customizing the Navigation Pane |
|
|
167 | (2) |
|
Adding Custom Shortcuts to the Navigation Pane |
|
|
169 | (1) |
|
Customizing the Outlook Today Page |
|
|
170 | (1) |
|
Using Custom Views to Display Information |
|
|
170 | (12) |
|
Using Views to Display, Sort, and Filter Items |
|
|
171 | (1) |
|
Arranging Items in a View |
|
|
172 | (1) |
|
Customizing an Existing View |
|
|
173 | (6) |
|
Creating a New Custom View |
|
|
179 | (2) |
|
|
181 | (1) |
|
Opening a Folder in a Separate Window |
|
|
181 | (1) |
|
Creating, Editing, and Managing Outlook Items |
|
|
182 | (4) |
|
Moving, Copying, and Deleting Items |
|
|
182 | (2) |
|
Entering Dates and Times Automatically |
|
|
184 | (1) |
|
Assigning Items to Categories |
|
|
185 | (1) |
|
|
186 | (4) |
|
Mailbox Folders on an Exchange Server Only |
|
|
189 | (1) |
|
Managing Outlook Data Files |
|
|
190 | (4) |
|
Cleaning Up and Archiving Outlook Information |
|
|
190 | (2) |
|
Recovering Free Space in Outlook Data Files |
|
|
192 | (1) |
|
Repairing a Damaged Personal Folders File |
|
|
193 | (1) |
|
Using Reminders and Follow-Up Flags |
|
|
194 | (3) |
|
Flagging Messages for Follow-Up |
|
|
194 | (2) |
|
|
196 | (1) |
|
|
197 | (5) |
|
Finding Contact Information Fast |
|
|
197 | (1) |
|
Using the Find Pane for Simple Searches |
|
|
198 | (1) |
|
Advanced Search Techniques |
|
|
199 | (3) |
|
Importing and Exporting Outlook Information |
|
|
202 | (4) |
|
Importing Data from External Programs |
|
|
202 | (3) |
|
|
205 | (1) |
|
Synchronizing Outlook Data with a Handheld Device |
|
|
205 | (1) |
|
|
206 | (1) |
|
Extra Credit: Building a Library of Saved Searches |
|
|
207 | (2) |
|
Keeping Your E-mail Under Control |
|
|
209 | (48) |
|
Making the Most of E-mail |
|
|
210 | (1) |
|
Switching from Outlook Express or Another E-mail Program |
|
|
210 | (1) |
|
Setting Up E-mail Accounts |
|
|
210 | (7) |
|
Configuring Internet Standard E-mail Accounts |
|
|
212 | (3) |
|
Configuring Your SMTP Server to Send Mail |
|
|
215 | (1) |
|
Hotmail and Other HTTP Accounts |
|
|
216 | (1) |
|
Managing Multiple E-mail Accounts |
|
|
217 | (1) |
|
Managing Connections to E-mail Servers |
|
|
217 | (4) |
|
|
219 | (1) |
|
Setting Up Alternative E-mail Profiles |
|
|
220 | (1) |
|
Checking Your Mail and Reading New Messages |
|
|
221 | (5) |
|
Setting Up Send/Receive Groups |
|
|
221 | (1) |
|
Choosing Which Messages to Download |
|
|
222 | (1) |
|
Checking for New Messages |
|
|
223 | (1) |
|
|
224 | (1) |
|
Speed-Reading New Messages with the Reading Pane |
|
|
225 | (1) |
|
Creating, Managing, and Using E-mail Addresses |
|
|
226 | (8) |
|
Configuring the Outlook Address Book |
|
|
227 | (2) |
|
Integrating Outlook with the Windows Address Book |
|
|
229 | (1) |
|
Those Other Address Books |
|
|
230 | (1) |
|
Addressing an E-mail Message |
|
|
231 | (1) |
|
Sending E-mail to Groups of People |
|
|
232 | (2) |
|
Using Word as an E-mail Editor |
|
|
234 | (1) |
|
Creating and Sending Messages |
|
|
234 | (9) |
|
Choosing a Message Format |
|
|
235 | (2) |
|
Using a Specific Account to Send a Message |
|
|
237 | (1) |
|
Creating, Editing, and Managing Signatures |
|
|
237 | (3) |
|
Using Stationery and Fonts in Formatted Messages |
|
|
240 | (1) |
|
|
241 | (1) |
|
Setting Reply and Forward Options |
|
|
242 | (1) |
|
|
243 | (9) |
|
Using E-mail Rules to Sort and Process Mail |
|
|
244 | (1) |
|
Creating a New E-mail Rule |
|
|
245 | (5) |
|
Managing E-mail Rules and Alerts |
|
|
250 | (1) |
|
Creating and Using Search Folders |
|
|
251 | (1) |
|
|
252 | (3) |
|
Extra Credit: Expert Strategies for Outlook Rules |
|
|
255 | (2) |
|
Stopping Viruses, Spam, and Other Security Threats |
|
|
257 | (18) |
|
Why Should You Care About E-mail Security? |
|
|
258 | (1) |
|
|
259 | (4) |
|
Configuring Attachment Options |
|
|
259 | (2) |
|
Controlling Execution of Scripts |
|
|
261 | (2) |
|
Restricting Access to the Outlook Address Book |
|
|
263 | (1) |
|
Stopping Spam and Other Unwanted E-mail |
|
|
263 | (6) |
|
Fine-Tuning Outlook's Junk Mail Filter |
|
|
264 | (4) |
|
Using E-mail Rules to Block Junk E-mail |
|
|
268 | (1) |
|
Using Third-Party Spam-Fighting Software |
|
|
269 | (1) |
|
|
269 | (2) |
|
Disabling HTML-Based E-mail |
|
|
271 | (1) |
|
|
272 | (1) |
|
Extra Credit: How to Avoid Being Victimized by a Phishing Attack |
|
|
273 | (2) |
|
Organizing Your Contacts List |
|
|
275 | (20) |
|
Managing Your List of Contacts |
|
|
276 | (1) |
|
Entering and Editing Contact Information |
|
|
277 | (5) |
|
Entering and Editing Names |
|
|
278 | (1) |
|
|
279 | (1) |
|
Entering Job and Company Details |
|
|
280 | (1) |
|
Managing Phone, Fax, and Other Numbers |
|
|
280 | (1) |
|
Entering and Editing E-mail and Web Addresses |
|
|
281 | (1) |
|
Entering Personal Information and Other Details |
|
|
282 | (1) |
|
Working Smarter with Contact Items |
|
|
282 | (5) |
|
Changing the Way a Contact Item Is Filed |
|
|
282 | (1) |
|
Entering Several New Contact Items at Once |
|
|
283 | (1) |
|
Exchanging Contact Information |
|
|
284 | (1) |
|
Expert Editing Techniques |
|
|
284 | (1) |
|
Merging Duplicate Contact Items |
|
|
285 | (2) |
|
Using Windows/MSN Messenger to Communicate with Contacts |
|
|
287 | (1) |
|
Addressing Letters and Envelopes Using Your Contacts List |
|
|
287 | (2) |
|
Printing Phone Lists from Your Contacts List |
|
|
289 | (3) |
|
|
292 | (1) |
|
Extra Credit: Putting a Face with Each Name |
|
|
293 | (2) |
|
Managing Appointments, Meetings, and Tasks |
|
|
295 | (30) |
|
Managing Your Personal Calendar |
|
|
296 | (1) |
|
Creating a New Appointment or Event |
|
|
297 | (4) |
|
Entering a Recurring Appointment |
|
|
300 | (1) |
|
Rescheduling an Appointment or Event |
|
|
301 | (1) |
|
Viewing a Dairy, Weekly, or Monthly Calendar |
|
|
301 | (9) |
|
Switching Between Day, Week, and Month Views |
|
|
301 | (3) |
|
Color-Coding Important Appointments |
|
|
304 | (1) |
|
Customizing the Calendar Display |
|
|
305 | (1) |
|
Customizing Other Calendar Options |
|
|
306 | (2) |
|
Juggling Multiple Time Zones |
|
|
308 | (2) |
|
Maintaining a Personal Task List |
|
|
310 | (3) |
|
|
310 | (1) |
|
|
311 | (1) |
|
Sorting and Filtering the Task List |
|
|
312 | (1) |
|
Printing a List of Appointments and Tasks |
|
|
313 | (2) |
|
Planning a Meeting with Outlook |
|
|
315 | (3) |
|
Responding to Meeting Requests |
|
|
318 | (1) |
|
Checking the Status of a Meeting You've Arranged |
|
|
319 | (1) |
|
Rescheduling or Canceling a Meeting |
|
|
320 | (1) |
|
|
320 | (1) |
|
Extra Credit: Publishing a Calendar As a Web Page |
|
|
321 | (4) |
|
|
|
Getting Started with Word |
|
|
325 | (42) |
|
|
326 | (1) |
|
Choosing the Right Document View |
|
|
326 | (7) |
|
|
326 | (1) |
|
|
327 | (1) |
|
|
328 | (1) |
|
|
328 | (1) |
|
|
329 | (1) |
|
Navigating with Thumbnails and the Document Map |
|
|
330 | (1) |
|
|
331 | (1) |
|
|
332 | (1) |
|
Splitting a Document Window |
|
|
332 | (1) |
|
Navigating Through a Word Document |
|
|
333 | (8) |
|
Using the Keyboard to Move Through a Document |
|
|
333 | (1) |
|
Using the Mouse to Move Through a Document |
|
|
334 | (1) |
|
Navigating with the Document Map |
|
|
335 | (1) |
|
Using the Keyboard and Mouse to Select Text |
|
|
336 | (1) |
|
|
337 | (1) |
|
Navigating Through Documents with the Select Browse Object Menu |
|
|
338 | (3) |
|
Entering Text and Graphics Automatically with AutoText and AutoCorrect |
|
|
341 | (2) |
|
|
343 | (2) |
|
Finding and Replacing Text and Other Parts of a Document |
|
|
345 | (6) |
|
|
346 | (2) |
|
|
348 | (1) |
|
Finding and Replacing Formatting |
|
|
349 | (1) |
|
|
350 | (1) |
|
Checking Spelling and Grammar |
|
|
351 | (1) |
|
|
352 | (3) |
|
|
352 | (1) |
|
|
353 | (1) |
|
|
354 | (1) |
|
|
355 | (1) |
|
|
355 | (4) |
|
Tracking Changes to a Document |
|
|
355 | (2) |
|
Adding Comments to Documents |
|
|
357 | (1) |
|
|
357 | (1) |
|
Restricting Changes to a Shared Document |
|
|
358 | (1) |
|
Strategies for Non-Word Environments |
|
|
358 | (1) |
|
Customizing the Word Interface |
|
|
359 | (5) |
|
Controlling How Word Documents Appear on the Taskbar |
|
|
360 | (1) |
|
|
360 | (3) |
|
Disabling AutoFormat Settings |
|
|
363 | (1) |
|
|
364 | (1) |
|
Extra Credit: Protect Your Privacy When Saving and Sharing Documents |
|
|
365 | (2) |
|
Creating Great-Looking Documents |
|
|
367 | (36) |
|
Understanding Your Formatting Options |
|
|
368 | (4) |
|
|
368 | (3) |
|
|
371 | (1) |
|
Direct Formatting Versus Styles |
|
|
371 | (1) |
|
Applying and Modifying Formats |
|
|
372 | (8) |
|
Revealing Formatting Within a Document |
|
|
372 | (1) |
|
|
373 | (1) |
|
|
374 | (1) |
|
Page/Section Setup Options |
|
|
374 | (2) |
|
Floating Versus Inline Objects |
|
|
376 | (1) |
|
|
376 | (2) |
|
Locking a Document's Formatting |
|
|
378 | (2) |
|
Changing Paper Size and Orientation |
|
|
380 | (1) |
|
|
381 | (3) |
|
|
384 | (3) |
|
Changing Paragraph Formatting |
|
|
387 | (8) |
|
Adjusting Paragraph Alignment and Outline Level |
|
|
388 | (1) |
|
Indenting Paragraphs for Emphasis |
|
|
389 | (1) |
|
Adjusting Line and Paragraph Spacing |
|
|
390 | (1) |
|
|
391 | (1) |
|
Using Drop Caps for Emphasis |
|
|
392 | (1) |
|
Positioning Text with Tabs |
|
|
393 | (2) |
|
Using the Ruler to Set Tab Stops |
|
|
395 | (1) |
|
Using Tabs to Create a User-Input Form |
|
|
395 | (1) |
|
Formatting Simple Lists with Bullets and Numbers |
|
|
396 | (2) |
|
Formatting All or Part of a Document Automatically |
|
|
398 | (2) |
|
|
400 | (1) |
|
Extra Credit: Straight Quotes or Curly Quotes? |
|
|
400 | (3) |
|
Tables, Sections, and Other Advanced Formatting Options |
|
|
403 | (44) |
|
Going Beyond Basic Formatting |
|
|
404 | (1) |
|
Using Tables to Organize Information |
|
|
404 | (1) |
|
Adding a Table to a Document |
|
|
405 | (4) |
|
|
406 | (1) |
|
|
407 | (1) |
|
Converting Text to a Table |
|
|
407 | (2) |
|
Nesting Tables Within Tables |
|
|
409 | (1) |
|
|
409 | (8) |
|
Selecting Cells, Rows, and Columns |
|
|
409 | (1) |
|
Entering and Editing Data |
|
|
410 | (1) |
|
Moving and Copying Parts of a Table |
|
|
411 | (1) |
|
Changing Column Widths and Row Heights |
|
|
411 | (2) |
|
Adding and Deleting Rows and Columns |
|
|
413 | (1) |
|
|
414 | (1) |
|
Merging and Splitting Cells and Tables |
|
|
414 | (2) |
|
Sorting Data Within Tables |
|
|
416 | (1) |
|
Positioning Tables on the Page |
|
|
417 | (1) |
|
Advanced Table Formatting Options |
|
|
418 | (4) |
|
Letting Word Do the Work with AutoFormat |
|
|
418 | (2) |
|
Using Borders and Shading |
|
|
420 | (1) |
|
|
420 | (1) |
|
|
421 | (1) |
|
Taking Control of Page Breaks |
|
|
422 | (1) |
|
Formatting Documents by Section |
|
|
423 | (3) |
|
|
423 | (1) |
|
Inserting and Deleting Section Breaks |
|
|
424 | (1) |
|
Copying Formatting Between Sections |
|
|
425 | (1) |
|
Adding Lines, Borders, Shading, and Backgrounds |
|
|
426 | (4) |
|
Quick Ways to Create Lines |
|
|
426 | (1) |
|
|
427 | (1) |
|
Shading Characters, Paragraphs, and Pages |
|
|
428 | (2) |
|
Formatting a Document with Columns |
|
|
430 | (1) |
|
Creating and Editing Headers and Footers |
|
|
431 | (5) |
|
Creating Headers and Footers |
|
|
432 | (1) |
|
|
433 | (1) |
|
Adding Dates and Document Details |
|
|
434 | (1) |
|
How Section Breaks Affect Headers and Footers |
|
|
435 | (1) |
|
Keeping Long Documents Under Control |
|
|
436 | (8) |
|
|
436 | (1) |
|
|
437 | (1) |
|
Inserting Cross-References |
|
|
438 | (2) |
|
|
440 | (2) |
|
Creating a Table of Contents |
|
|
442 | (2) |
|
Wrapping Text Around Graphics |
|
|
444 | (1) |
|
|
444 | (2) |
|
Extra Credit: Nested Tables for Superior Layout |
|
|
446 | (1) |
|
Mastering Styles and Templates |
|
|
447 | (24) |
|
Moving Beyond Manual Formatting |
|
|
448 | (1) |
|
Using Styles and Templates to Manage Formats |
|
|
448 | (3) |
|
Formatting Documents with Styles |
|
|
451 | (6) |
|
Paragraph Versus Character Styles |
|
|
451 | (2) |
|
|
453 | (1) |
|
|
454 | (1) |
|
Using the Styles and Formatting Task Pane |
|
|
455 | (2) |
|
Saving Formats as Named Styles |
|
|
457 | (2) |
|
Customizing the Normal Document Template |
|
|
459 | (2) |
|
Using Word's Built-in Templates |
|
|
461 | (1) |
|
Changing Document Formats Globally |
|
|
462 | (3) |
|
Managing Styles and Templates |
|
|
465 | (3) |
|
Creating a New Template from Scratch |
|
|
465 | (1) |
|
Where Does Word Store Templates? |
|
|
465 | (2) |
|
Customizing Word Templates |
|
|
467 | (1) |
|
Copying Styles and Settings Between Templates |
|
|
467 | (1) |
|
|
468 | (1) |
|
Extra Credit: Styles and Manually Applied Formatting |
|
|
469 | (2) |
|
Letters, Mail Merge, and ``Smart'' Documents |
|
|
471 | (44) |
|
|
472 | (1) |
|
Creating and Editing Letters |
|
|
472 | (6) |
|
|
472 | (2) |
|
Customizing Letter Templates |
|
|
474 | (3) |
|
Addressing Letters with the Outlook Contacts List |
|
|
477 | (1) |
|
Creating Envelopes and Labels |
|
|
478 | (3) |
|
|
478 | (2) |
|
|
480 | (1) |
|
|
480 | (1) |
|
Merging Data to Create Custom Reports and Letters |
|
|
481 | (2) |
|
Using Mail Merge to Personalize Form Letters |
|
|
483 | (6) |
|
|
484 | (1) |
|
Specifying a Source for Names and Addresses |
|
|
485 | (2) |
|
Placing Data Fields Within Your Document |
|
|
487 | (1) |
|
Previewing Mail Merge Results |
|
|
488 | (1) |
|
Mass E-mailing and Faxing with Outlook and Mail Merge |
|
|
489 | (1) |
|
|
490 | (1) |
|
Advanced Mail Merge Techniques |
|
|
491 | (3) |
|
|
491 | (2) |
|
|
493 | (1) |
|
Using Fields Intelligently |
|
|
494 | (3) |
|
Inserting a Field into a Document |
|
|
495 | (1) |
|
Showing and Hiding Field Codes |
|
|
496 | (1) |
|
|
497 | (1) |
|
|
497 | (3) |
|
General \* Format Switches |
|
|
497 | (1) |
|
Numeric \# Picture Switches |
|
|
498 | (1) |
|
Date-Time \@ Format Switches |
|
|
499 | (1) |
|
Displaying Field Results Correctly |
|
|
500 | (1) |
|
Some Useful Custom Fields |
|
|
501 | (10) |
|
|
502 | (2) |
|
|
504 | (1) |
|
Displaying Document Properties |
|
|
504 | (2) |
|
|
506 | (1) |
|
Customizing Form Letters with Fields |
|
|
507 | (1) |
|
Managing Custom Numeric Sequences |
|
|
508 | (3) |
|
Table of Contents and Index Fields |
|
|
511 | (1) |
|
|
511 | (1) |
|
Extra Credit: Professional Labels, Big Time |
|
|
512 | (3) |
|
|
|
Getting Started with Excel |
|
|
515 | (44) |
|
Working with Worksheets and Workbooks |
|
|
516 | (6) |
|
Moving, Copying, Inserting, and Deleting Worksheets |
|
|
516 | (2) |
|
|
518 | (1) |
|
Navigating in a Workbook with Keyboard Shortcuts |
|
|
519 | (1) |
|
Working with Multiple Worksheets |
|
|
520 | (1) |
|
Using Cell References and Range Names to Navigate in a Workbook |
|
|
521 | (1) |
|
Using Ranges to Work with Multiple Cells |
|
|
522 | (4) |
|
|
522 | (1) |
|
Moving from Cell to Cell Within a Range |
|
|
523 | (1) |
|
Entering the Same Data in Multiple Cells |
|
|
523 | (1) |
|
Selecting Ranges of Data with the Go To Dialog Box |
|
|
523 | (3) |
|
|
526 | (1) |
|
Finding, Replacing, and Transforming Data |
|
|
526 | (5) |
|
Finding and Replacing the Contents of a Cell or Range |
|
|
526 | (1) |
|
Dragging and Dropping to Convert Data |
|
|
527 | (1) |
|
Transforming Data with Paste Options |
|
|
528 | (3) |
|
Customizing the Worksheet Window |
|
|
531 | (2) |
|
|
531 | (1) |
|
Locking Row and Column Labels for Onscreen Viewing |
|
|
532 | (1) |
|
Splitting the Worksheet Window |
|
|
533 | (1) |
|
Using Links to Automatically Update or Consolidate Worksheet Data |
|
|
533 | (1) |
|
Restricting and Validating Data Entry for a Cell or Range |
|
|
534 | (5) |
|
Defining Data-Validation Rules |
|
|
535 | (1) |
|
Displaying Helpful Input Messages |
|
|
536 | (1) |
|
Alerting the User to Errors |
|
|
536 | (2) |
|
Deleting, Moving, or Copying Data-Validation Rules |
|
|
538 | (1) |
|
Troubleshooting Data Errors |
|
|
538 | (1) |
|
|
539 | (6) |
|
Using Ranges to Define the Default Print Area |
|
|
540 | (1) |
|
Inserting Your Own Page Breaks |
|
|
541 | (1) |
|
Extra Items You Can Print |
|
|
542 | (1) |
|
Labeling Printed Pages with Headers and Footers |
|
|
543 | (1) |
|
Using Repeating Titles for Multiple Page Printouts |
|
|
544 | (1) |
|
Forcing a Worksheet to Fit on a Specified Number of Pages |
|
|
544 | (1) |
|
|
545 | (5) |
|
Using Passwords to Restrict Access to a Workbook |
|
|
546 | (1) |
|
Preventing Changes to a Worksheet |
|
|
547 | (2) |
|
Protecting the Structure of a Workbook |
|
|
549 | (1) |
|
Publishing Excel Data in Web Pages |
|
|
550 | (2) |
|
|
552 | (4) |
|
Changing Default Formatting for New Workbooks and Worksheets |
|
|
555 | (1) |
|
|
555 | (1) |
|
|
556 | (1) |
|
|
556 | (2) |
|
Extra Credit: Beware of Undo |
|
|
558 | (1) |
|
Making Great-Looking Worksheets |
|
|
559 | (34) |
|
How Cell Formatting Works |
|
|
560 | (6) |
|
Using the General Number Format |
|
|
560 | (1) |
|
Controlling Automatic Number Formats |
|
|
560 | (2) |
|
|
562 | (2) |
|
|
564 | (1) |
|
Working with Numbers in Scientific Notation |
|
|
565 | (1) |
|
|
565 | (1) |
|
Changing Formatting for a Cell or Range |
|
|
566 | (11) |
|
|
566 | (2) |
|
Setting Date and Time Formats |
|
|
568 | (2) |
|
Excel and Year 2000 Issues |
|
|
570 | (1) |
|
Creating Custom Cell Formats |
|
|
571 | (6) |
|
Designing and Formatting a Worksheet for Maximum Readability |
|
|
577 | (7) |
|
Changing Fonts and Character Attributes |
|
|
577 | (2) |
|
Aligning, Wrapping, and Rotating Text and Numbers |
|
|
579 | (2) |
|
Using Borders, Boxes, and Colors |
|
|
581 | (2) |
|
|
583 | (1) |
|
Changing Row Height and Column Width |
|
|
583 | (1) |
|
Using Conditional Formatting to Identify Key Values |
|
|
584 | (2) |
|
Copying Formats with the Format Painter |
|
|
586 | (1) |
|
Saving Formats as Named Styles |
|
|
587 | (1) |
|
|
588 | (2) |
|
|
590 | (1) |
|
Extra Credit: Redesigning a Worksheet Clarifies the Information |
|
|
590 | (3) |
|
Using Formulas and Functions |
|
|
593 | (36) |
|
Entering and Editing Formulas |
|
|
594 | (8) |
|
Using Cell References in Formulas |
|
|
595 | (1) |
|
Using 3D References to Cells on Other Worksheets |
|
|
595 | (1) |
|
Controlling the Order and Timing of Calculations in Formulas |
|
|
595 | (2) |
|
Absolute Versus Relative Cell References |
|
|
597 | (2) |
|
Preventing Formulas from Displaying in the Formula Bar |
|
|
599 | (1) |
|
|
599 | (2) |
|
Using the Watch Window to Monitor Calculations |
|
|
601 | (1) |
|
Using Range Names and Labels in Formulas |
|
|
602 | (5) |
|
Using Natural-Language Formulas |
|
|
602 | (2) |
|
Limitations of Natural-Language Formulas |
|
|
604 | (1) |
|
Using Named Ranges in Formulas |
|
|
604 | (2) |
|
|
606 | (1) |
|
Manipulating Data with Worksheet Functions |
|
|
607 | (4) |
|
Entering Error-Free Formulas |
|
|
608 | (2) |
|
Totaling Rows and Columns Automatically |
|
|
610 | (1) |
|
Putting Worksheet Functions to Use |
|
|
611 | (7) |
|
Calculating Financial Formulas |
|
|
611 | (1) |
|
Working with Date and Time Functions |
|
|
612 | (1) |
|
Performing Statistical Analyses |
|
|
613 | (1) |
|
|
614 | (1) |
|
Performing Mathematical Operations |
|
|
614 | (1) |
|
Combining and Separating Text Values |
|
|
615 | (2) |
|
Using Logical and Information Functions |
|
|
617 | (1) |
|
|
618 | (4) |
|
How Formula AutoCorrect Work |
|
|
618 | (1) |
|
Resolving Common Error Messages |
|
|
618 | (2) |
|
Checking for Errors in a Worksheet |
|
|
620 | (2) |
|
Using the Range Finder to Locate Parts of a Formula |
|
|
622 | (1) |
|
Using Coal Seek to Find Values |
|
|
622 | (2) |
|
|
624 | (1) |
|
Extra Credit: Nesting Functions Within Functions |
|
|
625 | (4) |
|
Working with Lists and PivotTables |
|
|
629 | (40) |
|
Slicing and Dicing Data with Lists |
|
|
630 | (1) |
|
Creating a List on a Worksheet |
|
|
630 | (3) |
|
Speeding Up Repetitive Data Entry with AutoComplete |
|
|
633 | (1) |
|
Automatically Filling In a Series of Data |
|
|
634 | (4) |
|
Creating Custom AutoFill Lists to Fit Your Projects |
|
|
637 | (1) |
|
|
638 | (3) |
|
Sorting by Multiple Columns |
|
|
639 | (1) |
|
Sorting by Dates or Custom Series |
|
|
639 | (2) |
|
Finding and Filtering Data in a List |
|
|
641 | (8) |
|
Using AutoFilter to Find Sets of Data |
|
|
641 | (2) |
|
Using Comparison Criteria to Create Custom Filters |
|
|
643 | (1) |
|
Filtering with Advanced Criteria |
|
|
644 | (5) |
|
Using Forms to Add and Edit List Data |
|
|
649 | (2) |
|
Importing and Exporting Data |
|
|
651 | (1) |
|
How PivotTable and PivotChart Reports Work |
|
|
652 | (4) |
|
When Should You Use a PivotTable? |
|
|
656 | (1) |
|
|
656 | (2) |
|
Editing and Updating a PivotTable |
|
|
658 | (6) |
|
Changing Sort Order and Other Display Options |
|
|
660 | (1) |
|
Adding and Removing Column and Row Subtotals |
|
|
660 | (1) |
|
Switching Between Table and Outline Layouts |
|
|
661 | (1) |
|
Removing Blank Cells and Error Messages |
|
|
662 | (1) |
|
Refreshing Data in a PivotTable |
|
|
663 | (1) |
|
Creating and Editing PivotCharts |
|
|
664 | (2) |
|
Formatting and Printing PivotTables |
|
|
666 | (1) |
|
Extra Credit: Grouping Items in a PivotTable |
|
|
667 | (2) |
|
|
669 | (30) |
|
Every Picture Tells a Story |
|
|
670 | (1) |
|
Anatomy of an Excel Chart |
|
|
670 | (5) |
|
|
672 | (1) |
|
|
672 | (1) |
|
|
673 | (1) |
|
Data Labels, Legends, and Titles |
|
|
673 | (1) |
|
|
674 | (1) |
|
|
674 | (1) |
|
Working with Embedded Charts |
|
|
674 | (1) |
|
Using the Chart Wizard for Quick Results |
|
|
675 | (2) |
|
|
677 | (2) |
|
Selecting and Customizing a Chart Type |
|
|
679 | (8) |
|
Choosing a Standard Chart Type |
|
|
679 | (4) |
|
|
683 | (1) |
|
Creating and Saving Custom Chart Types |
|
|
684 | (2) |
|
|
686 | (1) |
|
Editing and Formatting Chart Elements |
|
|
687 | (7) |
|
|
687 | (3) |
|
|
690 | (1) |
|
|
691 | (1) |
|
Adding Background Colors, Textures, and Pictures |
|
|
692 | (1) |
|
Changing the Scale and Spacing of Axes |
|
|
692 | (1) |
|
Changing the Data Source for an Existing Chart |
|
|
692 | (2) |
|
|
694 | (1) |
|
Extra Credit: Creating a Custom Chart Library |
|
|
694 | (5) |
|
|
|
Getting Started with PowerPoint |
|
|
699 | (24) |
|
What Is PowerPoint Good For? |
|
|
700 | (1) |
|
Anatomy of a PowerPoint Presentation |
|
|
700 | (2) |
|
|
702 | (2) |
|
File Compatibility Issues |
|
|
704 | (1) |
|
|
704 | (6) |
|
Creating a Blank Presentation |
|
|
704 | (3) |
|
Starting PowerPoint with a Design Template |
|
|
707 | (1) |
|
Building a Presentation from ``Canned'' Content |
|
|
708 | (1) |
|
Copying the Design of an Existing Presentation |
|
|
708 | (1) |
|
Importing from a Word Outline |
|
|
709 | (1) |
|
|
710 | (5) |
|
Organizing Ideas in the Outline Pane |
|
|
711 | (1) |
|
Using Slide Sorter View to Rearrange a Presentation |
|
|
712 | (1) |
|
Previewing Your Presentation in Slide Show View |
|
|
713 | (1) |
|
|
713 | (1) |
|
Viewing Presentations in a Web Browser |
|
|
714 | (1) |
|
|
715 | (3) |
|
Navigating Through a Presentation |
|
|
718 | (3) |
|
Mouse and Keyboard Shortcuts |
|
|
718 | (1) |
|
|
719 | (1) |
|
Advanced Navigation with Action Settings |
|
|
720 | (1) |
|
Navigation Shorthand with Action Buttons |
|
|
720 | (1) |
|
Extra Credit: Supercharging PowerPoint with a Free Add-in |
|
|
721 | (2) |
|
Building Your Presentation |
|
|
723 | (36) |
|
Editing the Presentation Outline |
|
|
724 | (2) |
|
Editing Slides in Outline View |
|
|
724 | (1) |
|
|
725 | (1) |
|
|
725 | (1) |
|
Picking the Best Slide Layout |
|
|
726 | (3) |
|
|
726 | (1) |
|
|
727 | (1) |
|
Going Outside the Placeholders |
|
|
728 | (1) |
|
|
729 | (7) |
|
|
729 | (1) |
|
Working with Bulleted and Numbered Lists |
|
|
730 | (3) |
|
|
733 | (1) |
|
Adding Pictures, Diagrams, and Clip Art |
|
|
734 | (2) |
|
Organizing Formats with Master Slides |
|
|
736 | (11) |
|
|
736 | (2) |
|
|
738 | (3) |
|
Changing the Background of Every Slide |
|
|
741 | (1) |
|
Working with Headers and Footers |
|
|
741 | (2) |
|
Removing Slide Master Elements from a Single Slide |
|
|
743 | (1) |
|
Creating Speaker Notes and Audience Handouts |
|
|
744 | (2) |
|
Creating Multiple Master Slides |
|
|
746 | (1) |
|
Applying and Modifying Designs |
|
|
747 | (5) |
|
Choosing the Best Design for Your Presentation |
|
|
748 | (1) |
|
Modifying an Existing Design for Your Presentation |
|
|
748 | (2) |
|
Choosing the Best Background |
|
|
750 | (2) |
|
Changing the Background on Selected Slides |
|
|
752 | (1) |
|
|
752 | (3) |
|
Choosing a New Color Scheme |
|
|
753 | (1) |
|
Changing Colors on Selected Slides |
|
|
754 | (1) |
|
|
754 | (1) |
|
Changing Paragraph and Text Formatting |
|
|
755 | (2) |
|
Using Paragraph Formatting |
|
|
756 | (1) |
|
|
756 | (1) |
|
Replacing Fonts Throughout a Presentation |
|
|
756 | (1) |
|
|
757 | (1) |
|
Extra Credit: Creating Top-Notch Notes and Handouts |
|
|
757 | (2) |
|
Adding Sizzle to a Presentation |
|
|
759 | (24) |
|
Banishing Boring Slide Shows |
|
|
760 | (1) |
|
Using Transitions to Control Pacing |
|
|
760 | (3) |
|
Applying a Transition to One Slide |
|
|
761 | (1) |
|
Applying a Transition to a Group of Slides |
|
|
762 | (1) |
|
Controlling Slide Transition Speed |
|
|
762 | (1) |
|
Animating Text and Objects on a Slide |
|
|
763 | (11) |
|
|
764 | (2) |
|
|
766 | (1) |
|
|
766 | (5) |
|
Animating the Drawing Layer |
|
|
771 | (1) |
|
Hiding and Uncovering Slide Contents |
|
|
772 | (1) |
|
Animating Chart Components |
|
|
773 | (1) |
|
Adding Multimedia to Your Presentation |
|
|
774 | (6) |
|
Adding Music, Sounds, and Video Clips |
|
|
775 | (1) |
|
Controlling a Video or Sound Clip |
|
|
776 | (2) |
|
Using CD Audio and Recorded Audio |
|
|
778 | (2) |
|
Using Action Links to Combine Effects |
|
|
780 | (1) |
|
|
780 | (1) |
|
Extra Credit: Using PowerPoint to Show Off Digital Photos |
|
|
781 | (2) |
|
Delivering a Presentation with Style |
|
|
783 | (18) |
|
Planning Your Presentation |
|
|
784 | (3) |
|
The Importance of Preparation |
|
|
784 | (1) |
|
Organizing Your Remarks with Speaker Notes |
|
|
784 | (1) |
|
Using PowerPoint's Timer to Rehearse a Presentation |
|
|
785 | (2) |
|
Delivering a Perfect Presentation |
|
|
787 | (1) |
|
|
787 | (1) |
|
Creating Presentations for the Web |
|
|
788 | (1) |
|
|
789 | (2) |
|
Tuning Your Presentation for Your Hardware |
|
|
789 | (1) |
|
|
790 | (1) |
|
Using Hidden Slides to Anticipate Questions |
|
|
791 | (1) |
|
Writing or Drawing on Slides |
|
|
792 | (1) |
|
Taking Notes During a Slide Show |
|
|
793 | (1) |
|
Packaging a Presentation for Use on Other Computers |
|
|
793 | (2) |
|
Saving a Presentation on a CD |
|
|
794 | (1) |
|
Using the PowerPoint Viewer |
|
|
795 | (1) |
|
Printing Your Presentation |
|
|
795 | (2) |
|
Choosing Which Elements to Print |
|
|
795 | (1) |
|
Preparing a Color Presentation for a Black-and-White Printer |
|
|
796 | (1) |
|
|
797 | (1) |
|
Extra Credit: Anticipating Questions with Hidden Slides |
|
|
797 | (4) |
|
VI. Advanced Tasks and Features |
|
|
|
Using Macros to Automate Office Tasks |
|
|
801 | (32) |
|
Getting Started with Macros |
|
|
802 | (1) |
|
What Can You Do with a Macro? |
|
|
802 | (2) |
|
What Shouldn't You Do with Macros? |
|
|
803 | (1) |
|
|
803 | (1) |
|
Using the Visual Basic Editor |
|
|
804 | (2) |
|
How Office Applications Store Macros |
|
|
805 | (1) |
|
|
806 | (1) |
|
|
806 | (4) |
|
How the Macro Recorder Captures Actions |
|
|
807 | (1) |
|
|
808 | (1) |
|
|
809 | (1) |
|
Troubleshooting Recorded Macros |
|
|
810 | (4) |
|
Stepping Through and Editing Recorded Macros |
|
|
810 | (2) |
|
Common Recorded Macro Mistakes |
|
|
812 | (1) |
|
Testing and Bullet-Proofing Macros |
|
|
812 | (2) |
|
|
814 | (1) |
|
|
814 | (2) |
|
|
816 | (5) |
|
Using Digital Signatures to Verify a Macro's Source |
|
|
817 | (1) |
|
Configuring Office Security Levels |
|
|
818 | (1) |
|
Blocking Access to the Visual Basic Project |
|
|
819 | (1) |
|
Protecting Your PC and Network from Viruses |
|
|
820 | (1) |
|
Building Interactive VBA Programs |
|
|
821 | (3) |
|
Code Snippets You Can Use |
|
|
824 | (6) |
|
Using VBA to Navigate Office Documents |
|
|
824 | (1) |
|
Using VBA to Augment Find and Replace |
|
|
825 | (2) |
|
Using VBA to Apply Formatting |
|
|
827 | (1) |
|
Using VBA to Loop Through Collections |
|
|
828 | (2) |
|
|
830 | (1) |
|
Extra Credit: Getting Ready to Tackle VBA |
|
|
831 | (2) |
|
Using Office to Create Web Pages |
|
|
833 | (20) |
|
|
834 | (4) |
|
Using HTML, XML, and XHTML |
|
|
834 | (2) |
|
How Office Programs Handle Web Pages |
|
|
836 | (1) |
|
Removing Office-Generated HTML Tags |
|
|
837 | (1) |
|
Viewing Office Documents in a Browser Window |
|
|
837 | (1) |
|
What You Can (and Can't) Do with Office |
|
|
838 | (4) |
|
|
839 | (1) |
|
|
839 | (2) |
|
|
841 | (1) |
|
|
841 | (1) |
|
Moving Between HTML and Office Formats |
|
|
842 | (2) |
|
Web-Page Design Essentials |
|
|
844 | (3) |
|
Browser-Compatibility Issues |
|
|
845 | (1) |
|
|
845 | (1) |
|
Previewing and Testing Web Pages |
|
|
846 | (1) |
|
|
847 | (2) |
|
|
849 | (1) |
|
Extra Credit: Viewing and Editing Office Documents in a Web Browser |
|
|
849 | (4) |
|
Using Office on a Tablet PC |
|
|
853 | (12) |
|
Office 2003 and the Tablet PC |
|
|
854 | (2) |
|
Entering and Editing Text on a Tablet PC |
|
|
856 | (4) |
|
Using Ink to Add Annotations and Comments |
|
|
860 | (2) |
|
Using OneNote with Office |
|
|
862 | (1) |
|
|
863 | (2) |
Index |
|
865 | |