Office 2016 at Work For Dummies

Office 2016 at Work For Dummies

by Faithe Wempen
Released November 2015
Publisher(s): For Dummies
ISBN: 9781119144601

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

Get more productive using the new features in Microsoft Office 2016!

It may seem like an eternity since your IT department upgraded you to the latest version of Microsoft Office. Prepare yourself, because Office 2016 is packed with updated features and new ways to increase your productivity in the office! With Office 2016 at Work For Dummies, we make it easy by breaking the content down into over 300 of the most common tasks and operations, providing you with straightforward, simple-to-navigate, approachable information. With four-color illustrations for visual support as your work through the tasks, and then nearly three hours of supporting video, you can choose your path for learning the ins and outs of Office 2016.

As the world's leading productivity software, Microsoft Office plays an integral role in the daily lives of professionals. Understanding how to quickly and accurately use Office 2016 can improve your productivity, enhance your deliverables, and provide you with the tools and knowledge you need to be successful.

  • Choose your path for learning and explore the fundamental features of Microsoft Office 2016 through task based exercises supported by online video
  • Dive into Microsoft Word by creating a document, formatting paragraphs and pages, and adding tables and graphics
  • Explore Microsoft Excel's ability to analyze data through creating formulas and functions, and learn to format and print spreadsheets
  • Use Outlook to organize your work day, and find out how to make amazing PowerPoint presentations using the new features in the 2016 version

Office 2016 at Work For Dummies is the perfect office companion if you use Microsoft Office regularly and need to get up to speed on the changes with the latest release as quickly and efficiently as possible.

