You are previewing My Office® 2016.
O'Reilly logo
My Office® 2016

Book Description

My Office 2016 introduces readers to this new version of the suite and shows them how to get the most out of the apps. The book clearly explains what to expect from the new version of Office, what the program limitations are, and discusses best practices for using the apps. My Office 2016 teaches readers how to use Word, Excel, PowerPoint, Outlook, Access, and OneDrive in an easy-to-follow, task-based format. Topics covered include how to use the main features that come with each Office application, how to synchronize documents between devices, and how to collaborate with others.

• Master core skills you can use in every Office 2016 program
• Quickly create visual documents with advanced formatting and graphics
• Build complex documents with columns, footnotes, headers, and tables
• Enter and organize Excel data more accurately and efficiently
• Quickly move, copy, delete, and format large amounts of data with Excel ranges
• Use charts to make data more visual, intuitively understandable, and actionable
• Add pizzazz to PowerPoint slide shows with animations and transitions
• Use Outlook 2016 to efficiently manage your email, contacts, and calendar
• Bring all your ideas and notes together in a OneNote notebook
• Start building useful Access 2016 databases
• Customize your Office applications to work the way you do
• Store and share your Office files in the cloud with Microsoft OneDrive
• Collaborate with others, including people using other versions of Office



Table of Contents

  1. About This eBook
  2. Title Page
  3. Copyright Page
  4. Contents at a Glance
  5. Table of Contents
  6. About the Author
  7. Dedication
  8. Acknowledgments
  9. We Want to Hear from You!
  10. Reader Services
  11. 1. Getting Started with Office 2016
    1. Understanding Office 365 and Office 2016
      1. Learning How Office 365 Works
    2. Taking Your First Steps with Office 2016
      1. Sign In to Your Microsoft Account
      2. Create a Microsoft Account
      3. Sign Out of Your Microsoft Account
      4. Switch Between Office 2016 Applications
    3. Creating a New Document
      1. Create a Blank Document at Startup
      2. Create a Blank Document After an Office 2016 Application Is Running
      3. Creating a Document from a Template or Theme
    4. Preserving Your Work
      1. Save a New Document
      2. Create a Duplicate of a Document
      3. Convert a Document to the Latest Format
    5. Working with Documents
      1. Open a Document
      2. Pin a Document to the Recent Tab
      3. Print a Document
  12. 2. Formatting Documents
    1. Selecting Text
      1. Select Text with a Mouse
    2. Changing the Font
      1. Understanding Typefaces
      2. Set the Typeface
      3. Change the Type Size
      4. Apply Type Effects
      5. Set Text Colors
    3. Formatting Paragraphs
      1. Align Paragraphs
      2. Set the Line Spacing
      3. Build a Bulleted List
      4. Create a Numbered List
      5. Set the Indentation
    4. Working with Formatting
      1. Apply Styles
      2. Apply Text Effects
      3. Clear Formatting
  13. 3. Working with Office 2016 Graphics
    1. Working with Shapes
      1. Inserting a Line
      2. Inserting Any Other Shape
    2. Inserting Images
      1. Inserting a Picture
      2. Understanding SmartArt Graphics
      3. Inserting a SmartArt Graphic
      4. Inserting WordArt
    3. Formatting and Editing Graphic Objects
      1. Selecting Graphic Objects
      2. Lassoing Graphic Objects
      3. Sizing a Graphic Object
      4. Moving a Graphic Object
      5. Rotating a Graphic Object
      6. Formatting a Graphic Object
  14. 4. Working with Text in Word
    1. Learning Text Basics
      1. Enter and Edit Text
      2. Enter Text with AutoCorrect
      3. Insert Symbols
      4. Insert Symbols Using AutoCorrect
      5. Set Tabs
      6. Enter Headings
    2. Finding and Replacing Text
      1. Find Text
      2. Replace Text
    3. Proofing Text
      1. Handle Spelling and Grammar Errors
    4. Adding Hyperlinks
      1. Insert a Hyperlink
  15. 5. Working with Page Layout and Design in Word
    1. Building a Table
      1. Insert a Table
      2. Select Table Elements
      3. Format a Table
      4. Insert New Rows
      5. Insert New Columns
      6. Delete Table Elements
    2. Working with Headers and Footers
      1. Adding a Header
      2. Adding a Footer
    3. Changing the Page Setup
      1. Setting the Margins
      2. Changing the Page Orientation
      3. Changing the Paper Size
      4. Add a Page Break
      5. Understanding Sections
      6. Add a Section Break
      7. Display Text in Columns
    4. Adding Footnotes and Endnotes
      1. Insert a Footnote or Endnote
  16. 6. Entering Excel Data
    1. Understanding Worksheet Cells and Data
      1. Working with Numbers
      2. Working with Text
      3. Working with Dates and Times
    2. Entering and Editing Data
      1. Enter Cell Data
      2. Edit Cell Data
    3. Working with Formulas and Functions
      1. Build a Formula
      2. Understanding Functions
      3. Add a Function Directly to a Cell
      4. Add a Function Using the Function Wizard
    4. Building a Table
      1. Convert Cells to a Table
      2. Select Table Elements
      3. Format a Table
      4. Add New Rows and Columns
      5. Delete Rows and Columns
      6. Sort a Table
      7. Filter a Table
  17. 7. Getting More Out of Excel Ranges
    1. Selecting a Range
      1. Select a Range with a Mouse
      2. Select a Range on a Touchscreen
    2. Working with Excel Ranges
      1. Fill a Range with a Specific Value
      2. Fill a Range with a Series of Values
      3. Make a Copy of a Range
      4. Move a Range
      5. Insert a Range
      6. Delete a Range
    3. Working with Range Names
      1. Name a Range
    4. Formatting a Range
      1. Learning About Data Formats
      2. Apply a Numeric or Date Format
      3. Control the Number of Decimal Places
      4. Resize Columns
      5. Resize Rows
      6. Add Borders
      7. Wrap Text Within a Cell
  18. 8. Visualizing Excel Data with Charts
    1. Creating a Chart
      1. Create an Embedded Chart
      2. Create a Chart in a Separate Sheet
    2. Working with Charts
      1. Understanding Excel’s Chart Types
      2. Change the Chart Type
      3. Move a Chart
      4. Resize a Chart
      5. Change the Chart Layout and Style
    3. Working with Chart Elements
      1. Select Chart Elements
      2. Format Chart Elements
      3. Add Titles
      4. Add a Chart Legend
      5. Add Data Marker Labels
  19. 9. Building a PowerPoint Presentation
    1. Adding a Slide to the Presentation
      1. Understanding Slide Layouts
      2. Insert a New Slide
      3. Duplicate a Slide
    2. Adding Data to a Slide
      1. Add Text
      2. Create a Bulleted List
      3. Add a Video
      4. Add a Chart
      5. Add a Table
    3. Working with Slides
      1. Select Slides
      2. Rearrange Slides
      3. Change the Layout of a Slide
      4. Hide a Slide
      5. Add Notes to a Slide
    4. Understanding the Slide Master
      1. Work with the Slide Master
  20. 10. Working with PowerPoint Slide Shows
    1. Defining Slide Animations
      1. Animation Guidelines
      2. Set Up a Slide Transition
      3. Animate Slide Objects
      4. Add an Animation
    2. Preparing a Slide Show
      1. Rehearse Slide Timings
      2. Recording Narration
      3. Record Narration for a Slide
      4. Record Narration for an Entire Presentation
    3. Setting Up Multiple Versions of a Slide Show
      1. Create a Custom Slide Show
    4. Running a Slide Show
      1. Start the Slide Show
      2. Navigate Slides
      3. Set Up an Automatic Slide Show
  21. 11. Sending and Receiving Outlook Email
    1. Setting Up Your Email Account
      1. Add an Account Automatically
      2. Add an Account Manually
    2. Composing and Sending a New Message
      1. Compose a Message
      2. Use the Contacts List to Specify Recipients
      3. Attach a File to a Message
    3. Reading and Working with Incoming Mail
      1. Retrieve and Read Messages
      2. Reply to a Message
      3. Forward a Message
      4. Save an Attachment
      5. Move a Message
      6. Delete a Message
  22. 12. Scheduling with the Outlook Calendar
    1. Using the Calendar Folder
      1. Switch to the Calendar Folder
      2. Navigate to a Date
      3. Switch the Calendar’s View
    2. Setting Up Appointments
      1. Create a New Appointment
      2. Taking Advantage of AutoDate
      3. Create a Recurring Appointment
      4. Appointments Versus All-Day Events
      5. Schedule an All-Day Event
      6. Understanding Meeting Requests
      7. Request a Meeting
  23. 13. Keeping in Touch with Outlook Contacts
    1. Exploring the Contacts Folder
      1. Switch to the Contacts Folder
      2. Understanding the Contacts Folder Views
    2. Adding a New Contact
      1. Create a New Contact from Scratch
      2. Understanding Outlook’s Contact Data Fields
      3. Create a Contact from the Same Company
      4. Create a Contact from an Email Message
    3. Importing Contact Data
      1. Import Contact Data
    4. Working with Your Contacts
      1. Edit Contact Data
      2. Add a Picture for a Contact
      3. Send an Email to a Contact
      4. Request a Meeting with a Contact
      5. View a Map of a Contact’s Address
      6. Print a Contact Address on an Envelope or Label
  24. 14. Building a OneNote Notebook
    1. Working with Sections
      1. Insert a New Section
      2. Rename a Section
      3. Color-Code a Section
    2. Working with Pages
      1. Insert a New Page
      2. Insert a New Page from a Template
      3. Enter Text on a Page
      4. Work with Page Containers
    3. Building a OneNote Table
      1. Insert a Table
    4. Working with Tags
      1. Tag an Item
      2. Build Lists
      3. Create a To-Do List
  25. 15. Getting More Out of OneNote
    1. Working with Notebooks
      1. Create a New Notebook
      2. Switch Between Notebooks
      3. Set Notebook Properties
    2. Adding Data to a Page
      1. Insert the Date and Time
      2. Add a Link to a Website
      3. Add a Link to a OneNote Location
      4. Insert a Spreadsheet File
      5. Insert a New Spreadsheet
      6. Attach a File
    3. Adding Ink
      1. Handwrite Text
      2. Highlight Text
      3. Convert Ink to Text
      4. Erase Ink
  26. 16. Learning Access Basics
    1. Understanding Access Databases
    2. Creating a Database
      1. Create a Database
    3. Building and Working with Tables
      1. Designing a Table
      2. Learning About Access Data Types
      3. Create a Table
      4. Enter Data
      5. Sort Table Data
      6. Filter Table Data
    4. Querying Access Data
      1. Design a Simple Query
      2. Understanding Query Criteria
      3. Enter Query Criteria
    5. Creating Forms
      1. Create a Basic Form
      2. Navigating Form Fields and Records
      3. Run the Form Wizard
    6. Creating Reports
      1. Create a Basic Report
      2. Run the Report Wizard
  27. 17. Customizing the Office 2016 Applications
    1. Working with Application Options
      1. Working with the Options Dialog Box
      2. Changing Your User Name and Initials
      3. Bypassing the Start Screen at Launch
    2. Customizing the Interface
      1. Pinning the Ribbon
      2. Hiding the Ribbon
      3. Customizing the Ribbon
      4. Changing the Position of the Quick Access Toolbar
      5. Customizing the Quick Access Toolbar
      6. Setting the Office Background
  28. 18. Collaborating with Others
    1. Collaborating in Word with Comments and Changes
      1. Insert Comments in a Word Document
      2. Edit a Comment
      3. Delete a Comment
      4. Track Changes in a Word Document
      5. Control the Display of Comments and Changes
      6. Control the Markup Display
      7. Navigate Comments and Changes
      8. Accept or Reject Comments and Changes
    2. Collaborating in Excel with Comments and Changes
      1. Insert Comments in Cells
      2. View Workbook Comments
      3. Track Worksheet Changes
      4. Accept or Reject Workbook Changes
      5. Share an Excel Workbook with Other Users
      6. Display and Removing Reviewers
      7. Handle Sharing Conflicts
    3. Sharing a Document Online
      1. Save a Document to OneDrive
      2. Send an Invitation to Share a OneDrive Document
      3. Copy a Link to Share a OneDrive Document
  29. A. Excel Worksheet Function Reference
    1. Financial Functions
    2. Date and Time Functions
    3. Math and Trigonometry Functions
    4. Statistical Functions
    5. Lookup and Reference Functions
    6. Database Functions
    7. Text Functions
    8. Logical Functions
    9. Information Functions
    10. Engineering Functions
    11. Cube Functions
    12. Compatibility Functions
    13. Web Functions
  30. Index
  31. Code Snippets