Office 2013 All-In-One for Dummies

Office 2013 All-in-One For Dummies......Page 1
 About the Author......Page 7
 Contents at a Glance......Page 11
 Table of Contents......Page 13
  What’s in This Book, Anyway?......Page 33
  What Makes This Book Different......Page 34
  Foolish Assumptions......Page 35
  Icons Used in This Book......Page 36
 Book I: Common Office Tasks......Page 39
   A Survey of Office Applications......Page 41
   Starting an Office Program......Page 43
   Finding Your Way Around the Office Interface......Page 46
   Saving Your Files......Page 52
   Navigating the Save As and Open Windows......Page 55
   Opening and Closing Files......Page 57
   Reading and Recording File Properties......Page 58
   Locking a File with a Password......Page 59
   Manipulating the Text......Page 61
   Changing the Look of Text......Page 64
   Quick Ways to Handle Case, or Capitalization......Page 70
   Entering Symbols and Foreign Characters......Page 72
   Creating Hyperlinks......Page 73
   Undoing and Repeating Commands......Page 79
   Zooming In, Zooming Out......Page 80
   Correcting Typos on the Fly......Page 82
   Entering Text Quickly with the AutoCorrect Command......Page 84
 Book II: Word 2013......Page 87
   Introducing the Word Screen......Page 89
   Creating a New Document......Page 91
   Getting a Better Look at Your Documents......Page 93
   Selecting Text in Speedy Ways......Page 97
   Moving Around Quickly in Documents......Page 98
   Inserting a Whole File into a Document......Page 101
   Entering Information Quickly in a Computerized Form......Page 102
   Paragraphs and Formatting......Page 107
   Inserting a Section Break for Formatting Purposes......Page 108
   Starting a New Page......Page 110
   Setting Up and Changing the Margins......Page 111
   Indenting Paragraphs and First Lines......Page 113
   Numbering the Pages......Page 115
   Putting Headers and Footers on Pages......Page 118
   Adjusting the Space Between Lines......Page 122
   Adjusting the Space Between Paragraphs......Page 123
   Creating Numbered and Bulleted Lists......Page 124
   Working with Tabs......Page 127
   Hyphenating Text......Page 128
   All About Styles......Page 131
   Applying Styles to Text and Paragraphs......Page 133
   Creating a New Style......Page 137
   Modifying a Style......Page 140
   Creating and Managing Templates......Page 141
   Talking Table Jargon......Page 147
   Creating a Table......Page 148
   Entering the Text and Numbers......Page 150
   Selecting Different Parts of a Table......Page 151
   Laying Out Your Table......Page 152
   Aligning Text in Columns and Rows......Page 156
   Merging and Splitting Cells......Page 157
   Repeating Header Rows on Subsequent Pages......Page 158
   Formatting Your Table......Page 159
   Using Math Formulas in Tables......Page 164
   Neat Table Tricks......Page 165
  Chapter 5: Taking Advantage of the Proofing Tools......Page 171
   Correcting Your Spelling Errors......Page 172
   Checking for Grammatical Errors in Word......Page 175
   Getting a Word Definition......Page 176
   Finding and Replacing Text......Page 177
   Researching a Topic Inside Word......Page 185
   Finding the Right Word with the Thesaurus......Page 187
   Proofing Text Written in a Foreign Language......Page 188
   Translating Foreign Language Text......Page 189
   Experimenting with Themes......Page 191
   Sprucing Up Your Pages......Page 193
   Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos......Page 195
   Working with the Drawing Canvas......Page 196
   Positioning and Wrapping Objects Relative to the Page and Text......Page 197
   Working with Text Boxes......Page 201
   Watermarking for the Elegant Effect......Page 203
   Putting Newspaper-Style Columns in a Document......Page 205
   Landscape Documents......Page 206
   Printing on Different Size Paper......Page 207
   Showing Online Video in a Document......Page 208
   Highlighting Parts of a Document......Page 209
   Commenting on a Document......Page 210
   Tracking Changes to Documents......Page 213
   Printing an Address on an Envelope......Page 218
   Printing a Single Address Label (or a Page of the Same Label)......Page 220
   Churning Out Letters, Envelopes, and Labels for Mass Mailings......Page 221
   Alphabetizing a List......Page 229
   Outlines for Organizing Your Work......Page 230
   Generating a Table of Contents......Page 232
   Indexing a Document......Page 237
   Putting Cross-References in a Document......Page 241
   Putting Footnotes and Endnotes in Documents......Page 243
   Compiling a Bibliography......Page 246
 Book III: Excel 2013......Page 251
   Creating a New Excel Workbook......Page 253
   Getting Acquainted with Excel......Page 255
   Entering Data in a Worksheet......Page 257
   Quickly Entering Lists and Serial Data with the AutoFill Command......Page 263
   Formatting Numbers, Dates, and Time Values......Page 264
   Conditional Formats for Calling Attention to Data......Page 267
   Establishing Data-Validation Rules......Page 268
   Editing Worksheet Data......Page 271
   Moving Around in a Worksheet......Page 272
   Getting a Better Look at the Worksheet......Page 273
   Comments for Documenting Your Worksheet......Page 276
   Selecting Cells in a Worksheet......Page 278
   Handling the Worksheets in a Workbook......Page 279
   Keeping Others from Tampering with Worksheets......Page 281
   How Formulas Work......Page 285
   The Basics of Entering a Formula......Page 290
   Speed Techniques for Entering Formulas......Page 291
   Copying Formulas from Cell to Cell......Page 296
   Detecting and Correcting Errors in Formulas......Page 298
   Working with Functions......Page 301
   Laying Out a Worksheet......Page 307
   Decorating a Worksheet with Borders and Colors......Page 312
   Getting Ready to Print a Worksheet......Page 317
   Seeing What the Sparklines Say......Page 325
   Managing Information in Lists......Page 326
   Forecasting with the Goal Seek Command......Page 330
   Performing What-If Analyses with Data Tables......Page 331
   Analyzing Data with Pivot Tables......Page 335
 Book IV: PowerPoint 2013......Page 339
  Chapter 1: Getting Started in PowerPoint......Page 341
   Getting Acquainted with PowerPoint......Page 342
   A Brief Geography Lesson......Page 343
   A Whirlwind Tour of PowerPoint......Page 344
   Creating a New Presentation......Page 345
   Advice for Building Persuasive Presentations......Page 348
   Creating New Slides for Your Presentation......Page 350
   Getting a Better View of Your Work......Page 355
   Hiding and Displaying the Slides Pane and Notes Pane......Page 356
   Selecting, Moving, and Deleting Slides......Page 357
   Putting Together a Photo Album......Page 358
   Hidden Slides for All Contingencies......Page 361
   Looking at Themes and Slide Backgrounds......Page 363
   Creating Slide Backgrounds on Your Own......Page 366
   Changing the Background of a Single or Handful of Slides......Page 373
   Using Master Slides and Master Styles for a Consistent Design......Page 374
   Entering Text......Page 379
   Fun with Text Boxes and Text Box Shapes......Page 382
   Controlling How Text Fits in Text Frames and Text Boxes......Page 384
   Positioning Text in Frames and Text Boxes......Page 388
   Handling Bulleted and Numbered Lists......Page 389
   Putting Footers (and Headers) on Slides......Page 391
   Suggestions for Enlivening Your Presentation......Page 395
   Presenting Information in a Table......Page 396
   Exploring Transitions and Animations......Page 397
   Making Audio Part of Your Presentation......Page 402
   Playing Video on Slides......Page 406
   Recording a Voice Narration for Slides......Page 409
   All about Notes......Page 411
   Rehearsing and Timing Your Presentation......Page 412
   Showing Your Presentation......Page 413
   Tricks for Making Presentations a Little Livelier......Page 417
   Delivering a Presentation When You Can’t Be There in Person......Page 420
 Book V: OneNote 2013......Page 433
   Introducing OneNote......Page 435
   Finding Your Way Around the OneNote Screen......Page 436
   Units for Organizing Notes......Page 437
   Creating a Notebook......Page 439
   Creating Sections and Section Groups......Page 440
   Creating Pages and Subpages......Page 442
   Getting from Place to Place in OneNote......Page 443
   Changing Your View of OneNote......Page 444
   Notes: The Basics......Page 447
   Drawing on the Page......Page 450
   Converting a Handwritten Note to Text......Page 454
   Writing a Math Expression in a Note......Page 455
   Taking a Screen-Clipping Note......Page 456
   Recording and Playing Audio Notes......Page 457
   Attaching, Copying, and Linking Files to Notes......Page 459
   Finding a Stray Note......Page 463
   Tagging Notes for Follow Up......Page 465
   Merging and Moving Sections, Pages, and Notes......Page 469
 Book VI: Outlook 2013......Page 471
   What Is Outlook, Anyway?......Page 473
   Navigating the Outlook Folders......Page 474
   Categorizing Items......Page 475
   Searching for Stray Folder Items......Page 477
   Deleting E-Mail Messages, Contacts, Tasks, and Other Items......Page 480
   Finding and Backing Up Your Outlook File......Page 481
   Cleaning Out Your Folders......Page 482
   Maintaining a Happy and Healthy Contacts Folder......Page 487
   Contact Groups for Sending Messages to Groups......Page 491
   Finding a Contact in the Contacts Folder......Page 493
   Printing the Contacts Folder......Page 494
   Setting Up an E-Mail Account......Page 497
   Addressing and Sending E-Mail Messages......Page 498
   Sending Files and Photos......Page 503
   Being Advised When Someone Has Read Your E-Mail......Page 505
   Receiving E-Mail Messages......Page 506
   Reading Your E-Mail in the Inbox Window......Page 507
   Handling Files That Were Sent to You......Page 510
   Techniques for Organizing E-Mail Messages......Page 511
   All about E-Mail Folders......Page 516
   Yes, You Can Prevent Junk Mail (Sort of)......Page 517
   Introducing the Calendar......Page 521
   The Different Kinds of Activities......Page 522
   Seeing Your Schedule......Page 523
   Scheduling Appointments and Events......Page 524
   Canceling, Rescheduling, and Altering Activities......Page 527
   Tasks: Seeing What Needs to Get Done......Page 529
   Reminders for Being Alerted to Activities and Tasks......Page 532
   Making Notes to Yourself......Page 534
 Book VII: Access 2013......Page 537
   What Is a Database, Anyway?......Page 539
   Tables, Queries, Forms, and Other Objects......Page 541
   Creating a Database File......Page 545
   Finding Your Way Around the Navigation Pane......Page 546
   Designing a Database......Page 548
   Creating a Database Table......Page 553
   Opening and Viewing Tables......Page 557
   Entering and Altering Table Fields......Page 558
   Field Properties for Making Sure That Data Entries Are Accurate......Page 564
   Indexing for Faster Sorts, Searches, and Queries......Page 572
   Establishing Relationships Between Database Tables......Page 574
   The Two Ways to Enter Data......Page 581
   Entering the Data in Datasheet View......Page 582
   Entering the Data in a Form......Page 586
   Finding a Missing Record......Page 588
   Finding and Replacing Data......Page 589
   Sorting Records in a Database Table......Page 591
   Filtering to Find Information......Page 592
   Querying: The Basics......Page 598
   Six Kinds of Queries......Page 606
   Creating a Report......Page 611
   Tweaking a Report......Page 613
 Book VIII: Working with Charts and Graphics......Page 615
   The Basics: Creating a Chart......Page 617
   Choosing the Right Chart......Page 619
   Providing the Raw Data for Your Chart......Page 620
   Positioning Your Chart in a Workbook, Page, or Slide......Page 622
   Changing a Chart’s Appearance......Page 623
   Saving a Chart as a Template So That You Can Use It Again......Page 629
   Chart Tricks for the Daring and Heroic......Page 630
   Troubleshooting a Chart......Page 633
   The Basics: Creating SmartArt Diagrams......Page 635
   Creating the Initial Diagram......Page 637
   Changing the Size and Position of a Diagram......Page 639
   Laying Out the Diagram Shapes......Page 640
   Handling the Text on Diagram Shapes......Page 646
   Changing a Diagram’s Direction......Page 647
   Choosing a Look for Your Diagram......Page 648
   Changing the Appearance of Diagram Shapes......Page 649
   Creating a Diagram from Scratch......Page 652
   All about Picture File Formats......Page 655
   Inserting a Picture in an Office File......Page 659
   Touching Up a Picture......Page 663
   Compressing Pictures to Save Disk Space......Page 671
  Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects......Page 673
   The Basics: Drawing Lines, Arrows, and Shapes......Page 674
   Handling Lines, Arrows, and Connectors......Page 675
   Handling Rectangles, Ovals, Stars, and Other Shapes......Page 680
   WordArt for Embellishing Letters and Words......Page 683
   Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects......Page 684
   Changing an Object’s Size and Shape......Page 688
   Changing an Object’s Color, Outline Color, and Transparency......Page 689
   Moving and Positioning Objects......Page 694
 Book IX: Office 2013: One Step Beyond......Page 703
   Customizing the Ribbon......Page 705
   Customizing the Quick Access Toolbar......Page 711
   Changing the Screen Background......Page 714
   Customizing Keyboard Shortcuts in Word......Page 716
   Printing — the Old Standby......Page 719
   Distributing a File in PDF Format......Page 720
   Sending Your File in an E-Mail Message......Page 722
   Saving an Office File as a Web Page......Page 723
   Blogging from inside Word......Page 725
   “A Print Shop in a Can”......Page 729
   Introducing Frames......Page 730
   Creating a Publication......Page 731
   Redesigning a Publication......Page 732
   Getting a Better View of Your Work......Page 733
   Entering Text on the Pages......Page 735
   Making Text Fit in Text Frames......Page 736
   Replacing the Placeholder Pictures......Page 739
   Inserting, Removing, and Moving Pages......Page 741
   Master Pages for Handling Page Backgrounds......Page 742
   Running the Design Checker......Page 743
   Commercially Printing a Publication......Page 744
 Book X: File Sharing and Collaborating......Page 745
   Introducing the Office Web Apps......Page 747
   Storing and Sharing Files on the Internet......Page 748
   Office Web Apps: The Big Picture......Page 749
   Signing In and Out of Your Microsoft Account......Page 750
   Managing Your Folders......Page 751
   Creating an Office File in SkyDrive......Page 757
   Uploading Office Files to a Folder on SkyDrive......Page 758
   Saving a File from Office 2013 to SkyDrive......Page 759
   Opening Office Files Stored on SkyDrive......Page 761
   Managing Your Files on SkyDrive......Page 763
   Sharing Files: The Big Picture......Page 765
   Sharing Your Files and Folders with Others......Page 767
   Investigating and Changing How Files and Folders Are Shared......Page 769
   Soliciting Information with a Survey Form......Page 771
 Index......Page 775