Microsoft Office 2013 Simplified -- About the Author -- Author's Acknowledgments -- Dedication -- How to Use This Book -- Table of Contents -- Part I: Office Features -- Chapter 1: Office Basics -- Start and Exit Office Applications -- Navigate the Program Windows -- Work with Backstage View -- Work with the Ribbon -- Customize the Quick Access Toolbar -- Using an Office Program on a Tablet PC -- Chapter 2: Working with Files -- Create a New File -- Working with Files -- Save a File -- Open a File -- Print a File -- E-Mail a File -- Select Data -- Cut, Copy, and Paste Data -- Arrange Windows -- Chapter 3: Office Graphics Tools -- Insert a Picture -- Insert an Online Picture -- Resize and Move Graphic Objects -- Understanding Graphic Object Modification Techniques -- Chapter 4: Working with Office Files Online -- Office and the Cloud -- Sign In to Office Online -- Share a Document from Office -- Download Apps from the Office Store -- Download Apps from the Office Store (continued) -- Sign In to SkyDrive -- Using a Web App in SkyDrive -- Using an Office Program from SkyDrive -- Upload a Document to SkyDrive -- Share a Document Using SkyDrive -- Part II: Word -- Chapter 5: Adding Text -- Change Word's Views -- Type and Edit Text -- Insert Quick Parts -- Insert Symbols -- Create a Blog Post -- Chapter 6: Formatting Text -- Change the Font, Size, and Color -- Change the Font, Size, and Color (continued) -- Align Text -- Set Line Spacing -- Indent Text -- Set Tabs -- Set Margins -- Create Lists -- Copy Formatting -- Clear Formatting -- Format with Styles -- Apply a Template -- Chapter 7: Adding Extra Touches -- Insert an Online Video -- Assign a Theme -- Add Borders -- Create Columns -- Insert a Table -- Apply Table Styles -- Insert an Excel Spreadsheet -- Add Headers and Footers.

Insert Footnotes and Endnotes -- Insert Page Numbers and Page Breaks -- Generate a Table of Contents -- Create a Bibliography -- Chapter 8: Reviewing Documents -- Work in Read Mode View -- Find and Replace Text -- Scan Document Content -- Check Spelling and Grammar -- Work with AutoCorrect -- Using Word's Thesaurus and Dictionary -- Translate Text -- Track and Review Document Changes -- Lock and Unlock Tracking -- Work with Comments -- Part III: Excel -- Chapter 9: Building Spreadsheets -- Enter Cell Data -- Select Cells -- Faster Data Entry with AutoFill -- Building Spreadsheets -- Turn On Text Wrapping -- Center Data across Columns -- Adjust Cell Alignment -- Change the Font and Size -- Change Number Formats -- Increase or Decrease Decimals -- Add Cell Borders and Shading -- Format Data with Styles -- Apply Conditional Formatting -- Add Columns and Rows -- Resize Columns and Rows -- Freeze Column and Row Titles On-Screen -- Name a Range -- Clear or Delete Cells -- Split and Format a Column of Data -- Chapter 10: Worksheet Basics -- Add a Worksheet -- Name a Worksheet -- Change Page Setup Options -- Worksheet Basics -- Move and Copy Worksheets -- Delete a Worksheet -- Find and Replace Data -- Create a Table -- Filter or Sort Table Information -- Analyze Data Quickly -- Understanding Data Analysis Choices -- Track and Review Worksheet Changes -- Track and Review Worksheet Changes (continued) -- Insert a Comment -- Chapter 11: Working with Formulas and Functions -- Understanding Formulas -- Create a Formula -- Apply Absolute and Relative Cell References -- Understanding Functions -- Apply a Function -- Total Cells with AutoSum -- Audit a Worksheet for Errors -- Chapter 12: Working with Charts -- Create a Chart -- Move and Resize Charts -- Change the Chart Type -- Change the Chart Style.

Change the Chart Layout -- Add Chart Elements -- Format Chart Objects -- Change the Chart Data -- Using Sparklines to View Data Trends -- Part IV: PowerPoint -- Chapter 13: Creating a Presentation -- Create a New Presentation -- Create a Photo Album Presentation -- Change PowerPoint Views -- Insert Slides -- Change the Slide Layout -- Change the Slide Size -- Chapter 14: Populating Presentation Slides -- Add and Edit Slide Text -- Change the Font, Size, and Color -- Change the Font, Size, and Color (continued) -- Apply a Theme -- Set Line Spacing -- Align Text -- Add a Text Box to a Slide -- Add a Table to a Slide -- Add a Chart to a Slide -- Add a Video Clip to a Slide -- Move a Slide Object -- Resize a Slide Object -- Chapter 15: Assembling and Presenting a Slide -- Reorganize -- Reuse a Slide -- Define Slide Transitions -- Add Animation Effects -- Record Narration -- Insert a Background Song -- Create Speaker Notes -- Rehearse a Slide Show -- Run a Slide Show -- Run a Slide Show (continued) -- Review a Presentation -- Package Your Presentation on a CD -- Present Online -- Part V: Access -- Chapter 16: Database Basics -- Understanding Database Basics -- Create a Database Based on a Template -- Create a Blank Database -- Create a New Table -- Change Table Views -- Add a Field to a Table -- Delete a Field from a Table -- Hide a Field in a Table -- Move a Field in a Table -- Create a Form -- Change Form Views -- Move a Field in a Form -- Delete a Field in a Form -- Apply a Database Theme -- Chapter 17: Adding, Finding, and Querying Data -- Add a Record -- Add a Record to a Form -- Navigate Records in a Form -- Search for a Record in a Form -- Delete a Record from a Table -- Delete a Record from a Form -- Sort Records -- Filter Records -- Apply Conditional Formatting -- Perform a Simple Query.

Perform a Simple Query (continued) -- Create a Report -- Part VI: Outlook -- Chapter 18: Organizing with Outlook -- Navigate in Outlook -- Schedule an Appointment -- Create a New Contact -- Create a New Task -- Add a Note -- Customize the Navigation Bar -- Peek at Appointments and Tasks -- Perform a Basic Search -- Link Contacts -- Chapter 19: E-Mailiing with Outlook -- Compose and Send a Message -- Send a File Attachment -- Read an Incoming Message -- Reply To or Forward a Message -- Add a Sender to Your Outlook Contacts -- Delete a Message -- Work with Conversations -- Screen Junk E-Mail -- Part VII: Publisher -- Chapter 20: Publisher Basics -- Create a Publication -- Zoom In and Out -- Add Text -- Add a New Text Box -- Swap Pictures -- Save a Publication for Photo Center Printing -- Chapter 21: Fine-Tuning a Publication -- Change the Font, Size, and Color -- Change the Font, Size, and Color (continued) -- Apply a Text Effect -- Change Text Alignment -- Add a Border -- Control Text Wrap -- Link Text Boxes -- Edit the Background -- Part VIII: OneNote -- Chapter 22: Taking Notes with OneNote -- Navigate OneNote -- Type and Draw Notes -- Insert and Format a Table -- Attach Files to Notes -- Send Information to OneNote -- Insert a Screen Clipping -- Create a Quick Note -- Record an Audio Note -- Chapter 23: Organizing and Sharing Notes -- Create a New Notebook -- Create a New Section -- Create a New Page -- Rename a Section or Page -- Group Sections -- Search Notes -- Search for Recent Edits -- Set Synchronization Options -- Share Notes with People Who Do Not Have OneNote -- Index.