Table of contents

    1. Cover
    2. Introduction
      1. About This Book
      2. Foolish Assumptions
      3. Icons Used in This Book
      4. Beyond the Book
      5. Where to Go from Here
    3. Chapter 1: Getting to Know Office
      1. Start and exit an Office application
      2. Work with the Ribbon
      3. Use the File menu
      4. Create a new document
      5. Enter text
      6. Move around in an application
      7. Change the view
      8. Save your work
      9. Close a file
      10. Open a saved file
      11. Change locations when saving or opening files
    4. Chapter 2: Creating a Word Document
      1. Start a new document as Word starts
      2. Select text
      3. Choose between manual and style-based text formatting
      4. Remove manually applied formatting
      5. Change the text font
      6. Change the text size
      7. Select colors from a palette
      8. Change text color
      9. Apply text effects
      10. Copy formatting with Format Painter
      11. Change the style set
      12. Apply a different theme
      13. Check spelling and grammar
      14. Email a document to others
      15. Save a document in other formats
      16. Create a PDF or XPS version of your document
      17. Print your work
    5. Chapter 3: Paragraph Formatting
      1. Change a paragraph’s horizontal alignment
      2. Indent a paragraph
      3. Adjust a paragraph’s vertical spacing
      4. Place a border around a paragraph
      5. Shade a paragraph’s background
      6. Create a bulleted or numbered list
      7. Apply styles
      8. Modify styles
      9. Create new styles
    6. Chapter 4: Formatting Sections, Pages, and Documents
      1. Set margins
      2. Set page size and orientation
      3. Use page headers and footers
      4. Create page breaks
      5. Create section breaks
      6. Set up a multicolumn document
      7. Create a page border
      8. Apply a page background color
      9. Add line numbers
    7. Chapter 5: Working with Tables and Graphics in Word
      1. Create tables
      2. Select cells, rows, and columns
      3. Resize table rows and columns
      4. Add and remove rows and columns
      5. Apply borders to table cells
      6. Apply shading to table cells
      7. Insert a picture from a file
      8. Find pictures online
      9. Manage picture placement and size
      10. Caption and auto-number pictures
    8. Chapter 6: References and Mail Merges in Word
      1. Create a table of contents
      2. Insert footnotes or endnotes
      3. Cite sources and create a bibliography
      4. Create an index
      5. Mail merge: An overview
      6. Start a mail merge main document
      7. Select an existing data list for a mail merge
      8. Create a data list for a mail merge
      9. Insert merge fields in the main document
      10. Perform a mail merge
    9. Chapter 7: Creating Basic Excel Worksheets
      1. Understanding the Excel interface
      2. Move between cells
      3. Select cells and ranges
      4. Enter and edit text in cells
      5. Use AutoFill to fill cell content
      6. Copy and move data between cells
      7. Insert and delete rows, columns, and cells
      8. Use Flash Fill to extract content
      9. Create and manage multiple worksheets
    10. Chapter 8: Creating Excel Formulas and Functions
      1. Write basic formulas
      2. Copy and move formulas
      3. Insert functions
      4. Show the current date or time with a function
      5. Calculate loan terms
      6. Perform math calculations
      7. Evaluate a condition with an IF function
      8. Refer to named ranges
      9. Use Quick Analysis features
    11. Chapter 9: Formatting and Printing Excel Worksheets
      1. Apply and customize themes
      2. Apply a worksheet background
      3. Apply cell borders and shading
      4. Format cells using cell styles
      5. Resize rows and columns
      6. Make text wrap in a cell
      7. Use conditional formatting
      8. Set up headers and footers
      9. Print a worksheet
    12. Chapter 10: Storing and Managing Databases in Excel
      1. Create an Excel database
      2. Sort a table
      3. Filter a table
      4. Add a Total row to a table
      5. Create queries
      6. Remove duplicates from a dataset
      7. Restrict data entry with validation rules
    13. Chapter 11: Creating Charts in Excel
      1. Choose the correct chart type
      2. Create a chart
      3. Move and resize a chart
      4. Switch rows and columns
      5. Modify the data range for a chart
      6. Change the axis scale of a chart
      7. Apply a chart style
      8. Change a chart’s colors
      9. Add or remove chart elements
      10. Format a chart element
    14. Chapter 12: Managing Email with Outlook
      1. Understand the Outlook interface
      2. Set up a mail account
      3. Compose and send email
      4. Receive and read email
      5. Create folders for managing email
      6. Moving messages between folders
      7. Create a message handling rule
      8. Configure the junk mail filter
      9. Use an automatic signature
    15. Chapter 13: Using Outlook Contacts and Tasks
      1. Add and edit contacts
      2. View and search the People list
      3. Send a message to a contact
      4. Forward contact data via email
      5. Create and manage tasks
    16. Chapter 14: Getting Started with PowerPoint
      1. Start a new presentation
      2. Move around in a presentation
      3. Choose the right view
      4. Add and remove slides
      5. Change the slide layout
      6. Use content placeholders
      7. Manually place text on a slide
      8. Manually place a picture on a slide
      9. Move and resize slide objects
      10. Delete slide objects
    17. Chapter 15: Formatting a Presentation
      1. Understanding templates versus themes
      2. Change the theme
      3. Change the presentation colors and fonts
      4. Modify the theme in Slide Master view
      5. Enable footer placeholders
      6. Format text boxes and placeholders
      7. Create SmartArt graphics
      8. Modify the structure of a SmartArt graphic
      9. Format a SmartArt graphic
    18. Chapter 16: Adding Movement and Sound to a Presentation
      1. Add slide transition effects
      2. Set slides to advance manually or automatically
      3. Animate objects
      4. Insert a sound clip
      5. Insert a video clip on a slide
    19. Chapter 17: Presenting a Slide Show
      1. Display a slide show onscreen
      2. Annotate slides with the pen tools
      3. Use Presenter view
      4. Print handouts
      5. Export handouts to Word
    20. About the Author
    21. Cheat Sheet
    22. Advertisement Page
    23. Connect with Dummies
    24. End User License Agreement

Product information

  • Title: Office 2016 at Work For Dummies
  • Author(s): Faithe Wempen
  • Release date: November 2015
  • Publisher(s): For Dummies
  • ISBN: 9781119144601