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

Book Description

The long-awaited Microsoft Office 2016 for Mac delivers Microsoft's most advanced versions of Word, Excel, PowerPoint, and Outlook for Mac, plus the powerful new OneDrive cloud storage capabilities. Get the most out of Microsoft Office 2016 for Mac -- the fast, easy way! Friendly, quick, and 100% practical, My Office for Mac 2016 is the must-have companion for every Microsoft Office 2016 for Mac user.

Written by Paul McFedries, a leading expert in explaining new Microsoft and Apple technologies, this friendly, intuitive guide will walk you through every task you'll want to perform. Every task is presented step-by-step, using carefully annotated, full-color screenshots, all numbered so you'll never get lost or confused. Everything's clearly organized in modular, self-contained chapters that'll help you get great results with Office 2016 in no time.

From formatting to data visualization, calendars and email to collaboration with Windows users, McFedries covers all you'll need to know. Throughout, he offers helpful tips, lists, workarounds for Office's limitations, and quick solutions to the problems you're most likely to encounter. If you want instant answers for maximum productivity, here they are!

• Master core skills you can use in every Office 2016 for Mac 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 for Mac to efficiently manage your email, contacts, and calendar
• Bring all your ideas and notes together in a OneNote notebook
• Enhance your OneNote notebooks with links, files, and more
• 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 for Mac
    1. Understanding Office 365 and Office 2016 for Mac
      1. Learning How Office 365 Works
    2. Taking Your First Steps with Office 2016 for Mac
      1. Sign In to Your Microsoft Account
      2. Create a Microsoft Account
      3. Sign Out of Your Microsoft Account
      4. Switch Between Office 2016 for Mac Applications
    3. Creating a New Document
      1. Create a Blank Document at Startup
      2. Create a Blank Document After an Office 2016 for Mac Application Is Running
      3. Creating a Document from a Template
    4. Preserving Your Work
      1. Save a New Document
      2. Create a Duplicate of a Document
    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 or Trackpad
    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 for Mac 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 with a Keyboard
    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
    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. Create a Recurring Appointment
      3. Appointments Versus All-Day Events
      4. Schedule an All-Day Event
      5. Understanding Meeting Requests
      6. Request a Meeting
  23. 13. Keeping in Touch with Outlook People
    1. Exploring the People Folder
      1. Switch to the People Folder
    2. Adding a New Contact
      1. Create a New Contact from Scratch
      2. Understanding Outlook’s Contact Data Fields
      3. Create a Contact from an Email Message
    3. Importing Contact Data
      1. Import Contact Data from Outlook for Windows
      2. Import Contact Data from Outlook 2011 for Mac
    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
  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. Enter Text on a Page
      3. 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. Sync a Notebook
    2. Adding Data to a Page
      1. Insert the Date
      2. Add a Link to a Website
      3. Add a Link to a OneNote Location
      4. Attach a File
  26. 16. Customizing the Office 2016 for Mac Applications
    1. Working with Application Preferences
      1. Working with the Preferences Dialog
      2. Changing Your User Name and Initials
      3. Bypassing the Start Screen at Launch
    2. Customizing the Interface
      1. Collapsing the Ribbon
      2. Expanding the Ribbon
      3. Adding Group Titles to the Ribbon
      4. Setting the Office Theme
      5. Adding the Developer Tab
  27. 17. 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
  28. A. Excel Worksheet Function Reference
    1. Financial Functions
    2. Date and Time Functions
    3. Math and Trig 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
  29. Index
  30. Inside Front Cover
  31. Inside Back Cover
  32. Code Snippets