You are previewing Microsoft Office 2013: Visual QuickStart Guide.
O'Reilly logo
Microsoft Office 2013: Visual QuickStart Guide

Book Description

Visual QuickStart Guides, designed in an attractive tutorial and reference format, are the quickest, easiest, and most thorough way to learn applications, tasks, and technologies. The Visual QuickStart Guides are a smart choice and guide the learner in a friendly and respectful tone. Visually presented with copious screenshots, the focused discussions by topic and tasks make learning a breeze and quickly take you to exactly what you want to learn.

Microsoft Office 2013: Visual QuickStart Guide, written by best-selling author Steve Schwartz, has been extensively rewritten to provide expanded coverage of the core Office applications: Word, Excel, PowerPoint, and Outlook, provides in-depth instructions on many of the new features and changes introduced in Office 2013, and offers a thorough introduction to the Office Web Apps. Coverage of each application is jam-packed with information and tips that not only explain HOW to perform a task, but WHY you need this procedure and WHEN it's best to use it.

Includes eBook
In addition to concise, step-by-step explanations of core tools and tasks, with plenty of helpful screen shots to keep you on track as you work, Microsoft Office 2013 for Windows: Visual QuickStart Guide includes the eBook. You can download digital versions of this book to load on the mobile device of your choice so that you can continue learning whenever and wherever you are. We provide you with EPUB, PDF, and MOBI eBook formats to ensure that you get the experience that best suits your viewing needs.

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Table of Contents
  5. Introduction
    1. How This Book Is Organized
    2. Which Suites Are Covered?
    3. The Office Applications
    4. How to Use This Book
    5. Command Conventions
    6. About the Author
  6. Part I: Getting Started
    1. 1. What’s New in Office 2013?
      1. Office-wide Changes
      2. Application Changes
    2. 2. Office Basics
      1. Launching Office Applications
      2. Using the Backstage
      3. Using the Ribbon
      4. Working with Windows
      5. Setting Magnification
      6. Using the Office Clipboard
      7. Customizing Office
      8. Document Management Tools
      9. Installing and Using Apps for Office
      10. Getting Help
    3. 3. Tables, Charts, and Art
      1. Inserting Tables
      2. Entering Data Into a Table
      3. Modifying the Table Grid
      4. Formatting Table Data
      5. Calculations in Tables
      6. Creating Charts
      7. About Adding Graphics and Objects
      8. Adding Pictures
      9. Adding Shapes
      10. Using a Drawing Canvas
      11. Adding SmartArt
      12. Inserting Screenshots
      13. Creating WordArt
      14. Adding a Text Box
      15. Setting Text Wrap
      16. Resizing, Moving, and Rotating Objects
      17. Image-editing Tools
  7. Part II: Microsoft Word
    1. 4. Getting Started with Word 2013
      1. The Word Interface
      2. Working in Different Views
      3. Managing Windows
      4. Setting Display Options
      5. Entering Text
      6. Basic Text Editing
      7. Using the Proofing Tools
      8. Finding and Replacing Text
      9. Entering Symbols and Special Characters
      10. Using the Navigation Pane
      11. Editing PDF Files
    2. 5. Formatting Documents
      1. Specifying Page Settings
      2. Modifying the Background
      3. Inserting Breaks
      4. Adding a Cover Page or Blank Page
      5. Adding Headers or Footers
      6. Paragraph Formatting
      7. Character Formatting
      8. Working with Styles
      9. Merge Formatting
    3. 6. Creating Outlines
      1. Entering and Exiting Outline View
      2. Starting an Outline
      3. Reorganizing an Outline
      4. Changing Display Settings
    4. 7. Sharing Word Documents
      1. Choosing a File Format
      2. Emailing Word Documents
      3. Change Tracking
      4. Comparing Documents
      5. Combining Documents
      6. Publishing Blog Entries
      7. Broadcasting a Word Document
  8. Part III: Microsoft Excel
    1. 8. Getting Started with Excel 2013
      1. The Excel Interface
      2. Workbooks and Worksheets
      3. Cell and Range Selection
      4. Entering Data
      5. Editing Data
      6. Reorganizing a Worksheet
      7. Filling Cells
      8. Importing Data
      9. Finding and Replacing Data
      10. Sorting Data
      11. Naming Cells and Ranges
      12. Password-Protecting Workbooks
    2. 9. Worksheet and Data Formatting
      1. Setting Column Width and Row Height
      2. About Data and Cell Formatting
      3. Character and Paragraph Formatting
      4. Fitting Text Within a Cell
      5. Number Formatting
      6. Conditional Formatting
      7. Cell Backgrounds and Borders
      8. Removing, Replacing, and Reusing Formats
      9. Worksheet Formatting
    3. 10. Formulas and Functions
      1. About Cell References
      2. Formula Essentials
      3. Creating Formulas
      4. Editing Formulas
      5. Troubleshooting Tips
    4. 11. Working with Tables
      1. Creating a Table
      2. Formatting a Table
      3. Creating Calculated Columns
      4. Adding a Total Row
      5. Sorting and Filtering
      6. Changing a Table’s Size
      7. Printing Tables
    5. 12. Creating Charts
      1. Chart Elements
      2. Creating a Chart
      3. Changing the Background
      4. Adding and Formatting Text
      5. Rows or Columns
      6. Changing Layout and Style
      7. Displaying the Data Set
      8. Working with Gridlines
      9. Working with the Legend
      10. Adding Trendlines
      11. Modifying the Axes
      12. Creating Sparklines
      13. Changing the Chart Data
  9. Part IV: Microsoft PowerPoint
    1. 13. Getting Started with PowerPoint 2013
      1. PowerPoint Interface
      2. Working in Different Views
      3. Creating a Presentation
    2. 14. Creating a Presentation
      1. Starting a Presentation
      2. Setting the Theme
      3. Adding and Deleting Slides
      4. Replacing Placeholders
      5. Inserting Other Items
      6. Tips for Working with Objects
      7. Creating a Photo Album
      8. Previewing a Slide Show
    3. 15. Wrapping Up a Presentation
      1. Animating Objects and Text
      2. Editing Movies
      3. Organizing the Slides
      4. Adding Transitions
      5. Rehearsing a Presentation
      6. Printing Notes and Handouts
      7. Saving a Presentation In Other Formats
      8. Delivering the Presentation
  10. Part V: Microsoft Outlook
    1. 16. Getting Started with Outlook 2013
      1. Types of Email Accounts
      2. About Email Addresses
      3. The Outlook 2013 Interface
      4. Adding Email Accounts
      5. Changing Account Settings
      6. Working with Profiles
      7. Working with Send/Receive Groups
      8. Subscribing to RSS Feeds
      9. The Outlook Social Connector
      10. Working Online and Offline
      11. Setting Preferences
      12. Getting Help
    2. 17. Managing Your Contacts
      1. The People Window
      2. Creating Contact Records
      3. Editing Contact Records
      4. Viewing Contact Records
      5. Searching for a Contact
      6. Using Business Cards
      7. Creating Contact Groups
    3. 18. Composing and Sending Mail
      1. The Message Window
      2. Creating Messages
      3. About Message Formats
      4. Formatting Message Text
      5. Adding Attachments
      6. Inserting Items
      7. Correcting Spelling Errors
      8. Using Signatures
      9. Other Message Options
    4. 19. Receiving Mail
      1. Checking for New Mail
      2. Reading Messages
      3. Changing the View
      4. Viewing Conversations
      5. Searching for Messages
      6. Receiving Attachments
      7. Printing Messages
    5. 20. Managing the Mail
      1. Marking Messages as Read
      2. Deleting Messages
      3. Managing Conversations
      4. Copying and Moving Mail
      5. Creating Message Folders
      6. Flagging Messages
      7. Handling Junk Mail and Phishing Attempts
      8. Creating Rules
      9. Working with Quick Steps
    6. 21. Appointments and Tasks
      1. Calendar Basics
      2. Creating an Appointment or Event
      3. Creating Recurring Events
      4. Responding to Reminders
      5. Modifying Events and Appointments
      6. Searching for an Event or Appointment
      7. Sharing Calendars
      8. Task Basics
      9. Creating a Task
      10. Modifying Tasks
  11. Part VI: Advanced Topics
    1. 22. Combining Office Data
      1. Copying, Linking, and Embedding
      2. Word Table into Excel
      3. Sharing Outlines: Word and PowerPoint
      4. Word Text into Excel or PowerPoint
  12. Index