Microsoft Office 2007 on Demand

by Johnson, Steve; Perspection Inc.

• ISBN13: 9780789736406
• ISBN10: 0789736403
• Edition: 1st
• Format: Paperback
• Copyright: 2006-12-18
• Publisher: Que Pub

Summary

The ultimate full-colour, task-oriented guide for those who want to become Office 2007 power users.

Author Biography

Steve Johnson has written more than 35 books on a variety of computer software, including Microsoft Office 2007 and 2003, Microsoft Windows XP, Apple Mac OS X Panther, Macromedia Flash MX 2004 and 8, Macromedia Director MX 2004, Macromedia Fireworks, and Adobe Photoshop CS and CS2. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. When time permits, he likes to travel to such places as New Hampshire in October, and Hawaii. Steve and his family live in Pleasanton, California, but can also be found visiting family all over the western United States.

Table of Contents

Introduction	p. xxi
Getting Started with Office	p. 1
Starting an Office Program	p. 2
Viewing an Office Program Window	p. 3
Using the Ribbon	p. 4
Choosing Commands	p. 5
Working with Toolbars	p. 6
Choosing Dialog Box Options	p. 8
Using the Status Bar	p. 9
Creating a Blank Office Document	p. 10
Creating a Document Using a Template	p. 11
Opening an Existing Office Document	p. 12
Converting an Existing Office Document	p. 14
Using Task and Window Panes	p. 15
Arranging Windows	p. 16
Getting Help While You Work	p. 18
Saving an Office Document	p. 20
Saving an Office Document with Different Formats	p. 22
Checking Compatibility	p. 24
Documenting Properties	p. 25
Switching Views	p. 26
Getting Updates on the Web	p. 27
Recovering an Office Document	p. 28
Diagnosing and Repairing Problems	p. 30
Closing a Document and Exiting Office	p. 32
Using Shared Office Tools	p. 33
Editing Text	p. 34
Copying and Moving Text	p. 36
Finding and Replacing Text	p. 38
Correcting Text Automatically	p. 40
Inserting Information the Smart Way	p. 42
Checking Spelling	p. 44
Changing Proofing Options	p. 45
Using Custom Dictionaries	p. 46
Inserting Symbols	p. 47
Finding the Right Words	p. 48
Inserting Research Material	p. 49
Translating Text to Another Language	p. 50
Using Multiple Languages	p. 51
Undoing and Redoing an Action	p. 52
Zooming the View In and Out	p. 53
Previewing a Document	p. 54
Printing a Document	p. 55
Creating a Template	p. 56
Adding Art to Office Documents	p. 57
Locating and Inserting Clip Art	p. 58
Inserting a Picture	p. 59
Adding a Quick Style to a Picture	p. 60
Applying a Shape to a Picture	p. 61
Applying a Border to a Picture	p. 62
Applying Picture Effects	p. 63
Modifying Picture Size	p. 64
Compressing a Picture	p. 66
Modifying Picture Brightness and Contrast	p. 67
Recoloring a Picture	p. 68
Cropping and Rotating a Picture	p. 70
Scanning and Imaging Documents	p. 71
Managing Pictures	p. 72
Creating WordArt Text	p. 73
Formatting WordArt Text	p. 74
Applying WordArt Text Effects	p. 76
Modifying WordArt Text Position	p. 77
Creating SmartArt Graphics	p. 78
Formatting a SmartArt Graphic	p. 80
Modifying a SmartArt Graphic	p. 82
Creating an Organization Chart	p. 83
Modifying an Organization Chart	p. 84
Inserting and Creating a Chart	p. 85
Changing a ChartType	p. 86
Changing a Chart Layout and Style	p. 87
Changing Chart Titles	p. 88
Changing Chart Labels	p. 89
Formatting Line and Bar Charts	p. 90
Editing Chart Data	p. 91
Saving a Chart Template	p. 92
Adding Shapes to Office Documents	p. 93
Drawing and Resizing Shapes	p. 94
Adding Text to a Shape	p. 96
Creating and Editing Freeforms	p. 97
Adding a Quick Style to a Shape	p. 98
Adding a Quick Style to Shape Text	p. 99
Applying Color Fills	p. 100
Applying Picture or Texture Fills	p. 102
Applying Gradient Fills	p. 103
Applying Shape Effects	p. 104
Aligning and Distributing Objects	p. 106
Aligning Objects to Grids and Guides	p. 108
Changing Stacking Order	p. 110
Rotating and Flipping Objects	p. 111
Grouping and Ungrouping Objects	p. 112
Selecting Objects Using the Selection Pane	p. 114
Formatting Office Documents	p. 115
Formatting Text	p. 116
Changing Alignment	p. 118
Using the Format Painter	p. 120
Adding Custom Colors	p. 121
Understanding Themes	p. 122
Viewing and Applying a Theme	p. 123
Creating Theme Colors	p. 124
Choosing Theme Fonts	p. 126
Choosing Theme Effects	p. 128
Creating a Custom Theme	p. 129
Choosing a Custom Theme	p. 130
Creating a Document with Word	p. 131
Viewing the Word Window	p. 132
Moving Around in a Document	p. 133
Changing Document Views	p. 134
Reading a Document	p. 136
Setting Up the Page	p. 138
Setting Up the Page Margins	p. 140
Creating an Outline	p. 142
Selecting Text	p. 143
Checking Spelling and Grammar	p. 144
Inserting New Pages and Sections	p. 146
Adding Headers and Footers	p. 148
Inserting Page Numbers and the Date and Time	p. 150
Formatting a Document with Word	p. 153
Formatting Text for Emphasis	p. 154
Finding and Replacing Formatting	p. 156
Changing Paragraph Alignment	p. 158
Changing Line Spacing	p. 159
Displaying Rulers	p. 160
Setting Paragraph Tabs	p. 161
Setting Paragraph Indents	p. 162
Changing Character Spacing	p. 164
Applying a Quick Style	p. 165
Changing a Style Set	p. 166
Creating and Modifying Styles	p. 168
Creating Bulleted and Numbered Lists	p. 170
Hiding Text	p. 172
Enhancing a Document with Word	p. 173
Adding Desktop Publishing Effects	p. 174
Adding a Watermark	p. 175
Adding Page Backgrounds	p. 176
Adding Text in Columns	p. 178
Wrapping Text Around an Object	p. 180
Working with Text Boxes	p. 182
Inserting Building Blocks Using Quick Parts	p. 184
Creating a Table	p. 186
Entering Text in a Table	p. 187
Modifying a Table	p. 188
Adjusting Table Cells	p. 190
Formatting a Table	p. 192
Calculating a Value in a Table	p. 194
Addressing Envelopes and Labels	p. 195
Creating a Form Letter	p. 196
Creating Labels	p. 198
Inserting a Table of Contents	p. 200
Creating an Index	p. 201
Creating Captions	p. 202
Creating a Table of Figures	p. 203
Creating Footnotes or Endnotes	p. 204
Creating a Bookmark	p. 205
Inserting Cross References	p. 206
Comparing and Merging Documents	p. 207
Using Track Changing	p. 208
Adding a Cover Page	p. 210
Creating a Worksheet with Excel	p. 211
Viewing the Excel Window	p. 212
Selecting Cells	p. 213
Moving Around the Workbook	p. 214
Entering Labels on a Worksheet	p. 216
Entering Values on a Worksheet	p. 218
Entering Values Quickly with AutoFill	p. 219
Editing Cell Contents	p. 220
Clearing Cell Contents	p. 221
Inserting and Deleting Cell Contents	p. 222
Selecting Rows, Columns, and Special Ranges	p. 224
Selecting and Naming a Worksheet	p. 226
Inserting and Deleting a Worksheet	p. 227
Moving and Copying a Worksheet	p. 228
Hiding and Unhiding Worksheets and Workbooks	p. 230
Hiding and Unhiding a Column or Row	p. 231
Inserting a Column or Row	p. 232
Deleting a Column or Row	p. 233
Adjusting Column Width and Row Height	p. 234
Splitting a Worksheet into Panes	p. 236
Freezing and Unfreezing a Column or Row	p. 237
Showing and Hiding Workbook Elements	p. 238
Building a Worksheet with Excel	p. 239
Understanding Formulas	p. 240
Understanding Cell Referencing	p. 241
Creating a Simple Formula	p. 242
Creating a Formula Using Formula AutoComplete	p. 244
Editing a Formula	p. 245
Naming Cells and Ranges	p. 246
Entering Named Cells and Ranges	p. 248
Managing Names	p. 250
Simplifying a Formula with Ranges	p. 252
Calculating Totals with AutoSum	p. 253
Correcting Formulas	p. 254
Auditing a Worksheet	p. 256
Creating Functions	p. 257
Creating Functions Using the Library	p. 258
Calculating Multiple Results	p. 259
Using Nested Functions	p. 260
Using Text Functions	p. 261
Using Lookup and Reference Functions	p. 262
Summarizing Data Using Subtotals	p. 264
Summarizing Data Using Functions	p. 265
Converting Text to Columns	p. 266
Creating a Table	p. 267
Formatting a Table	p. 268
Formatting Table Elements	p. 269
Creating Calculations in a Table	p. 270
Removing Table Rows and Columns	p. 271
Working with Tables	p. 272
Sorting Data in a Table	p. 274
Displaying Parts of a Table with AutoFilter	p. 276
Creating Custom Searches	p. 277
Creating Groups and Outlines	p. 278
Adding Data Validation to a Worksheet	p. 279
Creating a Drop-Down List	p. 280
Designing a Worksheet with Excel	p. 281
Formatting Numbers	p. 282
Applying and Creating Cell Styles	p. 284
Applying Conditional Formatting	p. 286
Applying Specialized Conditional Formatting	p. 288
Creating Conditional Formatting	p. 290
Managing Conditional Formatting	p. 291
Controlling Text Flow	p. 292
Formatting Tabs and Background	p. 293
Adding Borders to Cells	p. 294
Setting Up the Page	p. 295
Adjusting Page Margins	p. 296
Adding Headers and Footers	p. 298
Inserting Page Breaks	p. 300
Customizing Worksheet Printing	p. 302
Setting the Print Area	p. 304
Creating a Presentation with PowerPoint	p. 305
Viewing the PowerPoint Window	p. 306
Browsing a Presentation	p. 307
Understanding PowerPoint Views	p. 308
Creating New and Consistent Slides	p. 310
Working with Objects	p. 312
Entering and Editing Text	p. 314
Resizing Text While Typing	p. 316
Changing Character Direction	p. 317
Inserting and Developing an Outline	p. 318
Moving and Indenting Text	p. 320
Modifying a Bulleted and Numbered List	p. 322
Creating Text Columns	p. 324
Changing Text Spacing	p. 325
Rearranging Slides	p. 326
Using Slides from Other Presentations	p. 328
Making Your Presentation Look Consistent	p. 329
Controlling Slide Appearance with Masters	p. 330
Controlling a Slide Layout with Masters	p. 332
Modifying Placeholders	p. 334
Controlling a Slide Background with Masters	p. 336
Adding a Background Style	p. 337
Inserting a Table	p. 338
Modifying a Table	p. 339
Formatting a Table	p. 340
Adding a Quick Style to a Table	p. 341
Creating a Text Box	p. 342
Delivering a Presentation with PowerPoint	p. 343
Changing Page Setup Options	p. 344
Adding Animation	p. 345
Using Specialized Animations	p. 346
Coordinating Multiple Animations	p. 348
Adding Slide Timings	p. 350
Creating Slide Transitions	p. 352
Recording a Narration	p. 353
Inserting Movies and Sounds	p. 354
Setting Movie and Sound Play Options	p. 355
Setting Up a Slide Show	p. 356
Creating a Custom Slide Show	p. 358
Starting a Slide Show	p. 359
Navigating a Slide Show	p. 360
Annotating a Slide Show	p. 361
Packaging a Presentation on CD	p. 362
Saving a Presentation as a Slide Show	p. 364
Preparing Handouts	p. 365
Preparing Speaker Notes	p. 366
Adding a Footer and Header	p. 368
Inserting the Date and Time	p. 359
Inserting Slide Numbers	p. 370
Previewing Slides	p. 372
Printing a Presentation	p. 373
Creating a Database with Access	p. 375
Understanding How Databases Store Data	p. 376
Creating a Database	p. 378
Viewing the Access Window	p. 380
Changing Database Display Options	p. 381
Viewing Database Objects	p. 382
Working with Database Objects	p. 384
Planning Tables	p. 386
Creating a Table by Entering Data	p. 387
Creating a Table Using a Template	p. 388
Creating a Table Using SharePoint	p. 389
Working with a Table	p. 390
Importing Data into Tables	p. 392
Working with a Table in Design View	p. 393
Working with Fields	p. 394
Specifying Data Types and Field Properties	p. 396
Changing Field Properties	p. 397
Creating Input Masks	p. 393
Creating a Lookup Field	p. 399
Planning Table Relationships	p. 400
Defining Table Relationships	p. 402
Ensuring Referential Integrity	p. 404
Locating and Managing Data with Access	p. 405
Sorting Records	p. 406
Filtering Out Records	p. 407
Creating Complex Filters Using Forms	p. 408
Understanding the Different Types of Queries	p. 409
Creating a Query Using a Wizard	p. 410
Creating a Query in Design View	p. 412
Getting Information with a Query	p. 413
Modifying a Query in Design View	p. 414
Performing Calculations in Queries	p. 415
Summarizing Values with a Crosstab Query	p. 416
Creating a Parameter Query	p. 418
Finding Duplicate Fields	p. 419
Identifying Object Dependencies	p. 420
Backing Up a Database	p. 421
Compacting and Repairing a Database	p. 422
Presenting Data with Access	p. 423
Creating a Form	p. 424
Working with a Form in Design View	p. 426
Entering and Editing Data in a Form	p. 427
Modifying a Form	p. 428
Creating a Report	p. 430
Modifying a Report in Design View	p. 432
Performing Calculations in Reports	p. 434
Formatting a Form or Report	p. 436
Aligning and Grouping Controls	p. 438
Grouping and Sorting in Reports	p. 440
Formatting a Datasheet	p. 442
Changing the Page Setup	p. 443
Previewing and Printing Information	p. 444
Creating Mailing Labels	p. 446
Communication with Outlook	p. 447
Preparing for Outlook	p. 448
Using Outlook for the First Time	p. 449
Viewing the Outlook Window	p. 450
Using Outlook Today	p. 451
Using the Navigation Pane	p. 452
Viewing Items and Folders	p. 453
Creating a Contact	p. 454
Sorting Contacts	p. 456
Creating a Distribution List	p. 457
Creating and Addressing and E-Mail Message	p. 458
Formatting Message Text	p. 460
Attaching a File or Item to a Message	p. 461
Using Stationery	p. 462
Creating a Signature	p. 463
Inserting Message Content	p. 464
Sending Messages	p. 465
Setting Message Delivery Options	p. 466
Receiving and Reading Messages	p. 468
Flagging Messages	p. 469
Categorizing Messages By Color	p. 470
Deleting Messages	p. 471
Replying To and Forwarding a Message	p. 472
Finding and Filtering Messages	p. 474
Organizing Messages in Folders	p. 476
Managing Messages with Colors and Rules	p. 478
Using Search Folders	p. 480
Reducing Junk E-Mail	p. 482
Archiving Messages	p. 483
Working with Outlook Data	p. 484
Sending and Receiving Instant Messages	p. 486
Enabling Instant Messaging	p. 488
Managing Information with Outlook	p. 489
Viewing the Calendar	p. 490
Customizing the Calendar	p. 491
Scheduling an Appointment and Event	p. 492
Scheduling Meetings	p. 494
Responding to Meeting Requests	p. 496
Updating and Canceling Meeting Requests	p. 498
Creating an Online Meeting Workspace	p. 499
Creating and Updating Tasks	p. 500
Organizing Tasks	p. 501
Assigning Tasks to Others	p. 502
Monitoring Task Progress	p. 503
Managing Tasks	p. 504
Tracking Activities with Contacts	p. 505
Recording Items in the Journal	p. 506
Opening and Modifying Journal Entries	p. 508
Organizing Items by Categories	p. 509
Customizing How You View Items	p. 510
Creating and Modifying Notes	p. 512
Previewing Items from Outlook	p. 513
Printing Items from Outlook	p. 514
Customizing Panes	p. 515
Sharing Calendars Over the Internet	p. 516
Adding and Viewing an RSS Feed	p. 518
Creating a Publication with Publisher	p. 519
Viewing the Publisher Window	p. 520
Creating a Quick Publication	p. 521
Creating a New Publication	p. 522
Creating a Blank Publication	p. 523
Changing Your View	p. 524
Inserting and Deleting Pages	p. 525
Inserting and Editing Text	p. 526
Creating a Web Site	p. 528
Adding a Hot Spot Hyperlink	p. 530
Applying Color	p. 531
Adding Design Gallery Elements	p. 532
Checking Your Design	p. 533
Setting Up the Page	p. 534
Using Commercial Printing Tools	p. 535
Printing Publications	p. 536
Designing a Publication with Publisher	p. 537
Setting Up Layout Guides	p. 538
Creating a Frame	p. 539
Working with Text	p. 540
Connecting Text Frames	p. 542
Creating a Consistent Look	p. 544
Creating Tables	p. 546
Working with Pictures and Shapes	p. 548
Wrapping Text Around an Object	p. 550
Layering Objects	p. 552
Grouping Objects Together	p. 553
Aligning with Precision	p. 554
Rotating and Flipping Objects	p. 556
Publishing Office Documents on the Web	p. 557
Opening a Web Page	p. 558
Previewing a Web Page	p. 559
Creating a Hyperlink	p. 560
Adding Hyperlinks to Slide Objects	p. 562
Formatting a Cell Hyperlink	p. 564
Changing Web Page Options	p. 565
Saving a Web Page	p. 566
Publishing a Web Page	p. 568
Saving Slides as Web Graphics	p. 569
Creating Refreshable Web Queries	p. 570
Getting Data from Web Queries	p. 571
Saving Web Queries	p. 572
Accessing Office Information on the Web	p. 573
Getting Documents from the Web	p. 574
Protecting and Securing Office Documents	p. 575
Inspecting Documents	p. 576
Protecting a Worksheet	p. 578
Locking or Unlocking Worksheet Cells	p. 580
Adding Security Encryption to a Document	p. 581
Adding Password Protection to a Document	p. 582
Restricting Document Access	p. 584
Adding a Digital Signature	p. 586
Adding a Signature Line	p. 588
Avoiding Harmful Attacks	p. 590
Using the Trust Center	p. 592
Selecting Trusted Publishers and Locations	p. 593
Setting Add-in Security Options	p. 594
Setting ActiveX Security Options	p. 595
Setting Macro Security Options	p. 596
Changing Message Bar Security Options	p. 597
Setting Privacy Options	p. 598
Setting External Content Security Options	p. 600
Working with Office Safe Modes	p. 602
Marking a Document as Read-Only	p. 604
Reviewing and Sharing Office Documents	p. 605
Sharing Workbooks	p. 606
Creating and Reading a Cell Comment	p. 608
Editing and Deleting a Cell Comment	p. 609
Adding Comments to a Presentation	p. 610
Tracking Changes	p. 612
Sending a Document for Review Using E-Mail	p. 614
Sending a Document by Internet Fax	p. 615
Working with XML	p. 616
Creating an XML Data Map	p. 618
Exporting and Saving Data in XML	p. 620
Creating a PDF Document	p. 622
Creating an XPS Document	p. 623
Sharing Information Between Programs	p. 624
Exporting and Importing Data	p. 626
Linking and Embedding Files	p. 628
Consolidating Data in Excel	p. 630
Linking Data in Excel	p. 632
Getting External Data in Excel	p. 633
Connecting to Data in Excel	p. 634
Getting Query Data from a Database	p. 636
Getting Data from Access	p. 638
Getting Text Data in Excel	p. 640
Working with a Shared Workspace	p. 641
Working with Excel Services	p. 642
Publishing Slides to a Library	p. 644
Saving a Document to a Document Management Server	p. 646
Expanding Office Functionality	p. 647
Viewing and Managing Add-ins	p. 648
Loading and Unloading Add-ins	p. 650
Enhancing a Document with VBA	p. 652
Viewing the Visual Basic Editor	p. 654
Setting Developer Options	p. 655
Understanding How Macros Automate Your Work	p. 656
Recording a Macro	p. 657
Creating a Macro	p. 658
Running a Macro	p. 659
Controlling a Macro	p. 660
Adding a Digital Signature to a Macro Project	p. 662
Assigning a Macro to a Toolbar	p. 663
Saving a Document with Macro	p. 664
Opening a Document with Macros	p. 665
Inserting ActiveX Controls	p. 666
Using ActiveX Controls	p. 668
Setting ActiveX Control Properties	p. 669
Adding VBA Code to an ActiveX Control	p. 670
Playing a Movie Using an ActiveX Control	p. 671
Changing the Document Information Panel	p. 672
New Features	p. 673
Microsoft Certified Applications Specialist	p. 683
Index	p. 691
Table of Contents provided by Ingram. All Rights Reserved.

