Microsoft Office 2010

Part One: Word - Page 37
Part One: Word - Page 38
Basic Word Processing - Page 39
The Word 2010 Screen - Page 40
The Word 2010 Screen - Page 41
The Word 2010 Screen - Page 42
The Word 2010 Screen - Page 43
Using Keyboard Shortcuts - Page 44
Creating a New Blank Document - Page 45
Creating a New Document from a Template - Page 46
Creating a New Document from an Existing Document - Page 47
Typing in Some Text - Page 48
Saving a Document - Page 49
Saving a Document Using Keyboard Shortcuts - Page 50
Closing a Document - Page 51
Closing a Document - Page 52
Opening an Existing Document - Page 53
Different Ways to View Your Work - Page 54
Different Ways to View Your Work - Page 55
Viewing a Document in the Navigation Pane - Page 56
Zooming In and Out - Page 57
Zooming In and Out - Page 58
Zooming In and Out - Page 59
Working with Multiple Windows - Page 60
Working with Multiple Windows - Page 61
Working with Multiple Windows - Page 62
Editing and Formatting - Page 63
Editing and Formatting - Page 64
Editing and Formatting - Page 65
Four Ways to Move Text - Page 66
Four Ways to Move Text - Page 67
Four Ways to Move Text - Page 68
Finding and Replacing Text - Page 69
Searching with the Navigation Pane - Page 70
Searching with the Navigation Pane - Page 71
Searching with the Traditional Find and Replace Dialog Box - Page 72
Replacing Text - Page 73
Replacing Text - Page 74
Text Formatting: Font, Size, and Style - Page 75
Text Formatting: Font, Size, and Style - Page 76
Copy Formatting with Format Painter - Page 77
Quick Formatting with the Mini Toolbar - Page 78
Formatting Power with Styles - Page 79
Formatting Power with Styles - Page 80
Formatting Power with Styles - Page 81
Paragraph Formatting: Aligning, Indenting, Spacing - Page 82
Aligning Text - Page 83
Indenting Paragraphs - Page 84
Indenting Paragraphs - Page 85
Spacing Within a Paragraph - Page 86
Spacing Between Paragraphs - Page 87
Creating a List - Page 88
Creating a List - Page 89
Creating a List - Page 90
Creating a List - Page 91
Creating a List - Page 92
Formatting a Document - Page 93
Formatting a Document - Page 94
Formatting a Document - Page 95
Using the Page Background Section - Page 96
Using the Page Background Section - Page 97
Using the Page Background Section - Page 98
Using the Page Background Section - Page 99
Using the Page Background Section - Page 100
Inserting Headers, Footers, and Page Numbers - Page 101
Inserting Headers, Footers, and Page Numbers - Page 102
Inserting Headers, Footers, and Page Numbers - Page 103
Inserting Headers, Footers, and Page Numbers - Page 104
Inserting Headers, Footers, and Page Numbers - Page 105
Inserting Headers, Footers, and Page Numbers - Page 106
Inserting Headers, Footers, and Page Numbers - Page 107
Inserting Headers, Footers, and Page Numbers - Page 108
Tables, Graphics, and Charts - Page 109
Creating a Table from Scratch - Page 110
Creating a Table from Scratch - Page 111
Creating a Table from Scratch - Page 112
Creating a Table from Text - Page 113
Adding Information to a Table - Page 114
Editing a Table - Page 115
Inserting Rows and Columns - Page 116
Moving Rows and Columns - Page 117
Merging and Splitting Cells - Page 118
Deleting All or Part of a Table - Page 119
Deleting All or Part of a Table - Page 120
Applying Shading and Borders - Page 121
Working with Borders - Page 122
Working with Borders - Page 123
Inserting Images - Page 124
Inserting Clip Art - Page 125
Inserting a Screenshot - Page 126
Inserting a Screenshot - Page 127
Editing an Image - Page 128
Changing an Image’s Size - Page 129
Removing a Picture’s Background - Page 130
Removing a Picture’s Background - Page 131
Moving and Rotating Images - Page 132
Adjusting an Image’s Appearance - Page 133
Using Picture Styles - Page 134
Wrapping Text Around an Image - Page 135
Searching for Images - Page 136
Fun with Fonts and Art That’s Smart - Page 137
Editing WordArt Text - Page 138
Editing WordArt Text - Page 139
Inserting SmartArt into Word Documents - Page 140
Inserting SmartArt into Word Documents - Page 141
Inserting SmartArt into Word Documents - Page 142
Proofing and - Page 143
Proofing and - Page 144
Proofing and - Page 145
Word’s Grammar Checker - Page 146
Word’s Grammar Checker - Page 147
Word’s Grammar Checker - Page 148
Getting Things Right with AutoCorrect - Page 149
Setting AutoCorrect Options - Page 150
Setting AutoCorrect Options - Page 151
Setting AutoCorrect Options - Page 152
AutoFormatting in Word - Page 153
AutoFormatting in Word - Page 154
AutoFormatting in Word - Page 155
Word’s Built-in Research Tools - Page 156
Looking Up a Word in the Dictionary - Page 157
Getting Information about a Subject - Page 158
Getting Information about a Subject - Page 159
Getting Information about a Subject - Page 160
Getting Information about a Subject - Page 161
Getting Information about a Subject - Page 162
Printing Documents - Page 163
Previewing a Document Before You Print It - Page 164
Selecting Print Options and Settings - Page 165
Specifying Settings - Page 166
Sending a Fax - Page 167
Sending a Fax - Page 168
Sending a Fax - Page 169
Printing Envelopes - Page 170
Printing Envelopes - Page 171
Formatting Envelope Addresses - Page 172
Selecting a Feed Method - Page 173
Adding Electronic Postage - Page 174
Printing Labels - Page 175
Merging Names and Addresses with Documents - Page 176
Step 1: Select Document Type - Page 177
Step 2: Select Starting Document - Page 178
Step 2: Select Starting Document - Page 179
Step 4: Write Your Letter - Page 180
Step 6: Complete the Merge - Page 181
Do-It-Yourself Mail Merge with the Mailings Tab’s Buttons - Page 182
Reports and Long Documents - Page 183
Breaking a Document into Sections - Page 184
Inserting a Section Break - Page 185
Footnotes and Endnotes - Page 186
Inserting a Footnote - Page 187
Inserting an Endnote - Page 188
Changing the Position of Footnotes or Endnotes - Page 189
Converting Footnotes to Endnotes (or Vice Versa) - Page 190
Citations and Bibliographies - Page 191
Inserting an Existing Citation - Page 192
Inserting an Existing Citation - Page 193
Inserting a Placeholder - Page 194
Editing a Citation or Its Source - Page 195
Deleting a Citation - Page 196
Updating a Bibliography - Page 197
Helping Readers Navigate Your Document - Page 198
Helping Readers Navigate Your Document - Page 199
Helping Readers Navigate Your Document - Page 200
Creating a Table of Contents - Page 201
Creating an Index - Page 202
Creating an Index - Page 203
Creating an Index - Page 204
Creating an Index - Page 205
Creating an Index - Page 206
Creating an Index - Page 207
Creating an Index - Page 208
Customizing Your - Page 209
Choosing a Theme - Page 210
Choosing a Theme - Page 211
Saving a Theme - Page 212
Templates: Reusable Document Blueprints - Page 213
Creating Your Own Template - Page 214
Creating Your Own Template - Page 215
Customizing a Template - Page 216
Customizing a Template - Page 217
Customizing a Template - Page 218
Customizing a Template - Page 219
Customizing a Template - Page 220
Save Time with Macros - Page 221
Save Time with Macros - Page 222
Save Time with Macros - Page 223
Running a Macro - Page 224
Deleting a Macro - Page 225
Deleting a Macro - Page 226
Desktop and Web Publishing - Page 227
Laying Out Text in Columns - Page 228
Formatting Columns - Page 229
Inserting a Text Box - Page 230
Inserting a Text Box - Page 231
Images and Text Wrapping - Page 232
Web Page Design - Page 233
Creating a Web Page from Scratch - Page 234
Creating a Web Page from Scratch - Page 235
Creating a Web Page from Scratch - Page 236
Creating a Web Page from Scratch - Page 237
Creating a Web Page from Scratch - Page 238
Creating a Web Page from Scratch - Page 239
Creating a Web Page from Scratch - Page 240
Creating More Pages for Your Site - Page 241
Creating More Pages for Your Site - Page 242
Sharing and Collaborating on Documents - Page 243
Emailing a Document - Page 244
Emailing a Document - Page 245
Saving a Document to SkyDrive - Page 246
Saving a Document to SharePoint - Page 247
Inserting a Comment - Page 248
Viewing Comments - Page 249
Editing a Comment - Page 250
Tracking Changes - Page 251
Selecting Which Changes to View - Page 252
Selecting Which Changes to View - Page 253
Accepting or Rejecting Changes - Page 254
Setting Track Changes Options - Page 255
Comparing Documents - Page 256
Comparing Documents - Page 257
Combining Documents - Page 258
Combining Documents - Page 259
Restricting Formatting and Editing - Page 260
Restricting Formatting and Editing - Page 261
Restricting Formatting and Editing - Page 262
Restricting Formatting and Editing - Page 263
Restricting Permissions - Page 264
Restricting Permissions - Page 265
Coauthoring and Simultaneous Editing - Page 266
Coauthoring and Simultaneous Editing - Page 267
Coauthoring and Simultaneous Editing - Page 268
Part Two: Outlook - Page 269
Part Two: Outlook - Page 270
Getting Started - Page 271
Getting Started - Page 272
Taking a Quick Look Around - Page 273
Contacts - Page 274
Contacts - Page 275
Sending an Email to More Than One Recipient - Page 276
Proofreading a Message - Page 277
Attaching a File to an Email Message - Page 278
Inserting a Picture into an Email Message - Page 279
Adding a Signature - Page 280
Adding a Signature - Page 281
Adding a Theme or Stationery - Page 282
Adding a Theme or Stationery - Page 283
Adding a Theme or Stationery - Page 284
Setting a Message’s Priority and Confidentiality - Page 285
Making Sure They Got the Message - Page 286
Setting a Delivery Time - Page 287
Adding Voting Buttons - Page 288
Receiving Email - Page 289
Opening an Attachment - Page 290
Opening an Attachment - Page 291
Getting Notified - Page 292
Flagging a Message - Page 293
Organizing Messages - Page 294
Organizing Messages - Page 295
Routing Incoming Messages - Page 296
Translating a Message - Page 297
Fighting Spam - Page 298
Setting Up a Safe Senders List - Page 299
Setting Up a Safe Senders List - Page 300
Saving Time with Quick Steps - Page 301
Customizing a Quick Step - Page 302
Deleting a Quick Step - Page 303
Adding Another Email Account - Page 304
Adding Another Email Account - Page 305
Adding Another Email Account - Page 306
Outlook’s Address Book - Page 307
Adding Contacts - Page 308
Adding Contacts - Page 309
Importing Email Addresses from Another Program - Page 310
Importing Email Addresses from Another Program - Page 311
Editing a Contact’s Information - Page 312
Editing a Contact’s Information - Page 313
Editing a Contact’s Information - Page 314
Finding a Contact - Page 315
Viewing Contacts - Page 316
Viewing Contacts - Page 317
Sorting and Grouping Contacts - Page 318
Customizing a View - Page 319
Customizing a View - Page 320
Saving a View - Page 321
The People Pane - Page 322
Communicating with a Contact - Page 323
Gathering Contacts into a Group - Page 324
Creating a Contact Group - Page 325
Creating a Contact Group - Page 326
Sending Email to a Contact Group - Page 327
Sending Email to a Contact Group - Page 328
Printing Your Contacts - Page 329
Printing Your Contacts - Page 330
Getting Organized - Page 331
Creating a New Folder - Page 332
Creating a New Folder - Page 333
Filling Up and Managing Folders - Page 334
Renaming a Folder - Page 335
Assigning a Category - Page 336
Creating a New Category - Page 337
Viewing Items by Category - Page 338
Customizing the Navigation Pane - Page 339
Customizing the To-Do Bar - Page 340
Searching Folders - Page 341
Expanding Your Search - Page 342
Refining Your Search - Page 343
Changing Search Settings - Page 344
Changing Search Settings - Page 345
Cleaning Out Folders - Page 346
Cleaning Out Folders - Page 347
Cleaning Out Folders - Page 348
Cleaning Out Folders - Page 349
Cleaning up Your Mailbox - Page 350
Cleaning up Your Mailbox - Page 351
Cleaning up Your Mailbox - Page 352
Getting Organized with Outlook’s Calendar, Tasks, and Notes - Page 353
Creating an Appointment or Meeting - Page 354
Scheduling an Appointment - Page 355
Setting up a Meeting - Page 356
Setting up a Meeting - Page 357
Accepting an Invitation to a Meeting - Page 358
Keeping Track of Who’s Attending - Page 359
Editing Events - Page 360
Getting Reminders - Page 361
Getting Reminders - Page 362
Deleting an Appointment - Page 363
Tasks - Page 364
Tasks - Page 365
Tasks - Page 366
Accepting a Task - Page 367
Managing Tasks - Page 368
Managing Tasks - Page 369
Flagging Tasks - Page 370
Marking a Task as Completed - Page 371
Adding a Note - Page 372
Working with Notes - Page 373
Viewing Notes - Page 374
Viewing Notes - Page 375
Viewing Notes - Page 376
Part Three: Excel - Page 377
Part Three: Excel - Page 378
Creating Your First Spreadsheet - Page 379
Creating Your First Spreadsheet - Page 380
Starting a New Workbook - Page 381
Adding the Column Titles - Page 382
Adding the Column Titles - Page 383
Adding Data - Page 384
Editing Data - Page 385
Moving Around the Grid - Page 386
The Go To Feature - Page 387
A Tour of the Excel Window - Page 388
A Tour of the Excel Window - Page 389
The Formula Bar - Page 390
The Status Bar - Page 391
The Status Bar - Page 392
The Status Bar - Page 393
The Status Bar - Page 394
Going Backstage - Page 395
Going Backstage - Page 396
Saving Files - Page 397
The Excel File Format - Page 398
The Excel File Format - Page 399
Preparing Your Spreadsheet for Excel 2007 - Page 400
Preparing Your Spreadsheet for Excel 2007 - Page 401
Saving Your Spreadsheet for Excel 2003 - Page 402
Saving a Spreadsheet in Other Formats - Page 403
Saving Your Spreadsheet As a PDF - Page 404
Saving Your Spreadsheet As a PDF - Page 405
Saving Your Spreadsheet with a Password - Page 406
Saving Your Spreadsheet with a Password - Page 407
Disaster Recovery - Page 408
Disaster Recovery - Page 409
Disaster Recovery - Page 410
Opening Files - Page 411
Protected View - Page 412
Opening Files—with a Twist - Page 413
Opening Files—with a Twist - Page 414
Opening Multiple Spreadsheets at Once - Page 415
Adding Different Types of Data - Page 416
Adding Different Types of Data - Page 417
Adding Different Types of Data - Page 418
How Excel Identifies Text - Page 419
How Excel Identifies Numbers - Page 420
How Excel Identifies Dates and Times - Page 421
How Excel Identifies Dates and Times - Page 422
Regional Dating - Page 423
Regional Dating - Page 424
Printing - Page 425
Printing - Page 426
Printing - Page 427
Printing - Page 428
Printing - Page 429
Printing - Page 430
Page Layout View: A Better Print Preview - Page 431
Page Layout View: A Better Print Preview - Page 432
Page Layout View: A Better Print Preview - Page 433
Page Layout View: A Better Print Preview - Page 434
Creating Headers and Footers - Page 435
Creating Headers and Footers - Page 436
Controlling Pagination - Page 437
Scaling - Page 438
Page Break Preview: A Bird’s-Eye View of Your Worksheet - Page 439
Page Break Preview: A Bird’s-Eye View of Your Worksheet - Page 440
Moving Data and - Page 441
Moving Data and - Page 442
Moving Data and - Page 443
Moving Data and - Page 444
Making Noncontiguous Selections - Page 445
Making Selections with the Keyboard - Page 446
Making Selections with the Keyboard - Page 447
Moving Cells Around - Page 448
Moving Cells Around - Page 449
A Quicker Cut-and-Paste or Copy-and-Paste - Page 450
Fancy Pasting Tricks - Page 451
Fancy Pasting Tricks - Page 452
Fancy Pasting Tricks - Page 453
Paste Special - Page 454
Paste Special - Page 455
Adding and Moving Columns or Rows - Page 456
Inserting Rows - Page 457
Deleting Columns and Rows - Page 458
Worksheets and Workbooks - Page 459
Worksheets and Workbooks - Page 460
Adding and Removing Worksheets - Page 461
Hiding Worksheets - Page 462
Naming and Rearranging Worksheets - Page 463
Moving Worksheets from one Workbook to Another - Page 464
Moving Worksheets from one Workbook to Another - Page 465
Moving Worksheets from one Workbook to Another - Page 466
Formatting Cells - Page 467
Formatting Cell Values - Page 468
Changing the Cell Value Format - Page 469
Formatting Numbers - Page 470
Formatting Numbers - Page 471
Formatting Numbers - Page 472
Formatting Numbers - Page 473
Formatting Numbers - Page 474
Formatting Numbers - Page 475
Formatting Dates and Times - Page 476
Formatting Dates and Times - Page 477
Special Formats for Special Numbers - Page 478
Formatting Cell Appearance - Page 479
Alignment and Orientation - Page 480
Alignment and Orientation - Page 481
Alignment and Orientation - Page 482
Fonts and Color - Page 483
Fonts and Color - Page 484
Fonts and Color - Page 485
Fonts and Color - Page 486
Borders and Fills - Page 487
Borders and Fills - Page 488
Borders and Fills - Page 489
Borders and Fills - Page 490
Building Basic Formulas - Page 491
Building Basic Formulas - Page 492
Excel’s Order of Operations - Page 493
Cell References - Page 494
Cell References - Page 495
How Excel Formats Cells That Contain Cell References - Page 496
Functions - Page 497
Using a Function in a Formula - Page 498
Using a Function in a Formula - Page 499
Using Cell References with a Function - Page 500
Using Cell References with a Function - Page 501
Excel Compatibility Functions - Page 502
Formula Errors - Page 503
Formula Errors - Page 504
Formula Errors - Page 505
Logical Operators - Page 506
Logical Operators - Page 507
Formula Shortcuts - Page 508
Point-and-Click Formula Editing - Page 509
Point-and-Click Formula Editing - Page 510
Using the Insert Function Button - Page 511
Using the Insert Function Button - Page 512
Using the Insert Function Button - Page 513
Using the Insert Function Button - Page 514
Copying Formulas - Page 515
Copying Formulas - Page 516
Absolute Cell References - Page 517
Partially Fixed References - Page 518
Partially Fixed References - Page 519
Referring to Other Worksheets - Page 520
A Function Sampler and Formula Troubleshooting - Page 521
ROUND(), ROUNDDOWN(), ROUNDUP(): Rounding Numbers - Page 522
Manipulating Text - Page 523
LEFT(), MID(), and RIGHT(): Copying Portions of a Text String - Page 524
SUBSTITUTE(): Replacing One Sequence of Characters with Another - Page 525
Solving Formula Errors - Page 526
Solving Formula Errors - Page 527
Solving Formula Errors - Page 528
Tracing Precedents and Dependents - Page 529
Tracing Precedents and Dependents - Page 530
Error Checking - Page 531
Error Checking - Page 532
Error Checking - Page 533
Error Checking - Page 534
Creating Charts - Page 535
Creating Charts - Page 536
Embedded and Standalone Charts - Page 537
The Chart Tools Ribbon Tabs - Page 538
Basic Tasks with Charts - Page 539
Moving and Resizing a Chart - Page 540
Moving and Resizing a Chart - Page 541
Creating a Standalone Chart - Page 542
Editing and Adding to Chart Data - Page 543
Changing the Chart Type - Page 544
Practical Charting - Page 545
Charts with Multiple Series of Numbers - Page 546
Charts with Multiple Series of Numbers - Page 547
Data That Uses a Date or Time Scale - Page 548
Data That Uses a Date or Time Scale - Page 549
Data That Uses a Date or Time Scale - Page 550
Non-Contiguous Chart Ranges - Page 551
Changing the Order of Your Data Series - Page 552
Changing the Way Excel Plots Blank Values - Page 553
Column - Page 554
Column - Page 555
Bar - Page 556
Bar - Page 557
Pie - Page 558
Chart Styles and Layouts - Page 559
Chart Styles - Page 560
Chart Layouts - Page 561
Adding Chart Elements - Page 562
Adding Chart Elements - Page 563
Adding Titles - Page 564
Adding a Legend - Page 565
Adding a Legend - Page 566
Adding a Legend - Page 567
Adding Individual Data Labels - Page 568
Adding Individual Data Labels - Page 569
Adding Individual Data Labels - Page 570
Part Four: PowerPoint - Page 571
Part Four: PowerPoint - Page 572
Creating a Presentation - Page 573
Creating a New Presentation from a Template - Page 574
Choosing a Theme - Page 575
Adding Text to a Slide - Page 576
Creating a New Slide - Page 577
Creating a New Slide - Page 578
Adding Content - Page 579
Deleting Content - Page 580
Saving a Presentation - Page 581
Saving a Presentation - Page 582
Opening an Existing Presentation - Page 583
Open Any Saved Presentation in PowerPoint - Page 584
Normal View - Page 585
Reading View - Page 586
Reading View - Page 587
Notes Page View - Page 588
Zooming In and Out - Page 589
Printing a Presentation - Page 590
Printing a Presentation - Page 591
Printing a Presentation - Page 592
Editing Slides - Page 593
Formatting Text - Page 594
Formatting Text - Page 595
Positioning Text - Page 596
Formatting a Text Box - Page 597
Creating Lists - Page 598
Linking Text to a Web Page - Page 599
Checking Your Spelling - Page 600
Turning Text into WordArt - Page 601
Embedding Other Files in Slides - Page 602
Updating Links - Page 603
Adding Tables to Slides - Page 604
Adding Tables to Slides - Page 605
Adding Tables to Slides - Page 606
Adding Information to a Table - Page 607
Adding Information to a Table - Page 608
Adding Images to Slides - Page 609
Creating a Photo Album - Page 610
Creating a Photo Album - Page 611
Creating a Photo Album - Page 612
Working with Shapes - Page 613
Working with Shapes - Page 614
Working with Shapes - Page 615
Working with SmartArt - Page 616
Working with SmartArt - Page 617
Working with SmartArt - Page 618
Working with SmartArt - Page 619
Working with SmartArt - Page 620
Working with Charts and Diagrams - Page 621
Arranging Objects on a Slide - Page 622
Ordering Objects - Page 623
Ordering Objects - Page 624
Editing a Presentation - Page 625
Duplicating a Slide - Page 626
Duplicating a Slide - Page 627
Rearranging Slides in a Presentation - Page 628
Hiding Slides - Page 629
Headers and Footers - Page 630
Adding a Footer to Your Slides - Page 631
Adding a Header and Footer to Notes and Handouts - Page 632
Creating a Section - Page 633
Collapsing and Expanding Sections - Page 634
Moving a Section Within a Presentation - Page 635
Inserting a Hyperlink to Another Slide - Page 636
Creating a Table of Contents for Your Presentation - Page 637
Creating a Table of Contents for Your Presentation - Page 638
Inserting an Action Button - Page 639
Inserting an Action Button - Page 640
Opening an Inserted File - Page 641
Slide Masters: Powerful Slide Blueprints - Page 642
Slide Masters: Powerful Slide Blueprints - Page 643
Changing the Layout for a Particular Type of Slide - Page 644
Changing the Layout for a Particular Type of Slide - Page 645
Working with Masters for Handouts and Notes - Page 646
Working with Masters for Handouts and Notes - Page 647
Collaborating with Others - Page 648
Adding and Reading Comments - Page 649
Adding and Reading Comments - Page 650
Comparing Versions of a Presentation - Page 651
Comparing Versions of a Presentation - Page 652
Adding Multimedia and Movement - Page 653
Adding Video from a Website - Page 654
Adding Video from a Website - Page 655
Adding Animated Clip Art - Page 656
Adding Clip Art Audio - Page 657
Recording Audio - Page 658
Formatting Video Clips - Page 659
Formatting Audio Clips - Page 660
Editing Media Clips - Page 661
Editing Media Clips - Page 662
Editing Media Clips - Page 663
Editing Media Clips - Page 664
Editing Media Clips - Page 665
Animating Objects - Page 666
Animating an Object - Page 667
Changing an Animation - Page 668
Adjusting Effect Options - Page 669
Adjusting Effect Options - Page 670
Adjusting Effect Options - Page 671
Adding More Animation - Page 672
Creating a Motion Path - Page 673
Triggering an Animation - Page 674
Timing Animations - Page 675
Reordering Animations - Page 676
Reordering Animations - Page 677
Reordering Animations - Page 678
Animating Lists - Page 679
Stacking Objects - Page 680
Creating Transitions Between Slides - Page 681
Tweaking Transition Effects - Page 682
Timing Transitions - Page 683
Timing Transitions - Page 684
It’s Showtime! Giving a Presentation - Page 685
Starting a Slideshow - Page 686
Starting a Slideshow - Page 687
Ending a Slideshow - Page 688
Ending a Slideshow - Page 689
Ending a Slideshow - Page 690
Adding Narration to Your Presentation - Page 691
Adding Narration to Your Presentation - Page 692
Creating a Custom Slideshow - Page 693
Creating a Custom Slideshow - Page 694
Creating a Handout - Page 695
Setting Up Your Show - Page 696
Setting Up Your Show - Page 697
At the Event - Page 698
Launching a Slideshow - Page 699
Launching a Slideshow - Page 700
Launching a Slideshow - Page 701
Launching a Slideshow - Page 702
Ending the Show - Page 703
Ending the Show - Page 704
Ending the Show - Page 705
Creating a Slideshow that Runs by Itself - Page 706
Creating a Slideshow that Runs by Itself - Page 707
Creating an Interactive Slideshow - Page 708
Turning Your Presentation into a Video - Page 709
Sharing Your Presentation - Page 710
Packaging Your Presentation on a CD or DVD - Page 711
Packaging Your Presentation on a CD or DVD - Page 712
Part Five: Access - Page 713
Part Five: Access - Page 714
Creating Your First Database - Page 715
Understanding Access Databases - Page 716
Getting Started with Your First Database - Page 717
Getting Started with Your First Database - Page 718
Getting Started with Your First Database - Page 719
Understanding Tables - Page 720
Understanding Tables - Page 721
Creating a Simple Table - Page 722
Creating a Simple Table - Page 723
Creating a Simple Table - Page 724
Editing a Table - Page 725
Editing a Table - Page 726
Editing a Table - Page 727
Editing a Table - Page 728
Saving Databases - Page 729
Making Backups - Page 730
Saving a Database with a Different Name or Format - Page 731
Opening Databases - Page 732
Opening Recent Databases - Page 733
Opening More Than One Database at Once - Page 734
The Navigation Pane - Page 735
Browsing Tables with the Navigation Pane - Page 736
Browsing Tables with the Navigation Pane - Page 737
Managing Database Objects - Page 738
Building Smarter Tables - Page 739
Design View - Page 740
Organizing and Describing Your Fields - Page 741
Organizing and Describing Your Fields - Page 742
How Updates Work in Design View - Page 743
Access Data Types - Page 744
Access Data Types - Page 745
Access Data Types - Page 746
Text - Page 747
Memo - Page 748
Memo - Page 749
Memo - Page 750
Number - Page 751
Number - Page 752
Number - Page 753
Currency - Page 754
Date/Time - Page 755
Date/Time - Page 756
Date/Time - Page 757
Date/Time - Page 758
Yes/No - Page 759
Yes/No - Page 760
Attachment - Page 761
Attachment - Page 762
Attachment - Page 763
AutoNumber - Page 764
AutoNumber - Page 765
AutoNumber - Page 766
Calculated - Page 767
The Primary Key - Page 768
Creating Your Own Primary Key Field - Page 769
Six Principles of Database Design - Page 770
2. Break Down Your Information - Page 771
3. Include All the Details in One Place - Page 772
4. Avoid Duplicating Information - Page 773
5. Avoid Redundant Information - Page 774
6. Include an ID Field - Page 775
Blocking Bad Data - Page 776
Blocking Bad Data - Page 777
Blocking Bad Data - Page 778
Setting Default Values - Page 779
Preventing Duplicate Values with Indexes - Page 780
Preventing Duplicate Values with Indexes - Page 781
Preventing Duplicate Values with Indexes - Page 782
Preventing Duplicate Values with Indexes - Page 783
Lookups - Page 784
Lookups - Page 785
Lookups - Page 786
Adding New Values to Your Lookup List - Page 787
Adding New Values to Your Lookup List - Page 788
Mastering the Datasheet: Sorting, Searching, - Page 789
Datasheet Customization - Page 790
Rearranging Columns - Page 791
Resizing Rows and Columns - Page 792
Hiding Columns - Page 793
Hiding Columns - Page 794
Freezing Columns - Page 795
Datasheet Navigation - Page 796
Datasheet Navigation - Page 797
Datasheet Navigation - Page 798
Filtering - Page 799
Filtering - Page 800
Filtering - Page 801
Filtering - Page 802
Searching - Page 803
Searching - Page 804
Searching - Page 805
Printing the Datasheet - Page 806
Printing the Datasheet - Page 807
Fine-Tuning a Printout - Page 808
Fine-Tuning a Printout - Page 809
Fine-Tuning a Printout - Page 810
Linking Tables with Relationships - Page 811
Relationship Basics - Page 812
Relationship Basics - Page 813
Matching Fields: The Relationship Link - Page 814
Linking with the ID Column - Page 815
The Parent-Child Relationship - Page 816
Using a Relationship - Page 817
Using a Relationship - Page 818
Using a Relationship - Page 819
Using a Relationship - Page 820
Using a Relationship - Page 821
Editing Relationships - Page 822
Referential Integrity - Page 823
Referential Integrity - Page 824
Referential Integrity - Page 825
Navigating a Relationship - Page 826
Navigating a Relationship - Page 827
Navigating a Relationship - Page 828
Lookups with Related Tables - Page 829
Lookups with Related Tables - Page 830
Lookups with Related Tables - Page 831
More Exotic Relationships - Page 832
One-to-One Relationships - Page 833
Many-to-Many Relationships - Page 834
Many-to-Many Relationships - Page 835
Many-to-Many Relationships - Page 836
Many-to-Many Relationships - Page 837
Many-to-Many Relationships - Page 838
Part Six: Other Office Tools - Page 839
Part Six: Other Office Tools - Page 840
Publisher - Page 841
Creating a Publication from a Template - Page 842
Creating a Publication from Scratch - Page 843
Creating a Publication from Scratch - Page 844
Entering Text - Page 845
Adding Pages - Page 846
Navigating Pages - Page 847
Adding Text - Page 848
Adding Text - Page 849
Adding Text - Page 850
Adding Text - Page 851
Adding Text - Page 852
Inserting Your Business Information - Page 853
Flowing Text from One Box to Another - Page 854
Flowing Text from One Box to Another - Page 855
Flowing Text from One Box to Another - Page 856
Flowing Text Around an Object - Page 857
Adding Pictures, Shapes, and Other Objects - Page 858
Adding Pictures, Shapes, and Other Objects - Page 859
Stacking and Grouping Objects - Page 860
Designing and Laying Out Pages - Page 861
Choosing a Font Scheme - Page 862
Choosing a Font Scheme - Page 863
Choosing a Font Scheme - Page 864
Snapping an Object to a Guide - Page 865
Snapping an Object to a Guide - Page 866
Printing a Publication - Page 867
Printing a Publication - Page 868
OneNote - Page 869
OneNote - Page 870
Getting Familiar with the OneNote Workspace - Page 871
Creating and Filling up a Notebook - Page 872
Adding Notes to a Page - Page 873
Adding Notes to a Page - Page 874
Adding Notes to a Page - Page 875
Adding Notes to a Page - Page 876
Adding Notes to a Page - Page 877
Organizing a Notebook - Page 878
Working with Sections and Pages - Page 879
Working with Sections and Pages - Page 880
Deleting Notebooks, Sections, and Pages - Page 881
Writing Side Notes - Page 882
Linking a Note to its Source - Page 883
Tagging a Note - Page 884
Tagging a Note - Page 885
Tagging a Note - Page 886
Finding a Note - Page 887
Sharing Notes - Page 888
Finding Changes Others Have Made - Page 889
Using OneNote with Other Office Programs - Page 890
Using OneNote with Other Office Programs - Page 891
Getting Office Files into OneNote - Page 892
Getting Office Files into OneNote - Page 893
Getting Office Files into OneNote - Page 894
Office Web Apps - Page 895
Office Web Apps - Page 896
Setting Up Office Web Apps - Page 897
Setting Up Office Web Apps - Page 898
Creating and Editing Files - Page 899
Saving a Web Apps File - Page 900
Working with Folders in SkyDrive - Page 901
Renaming a Folder - Page 902
Uploading Files to SkyDrive from Your Computer - Page 903
Uploading Files to SkyDrive from Your Computer - Page 904
Downloading Files from SkyDrive to Your Computer - Page 905
Move, Rename, Delete: File Management Tips - Page 906
Sharing Files - Page 907
Sharing Files - Page 908
Leaving Comments - Page 909
Docs.com: Office Web Apps for Facebook - Page 910
Adding Docs - Page 911
Adding Docs - Page 912
Viewing Your Docs - Page 913
Editing a Doc - Page 914
Part Seven: Appendix - Page 915
Part Seven: Appendix - Page 916
Customizing Office 2010 Applications - Page 917
Customizing Office 2010 Applications - Page 918
Customizing Office 2010 Applications - Page 919
Customizing Office 2010 Applications - Page 920
Customizing Office 2010 Applications - Page 921
Customizing Office 2010 Applications - Page 922