Office 2003 Timesaving Techniques For Dummies

Woody Leonhard9780764567612, 0764567616

Wouldn’t it be a waste to go on a spectacular, exotic vacation abroad and just hang out at the hotel pool? Wouldn’t it be a waste to buy a new iPod, download four favorite songs, and play them over and over?Most people with Office 2003 are wasting a lot of software power and a lot of time. They do the same routine things in the same routine ways and haven’t begun to explore the capabilities of Office 2003. If you’re one of them, Office 2003 Timesaving Techniques For Dummies gets you out of your rut and into action. It provides over 70 timesaving techniques for Word, Excel, Access, Outlook, and PowerPoint. (Most of the tips work with Office 2000 and Office XP, too.) You’ll customize Office to meet your needs and start working like a pro in no time with easy-to-use tricks, tips, and techniques for: * Streamlining your toolbars (Word alone has dozens to choose from) * Setting up Outlook, searching with folders, organizing with flags, and dealing with spam * Taking proper security measures, including using and updating an antivirus package and avoiding potentially dangerous file extensions * Editing and laying out impressive Word documents * Using keyboard shortcuts * Diving into more advanced Office skills such as writing macros, setting up templates, and using multimedia with PowerPoint * Using Excel to build self-verifying spreadsheets * Running totals and subtotals in Access * Combining applications to print holiday greetings and run an electronic newsletter

---

