You are previewing Microsoft Office Home and Student 2013: Step by Step.
O'Reilly logo
Microsoft Office Home and Student 2013: Step by Step

Book Description

The smart way to learn Microsoft Office Home and Student 2013—one step at a time!

Experience learning made easy—and quickly teach yourself how to get more done with Microsoft Word, Excel, PowerPoint, and OneNote. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Use Office anywhere with touch-enabled devices

  • Save time and work more easily with templates

  • Make professional-looking documents and presentations

  • Build spreadsheets to calculate and visualize data

  • Organize and share your best ideas with OneNote

  • Work with friends using social media and the cloud

  • Table of Contents

    1. Microsoft Office Home and Student 2013: Step by Step
    2. A Note Regarding Supplemental Files
    3. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Download the practice files
      4. Your companion ebook
      5. Getting support and giving feedback
        1. Errata
        2. We want to hear from you
        3. Stay in touch
    4. I. Office Home and Student 2013 fundamentals
      1. 1. Getting comfortable in Office Home and Student 2013
        1. Exploring the Office environment
        2. Working with Office files
        3. Recovering unsaved files and versions
        4. Customizing the user interface
          1. Customizing the Office environment
          2. Customizing the Quick Access toolbar
          3. Customizing the status bar
        5. Customizing the ribbon
        6. Choosing the right application for the task at hand
        7. Key points
      2. 2. Using shared Office features
        1. Identifying new shared features in Office Home and Student 2013
        2. Applying Office themes
        3. Inserting graphics, videos, charts, and diagrams
          1. Inserting charts
        4. Searching for online templates
        5. Presenting Office documents online
          1. Inserting online video
        6. Key points
      3. 3. Sharing and collaborating
        1. Defining the term cloud service
        2. Signing in and managing your Office account
        3. Connecting cloud services to your Office account
          1. Saving files on SharePoint Online and SkyDrive
          2. Sharing files with others from SharePoint Online or SkyDrive
          3. Opening files from the cloud
        4. Syncing files with SkyDrive for offline use
          1. Syncing with SkyDrive Pro
          2. Syncing with SkyDrive for a Microsoft Account
        5. Getting started with co-authoring
        6. Key points
      4. 4. Using touch in Office
        1. Getting comfortable with Office on a tablet
          1. Looking at unsupported features
        2. Using touch mode
        3. Selecting content with touch
        4. Working with ink in Office
        5. Key points
    5. II. Word 2013
      1. 5. Getting comfortable in Word 2013
        1. Exploring the Word 2013 user interface
        2. Modifying your document view
        3. Changing other view options
        4. Discovering what’s new in Word 2013
        5. Key points
      2. 6. Navigating and reading documents
        1. Navigating a document by scrolling and using keyboard shortcuts
        2. Searching and navigating a document by using the Navigation pane
        3. Collapsing and expanding document content
        4. Working with documents in the new Read Mode
        5. Exploring research tools in Read Mode
        6. Key points
      3. 7. Editing and composing documents
        1. Moving the cursor by using keyboard shortcuts
        2. Selecting text by using the keyboard and mouse
          1. Selecting text by using the keyboard
          2. Selecting text by using the mouse
          3. Using other selection methods
        3. Using formatting marks during document composition
        4. Inserting symbols, international characters, and other special characters
          1. Inserting special characters
        5. Using AutoCorrect
        6. Composing documents faster by using building blocks
        7. Key points
      4. 8. Formatting documents
        1. Formatting documents more efficiently
        2. Setting default document formatting for your documents
        3. Setting section formatting
        4. Using styles for paragraph and character formats
        5. Exploring other paragraph formats
        6. Exploring other character formats
          1. Changing case
        7. Managing pagination through formatting
        8. Key points
      5. 9. Presenting information
        1. Formatting simple lists by using bullets and numbering
        2. Creating tabbed lists
        3. Inserting tables
        4. Enhancing tables
        5. Key points
      6. 10. Finalizing documents
        1. Correcting proofing errors
        2. Inspecting documents before publishing
        3. Marking documents as final
        4. Creating PDF files in Word
          1. Converting PDF files for editing
        5. Printing documents
        6. Key points
    6. III. PowerPoint 2013
      1. 11. Getting comfortable in PowerPoint 2013
        1. Getting started working with PowerPoint 2013
        2. Exploring the PowerPoint 2013 tools
        3. Discovering the new features in PowerPoint 2013
        4. Key points
      2. 12. Designing and creating presentations
        1. Creating a new presentation based on a theme or template
        2. Applying a theme to an existing presentation
        3. Customizing your file with colors, fonts, and effects
          1. Theme fonts
          2. Theme colors
        4. Applying theme effects to your presentation
          1. Applying background styles to your presentation
          2. Formatting placeholders on the slide master
        5. Adding graphics to the slide master and layouts
        6. Creating a custom slide layout
        7. Changing your presentation from a 16:9 format to a 4:3 format
        8. Key points
      3. 13. Creating on-slide content
        1. Choosing a slide layout and adding text in placeholders
        2. Adding manual text boxes
        3. Adding and formatting a table
        4. Inserting and formatting charts
        5. Creating and formatting SmartArt diagrams
        6. Reusing slides and keeping their source formatting
        7. Key points
      4. 14. Creating Office graphics
        1. Adding and formatting shapes
        2. Applying enhanced fills and effects
        3. Creating your own shapes
        4. Inserting, cropping, and formatting pictures
        5. Key points
      5. 15. Adding animation and multimedia
        1. Adding animation to text and shapes
        2. Editing video and applying transitions
        3. Inserting and playing online video
        4. Saving your presentation as a video
        5. Key points
      6. 16. Finalizing and presenting
        1. Adding and renaming sections
        2. Inserting comments
        3. Printing slides and notes
        4. Finalizing your presentation
        5. Delivering a presentation
        6. Practicing with Presenter view
        7. Key points
    7. IV. Excel 2013
      1. 17. Getting comfortable in Excel 2013
        1. Starting Excel 2013
        2. Identifying what’s new in Excel 2013
          1. Using the new features in Excel
          2. Other enhancements, improvements, and feature upgrades
        3. Key points
      2. 18. Creating and editing worksheets
        1. Entering and organizing data
        2. Changing column widths
        3. Using formatting to alter the appearance of data
        4. Extending a series with AutoFill
          1. Introducing Flash Fill
        5. Selecting and naming cell ranges
        6. Using column headers to define names
        7. Moving around in the worksheet
        8. Moving and adjusting cells
        9. Moving and copying rows and columns
        10. Copying one or more cells to many
        11. Key points
      3. 19. Manipulating numbers and text
        1. Creating, editing, and copying formulas
        2. Using functions
          1. Using the AutoSum button and built-in function
          2. Inserting functions
          3. Using relative, fixed, and mixed cell references
          4. Using names in formulas and validating cell entries
          5. Looking at useful functions
            1. Handy math and trig functions
            2. Handy logical functions
            3. Handy text functions
            4. Handy date and time functions
            5. Handy lookup and reference functions
            6. Handy financial functions
        3. Working with text in Excel
          1. Combining text from multiple cells into one string
          2. Removing extra spaces
          3. Copying cells containing formulas and pasting only their resulting values
          4. Changing the case of text
        4. Restricting cell entries
        5. Key points
      4. 20. Analyzing data
        1. Exploring a built-in template
        2. Performing what-if analyses
          1. Managing multiple what-if models
        3. Using the Quick Analysis tools
        4. Formatting conditionally
        5. Analyzing data from another source
        6. Filtering data with tables
          1. Filter menu commands
        7. Adding data to tables
        8. Sorting data
        9. Creating a custom sort list
        10. Creating a PivotTable
        11. Key points
      5. 21. Formatting worksheets
        1. Applying number formatting
        2. Formatting with styles
        3. Creating custom themes
        4. Formatting in cells
        5. Working with custom number formats
        6. Working with percentage formats
        7. Working with fraction formats
        8. Working with date formats
        9. Protecting worksheets
        10. Setting view options
        11. Storing formats in templates
        12. Key points
      6. 22. Manipulating workbooks and worksheets
        1. Inserting rows and columns
        2. Inserting and deleting cells
        3. Working with panes and page layout options
        4. Printing row and column labels on every page
        5. Adjusting page breaks
        6. Creating a multisheet workbook
        7. Manipulating sheets
        8. Summarizing a multisheet workbook
        9. Working with sheet references
        10. Managing multiple workbooks
        11. Key points
      7. 23. Creating charts and graphics
        1. Creating and modifying a chart
        2. Adding a slicer to a PivotChart
          1. Manipulating chart elements
        3. Adding a timeline to a chart
        4. Manipulating objects
        5. Creating and sharing graphics
          1. Using graphics elsewhere
        6. Key points
    8. V. OneNote 2013
      1. 24. Getting comfortable in OneNote 2013
        1. Getting started with OneNote 2013
        2. Exploring the OneNote interface
        3. Identifying new and improved features in OneNote 2013
        4. Key points
      2. 25. Working with notebooks, sections, and pages
        1. Creating a notebook
        2. Creating and organizing sections
          1. Section groups
        3. Creating and organizing pages
          1. Creating subpages
          2. Adding and organizing notes
          3. Inserting images
        4. Working with ink and shapes
          1. Custom pens
          2. Shapes
          3. Erasing ink or shapes
          4. Inserting space
          5. Arranging shapes
        5. Recovering deleted sections or pages
        6. Key points
      3. 26. Using organizational tools
        1. Using tags
        2. Creating and customizing tags
        3. Using styles to format your notes
        4. Connecting OneNote to Outlook
          1. Sending email messages to OneNote
          2. Connecting appointments to OneNote
          3. Annotating contacts
        5. Connecting OneNote tasks to Outlook
        6. Using hyperlinks to tie your notes together
        7. Creating custom hyperlinks to other pages
        8. Creating and organizing tables
        9. Using the Insert Table feature
        10. Searching your notes to find information quickly
        11. Changing your search scope
        12. Key points
      4. 27. Sharing notes with others
        1. Creating a new notebook on SkyDrive
        2. Moving a notebook to SkyDrive
          1. Stopping sharing in SkyDrive
        3. Using a file server to share notes
          1. Stopping sharing on a file server
        4. Sharing notes via SharePoint
        5. Sharing notes with others during a meeting
        6. Sending notes via email
        7. Exporting to other formats
        8. Key points
      5. 28. Using OneNote everywhere
        1. Syncing your notes by using SkyDrive
        2. Accessing your notes in a web browser
        3. Using OneNote on your phone or tablet
        4. Using OneNote on an iPhone or iPad
        5. Using OneNote Mobile for Android
        6. Using OneNote Mobile on a Windows Phone
        7. Using OneNote with a Windows 8 tablet
        8. Key points
      6. 29. Saving time with OneNote
        1. Finding tags
        2. Recording audio
        3. Using Quick Notes
        4. Using screen clipping
        5. Using linked notes
        6. Searching your images
        7. Inserting a spreadsheet
        8. Using the Napkin Math feature
        9. Formatting with templates
        10. Key points
    9. A. About the authors
    10. Index
    11. About the Authors
    12. Copyright