Excerpts

Introduction Introduction How You'll Learn How This Book Works What's New Keyboard Shortcuts Step-by-Step Instructions Real World Examples Workshop Microsoft Certified Applications Specialist Get More on the Web Welcome toMicrosoft Office 2007 On Demand, a visual quick reference book that shows you how to work efficiently with Microsoft Office. This book provides complete coverage of basic to advanced Office skills. How This Book Works You don't have to read this book in any particular order. We've designed the book so that you can jump in, get the information you need, and jump out. However, the book does follow a logical progression from simple tasks to more complex ones. Each task is presented on no more than two facing pages, which lets you focus on a single task without having to turn the page. To find the information that you need, just look up the task in the table of contents or index, and turn to the page listed. Read the task introduction, follow the step-by-step instructions in the left column along with screen illustrations in the right column, and you're done. What's New If you're searching for what's new in Office 2007, just look for the icon:New!. The new icon appears in the table of contents and through out this book so you can quickly and easily identify a new or improved feature in Office 2007. A complete description of each new feature appears in the New Features guide in the back of this book. Keyboard Shortcuts Most menu commands have a keyboard equivalent, such as Ctrl+P, as a quicker alternative to using the mouse. A complete list of keyboard shortcuts is available on the Web at http://www.perspection.com . Step-by-Step Instructions This book provides concise step-by-step instructions that show you "how" to accomplish a task. Each set of instructions include illustrations that directly correspond to the easy-to-read steps. Also included in the text are timesavers, tables, and sidebars to help you work more efficiently or to teach you more in-depth information. A "Did You Know?" provides tips and techniques to help you work smarter, while a "See Also" leads you to other parts of the book containing related information about the task. Real World Examples This book uses real world examples files to give you a context in which to use the task. By using the example files, you won't waste time looking for or creating sample files. You get a start file and a result file, so you can compare your work. Not every topic needs an example file, such as changing options, so we provide a complete list of the example files used through out the book. The example files that you need for project tasks along with a complete file list are available on the Web at http://www.perspection.com . Workshop This book shows you how to put together the individual step-by-step tasks into indepth projects with the Workshop. You start each project with a sample file, work through the steps, and then compare your results with project results file at the end. The Workshop projects and associated files are available on the Web at http://www.perspection.com . Microsoft Certified Applications Specialist This book prepares you for the Microsoft Certified Applications Specialist (MCAS) exam for Microsoft Office 2007 programs. Each MCAS certification exam has a set of objectives, which are organized into broader skill sets. To prepare for the certification exam, you should review and perform each task identified with a MCA