Table of contents :
Team DDU……Page 1
Table Of Contents……Page 14
About This Book……Page 22
What’s in This Book……Page 23
Part IV: Exploiting Excel……Page 24
Icons Used in This Book……Page 25
Where to Go from Here……Page 26
Part I: Knocking Office Into Shape……Page 28
Updating Windows Manually……Page 30
Showing Filename Extensions……Page 32
Using an Antivirus Product……Page 33
Firewalling……Page 34
Empowering Quick Launch……Page 36
Putting Office Apps on the Quick Launch Toolbar……Page 37
Changing Quick Launch Names……Page 39
Changing Start Menu Names……Page 40
Understanding Your Requirements……Page 42
Translating Requirements to Reality……Page 44
Technique 4: Drilling Down with the My Places Bar……Page 46
Adding Locations to the My Places Bar……Page 47
Showing More Icons on the My Places Bar……Page 48
Hiding Built-In Icons……Page 49
Backing up your My Places settings……Page 50
Tweaking My Places in the Registry……Page 51
Backing Up: Why Pay More?……Page 54
Choosing Which Files to Back Up……Page 55
Finding your Office files……Page 56
Running ZipBackup……Page 57
Scheduling ZipBackup……Page 60
Patching Jargon: A Rose by Any Other Name……Page 62
Finding (And Using) Office Update……Page 64
Applying Patches Manually……Page 65
Identifying Versions to Get Help……Page 66
Updating Office 97……Page 68
Updating Office XP……Page 69
Understanding IntelliNONsense……Page 70
Turning Off Automatic Hyperlinks……Page 71
Creating a Manual Hyperlink – Quickly……Page 73
Fixing the Research Pane……Page 74
Looking in the Dictionary……Page 76
Using the Encarta Encyclopedia……Page 77
Searching for Business……Page 78
Working with the Office Clipboard versus the Windows Clipboard……Page 80
Moving Stuff Onto and Off the Office Clipboard……Page 82
Customizing the Clipboard……Page 83
Replacing the Office Clipboard……Page 84
Exploiting Vital Shortcuts……Page 85
Using Word Shortcuts……Page 87
Using Excel Shortcuts……Page 89
Using PowerPoint Shortcuts……Page 90
Drawing on the Drawing Layer(s)……Page 91
Constraining a line……Page 94
Fletching an arrow……Page 95
Rolling your own shapes……Page 96
Adding AutoShapes……Page 97
Grouping, Aligning, and Distributing……Page 99
Picking Your Compression Battles……Page 100
Compressing an Image……Page 102
Using Toolbars Effectively……Page 104
Adding Recommended Icons……Page 106
Making Any Command a Toolbar Icon……Page 107
Making Help Visible……Page 110
Popping the Question……Page 112
Drilling Down Fast……Page 113
Digging Deeper: The Knowledge Base……Page 114
Finding Help from Other Users……Page 116
Part II: Saving Time with Word……Page 118
Blistering the Bouncing Menus……Page 120
Seeing Clearly……Page 121
Zapping the Drawing Canvas……Page 123
Taking Back Your Mouse……Page 124
Correcting AutoCorrect……Page 125
Making Final Timesaving Changes……Page 126
Saving Your Settings……Page 128
Customizing Blank Documents……Page 129
Creating New Templates……Page 132
Making Privacy Settings Stick……Page 133
Setting Formatting for Drawings……Page 134
Seeing Word’s Way……Page 137
Laying Out Forms with Tabs……Page 139
Aligning Text with Tables……Page 141
Cramming Lists with Snaking Columns……Page 143
Linking Text with Text Boxes……Page 146
Technique 18: Making Professional Labels……Page 148
Creating and Printing Simple Labels……Page 149
Customizing a Template for Fancy Labels……Page 150
Filling In and Printing Labels from a Template……Page 154
Micro-Adjusting Pictures……Page 155
Editing in a SharePoint World……Page 157
Tracking Changes……Page 158
Turning on Track Changes……Page 159
Working with Track Changes in Word 2003……Page 160
Making Comments……Page 161
Changing the Font of Tracked Changes and Comments……Page 162
Reviewing and Finalizing a Document……Page 163
Using Editing Tools the Timesaving Way……Page 164
Streamlining Text Searches……Page 166
Searching for More Than Plain Text……Page 168
Matching Wildcards……Page 170
Replacing with wildcards……Page 173
Removing extra paragraph marks……Page 174
Getting Styles……Page 176
Applying Styles……Page 177
Finding Styles……Page 180
Modifying a style……Page 182
Numbering headings automatically……Page 183
Making New Styles……Page 186
Refreshing Styles to Match a Template……Page 187
Creating a Linked Table of Contents Automatically……Page 189
Linking Text to Headings in a Document……Page 190
Creating Custom Links That Are Hard to Break……Page 191
Making Letterhead Decisions……Page 193
Creating a New Letterhead Template……Page 194
Laying Out the Letterhead……Page 195
Altering Template Settings……Page 196
Adding Text to Your Letterhead Template……Page 199
Making Dates – With a Macro……Page 201
Distributing the Letterhead Template……Page 203
Working with the Drawing Layer……Page 204
Making a Picture Float……Page 206
Moving Pictures Small Distances……Page 209
Creating Consistent-Looking Fractions……Page 211
Creating the fractions you want to use……Page 212
Entering fraction sets in AutoCorrect……Page 214
Part III: Streamlining Outlook……Page 216
Strolling through the Panes……Page 218
Controlling the Navigation Pane……Page 219
Displaying Your Contacts and Calendar in Separate Windows……Page 220
Moving More Mail Faster……Page 221
Slimming down the Message List pane……Page 222
Downloading only the images you want to see……Page 223
Adjusting the E-Mail Editor Settings……Page 224
Making Other Timesaving Changes……Page 226
Using Search Folders……Page 227
Creating Search Folders……Page 229
Rationalizing Search Folders……Page 231
Flagging mail you’ve received……Page 233
Tacking other information to a flag……Page 234
Following Up on Flags……Page 235
Moving the Flag Column……Page 236
Understanding AutoComplete……Page 238
Setting the Address Book Straight……Page 240
Employing an Ounce of Prevention……Page 243
Deploying a Pound of Cure……Page 247
Understanding the Classic Hooks……Page 250
Phishing for Fun and Profit……Page 252
Keeping phishers at bay……Page 253
Understanding Draconian Blocks……Page 255
Bypassing the Blocks……Page 258
Getting a Digital Certificate……Page 260
Using a Digital Certificate……Page 262
Encrypting Messages……Page 263
Part IV: Exploiting Excel……Page 266
Bagging the Bouncing Menus……Page 268
Making Key Changes……Page 269
Setting up the Options dialog box and AutoCorrect……Page 270
Increasing the levels of undo……Page 272
Modifying Your Default Spreadsheet……Page 273
Highlighting Conditionally……Page 276
Running Self-Verifying Cross-Totals……Page 278
Freezing Column Headings……Page 282
Splitting the Screen……Page 283
Printing Repeating Column Headings……Page 284
Bending an Elbow at A1……Page 285
Making a List, Checking It Twice……Page 287
Filling In Data with AutoComplete……Page 289
AutoFiltering to Find Stuff Fast……Page 290
Setting up data for AutoFiltering……Page 292
Generating the totals……Page 294
Showing Subtotals……Page 295
Using Fill Lists……Page 297
Making Your Own AutoFill Series……Page 300
Creating a Pivot Table……Page 302
Manipulating a Pivot Table……Page 304
Making a Pivot Table Boogie……Page 306
Starting with a Good List……Page 310
Building a Pivot Chart……Page 311
Re-Creating a Pivot Chart……Page 312
Changing the Chart Type……Page 313
Gussying Up Pivot Charts……Page 314
Technique 42: Setting Scenarios and Seeking Goals……Page 315
Building a Loan Amortization Spreadsheet……Page 316
Establishing Scenarios……Page 317
Working Backward: Goal Seeking……Page 319
Technique 43: Using the Lookup Wizard……Page 321
Primping a List for Lookup……Page 322
Running a Comparative Lookup……Page 323
Running an Exact Lookup……Page 326
Part V: Pushing PowerPoint……Page 328
Working through the Changes……Page 330
Setting the View……Page 331
Taking Back Control……Page 332
Reversing a Privacy-Busting Setting……Page 333
Installing All Your Templates……Page 334
Understanding PowerPoint File Types……Page 335
Saving Files to Run Automatically……Page 336
Adding a Custom Presentation Skeleton to the AutoContent Wizard……Page 337
Understanding Blank Presentations……Page 340
Creating a Bare-Bones Blank Presentation……Page 341
Using Slide Masters……Page 343
Using Recorded Narrations……Page 345
Creating a Narration……Page 346
Editing a Narration……Page 348
Choosing Self-Running Transitions……Page 350
Looping a Presentation Continuously……Page 351
Applying slide timing manually……Page 352
Adding timing settings with a rehearsal timing……Page 353
Adding Navigation Action Buttons……Page 354
Planning for the Predictable……Page 356
Creating the Supporting Slide……Page 357
Running Several Supporting Slides……Page 360
Technique 50: Building toward a Goal……Page 362
Reducing the Goal Slide……Page 363
Building Forward to the Goal Slide……Page 365
Choosing the Right Player……Page 367
Inserting Multimedia with Native PowerPoint Tools……Page 368
Inserting a Media Player Movie……Page 369
Packaging for CD……Page 372
Playing the Burned CD……Page 374
Covering Your B…ases……Page 375
Part VI: Assimilating Access……Page 378
Setting Access Startup Options……Page 380
Changing Access Defaults……Page 382
Generating a Report……Page 385
Creating the Cover Sheet……Page 387
Centering the report title……Page 388
Adding text to the cover sheet……Page 389
Setting up the totals……Page 391
Setting up groups……Page 393
Displaying Subtotals and Totals……Page 394
Running the Access Label Wizard……Page 397
Tweaking the Label Wizard’s Results……Page 399
Creating Custom Labels and Reports……Page 401
Understanding Access Formatting……Page 403
Setting Custom Defaults……Page 404
Changing defaults via the Properties window……Page 405
Changing defaults using an existing control……Page 406
Creating a Form Template……Page 407
Using a Form Template……Page 408
Understanding the Forms……Page 410
Creating the Omnipotent Form……Page 411
Modifying the Form……Page 412
Using the Modified Form……Page 415
Applying an AutoFormat……Page 416
Customizing AutoFormat Styles……Page 418
Deleting Old Styles……Page 420
Part VII: Combining the Applications……Page 422
Choosing an Insertion Method……Page 424
Copying Data……Page 425
Embedding a Spreadsheet……Page 427
Linking a Spreadsheet……Page 430
Choosing to Start a Newsletter……Page 432
Creating and maintaining a subscriber list……Page 433
Creating and sending the newsletter……Page 435
Using a Newsletter Service……Page 436
Growing Larger Gracefully……Page 438
Understanding Outline Levels……Page 439
Converting a TOC to a Presentation……Page 441
Converting a Presentation to a TOC……Page 442
Building Charts in Excel……Page 445
Putting a Chart on a Slide……Page 447
Animating the Chart……Page 449
Running Fine-Grain Animation……Page 452
Rotating Text with Word Tools……Page 454
Making a Name Tent……Page 456
Rotating Any Text……Page 457
Part VIII: The Scary (Or Fun!) Stuff……Page 460
Seeing Word’s Critical Marks……Page 462
Building a Better Show/Hide……Page 463
Writing the Macro……Page 464
Word Pasting 101……Page 466
Writing a Pasting Macro……Page 468
Assigning a Shortcut to the Pasting Macro……Page 469
Technique 67: Inserting Unformatted Text in Excel……Page 471
Recording a Macro……Page 472
Editing an Excel Macro……Page 474
Technique 68: Printing a Bunch of Spreadsheets – Fast……Page 476
Building the PrintWorkbooks Macro……Page 477
Running and Testing the Macro……Page 480
Assigning the Macro to a Button……Page 481
Seeing the Hidden Stuff……Page 483
Zapping the Embarrassing Stuff……Page 484
Understanding Mass Mailing……Page 486
Entering and Updating Contacts……Page 487
Checking Contacts……Page 489
Printing Personalized Newsletters……Page 491
Printing Envelopes……Page 493
E-mailing Holiday Greetings……Page 495
Setting a Standard Watermark……Page 496
Modifying Watermark WordArt……Page 497
Making Watermarks Appear on the First Page Only……Page 499
Using Built-in Stationery……Page 501
Setting up stationery in Word……Page 502
Setting up stationery in Outlook……Page 503
Creating Your Own Stationery……Page 504
Index……Page 506