Microsoft Office Home and Student Edition 2013 All-in-One For Dummies

Peter Weverka is a veteran For Dummies author who has written about a wide variety of applications. Along with two bestselling editions of Office All-in-One For Dummies, Peter has written PowerPoint All-in-One For Dummies and Microsoft Money For Dummies.

• Introduction 1What’s in This Book, Anyway? 1What Makes This Book Different 2Easy-to-look-up information 2A task-oriented approach 3Meaningful screen shots 3Foolish Assumptions 3Conventions Used in This Book 3Icons Used in This Book 4Book I: Common Office Tasks 5Chapter 1: Office Nuts and Bolts 7A Survey of Office Applications 7Starting an Office Program 9Starting an Office program in Windows 7 and Vista 9Starting an Office program in Windows 8 10Finding Your Way Around the Office Interface 12The File tab and Backstage 13The Quick Access toolbar 13The Ribbon and its tabs 14Context-sensitive tabs 14The anatomy of a tab 15Live previewing 16Mini-toolbars and shortcut menus 17Office 2013 for keyboard lovers 17Saving Your Files 18Saving a file 18Saving a file for the first time 18Declaring where you like to save files 19Saving AutoRecovery information 20Navigating the Save As and Open Windows 21Opening and Closing Files 23Opening a file 23Closing a file 24Reading and Recording File Properties 24Locking a File with a Password 25Password-protecting a file 25Removing a password from a file 26Chapter 2: Wrestling with the Text 27Manipulating the Text 27Selecting text 27Moving and copying text 28Taking advantage of the Clipboard task pane 29Deleting text 30Changing the Look of Text 30Choosing fonts for text 31Changing the font size of text 32Applying font styles to text 33Applying text effects to text 34Underlining text 35Changing the color of text 35Quick Ways to Handle Case, or Capitalization 36Entering Symbols and Foreign Characters 38Creating Hyperlinks 39Linking a hyperlink to a web page 39Creating a hyperlink to another place in your file 41Creating an e-mail hyperlink 42Repairing and removing hyperlinks 43Chapter 3: Speed Techniques Worth Knowing About 45Undoing and Repeating Commands 45Undoing a mistake 45Repeating an action — and quicker this time 46Zooming In, Zooming Out 47Viewing a File Through More Than One Window 48Correcting Typos on the Fly 48Entering Text Quickly with the AutoCorrect Command 50Book II: Word 2013 53Chapter 1: Speed Techniques for Using Word 55Introducing the Word Screen 55Creating a New Document 57Getting a Better Look at Your Documents 60Viewing documents in different ways 60Splitting the screen 63Selecting Text in Speedy Ways 64Moving Around Quickly in Documents 65Keys for getting around quickly 65Navigating from page to page or heading to heading 66Going there fast with the Go To command 66Bookmarks for hopping around 68Inserting a Whole File into a Document 69Entering Information Quickly in a Computerized Form 69Creating a computerized form 70Entering data in the form 72Chapter 2: Laying Out Text and Pages 73Paragraphs and Formatting 73Inserting a Section Break for Formatting Purposes 74Breaking a Line 76Starting a New Page 76Setting Up and Changing the Margins 77Indenting Paragraphs and First Lines 79Clicking an Indent button (for left-indents) 79“Eyeballing it” with the ruler 80Indenting in the Paragraph dialog box 81Numbering the Pages 81Numbering with page numbers only 82Including a page number in a header or footer 83Changing page number formats 83Putting Headers and Footers on Pages 84Creating, editing, and removing headers and footers 85Fine-tuning a header or footer 87Adjusting the Space between Lines 88Adjusting the Space Between Paragraphs 89Creating Numbered and Bulleted Lists 90Simple numbered and bulleted lists 90Constructing lists of your own 91Managing a multilevel list 92Working with Tabs 93Hyphenating Text 94Automatically and manually hyphenating a document 95Unhyphenating and other hyphenation tasks 96Chapter 3: Word Styles 97All About Styles 97Styles and templates 97Types of styles 98Applying Styles to Text and Paragraphs 99Applying a style 99Experimenting with style sets 100Choosing which style names appear on the Style menus 101Creating a New Style 103Creating a style from a paragraph 103Creating a style from the ground up 103Modifying a Style 105Creating and Managing Templates 106Creating a new template 107Opening a template so that you can modify it 110Modifying, deleting, and renaming styles in templates 111Chapter 4: Constructing the Perfect Table 113Talking Table Jargon 113Creating a Table 114Entering the Text and Numbers 116Selecting Different Parts of a Table 117Laying Out Your Table 118Changing the size of a table, columns, and rows 118Adjusting column and row size 119Inserting columns and rows 119Deleting columns and rows 121Moving columns and rows 122Aligning Text in Columns and Rows 122Merging and Splitting Cells 123Repeating Header Rows on Subsequent Pages 124Formatting Your Table 125Designing a table with a table style 125Calling attention to different rows and columns 127Decorating your table with borders and colors 127Using Math Formulas in Tables 130Neat Table Tricks 131Changing the direction of header row text 131Wrapping text around a table 132Using a picture as the table background 133Drawing diagonal lines on tables 134Drawing on a table 135Chapter 5: Taking Advantage of the Proofing Tools 137Correcting Your Spelling Errors 137Correcting misspellings one at a time 138Running a spell-check 139Preventing text from being spell checked 140Checking for Grammatical Errors in Word 141Getting a Word Definition 142Finding and Replacing Text 142The basics: Finding stray words and phrases 143Narrowing your search 144Conducting a find-and-replace operation 149Researching a Topic Inside Word 150Finding the Right Word with the Thesaurus 152Proofing Text Written in a Foreign Language 153Telling Office which languages you will use 153Marking text as foreign language text 154Translating Foreign Language Text 155Chapter 6: Desktop Publishing with Word 157Experimenting with Themes 157Sprucing Up Your Pages 159Decorating a page with a border 159Putting a background color on pages 160Getting Word’s help with cover letters 160Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos 161Working with the Drawing Canvas 162Positioning and Wrapping Objects Relative to the Page and Text 163Wrapping text around an object 163Positioning an object on a page 165Working with Text Boxes 167Inserting a text box 167Making text flow from text box to text box 168Dropping In a Drop Cap 168Watermarking for the Elegant Effect 169Putting Newspaper-Style Columns in a Document 170Doing the preliminary work 170Running text into columns 171Landscape Documents 172Printing on Different Size Paper 173Showing Online Video in a Document 173Chapter 7: Getting Word’s Help with Office Chores 175Highlighting Parts of a Document 175Commenting on a Document 176Entering a comment 176Viewing and displaying comments 178Caring for and feeding comments 178Tracking Changes to Documents 179Telling Word to start marking changes 180Reading and reviewing a document with change marks 180Marking changes when you forgot to turn on change marks 182Accepting and rejecting changes to a document 184Printing an Address on an Envelope 184Printing a Single Address Label (Or a Page of the Same Label) 186Churning Out Letters, Envelopes, and Labels for Mass Mailings 187Preparing the source file 188Merging the document with the source file 189Printing form letters, envelopes, and labels 193Chapter 8: Tools for Reports and Scholarly Papers 195Alphabetizing a List 195Outlines for Organizing Your Work 196Viewing the outline in different ways 197Rearranging document sections in Outline view 197Collapsing and Expanding Parts of a Document 198Generating a Table of Contents 199Creating a TOC 199Updating and removing a TOC 200Customizing a TOC 200Changing the structure of a TOC 201Indexing a Document 203Marking index items in the document 203Generating the index 205Editing an index 206Putting Cross-References in a Document 207Putting Footnotes and Endnotes in Documents 209Entering a footnote or endnote 209Choosing the numbering scheme and position of notes 210Deleting, moving, and editing notes 211Compiling a Bibliography 211Inserting a citation for your bibliography 212Editing a citation 214Changing how citations appear in text 214Generating the bibliography 214Book III: Excel 2013 217Chapter 1: Up and Running with Excel 219Creating a New Excel Workbook 219Getting Acquainted with Excel 221Rows, columns, and cell addresses 222Workbooks and worksheets 223Entering Data in a Worksheet 223The basics of entering data 223Entering text labels 224Entering numeric values 225Entering date and time values 225Quickly Entering Lists and Serial Data with the AutoFill Command 228Formatting Numbers, Dates, and Time Values 231Conditional Formats for Calling Attention to Data 232Establishing Data-Validation Rules 234Chapter 2: Refining Your Worksheet 237Editing Worksheet Data 237Moving Around in a Worksheet 238Getting a Better Look at the Worksheet 239Freezing and splitting columns and rows 239Hiding columns and rows 241Comments for Documenting Your Worksheet 242Selecting Cells in a Worksheet 244Deleting, Copying, and Moving Data 245Handling the Worksheets in a Workbook 245Keeping Others from Tampering with Worksheets 247Hiding a worksheet 248Protecting a worksheet 248Chapter 3: Formulas and Functions for Crunching Numbers 251How Formulas Work 251Referring to cells in formulas 251Referring to formula results in formulas 254Operators in formulas 255The Basics of Entering a Formula 257Speed Techniques for Entering Formulas 257Clicking cells to enter cell references 257Entering a cell range 258Naming cell ranges so that you can use them in formulas 259Referring to cells in different worksheets 262Copying Formulas from Cell to Cell 263Detecting and Correcting Errors in Formulas 264Correcting errors one at a time 264Running the error checker 265Tracing cell references 266Working with Functions 267Using arguments in functions 268Entering a function in a formula 269Chapter 4: Making a Worksheet Easier to Read and Understand 273Laying Out a Worksheet 273Aligning numbers and text in columns and rows 273Inserting and deleting rows and columns 275Changing the size of columns and rows 277Decorating a Worksheet with Borders and Colors 278Cell styles for quickly formatting a worksheet 279Formatting cells with table styles 281Slapping borders on worksheet cells 281Decorating worksheets with colors 283Getting Ready to Print a Worksheet 283Making a worksheet fit on a page 284Making a worksheet more presentable 287Repeating row and column headings on each page 288Chapter 5: Advanced Techniques for Analyzing Data 291Seeing What the Sparklines Say 291Managing Information in Lists 292Sorting a list 293Filtering a list 293Forecasting with the Goal Seek Command 295Performing What-If Analyses with Data Tables 297Using a one-input table for analysis 297Using a two-input table for analysis 299Analyzing Data with PivotTables 300Creating a PivotTable 301Putting the finishing touches on a PivotTable 302Book IV: PowerPoint 2013 303Chapter 1: Getting Started in PowerPoint 305Getting Acquainted with PowerPoint 306A Brief Geography Lesson 307A Whirlwind Tour of PowerPoint 309Creating a New Presentation 310Advice for Building Persuasive Presentations 312Creating New Slides for Your Presentation 315Inserting a new slide 315Speed techniques for inserting slides 317Conjuring slides from Word document headings 318Selecting a different layout for a slide 318Getting a Better View of Your Work 319Changing views 319Looking at the different views 319Hiding and Displaying the Slides Pane and Notes Pane 321Selecting, Moving, and Deleting Slides 321Selecting slides 321Moving slides 322Deleting slides 322Putting Together a Photo Album 322Creating your photo album 323Putting on the final touches 325Editing a photo album 325Hidden Slides for All Contingencies 325Hiding a slide 326Showing a hidden slide during a presentation 326Chapter 2: Fashioning a Look for Your Presentation 327Looking at Themes and Slide Backgrounds 327Choosing a Theme for Your Presentation 329Creating Slide Backgrounds on Your Own 330Using a solid (or transparent) color for the slide background 330Creating a gradient color blend for slide backgrounds 331Placing a picture in the slide background 332Using a photo of your own for a slide background 334Using a texture for a slide background 335Changing the Background of a Single or Handful of Slides 336Choosing the Slide Size 337Using Master Slides and Master Styles for a Consistent Design 337Switching to Slide Master view 338Understanding master slides and master styles 338Editing a master slide 340Changing a master slide layout 340Chapter 3: Entering the Text 341Entering Text 341Choosing fonts for text 342Changing the font size of text 342Changing the look of text 343Fun with Text Boxes and Text Box Shapes 345Controlling How Text Fits in Text Frames and Text Boxes 346Choosing how PowerPoint “AutoFits” text in text frames 346Choosing how PowerPoint “AutoFits” text in text boxes 349Positioning Text in Frames and Text Boxes 349Handling Bulleted and Numbered Lists 350Creating a standard bulleted or numbered list 350Choosing a different bullet character, size, and color 351Choosing a different list-numbering style, size, and color 352Putting Footers (and Headers) on Slides 353Some background on footers and headers 353Putting a standard footer on all your slides 354Creating a nonstandard footer 354Removing a footer from a single slide 356Chapter 4: Making Your Presentations Livelier 357Suggestions for Enlivening Your Presentation 357Presenting Information in a Table 358Exploring Transitions and Animations 360Showing transitions between slides 361Animating parts of a slide 362Making Audio Part of Your Presentation 364Inserting an audio file on a slide 365Telling PowerPoint when and how to play an audio file 366Playing audio during a presentation 367Playing Video on Slides 368Inserting a video on a slide 368Fine-tuning a video presentation 368Experimenting with the look of the video 370Recording a Voice Narration for Slides 371Chapter 5: Delivering a Presentation 373All about Notes 373Rehearsing and Timing Your Presentation 374Showing Your Presentation 375Starting and ending a presentation 376Going from slide to slide 377Tricks for Making Presentations a Little Livelier 379Wielding a pen or highlighter in a presentation 379Blanking the screen 381Zooming In 381Delivering a Presentation When You Can’t Be There in Person 382Providing handouts for your audience 382Creating a self-running, kiosk-style presentation 383Creating a user-run presentation 385Presenting a Presentation Online 387Packaging your presentation on a CD 389Creating a presentation video 391Book V: OneNote 2013 395Chapter 1: Up and Running with OneNote 397Introducing OneNote 397Finding Your Way Around the OneNote Screen 398Notebook pane 399Section (and section group) tabs 399Page window 399Page pane 399Units for Organizing Notes 399Creating a Notebook 400Creating Sections and Section Groups 402Creating a new section 402Creating a section group 403Creating Pages and Subpages 404Creating a new page 404Creating a new subpage 404Renaming and Deleting Groups and Pages 405Getting from Place to Place in OneNote 405Changing Your View of OneNote 406Chapter 2: Taking Notes 409Entering a Typewritten Note 409Notes: The Basics 409Moving and resizing note containers 410Formatting the Text in Notes 410Selecting notes 411Deleting notes 412Getting more space for notes on a page 412Drawing on the Page 412Drawing with a pen or highlighter 413Drawing a shape 413Changing the size and appearance of drawings and shapes 415Converting a Handwritten Note to Text 416Writing a Math Expression in a Note 417Taking a Screen-Clipping Note 418Recording and Playing Audio Notes 419Recording an audio note 420Playing an audio note 420Attaching, Copying, and Linking Files to Notes 421Attaching an Office file to a note 421Copying an Office file into OneNote 423Linking a Word or PowerPoint file to OneNote 423Copying a note into another Office program 424Chapter 3: Finding and Organizing Your Notes 425Finding a Stray Note 425Searching by word or phrase 425Searching by author 426Tagging Notes for Follow Up 427Tagging a note 428Arranging tagged notes in the task pane 428Creating and modifying tags 429Color-Coding Notebooks, Sections, and Pages 430Merging and Moving Sections, Pages, and Notes 431Book VI: Working with Charts and Graphics 433Chapter 1: Creating a Chart 435The Basics: Creating a Chart 435Choosing the Right Chart 437Area charts 438Bar charts 439Column charts 440Combo charts 442Line charts 442Pie charts 443Radar charts 444Stock charts 445Surface charts 446XY (scatter) charts 447Providing the Raw Data for Your Chart 448Positioning Your Chart in a Workbook, Page, or Slide 450Changing a Chart’s Appearance 450Changing the chart type 452Changing the size and shape of a chart 452Choosing a new look for your chart 452Changing the layout of a chart 453Handling the gridlines 454Changing a chart element’s color, font, or other particular 455Saving a Chart as a Template So That You Can Use It Again 456Saving a chart as a template 456Creating a chart from a template 457Chart Tricks for the Daring and Heroic 457Decorating a chart with a picture 457Annotating a chart 458Displaying the raw data alongside the chart 459Placing a trendline on a chart 460Troubleshooting a Chart 461Chapter 2: Making a SmartArt Diagram 463The Basics: Creating SmartArt Diagrams 463Choosing a diagram 464Making the diagram your own 465Creating the Initial Diagram 465Creating a diagram 466Swapping one diagram for another 466Changing the Size and Position of a Diagram 467Laying Out the Diagram Shapes 467Selecting a diagram shape 468Removing a shape from a diagram 468Moving diagram shapes to different positions 468Adding shapes to diagrams apart from hierarchy diagrams 469Adding shapes to hierarchy diagrams 470Adding shapes to Organization charts 471Promoting and demoting shapes in hierarchy diagrams 473Handling the Text on Diagram Shapes 474Entering text on a diagram shape 474Entering bulleted lists on diagram shapes 474Changing a Diagram’s Direction 475Choosing a Look for Your Diagram 476Changing the Appearance of Diagram Shapes 477Changing the size of a diagram shape 477Exchanging one shape for another 478Changing a shape’s color, fill, or outline 478Changing fonts and font sizes on shapes 480Creating a Diagram from Scratch 480Chapter 3: Handling Graphics, Photos, and Clip Art 481All about Picture File Formats 481Bitmap and vector graphics 481Resolution 483Compression 484Color depth 484Choosing file formats for graphics 485Inserting a Picture in an Office File 485Inserting a picture of your own 486Obtaining a picture online 487Touching Up a Picture 489Softening and sharpening pictures 489Correcting a picture’s brightness and contrast 490Recoloring a picture 491Choosing an artistic effect 492Selecting a picture style 493Cropping off part of a picture 494Removing the background 495Compressing Pictures to Save Disk Space 496Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 499The Basics: Drawing Lines, Arrows, and Shapes 500Handling Lines, Arrows, and Connectors 501Changing the length and position of a line or arrow 502Changing the appearance of a line, arrow, or connector 502Attaching and handling arrowheads on lines and connectors 504Connecting shapes by using connectors 504Handling Rectangles, Ovals, Stars, and Other Shapes 506Drawing a shape 506Changing a shape’s symmetry 508Using a shape as a text box 508WordArt for Embellishing Letters and Words 509Creating WordArt 510Editing WordArt 510Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 511Selecting objects so that you can manipulate them 512Hiding and displaying the rulers and grid 513Changing an Object’s Size and Shape 514Changing an Object’s Color, Outline Color, and Transparency 515Filling an object with color, a picture, or a texture 516Making a color transparent 518Putting the outline around an object 518Moving and Positioning Objects 520Tricks for aligning and distributing objects 520When objects overlap: Choosing which appears above the other 523Rotating and flipping objects 525Grouping objects to make working with them easier 526Book VII: Office 2013 — One Step Beyond 529Chapter 1: Customizing an Office Program 531Customizing the Ribbon 531Displaying and selecting tab, group, and command names 533Moving tabs and groups on the Ribbon 533Adding, removing, and renaming tabs, groups, and commands 534Creating new tabs and groups 535Resetting your Ribbon customizations 536Customizing the Quick Access Toolbar 537Adding buttons to the Quick Access toolbar 537Changing the order of buttons on the Quick Access toolbar 539Removing buttons from the Quick Access toolbar 539Placing the Quick Access toolbar above or below the Ribbon 539Customizing the Status Bar 540Changing the Screen Background 541Customizing Keyboard Shortcuts in Word 542Chapter 2: Ways of Distributing Your Work 545Printing — the Old Standby 545Distributing a File in PDF Format 546About PDF files 546Saving an Office file as a PDF 547Saving an Office File as a Web Page 548Choosing how to save the component parts 548Turning a file into a web page 549Opening a web page in your browser 550Blogging from inside Word 550Describing a blog account to Word 550Posting an entry to your blog 552Taking advantage of the Blog Post tab 552Chapter 3: Automating Tasks with Macros 553What Is a Macro? 553Displaying the Developer Tab 554Managing the Macro Security Problem 554Recording a Macro 556Enabling your files for macros 556Ground rules for recording macros 557Recording the macro 558Running a Macro 560Editing a Macro 561Opening a macro in the Visual Basic Editor 561Reading a macro in the Code window 562Editing the text that a macro enters 562Deleting parts of a macro 563Running a Macro from a Button on the Quick Access Toolbar 563Chapter 4: Linking and Embedding in Compound Files 565What Is OLE, Anyway? 565Linking and embedding 566Uses for object linking 566Uses for object embedding 568Pitfalls of object linking and embedding 568Embedding Data from Other Programs 568Embedding foreign data 569Editing an embedded object 571Linking to a Source File 571Establishing the link 572Updating a link 573Editing data in the source file 574Converting a linked object to an embedded object 574Book VIII: File Sharing and Collaborating 577Chapter 1: Preparing to Use the Office Web Apps 579Introducing the Office Web Apps 579Storing and Sharing Files on the Internet 580Office Web Apps: The Big Picture 581Creating a Microsoft Account 582Signing In and Out of Your Microsoft Account 582Navigating in a Microsoft Account 583Managing Your Folders 583Creating a folder 584Viewing and locating folders in the SkyDrive window 584Going from folder to folder in SkyDrive 586Deleting, moving, and renaming folders 587Chapter 2: Using the Office Web Apps 589Creating an Office File in SkyDrive 589Uploading Office Files to a Folder on SkyDrive 590Saving a File from Office 2013 to SkyDrive 591Opening Office Files Stored on SkyDrive 593Opening a file in an Office Web App 593Opening a file in an Office 2013 application 593Downloading Files from SkyDrive to Your Computer 595Managing Your Files on SkyDrive 596Chapter 3: Sharing and Collaborating 599Sharing Files: The Big Picture 599File access privileges 599Links for sharing files 600Sharing Your Files and Folders with Others 601Seeing Files and Folders Others Have Shared with You 603Investigating and Changing How Files and Folders Are Shared 603Co-editing Shared Files on SkyDrive 605Soliciting Information with a Survey Form 605Index 609