PC Magazine Office 2007 Solutions

PC Magazine Office 2007 Solutions......Page 1
Contents......Page 14
Introduction......Page 26
Part I: Getting Started......Page 32
Installing Microsoft Office 2007......Page 34
Before Installation......Page 35
Installation Step-by-Step......Page 36
Activation and Product Keys......Page 38
All About Registration......Page 39
What Office 2007 Brings to the Table......Page 40
New Features......Page 41
Summary......Page 42
Viruses and Antivirus Programs......Page 44
Custom-Configure Antivirus Programs......Page 45
Beware of Attachments......Page 48
Patch Security Holes......Page 50
Summary......Page 55
Basic Default Options......Page 56
Changing Where Files Are Stored by Default......Page 58
Creating New Organizational Folders......Page 62
Getting Organized......Page 63
Creating Your New Folder Structure......Page 64
Staying Organized over the Long Run......Page 67
Summary......Page 68
Part II: Avoiding Disasters......Page 70
Understanding Backup Media......Page 72
External Hard Drives......Page 73
Internet Options......Page 74
Drag Files to Any Drive......Page 75
Burning CDs and DVDs......Page 76
Backing Up E-mail......Page 77
Back Up Outlook 2007......Page 78
Restore Outlook 2007......Page 79
Using Search Folders......Page 80
Summary......Page 81
Setting Up Automatic Updates......Page 82
Getting Updates Manually......Page 83
Understanding Update Types......Page 87
Feature Packs......Page 88
Summary......Page 89
Using System Restore......Page 90
Enabling System Restore......Page 92
Creating a Restore Point......Page 93
Restoring to an Earlier Time......Page 94
Using the Office Interface......Page 96
Using the Operating System’s Search Tool......Page 97
Working with Recovered Files......Page 102
Locating Recovered Files......Page 103
Using the Microsoft Office Assistance Home Page......Page 104
Summary......Page 105
Part III: Exploring the New Interface......Page 106
Personalizing Office with Your Language, Name, and Initials......Page 108
Changing the Skin......Page 109
To View or Not to View......Page 111
Saving in Compatible Formats......Page 112
Using AutoCorrect to Save Key Strokes......Page 113
Using AutoCorrect to Add Mathematical Symbols......Page 114
Customizing the Quick Access Toolbar......Page 115
Summary......Page 117
Introducing a Results-Oriented Interface......Page 118
Exploring the Other Tabs......Page 120
Word: Changing Font Types, Font Size, and Styles......Page 121
PowerPoint: Inserting Objects......Page 123
Excel: Working With Formulas......Page 125
Introducing Contextual Tabs in PowerPoint......Page 126
Introducing Contextual Tabs in Word......Page 128
Introducing Contextual Tabs in Excel......Page 129
Summary......Page 130
Galleries and Quick Styles Explained......Page 132
Exploring Basic Features......Page 134
Using Quick Styles and Galleries......Page 135
Creating and Saving Your Own Quick Style......Page 137
Working with Excel Charts......Page 138
Working with Publisher Data......Page 139
Summary......Page 140
Part IV: Working Together......Page 142
Applying Proper File-Saving Techniques......Page 144
Organizing Your Files......Page 145
Applying File Protection......Page 147
Using a Workgroup Share......Page 149
Sharing Folders......Page 150
Working with Permissions......Page 152
Caching......Page 153
Saving in XML File Formats......Page 155
XML Default Document Extensions......Page 156
Summary......Page 159
Assigning Owners......Page 160
Determining Folder Permissions......Page 161
Granting Permissions......Page 162
Object Auditing......Page 163
Controlling User Access by Configuring Permissions......Page 164
File and Folder Permissions at a Glance......Page 165
Setting, Viewing, Changing, or Removing File and Folder Permissions......Page 167
Managing Project Data......Page 169
SharePoint Server 2007......Page 170
Summary......Page 171
Understanding Integrated Communication......Page 172
Knowing Who Is Online......Page 173
Using Instant Messaging......Page 174
Using SharePoint Services Technology and SharePoint Server 2007......Page 176
Using Office Groove 2007......Page 177
Understanding Shared Note-Taking......Page 179
Summary......Page 181
Part V: Writing with Word......Page 182
Word’s New Look......Page 184
Exploring New Tools and Features......Page 186
Customizing the Interface......Page 187
Enhancing Documents with Fonts and Headings......Page 190
Linking to Live Data from Charts, Diagrams, and Tables......Page 192
Inserting Pictures and Drawings......Page 194
Embellishing Your Documents with Easy Effects......Page 195
Inserting Special Characters......Page 196
Using Bullets, Numbers, and References......Page 197
Setting Tabs......Page 198
Summarizing Documents......Page 200
Creating Outlines......Page 201
Working Collaboratively......Page 202
Comparing and Combining Document Files......Page 203
Starting Mail Merge......Page 204
Write and Insert Fields......Page 205
Summary......Page 207
Accessing the Mini Toolbar......Page 208
Applying Formatting from the Mini Toolbar......Page 210
Getting Information from Super ToolTips......Page 211
Using the Document Inspector......Page 212
What You Can Get Rid Of......Page 213
Using Quick Parts......Page 215
Managing Documents with the Document Information Panel......Page 217
Summary......Page 219
Part VI: Presenting with PowerPoint......Page 220
Understanding PowerPoint’s New Look......Page 222
New Tools and Features......Page 223
Customizing the Interface......Page 225
Choosing a Presentation Template......Page 228
Using Slide Libraries......Page 229
Formatting Text......Page 230
Working with Objects......Page 233
Working with Diagrams and Charts......Page 237
Creating Charts......Page 238
Collaborating and Sharing......Page 239
Summary......Page 240
Converting Lists to Diagrams in Two Clicks......Page 242
Creating and Saving Custom Layouts......Page 244
Packaging for CD......Page 246
Summary......Page 247
Part VII: Managing Data with Excel......Page 248
Exploring the Interface......Page 250
Exploring the Excel 2007 Ribbon......Page 252
Customizing the Interface......Page 254
Formatting Worksheets......Page 255
Creating a Table......Page 256
Using Key Tips......Page 259
Exploring Page Layout View......Page 260
Creating Equations......Page 263
Using Formula AutoComplete......Page 264
Working with Function Arguments......Page 265
Database Basics......Page 266
Importing and Exporting Data......Page 267
Sorting and Filtering Data......Page 268
Creating Criteria......Page 270
Charting Data......Page 271
Creating PivotCharts......Page 272
Formatting Chart Elements......Page 273
Summary......Page 274
Creating Formulas with Ease......Page 276
Exploring New Charting Options......Page 280
Getting Better Printouts......Page 282
Working with Larger Workbooks......Page 283
Getting and Using Free Templates from the Web......Page 285
Summary......Page 287
Part VIII: Keeping in Touch with Outlook......Page 288
New Look......Page 290
Customizing the Interface......Page 291
Creating a Profile......Page 293
Editing and Deleting Profiles......Page 295
Working with Attachments......Page 296
Creating E-mail Signatures......Page 298
Using Stationery and Templates......Page 299
Creating an Out-of-Office Reply......Page 300
Sorting Options......Page 301
Search Folders......Page 302
Dealing with Spam......Page 303
Creating Rules......Page 304
Using the Calendar......Page 305
Exploring Scheduling Options......Page 306
Sharing Your Calendar......Page 307
Summary......Page 308
Using Integrated Search Features......Page 310
Using Instant Search......Page 311
Previewing Attachments with a Single Click......Page 312
Configuring Automatic Reminders for Procrastinators......Page 313
Sending a Calendar Page with Calendar Snapshots......Page 315
Customizing Electronic Business Cards......Page 316
Configuring the New RSS Reader......Page 318
Setting a Task List......Page 320
Summary......Page 323
Part IX: Managing Data with Access......Page 324
Introducing the Navigation Pane......Page 326
Exploring the Ribbon......Page 328
New Tools and Features......Page 329
Customizing the Interface......Page 330
Using Access 2007 for the First Time......Page 331
Creating a New Database......Page 332
Creating a Database from a Template......Page 333
Opening an Existing Database......Page 334
Importing Data into Access......Page 335
Exporting Data from Access into Excel......Page 340
Creating Good Tables......Page 341
Setting Field Properties......Page 342
Understanding and Using Forms......Page 343
Working with Data......Page 349
Understanding Relationships......Page 350
Querying the Database with a Simple Select Query......Page 352
Using Group, Sort, and Total......Page 355
Summary......Page 356
Using Prebuilt Database Solutions......Page 358
Working with Embedded Macros and New Macro Actions......Page 360
Sharing Tracked Information with Others......Page 362
More about Data Collection......Page 363
Incorporating PDF and XPS Support......Page 365
Grouping Information......Page 366
Using New Field Types......Page 368
Using Attachments......Page 369
Creating Multivalued Fields......Page 370
Summary......Page 371
Part X: Publishing with Publisher......Page 372
New Look......Page 374
New Features and Tools......Page 376
Working with Text......Page 378
Working Inside a Text Box......Page 379
Exploring Formatting Options......Page 380
Creating Live Links......Page 384
Working with Multiple Pages......Page 385
Laying Out Your Publication......Page 387
Adding Objects......Page 388
Finalizing Your Publication......Page 391
Summary......Page 393
Accessing New Design Templates......Page 394
Importing Word Documents into Publisher......Page 396
Customizing the Content Library......Page 397
Using Publisher Tasks......Page 398
Double-Checking with Design Checker......Page 399
Publishing to the Web......Page 401
Summary......Page 402
Part XI: Doing Even More with Office......Page 404
Understanding Web Pages......Page 406
Understanding HTML......Page 407
Creating Basic Web Pages......Page 408
Microsoft Word Documents......Page 409
PowerPoint Slides......Page 411
Adding and Removing Hyperlinks......Page 412
Tweaking Your Web Page Settings......Page 415
Previewing Your Web Pages......Page 417
Summary......Page 418
Exploring Office’s Open Dialog Box......Page 420
Searching from the Start Menu with Vista......Page 424
Creating Manual Searches......Page 425
Saving Searches with a Search Folder......Page 426
Using Outlook and Vista......Page 428
Using Outlook for RSS Feeds......Page 429
Summary......Page 431
Understanding OneNote......Page 432
Understanding Outlook with Business Contact Manager......Page 434
Understanding Integrated Enterprise Content Management......Page 435
Understanding Information Rights Management and Policy Capabilities......Page 436
Summary......Page 437
Index......Page 438