Microsoft Office 2016 Step by Step

Microsoft Office 2016 Step by Step

by Joan Lambert, Curtis Frye
Released November 2015
Publisher(s): Microsoft Press
ISBN: 9780735699717

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Now in full color!

The quick way to get started with Microsoft Office 2016!
This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answers--brisk lessons and colorful screenshots show you exactly what to do, step by step.

  • Covers Word, Excel, PowerPoint and Outlook

  • Format documents for visual impact

  • Quickly prepare personalized email messages and labels

  • Build powerful workbooks for analysis and reporting

  • Analyze alternative data sets with Quick Analysis Lens, Goal Seek, and Solver

  • Prepare highly effective presentations

  • Strengthen your presentations by adding tables and graphics

  • Organize your email, scheduling, and contacts

  • Look up just the tasks and lessons you need

    •

    Table of contents

    1. Cover
    2. Title Page
    3. Copyright Page
    4. Contents
    5. Introduction
      1. Who this book is for
      2. The Step by Step approach
      3. Download the practice files
      4. Ebook edition
      5. Get support and give feedback
        1. Errata and support
        2. We want to hear from you
        3. Stay in touch
    6. Part 1: Microsoft Office 2016
      1. 1. Explore Office 2016
        1. Work in the Office user interface
          1. Identify app window elements
          2. Work with the ribbon and status bar
        2. Change Office and app options
          1. Manage account information
          2. Manage app options
        3. Customize the Quick Access Toolbar
        4. Customize the ribbon
        5. Skills review
        6. Practice tasks
          1. Work in the Office user interface
          2. Change Office and app options
          3. Customize the Quick Access Toolbar
          4. Customize the ribbon
      2. 2. Create and manage files
        1. Create files
        2. Open and move around in files
        3. Display different views of files
        4. Display and edit file properties
        5. Save and close files
        6. Skills review
        7. Practice tasks
          1. Create files
          2. Open and move around in files
          3. Display different views of files
          4. Display and edit file properties
          5. Save and close files
    7. Part 2: Microsoft Word 2016
      1. 3. Modify the structure and appearance of text
        1. Apply paragraph formatting
          1. Configure alignment
          2. Configure vertical spacing
          3. Configure indents
        2. Structure content manually
        3. Apply character formatting
        4. Create and modify lists
        5. Apply built-in styles to text
          1. Apply styles
          2. Manage outline levels
        6. Change the document theme
        7. Skills review
        8. Practice tasks
          1. Apply paragraph formatting
          2. Structure content manually
          3. Apply character formatting
          4. Create and modify lists
          5. Apply built-in styles to text
          6. Change the document theme
      2. 4. Collaborate on documents
        1. Mark up documents
          1. Insert comments
          2. Track changes
        2. Display and review document markup
          1. Display markup
          2. Review and respond to comments
          3. Review and process tracked changes
        3. Compare and merge documents
          1. Compare and combine separate copies of a document
          2. Compare separate versions of a document
        4. Control content changes
          1. Restrict actions
          2. Restrict access by using a password
        5. Coauthor documents
        6. Skills review
        7. Practice tasks
          1. Mark up documents
          2. Display and review document markup
          3. Compare and merge documents
          4. Control content changes
          5. Coauthor documents
      3. 5. Merge data with documents and labels
        1. Understand the mail merge process
        2. Start the mail merge process
          1. Get started with letters
          2. Get started with labels
          3. Get started with email messages
        3. Choose and refine the data source
          1. Select an existing data source
          2. Create a new data source
          3. Refine the data source records
        4. Insert merge fields
        5. Preview and complete the merge
        6. Create individual envelopes and labels
          1. Generate individual envelopes
          2. Generate individual mailing labels
        7. Skills review
        8. Practice tasks
          1. Understand the mail merge process
          2. Start the mail merge process
          3. Choose and refine the data source
          4. Insert merge fields
          5. Preview and complete the merge
          6. Create individual envelopes and labels
    8. Part 3: Microsoft Excel 2016
      1. 6. Perform calculations on data
        1. Name groups of data
        2. Define Excel tables
        3. Create formulas to calculate values
        4. Summarize data that meets specific conditions
        5. Set iterative calculation options and enable or disable automatic calculation
        6. Use array formulas
        7. Find and correct errors in calculations
        8. Skills review
        9. Practice tasks
          1. Name groups of data
          2. Create formulas to calculate values
          3. Define Excel tables
          4. Summarize data that meets specific conditions
          5. Set iterative calculation options and enable or disable automatic calculation
          6. Use array formulas
          7. Find and correct errors in calculations
      2. 7. Manage worksheet data
        1. Limit data that appears on your screen
        2. Manipulate worksheet data
          1. Summarize data in worksheets that have hidden and filtered rows
          2. Find unique values within a data set
        3. Define valid sets of values for ranges of cells
        4. Skills review
        5. Practice tasks
          1. Limit data that appears on your screen
          2. Manipulate worksheet data
          3. Define valid sets of values for ranges of cells
      3. 8. Reorder and summarize data
        1. Sort worksheet data
        2. Sort data by using custom lists
        3. Organize data into levels
        4. Look up information in a worksheet
        5. Skills review
        6. Practice tasks
          1. Sort worksheet data
          2. Sort data by using custom lists
          3. Organize data into levels
          4. Look up information in a worksheet
      4. 9. Analyze alternative data sets
        1. Examine data by using the Quick Analysis Lens
        2. Define an alternative data set
        3. Define multiple alternative data sets
        4. Analyze data by using data tables
        5. Vary your data to get a specific result by using Goal Seek
        6. Find optimal solutions by using Solver
        7. Analyze data by using descriptive statistics
        8. Skills review
        9. Practice tasks
          1. Examine data by using the Quick Analysis Lens
          2. Define an alternative data set
          3. Define multiple alternative data sets
          4. Analyze data by using data tables
          5. Vary your data to get a specific result by using Goal Seek
          6. Find optimal solutions by using Solver
          7. Analyze data by using descriptive statistics
    9. Part 4: Microsoft PowerPoint 2016
      1. 10. Create and manage slides
        1. Add and remove slides
          1. Insert new slides
          2. Copy and import slides and content
          3. Hide and delete slides
        2. Divide presentations into sections
        3. Rearrange slides and sections
        4. Apply themes
        5. Change slide backgrounds
        6. Skills review
        7. Practice tasks
          1. Add and remove slides
          2. Divide presentations into sections
          3. Rearrange slides and sections
          4. Apply themes
          5. Change slide backgrounds
      2. 11. Insert and manage simple graphics
        1. Insert, move, and resize pictures
        2. Edit and format pictures
        3. Draw and modify shapes
          1. Draw and add text to shapes
          2. Move and modify shapes
          3. Format shapes
        4. Capture and insert screen clippings
        5. Create a photo album
        6. Skills review
        7. Practice tasks
          1. Insert, move, and resize pictures
          2. Edit and format pictures
          3. Draw and modify shapes
          4. Capture and insert screen clippings
          5. Create a photo album
      3. 12. Add sound and movement to slides
        1. Animate text and pictures on slides
        2. Customize animation effects
        3. Add audio content to slides
        4. Add video content to slides
        5. Compress media to decrease file size
        6. Skills review
        7. Practice tasks
          1. Animate text and pictures on slides
          2. Customize animation effects
          3. Add audio content to slides
          4. Add video content to slides
          5. Compress media to decrease file size
    10. Part 5: Microsoft Outlook 2016
      1. 13. Send and receive email messages
        1. Create and send messages
          1. Create messages
          2. Troubleshoot message addressing
          3. Save and send messages
        2. Attach files and Outlook items to messages
        3. Display messages and message attachments
          1. Display message content
          2. Display attachment content
        4. Display message participant information
        5. Respond to messages
        6. Skills review
        7. Practice tasks
          1. Create and send messages
          2. Attach files and Outlook items to messages
          3. Display messages and message attachments
          4. Display message participant information
          5. Respond to messages
      2. 14. Organize your Inbox
        1. Display and manage conversations
        2. Arrange messages by specific attributes
        3. Categorize items
        4. Organize messages in folders
        5. Skills review
        6. Practice tasks
          1. Display and manage conversations
          2. Arrange messages by specific attributes
          3. Categorize items
          4. Organize messages in folders
      3. 15. Manage scheduling
        1. Schedule appointments and events
        2. Convert calendar items
        3. Configure calendar item options
        4. Schedule and change meetings
        5. Respond to meeting requests
        6. Display different views of a calendar
        7. Skills review
        8. Practice tasks
          1. Schedule appointments and events
          2. Convert calendar items
          3. Configure calendar item options
          4. Schedule and change meetings
          5. Respond to meeting requests
          6. Display different views of a calendar
    11. Index
    12. About the authors
    13. Acknowledgments
    14. Survey

    Product information

    • Title: Microsoft Office 2016 Step by Step
    • Author(s): Joan Lambert, Curtis Frye
    • Release date: November 2015
    • Publisher(s): Microsoft Press
    • ISBN: 9780735699717