Microsoft Office 2007 On Demand

Contents......Page 8
Introduction......Page 22
1 Getting Started with Office......Page 26
Starting an Office Program......Page 27
Viewing an Office Program Window......Page 28
Using the Ribbon......Page 29
Choosing Commands......Page 30
Working with Toolbars......Page 31
Choosing Dialog Box Options......Page 33
Using the Status Bar......Page 34
Creating a Blank Office Document......Page 35
Creating a Document Using a Template......Page 36
Opening an Existing Office Document......Page 37
Converting an Existing Office Document......Page 39
Using Task and Window Panes......Page 40
Arranging Windows......Page 41
Getting Help While You Work......Page 43
Saving an Office Document......Page 45
Saving an Office Document with Different Formats......Page 47
Checking Compatibility......Page 49
Documenting Properties......Page 50
Switching Views......Page 51
Getting Updates on the Web......Page 52
Recovering an Office Document......Page 53
Diagnosing and Repairing Problems......Page 55
Closing a Document and Exiting Office......Page 57
2 Using Shared Office Tools......Page 58
Editing Text......Page 59
Copying and Moving Text......Page 61
Finding and Replacing Text......Page 63
Correcting Text Automatically......Page 65
Inserting Information the Smart Way......Page 67
Checking Spelling......Page 69
Changing Proofing Options......Page 70
Using Custom Dictionaries......Page 71
Inserting Symbols......Page 72
Finding the Right Words......Page 73
Inserting Research Material......Page 74
Translating Text to Another Language......Page 75
Using Multiple Languages......Page 76
Undoing and Redoing an Action......Page 77
Zooming the View In and Out......Page 78
Previewing a Document......Page 79
Printing a Document......Page 80
Creating a Template......Page 81
3 Adding Art to Office Documents......Page 82
Locating and Inserting Clip Art......Page 83
Inserting a Picture......Page 84
Adding a Quick Style to a Picture......Page 85
Applying a Shape to a Picture......Page 86
Applying a Border to a Picture......Page 87
Applying Picture Effects......Page 88
Modifying Picture Size......Page 89
Compressing a Picture......Page 91
Modifying Picture Brightness and Contrast......Page 92
Recoloring a Picture......Page 93
Cropping and Rotating a Picture......Page 95
Scanning and Imaging Documents......Page 96
Managing Pictures......Page 97
Creating WordArt Text......Page 98
Formatting WordArt Text......Page 99
Applying WordArt Text Effects......Page 101
Modifying WordArt Text Position......Page 102
Creating SmartArt Graphics......Page 103
Formatting a SmartArt Graphic......Page 105
Modifying a SmartArt Graphic......Page 107
Creating an Organization Chart......Page 108
Modifying an Organization Chart......Page 109
Inserting and Creating a Chart......Page 110
Changing a Chart Type......Page 111
Changing a Chart Layout and Style......Page 112
Changing Chart Titles......Page 113
Changing Chart Labels......Page 114
Formatting Line and Bar Charts......Page 115
Editing Chart Data......Page 116
Saving a Chart Template......Page 117
4 Adding Shapes to Office Documents......Page 118
Drawing and Resizing Shapes......Page 119
Adding Text to a Shape......Page 121
Creating and Editing Freeforms......Page 122
Adding a Quick Style to a Shape......Page 123
Adding a Quick Style to Shape Text......Page 124
Applying Color Fills......Page 125
Applying Picture or Texture Fills......Page 127
Applying Gradient Fills......Page 128
Applying Shape Effects......Page 129
Aligning and Distributing Objects......Page 131
Aligning Objects to Grids and Guides......Page 133
Changing Stacking Order......Page 135
Rotating and Flipping Objects......Page 136
Grouping and Ungrouping Objects......Page 137
Selecting Objects Using the Selection Pane......Page 139
5 Formatting Office Documents......Page 140
Formatting Text......Page 141
Changing Alignment......Page 143
Using the Format Painter......Page 145
Adding Custom Colors......Page 146
Understanding Themes......Page 147
Viewing and Applying a Theme......Page 148
Creating Theme Colors......Page 149
Choosing Theme Fonts......Page 151
Choosing Theme Effects......Page 153
Creating a Custom Theme......Page 154
Choosing a Custom Theme......Page 155
6 Creating a Document with Word......Page 156
Viewing the Word Window......Page 157
Moving Around in a Document......Page 158
Changing Document Views......Page 159
Reading a Document......Page 161
Setting Up the Page......Page 163
Setting Up the Page Margins......Page 165
Creating an Outline......Page 167
Selecting Text......Page 168
Checking Spelling and Grammar......Page 169
Inserting New Pages and Sections......Page 171
Adding Headers and Footers......Page 173
Inserting Page Numbers and the Date and Time......Page 175
7 Formatting a Document with Word......Page 178
Formatting Text for Emphasis......Page 179
Finding and Replacing Formatting......Page 181
Changing Paragraph Alignment......Page 183
Changing Line Spacing......Page 184
Displaying Rulers......Page 185
Setting Paragraph Tabs......Page 186
Setting Paragraph Indents......Page 187
Changing Character Spacing......Page 189
Applying a Quick Style......Page 190
Changing a Style Set......Page 191
Creating and Modifying Styles......Page 193
Creating Bulleted and Numbered Lists......Page 195
Hiding Text......Page 197
8 Enhancing a Document with Word......Page 198
Adding Desktop Publishing Effects......Page 199
Adding a Watermark......Page 200
Adding Page Backgrounds......Page 201
Adding Text in Columns......Page 203
Wrapping Text Around an Object......Page 205
Working with Text Boxes......Page 207
Inserting Building Blocks Using Quick Parts......Page 209
Creating a Table......Page 211
Entering Text in a Table......Page 212
Modifying a Table......Page 213
Adjusting Table Cells......Page 215
Formatting a Table......Page 217
Calculating a Value in a Table......Page 219
Addressing Envelopes and Labels......Page 220
Creating a Form Letter......Page 221
Creating Labels......Page 223
Inserting a Table of Contents......Page 225
Creating an Index......Page 226
Creating Captions......Page 227
Creating a Table of Figures......Page 228
Creating Footnotes or Endnotes......Page 229
Creating a Bookmark......Page 230
Inserting Cross References......Page 231
Comparing and Merging Documents......Page 232
Using Track Changing......Page 233
Adding a Cover Page......Page 235
9 Creating a Worksheet with Excel......Page 236
Viewing the Excel Window......Page 237
Selecting Cells......Page 238
Moving Around the Workbook......Page 239
Entering Labels on a Worksheet......Page 241
Entering Values on a Worksheet......Page 243
Entering Values Quickly with AutoFill......Page 244
Editing Cell Contents......Page 245
Clearing Cell Contents......Page 246
Inserting and Deleting Cell Contents......Page 247
Selecting Rows, Columns, and Special Ranges......Page 249
Selecting and Naming a Worksheet......Page 251
Inserting and Deleting a Worksheet......Page 252
Moving and Copying a Worksheet......Page 253
Hiding and Unhiding Worksheets and Workbooks......Page 255
Hiding and Unhiding a Column or Row......Page 256
Inserting a Column or Row......Page 257
Deleting a Column or Row......Page 258
Adjusting Column Width and Row Height......Page 259
Splitting a Worksheet into Panes......Page 261
Freezing and Unfreezing a Column or Row......Page 262
Showing and Hiding Workbook Elements......Page 263
10 Building a Worksheet with Excel......Page 264
Understanding Formulas......Page 265
Understanding Cell Referencing......Page 266
Creating a Simple Formula......Page 267
Creating a Formula Using Formula AutoComplete......Page 269
Editing a Formula......Page 270
Naming Cells and Ranges......Page 271
Entering Named Cells and Ranges......Page 273
Managing Names......Page 275
Simplifying a Formula with Ranges......Page 277
Calculating Totals with AutoSum......Page 278
Correcting Formulas......Page 279
Auditing a Worksheet......Page 281
Creating Functions......Page 282
Creating Functions Using the Library......Page 283
Calculating Multiple Results......Page 284
Using Nested Functions......Page 285
Using Text Functions......Page 286
Using Lookup and Reference Functions......Page 287
Summarizing Data Using Subtotals......Page 289
Summarizing Data Using Functions......Page 290
Converting Text to Columns......Page 291
Creating a Table......Page 292
Formatting a Table......Page 293
Formatting Table Elements......Page 294
Creating Calculations in a Table......Page 295
Removing Table Rows and Columns......Page 296
Working with Tables......Page 297
Sorting Data in a Table......Page 299
Displaying Parts of a Table with AutoFilter......Page 301
Creating Custom Searches......Page 302
Creating Groups and Outlines......Page 303
Adding Data Validation to a Worksheet......Page 304
Creating a Drop-Down List......Page 305
11 Designing a Worksheet with Excel......Page 306
Formatting Numbers......Page 307
Applying and Creating Cell Styles......Page 309
Applying Conditional Formatting......Page 311
Applying Specialized Conditional Formatting......Page 313
Creating Conditional Formatting......Page 315
Managing Conditional Formatting......Page 316
Controlling Text Flow......Page 317
Formatting Tabs and Background......Page 318
Adding Borders to Cells......Page 319
Setting Up the Page......Page 320
Adjusting Page Margins......Page 321
Adding Headers and Footers......Page 323
Inserting Page Breaks......Page 325
Customizing Worksheet Printing......Page 327
Setting the Print Area......Page 329
12 Creating a Presentation with PowerPoint......Page 330
Viewing the PowerPoint Window......Page 331
Browsing a Presentation......Page 332
Understanding PowerPoint Views......Page 333
Creating New and Consistent Slides......Page 335
Working with Objects......Page 337
Entering and Editing Text......Page 339
Resizing Text While Typing......Page 341
Changing Character Direction......Page 342
Inserting and Developing an Outline......Page 343
Moving and Indenting Text......Page 345
Modifying a Bulleted and Numbered List......Page 347
Creating Text Columns......Page 349
Changing Text Spacing......Page 350
Rearranging Slides......Page 351
Using Slides from Other Presentations......Page 353
Making Your Presentation Look Consistent......Page 354
Controlling Slide Appearance with Masters......Page 355
Controlling a Slide Layout with Masters......Page 357
Modifying Placeholders......Page 359
Controlling a Slide Background with Masters......Page 361
Adding a Background Style......Page 362
Inserting a Table......Page 363
Modifying a Table......Page 364
Formatting a Table......Page 365
Adding a Quick Style to a Table......Page 366
Creating a Text Box......Page 367
13 Delivering a Presentation with PowerPoint......Page 368
Changing Page Setup Options......Page 369
Adding Animation......Page 370
Using Specialized Animations......Page 371
Coordinating Multiple Animations......Page 373
Adding Slide Timings......Page 375
Creating Slide Transitions......Page 377
Recording a Narration......Page 378
Inserting Movies and Sounds......Page 379
Setting Movie and Sound Play Options......Page 380
Setting Up a Slide Show......Page 381
Creating a Custom Slide Show......Page 383
Starting a Slide Show......Page 384
Navigating a Slide Show......Page 385
Annotating a Slide Show......Page 386
Packaging a Presentation on CD......Page 387
Saving a Presentation as a Slide Show......Page 389
Preparing Handouts......Page 390
Preparing Speaker Notes......Page 391
Adding a Footer and Header......Page 393
Inserting the Date and Time......Page 394
Inserting Slide Numbers......Page 395
Previewing Slides......Page 397
Printing a Presentation......Page 398
14 Creating a Database with Access......Page 400
Understanding How Databases Store Data......Page 401
Creating a Database......Page 403
Viewing the Access Window......Page 405
Changing Database Display Options......Page 406
Viewing Database Objects......Page 407
Working with Database Objects......Page 409
Planning Tables......Page 411
Creating a Table by Entering Data......Page 412
Creating a Table Using a Template......Page 413
Creating a Table Using SharePoint......Page 414
Working with a Table......Page 415
Importing Data into Tables......Page 417
Working with a Table in Design View......Page 418
Working with Fields......Page 419
Specifying Data Types and Field Properties......Page 421
Changing Field Properties......Page 422
Creating Input Masks......Page 423
Creating a Lookup Field......Page 424
Planning Table Relationships......Page 425
Defining Table Relationships......Page 427
Ensuring Referential Integrity......Page 429
15 Locating and Managing Data with Access......Page 430
Sorting Records......Page 431
Filtering Out Records......Page 432
Creating Complex Filters Using Forms......Page 433
Understanding the Different Types of Queries......Page 434
Creating a Query Using a Wizard......Page 435
Creating a Query in Design View......Page 437
Getting Information with a Query......Page 438
Modifying a Query in Design View......Page 439
Performing Calculations in Queries......Page 440
Summarizing Values with a Crosstab Query......Page 441
Creating a Parameter Query......Page 443
Finding Duplicate Fields......Page 444
Identifying Object Dependencies......Page 445
Backing Up a Database......Page 446
Compacting and Repairing a Database......Page 447
16 Presenting Data with Access......Page 448
Creating a Form......Page 449
Working with a Form in Design View......Page 451
Entering and Editing Data in a Form......Page 452
Modifying a Form......Page 453
Creating a Report......Page 455
Modifying a Report in Design View......Page 457
Performing Calculations in Reports......Page 459
Formatting a Form or Report......Page 461
Aligning and Grouping Controls......Page 463
Grouping and Sorting in Reports......Page 465
Formatting a Datasheet......Page 467
Changing the Page Setup......Page 468
Previewing and Printing Information......Page 469
Creating Mailing Labels......Page 471
17 Communication with Outlook......Page 472
Preparing for Outlook......Page 473
Using Outlook for the First Time......Page 474
Viewing the Outlook Window......Page 475
Using Outlook Today......Page 476
Using the Navigation Pane......Page 477
Viewing Items and Folders......Page 478
Creating a Contact......Page 479
Sorting Contacts......Page 481
Creating a Distribution List......Page 482
Creating and Addressing and E-Mail Message......Page 483
Formatting Message Text......Page 485
Attaching a File or Item to a Message......Page 486
Using Stationery......Page 487
Creating a Signature......Page 488
Inserting Message Content......Page 489
Sending Messages......Page 490
Setting Message Delivery Options......Page 491
Receiving and Reading Messages......Page 493
Flagging Messages......Page 494
Categorizing Messages By Color......Page 495
Deleting Messages......Page 496
Replying To and Forwarding a Message......Page 497
Finding and Filtering Messages......Page 499
Organizing Messages in Folders......Page 501
Managing Messages with Colors and Rules......Page 503
Using Search Folders......Page 505
Reducing Junk E-Mail......Page 507
Archiving Messages......Page 508
Working with Outlook Data......Page 509
Sending and Receiving Instant Messages......Page 511
Enabling Instant Messaging......Page 513
18 Managing Information with Outlook......Page 514
Viewing the Calendar......Page 515
Customizing the Calendar......Page 516
Scheduling an Appointment and Event......Page 517
Scheduling Meetings......Page 519
Responding to Meeting Requests......Page 521
Updating and Canceling Meeting Requests......Page 523
Creating an Online Meeting Workspace......Page 524
Creating and Updating Tasks......Page 525
Organizing Tasks......Page 526
Assigning Tasks to Others......Page 527
Monitoring Task Progress......Page 528
Managing Tasks......Page 529
Tracking Activities with Contacts......Page 530
Recording Items in the Journal......Page 531
Opening and Modifying Journal Entries......Page 533
Organizing Items by Categories......Page 534
Customizing How You View Items......Page 535
Creating and Modifying Notes......Page 537
Previewing Items from Outlook......Page 538
Printing Items from Outlook......Page 539
Customizing Panes......Page 540
Sharing Calendars Over the Internet......Page 541
Adding and Viewing an RSS Feed......Page 543
19 Creating a Publication with Publisher......Page 544
Viewing the Publisher Window......Page 545
Creating a Quick Publication......Page 546
Creating a New Publication......Page 547
Creating a Blank Publication......Page 548
Changing Your View......Page 549
Inserting and Deleting Pages......Page 550
Inserting and Editing Text......Page 551
Creating a Web Site......Page 553
Adding a Hot Spot Hyperlink......Page 555
Applying Color......Page 556
Adding Design Gallery Elements......Page 557
Checking Your Design......Page 558
Setting Up the Page......Page 559
Using Commercial Printing Tools......Page 560
Printing Publications......Page 561
20 Designing a Publication with Publisher......Page 562
Setting Up Layout Guides......Page 563
Creating a Frame......Page 564
Working with Text......Page 565
Connecting Text Frames......Page 567
Creating a Consistent Look......Page 569
Creating Tables......Page 571
Working with Pictures and Shapes......Page 573
Wrapping Text Around an Object......Page 575
Layering Objects......Page 577
Grouping Objects Together......Page 578
Aligning with Precision......Page 579
Rotating and Flipping Objects......Page 581
21 Publishing Office Documents on the Web......Page 582
Opening a Web Page......Page 583
Previewing a Web Page......Page 584
Creating a Hyperlink......Page 585
Adding Hyperlinks to Slide Objects......Page 587
Formatting a Cell Hyperlink......Page 589
Changing Web Page Options......Page 590
Saving a Web Page......Page 591
Publishing a Web Page......Page 593
Saving Slides as Web Graphics......Page 594
Creating Refreshable Web Queries......Page 595
Getting Data from Web Queries......Page 596
Saving Web Queries......Page 597
Accessing Office Information on the Web......Page 598
Getting Documents from the Web......Page 599
22 Protecting and Securing Office Documents......Page 600
Inspecting Documents......Page 601
Protecting a Worksheet......Page 603
Locking or Unlocking Worksheet Cells......Page 605
Adding Security Encryption to a Document......Page 606
Adding Password Protection to a Document......Page 607
Restricting Document Access......Page 609
Adding a Digital Signature......Page 611
Adding a Signature Line......Page 613
Avoiding Harmful Attacks......Page 615
Using the Trust Center......Page 617
Selecting Trusted Publishers and Locations......Page 618
Setting Add-in Security Options......Page 619
Setting ActiveX Security Options......Page 620
Setting Macro Security Options......Page 621
Changing Message Bar Security Options......Page 622
Setting Privacy Options......Page 623
Setting External Content Security Options......Page 625
Working with Office Safe Modes......Page 627
Marking a Document as Read-Only......Page 629
23 Reviewing and Sharing Office Documents......Page 630
Sharing Workbooks......Page 631
Creating and Reading a Cell Comment......Page 633
Editing and Deleting a Cell Comment......Page 634
Adding Comments to a Presentation......Page 635
Tracking Changes......Page 637
Sending a Document for Review Using E-Mail......Page 639
Sending a Document by Internet Fax......Page 640
Working with XML......Page 641
Creating an XML Data Map......Page 643
Exporting and Saving Data in XML......Page 645
Creating a PDF Document......Page 647
Creating an XPS Document......Page 648
Sharing Information Between Programs......Page 649
Exporting and Importing Data......Page 651
Linking and Embedding Files......Page 653
Consolidating Data in Excel......Page 655
Linking Data in Excel......Page 657
Getting External Data in Excel......Page 658
Connecting to Data in Excel......Page 659
Getting Query Data from a Database......Page 661
Getting Data from Access......Page 663
Getting Text Data in Excel......Page 665
Working with a Shared Workspace......Page 666
Working with Excel Services......Page 667
Publishing Slides to a Library......Page 669
Saving a Document to a Document Management Server......Page 671
24 Expanding Office Functionality......Page 672
Viewing and Managing Add-ins......Page 673
Loading and Unloading Add-ins......Page 675
Enhancing a Document with VBA......Page 677
Viewing the Visual Basic Editor......Page 679
Setting Developer Options......Page 680
Understanding How Macros Automate Your Work......Page 681
Recording a Macro......Page 682
Creating a Macro......Page 683
Running a Macro......Page 684
Controlling a Macro......Page 685
Adding a Digital Signature to a Macro Project......Page 687
Assigning a Macro to a Toolbar......Page 688
Saving a Document with Macros......Page 689
Opening a Document with Macros......Page 690
Inserting ActiveX Controls......Page 691
Using ActiveX Controls......Page 693
Setting ActiveX Control Properties......Page 694
Adding VBA Code to an ActiveX Control......Page 695
Playing a Movie Using an ActiveX Control......Page 696
Changing the Document Information Panel......Page 697
New Features......Page 698
Microsoft Certified Applications Specialist......Page 708
A......Page 716
C......Page 720
D......Page 723
E......Page 724
F......Page 730
G......Page 731
I......Page 732
M......Page 733
N......Page 734
O......Page 735
P......Page 737
R......Page 744
S......Page 745
T......Page 748
W......Page 750
Z......Page 753