Office 2016 In Depth

Office 2016 In Depth

Released October 2015
Publisher(s): Que
ISBN: 9780134273761

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

Beyond the Basics…

Beneath the Surface…In Depth

Do more in less time!

Whatever your Microsoft Office experience, don’t let Office 2016 make you feel like a beginner! This book is packed with intensely useful knowledge, tips, and shortcuts you just won’t find anywhere else. It’s the fastest, best way to master Office 2016’s full power, and the great new features built into Word, Excel, PowerPoint, Outlook, Publisher, and OneNote. This friendly, expert guide will make you way more productive… whether you’re creating documents, analyzing data, delivering presentations, designing newsletters, taking quick notes, or managing your life!

  • Take full advantage of Office 2016’s cloud integration

  • Use Insights for Office to quickly access information

  • Easily create complex Word documents, from books to mail merges

  • Coauthor Word documents with collaborators in real time

  • Build flexible, reliable Excel workbooks with formulas and functions

  • Transform data into insight with Excel charts and PivotTables

  • Discover best practices for creating great PowerPoint slides, handouts, and notes

  • Take advantage of the new Tell Me Box, which provides access to contextual and traditional Office help features including the new Insights pane

  • Use Outlook 2016’s Clutter feature to clear away low-priority email

  • Create visually compelling documents of all kinds with Publisher 2016

  • Gather, organize, share, and use knowledge with OneNote 2016

  • Get more done faster by integrating OneNote with other Office 2016 components

  • Discover Microsoft’s new mobile Word, Excel, and PowerPoint apps for Windows 10

    • All In Depth books offer

  • Comprehensive coverage, with detailed solutions

  • Practical, real-world examples with nothing glossed over or left out

  • Troubleshooting help for tough problems you can’t fix on your own

    •

    Table of contents

    1. About This eBook
    2. Title Page
    3. Copyright Page
    4. Contents at a Glance
    5. Contents
    6. About the Author
    7. Dedication
    8. Acknowledgments
    9. We Want to Hear from You!
    10. Reader Services
    11. Introduction
      1. Who Should Buy This Book
      2. How This Book Is Organized
      3. Conventions Used in This Book
        1. Key Combinations
        2. Special Elements
        3. Cross-References
    12. I: Introduction to the Office 2016 Application Suite
      1. 1. Getting Oriented to the Office 2016 Applications
        1. Introducing Office 2016
        2. New Features and Tools in Office 2016
          1. Saving and Sharing Files in the Cloud
          2. Editing Adobe Acrobat Files
          3. Other Office 2016 Improvements and Updates
        3. The Office 2016 Suite Applications
        4. The Different Versions of the Office 2016 Suite
        5. Hardware and Software Requirements for Office 2016
        6. Installing Office 2016
        7. Getting Help in the Office Applications
      2. 2. Navigating and Customizing the Office Interface
        1. Getting Familiar with the Office Interface
          1. Galleries
          2. Contextual Tabs
          3. Overview of the Office Application Window
        2. Navigating the Office Applications
          1. Working with the Ribbon
          2. Working in the Backstage
        3. Customizing an Application Interface
          1. Customizing the Ribbon
          2. Customizing the Quick Access Toolbar
          3. Customizing the Status Bar
        4. Configuring Application Options
          1. Advanced Option Settings
          2. Add-Ins
        5. Using Office Add-ins
        6. Using the Trust Center
          1. Trusted Publishers
          2. Trusted Locations
      3. 3. Managing and Sharing Office Files
        1. Understanding Office File Formats
          1. Saving Files as Different File Types
          2. Converting Files to Different File Types
        2. Configuring Save File Options
        3. Creating and Managing Files
          1. Managing Files
          2. Creating a New Folder
          3. Creating a New Library
          4. Viewing File Versions in an Application
        4. Searching for Office Files
        5. Sharing Files Using Homegroup
        6. Protecting an Office File
        7. Prepare a File for Sharing
      4. 4. Using and Creating Graphics
        1. The Office 2016 Options for Graphics and Pictures
          1. Working with SmartArt Graphics
          2. Inserting SmartArt Graphics
          3. Modifying SmartArt Graphics
        2. Working with Your Digital Pictures
          1. Inserting Pictures
          2. Adjusting Pictures
          3. Cropping an Image
          4. Using the Background Removal Tool
        3. Inserting Online Pictures
          1. Inserting Bing Image Search Results
          2. Inserting Facebook Images
          3. Inserting Flickr.com Images
          4. Inserting Images from Your OneDrive
        4. Using Shapes and the Office Drawing Tools
          1. Adding and Combining Multiple Shapes
          2. Formatting a Shape with the Drawing Tools
        5. Using the Screenshot Feature
        6. Using WordArt
      5. 5. Using the Office Apps
        1. What the Online Apps Can Do
        2. Where the Online Apps Live
        3. Saving Office Application Files to the Cloud
          1. Saving a File to OneDrive or OneDrive for Business
          2. Sharing a File Saved to the Cloud
        4. Using the Word Online app
          1. The Word Online App’s File Tab
          2. The Word Online App’s Home Tab
          3. The Word Online App’s Insert Tab
          4. The Word Online App’s Review Tab
          5. The Word Online App’s View Tab
        5. Using Excel Online
          1. The Excel Online App’s File Tab
          2. Working in the Excel Online App
          3. Inserting Functions and Charts in the Excel Online App
        6. Using PowerPoint Online
          1. Working with Slides
          2. Adding Pictures and SmartArt
        7. The Windows 10 Mobile Office Apps
          1. The Word Mobile App
          2. The Excel Mobile App
    13. II: Word
      1. 6. Requisite Word: Essential Features
        1. Introducing Word 2016
          1. The Word 2016 Interface
          2. New Features and Improvements
        2. Options for Creating a New Word Document
        3. Using Templates
          1. Creating a Template
          2. Attaching a Template
        4. Navigating a Word Document
          1. Moving Around a Document with the Mouse
        5. Moving Around a Document with the Keyboard
          1. Selecting Text
        6. Understanding Document Formatting
          1. Character Formatting Versus Paragraph Formatting
          2. Manual Formatting Versus Styles and Themes
        7. Working with Fonts and Text Formatting
          1. Formatting Text
        8. Working with Paragraph Formatting
          1. Setting Paragraph Alignment
          2. Changing Line Spacing
          3. Setting Line and Page Breaks
          4. Setting Indents
          5. Working with Tabs
          6. Revealing Format Settings
        9. Page Layout: Margins and Page Options
          1. Changing Margins
          2. Changing Page Orientation and Paper Size
          3. Inserting Page Breaks
        10. Printing Documents
      2. 7. Enhancing Word Documents
        1. Creating Better Documents
        2. Creating Bulleted and Numbered Lists
          1. Bulleted Lists
          2. Numbered Lists
          3. Multilevel Lists
        3. Working with Borders and Shading
        4. Formatting with Themes
        5. Creating Headers and Footers
          1. Inserting Headers and Footers
          2. The Header and Footer Tools
          3. Working with Page Numbering
        6. Inserting Pictures, Clip Art, and Charts
          1. Inserting Pictures
          2. Inserting Online Pictures and Clip Art
          3. Inserting a Chart
          4. Integrating Text and Images
        7. Changing the Document Display
          1. Using the Navigation Pane
          2. Using the Outline View
          3. Splitting the Document Window
        8. Using the Review Tools
          1. Running Spelling and Grammar
          2. Using the Thesaurus
          3. Using the Insights Command
        9. Working with Quick Parts
          1. Creating and Inserting an AutoText Entry
          2. Creating and Inserting Building Blocks
        10. Configuring AutoCorrect
        11. Understanding Styles
          1. Using the Styles Gallery
          2. Creating Styles
          3. Editing Styles
          4. Managing Styles
      3. 8. Working with Tables, Columns, and Sections
        1. Options for Adding a Table
          1. Inserting a Table
          2. Drawing a Table
          3. Converting Text to a Table
          4. Entering and Deleting Text and Navigating a Table
          5. Selecting and Positioning a Table
        2. Formatting Tables
          1. Adjusting Columns and Rows
          2. Formatting Cells
          3. Using Table Styles
        3. Sorting Table Data
        4. Using Formulas in Tables
        5. Adding Columns to a Document
        6. Understanding Sections
          1. Adding and Removing Section Breaks
          2. Formatting Page Attributes in a Section
      4. 9. Managing Mailings and Forms
        1. Options for Mail-Related Documents
        2. Creating an Envelope
        3. Creating a Label or Labels
        4. Understanding Mass Mailings
        5. Performing a Mail Merge
          1. Using the Mail Merge Commands
          2. Understanding Recipient Lists
          3. Creating a Recipient List
          4. Editing and Manipulating a Recipient List
          5. Using Merge Fields
          6. Using Merge Rules
          7. Previewing Merge Results
          8. Completing the Merge
          9. Creating Merged Envelopes and Labels
        6. Understanding Word Fields
        7. Building a Form with Form Controls
      5. 10. Creating Special Documents
        1. Options for Large Documents
        2. Creating a Table of Contents
          1. Creating a Table of Contents with Built-in Styles
          2. Creating a Table of Contents with Your Own Styles
          3. Adding Entries and Updating the TOC
          4. Building a TOC with Field Codes
        3. Working with Captions and Tables of Figures
          1. Inserting a Caption
          2. Inserting a Table of Figures
        4. Using Cross-References
        5. Generating an Index
          1. Marking Index Entries
          2. Inserting the Index
        6. Working with Citations and Bibliographies
          1. Creating Citations
          2. Managing Citations
          3. Inserting the Bibliography
        7. Inserting Footnotes and Endnotes
        8. Tracking Document Changes
          1. Options for Viewing Changes
          2. Reviewing Changes
          3. Comparing Documents
        9. Building a Better “Big” Document
          1. Creating Bookmarks
          2. Inserting Comments
        10. Creating a Master Document
          1. Working in Outline View
          2. Creating Subdocuments from Scratch
          3. Inserting Existing Document Files into a Master Document Outline
          4. Manipulating the Master Document
    14. III: Excel
      1. 11. Requisite Excel: Essential Features
        1. Introducing Excel 2016
        2. Navigating the Excel Workspace
          1. The Excel Ribbon
          2. Moving Around a Worksheet
        3. Creating Workbooks and Worksheets
          1. Using Office.com Templates
          2. Inserting and Rearranging Worksheets
        4. Managing Excel Workbooks
          1. Protecting Workbooks and Worksheets
          2. Locking Cells
          3. Specifying Edit Ranges
          4. Preparing a Workbook for Sharing
          5. Managing Versions
        5. Entering Data in a Worksheet
          1. Entering Labels
          2. Entering Values
          3. Using AutoComplete
        6. Filling and Entering Series
          1. Using the Fill Handle
          2. Creating Custom Fill Lists
          3. Creating Custom Series
          4. Using Flash Fill
        7. Copying, Moving, and Deleting Cell Contents
          1. Using the Paste Special Dialog Box
          2. Moving Cells and Ranges
          3. Clearing and Deleting Cells
        8. Editing Cell Content
        9. Viewing Worksheets
        10. Printing Worksheets
          1. Using the Page Layout Commands
          2. Setting a Print Area
          3. Inserting Page Breaks
          4. Setting Print Titles
          5. Working on the Print Page
          6. Inserting Headers and Footers
      2. 12. Worksheet Formatting and Management
        1. Formatting Text Entries
          1. Accessing the Format Cells Dialog Box
          2. Changing Text Orientation
        2. Formatting Values
          1. Using the Format Cells Dialog Box
          2. Creating Custom Number Formats
        3. Adding Comments to Cells
          1. Formatting Comment Text
          2. Deleting and Viewing Comments
        4. Using Themes
        5. Formatting Cells Using Borders and Color
          1. Adding Cell Borders
          2. Using Background Colors
        6. Using Cell Styles and the Format Painter
          1. Creating a Cell Style
          2. Using the Format Painter
        7. Using Conditional Formatting
          1. Using Highlight Cell Rules
          2. Using Top/Bottom Rules
          3. Using Data Bars
          4. Using Color Scales
          5. Using Icon Sets
          6. Creating Conditional Formatting Rules
        8. Manipulating Cells and Cell Content
          1. Inserting Cells
          2. Merging Cells and Wrapping Text
          3. Finding and Replacing Cell Items
        9. Working with Columns and Rows
          1. Changing Column Width and Row Height
          2. Inserting Columns and Rows
          3. Deleting Columns and Rows
          4. Hiding Columns and Rows
        10. Working with Worksheets
          1. Freezing Rows and Columns
          2. Splitting Worksheets
          3. Hiding Worksheets
        11. Naming Ranges
          1. Creating Range Names from Selections
          2. Managing Range Names
        12. Adding Images and Graphics to Worksheets
      3. 13. Getting the Most from Formulas and Functions
        1. Performing Calculations in Excel Worksheets
        2. Relative Versus Absolute Referencing
        3. Creating and Editing Formulas
          1. Understanding Operator Precedence
          2. Entering Formulas
          3. Editing Formulas
        4. Working with Excel Functions
        5. Entering a Function in a Cell
          1. Using AutoSum
          2. Using the Status Bar Statistical Functions
          3. Using the Insert Function Dialog Box
          4. Using the Function Library
        6. Using Range Names in Formulas and Functions
          1. Inserting a Range Name into a Formula
          2. Inserting a Range Name into a Function
        7. Referencing Cells or Ranges on Other Worksheets
        8. Copying and Moving Formulas and Functions
        9. Choosing the Right Function
          1. Financial Functions
          2. Logical Functions
          3. Statistical Functions
          4. Lookup & Reference Functions
          5. Date & Time Functions
          6. Text Functions
          7. Other Function Categories
        10. Proofing Your Formulas and Functions
          1. Common Error Messages
          2. Using the Auditing Tools
          3. Using the Watch Window
      4. 14. Enhancing Worksheets with Charts
        1. Understanding Excel Charts
          1. Chart Terminology
          2. Using Different Chart Types
        2. Creating Charts
          1. Inserting a Chart from the Ribbon
          2. Selecting a Recommended Chart
          3. Inserting Charts with the Quick Analysis Gallery
          4. Tools for Quickly Customizing a Chart
          5. Moving, Copying, or Deleting a Chart
        3. Modifying a Chart
          1. Changing Chart Type or Chart Data
          2. Selecting Chart Layouts and Styles
        4. Working with Chart Elements
          1. Modifying Titles and Data Labels
          2. Working with the Legend and Data Points
          3. Manipulating Axes and Gridlines
          4. Adding Trendlines, Drop Lines, and Bars to a Chart
        5. Creating a Combination Chart
          1. Working with a Pie of Pie Chart
          2. Creating a Custom Combination Chart
          3. Using Sparklines
          4. Creating Sparklines
          5. Modifying Sparklines
      5. 15. Using Excel Tables and Pivottables
        1. Excel and Databases
        2. Defining a Table Range
        3. Creating a Table Using Styles
        4. Using the Table Tools
        5. Sorting Table Data
          1. How Excel Sorts Data
          2. Using the Sort Dialog Box
        6. Filtering Table Data
          1. Using the AutoFilter Search Box
          2. Creating Custom AutoFilters
          3. Filtering Tables with Slicers
          4. Creating Advanced Filters
        7. Using the Data Form
        8. Creating Outlines and Subtotals
        9. Working with External Data
          1. Importing Data from Access
          2. Importing a Web Table
          3. Importing Text Files
        10. Connecting to Other Data Sources
          1. Using Microsoft Query
          2. Viewing and Refreshing Connections
        11. Working with PivotTables
          1. Using the Recommended PivotTables Command
          2. Creating a PivotTable
          3. Working with the PivotTable Tools
          4. Using Slicers
      6. 16. Validating and Analyzing Worksheet Data
        1. Taking Advantage of Data Validation
          1. Specifying Validation Criteria
          2. Configuring Input Messages and Error Alerts
          3. Circling Invalid Data
        2. Performing a What-If Analysis
          1. Creating a Data Table
          2. Creating Scenarios
          3. Viewing Scenarios and Creating Reports
        3. Using Goal Seek and Solver
          1. Working with Goal Seek
          2. Working with Solver
    15. IV: PowerPoint
      1. 17. Requisite Powerpoint: Essential Features
        1. PowerPoint 2016
        2. Options for Creating a New Presentation
          1. Using Templates
          2. Using a Theme to Create a New Presentation
          3. Creating a Presentation from an Existing Presentation
          4. Inserting Slides from the Reuse Slides Task Pane
          5. Publishing Slides to a Library
        3. Creating a Template
        4. Inserting New Slides
          1. Entering Text
          2. Inserting Slides from a Word Outline
          3. Inserting Other Object Content
        5. Modifying a Slide’s Layout
        6. Working with Slides in Different Views
          1. Zooming In and Out
          2. Rulers, Gridlines, and Guides
          3. Color/Grayscale Commands
        7. Opening a New Presentation Window
        8. Rearranging and Deleting Slides
        9. Modifying Bulleted Lists
        10. Using Numbered Lists
        11. Viewing a Presentation During Editing
      2. 18. Advanced Presentation Formatting, Themes, and Masters
        1. Working with Text Boxes and Formatting
          1. Inserting a Text Box
          2. Basic Text Formatting
          3. Formatting a Text Box with the Drawing Tools
          4. Selecting Quick Styles and Shape Attributes
          5. Shape Fill, Outline, and Effects
          6. Using WordArt Styles and Text Settings
        2. Arranging Text in Tables
          1. Inserting a Table on an Existing Slide
          2. Formatting a Table
          3. Table Layout Commands
        3. Working with Themes
          1. Applying Themes
          2. Applying Theme Variants
          3. Creating a Custom Theme
        4. Using Headers and Footers
        5. Understanding Masters
        6. Altering and Creating Master Slides
        7. Creating Layout Masters
        8. Using Slide Sections
      3. 19. Better Slides with Clip Art, Pictures, and SmartArt
        1. Using Graphics to Enhance Slides
        2. Inserting a Picture
        3. Adding Online Images to Slides
        4. Creating a Photo Album
          1. Adjusting Picture Settings
          2. Configuring Album Layout Settings
        5. Working with Shapes
        6. Using SmartArt Graphics
          1. Inserting a SmartArt Graphic
          2. Converting Text to a SmartArt Graphic
          3. Using the SmartArt Tools
        7. Adding Charts to Slides
          1. Inserting a Chart onto a Slide
          2. Modifying and Formatting a Chart
        8. Working with Slide Objects
          1. Grouping Objects
          2. Layering Objects
        9. Adding Hyperlinks to Slides
      4. 20. Enhancing Slides with Animation, Transitions, and Multimedia
        1. Animations versus Transitions
        2. Assigning Animation to a Slide Object
          1. Accessing Additional Animation Effects
          2. Using Motion Paths
        3. Advanced Animation Techniques
          1. Changing Effect Options
          2. Adding Additional Animations
          3. Using the Animation Painter
          4. Including Sound Effects with Animations
          5. Setting Timings for Animations
        4. Managing Slide Animations
        5. Adding Transitions to Slides
        6. Modifying Transitions
        7. Adding Sound to a Slide
        8. Editing Sound Options
        9. Adding Video to a Slide
          1. Inserting Online Video
          2. Inserting a Video File
          3. Modifying Your Video Clips
      5. 21. Delivering a Presentation and Creating Support Materials
        1. Planning Your Presentation
        2. Checking the Presentation for Spelling and Grammar Errors
        3. Running Through a Completed Presentation
        4. Using the Presenter View
        5. Using Hidden Slides
        6. Creating a Custom Slide Show
        7. Creating a Self-Running Presentation
          1. Setting Up a Slide Show
          2. Rehearsing Timings
          3. Recording a Slide Show
        8. Creating an Interactive Presentation
        9. Presenting a Slide Show Online
          1. Presenting Online with Skype for Business
          2. Presenting Online with the Office Presentation Service
        10. Working with the Notes and Handout Masters
          1. Setting Handout Master Options
          2. Setting Notes Master Options
        11. Printing Presentations, Notes, and Handouts
        12. Exporting a Presentation
        13. Sharing Your Presentation
    16. V: Outlook
      1. 22. Requisite Outlook: Configuration and Essential Features
        1. Introducing Outlook 2016
        2. Outlook and Email Accounts
          1. Exchange ActiveSync
          2. Outlook.com Email
          3. Internet Email
        3. Configuring Outlook at First Start
        4. Understanding Outlook Profiles
          1. Creating a New Profile
          2. Managing Profiles
          3. Loading Profiles
        5. Understanding Outlook Data Files
          1. Configuring Outlook for Microsoft Exchange Server
          2. Creating Personal Folders Files
          3. Repairing Outlook Data Files
        6. Importing and Exporting Data
          1. Importing Data
          2. Exporting Data
        7. Navigating the Outlook Workspace
          1. Accessing Outlook Items Using the Navigation Bar
        8. Working with Views in Outlook
        9. Categorizing Outlook Items
        10. Searching for Outlook Items
          1. Using Advanced Find
          2. Using Search Folders
        11. Printing Outlook Items
      2. 23. Managing Email in Outlook
        1. Working in the Mail Folder
        2. Creating an Email Message
        3. Using the Outlook Address Book
        4. Setting Message Options
          1. Specifying Email Format
          2. Setting Message Flags, Importance, and Sensitivity
          3. Configuring Voting Buttons, Receipts, and Delivery Options
          4. The Message Options/Properties Dialog Box
        5. Attaching Files and Items to a Message
          1. Attaching a Business Card
          2. Attaching a Calendar
        6. Using Themes and Email Stationery
        7. Adding a Signature
        8. Sending Mail
        9. Recalling a Message
        10. Working with Received Email
          1. Organizing Messages in the Inbox
          2. Showing Messages as Conversations
          3. Filtering Email
        11. Managing Email
          1. Using Quick Steps
          2. Answering a Message
          3. Forwarding a Message
          4. Saving an Attachment
          5. Deleting Messages
          6. Printing Mail
          7. Moving Email
        12. Managing Email Accounts
          1. Editing Email Account Settings
          2. Adding an Email Account
          3. Adding an Outlook.com Mail Account
        13. Setting Outlook Mail Options
      3. 24. Using the Calendar for Appointments and Tasks
        1. Navigating the Calendar
          1. Changing the Calendar View
          2. Change the Time Scale and Time Zone
        2. Scheduling an Appointment
          1. Scheduling a Recurring Appointment
          2. Scheduling an Event
          3. Editing and Managing Appointments
        3. Searching the Calendar
        4. Sharing Calendars
          1. Creating a Calendar Share Invitation
          2. Opening a Shared Calendar
          3. Viewing Multiple Calendars
          4. Emailing a Calendar
          5. Publishing a Calendar Online
        5. Setting Calendar Options
        6. Working with Tasks
          1. Using the Task Folder
          2. Creating a New Task from the Task Folder
          3. Creating a Recurring Task
          4. Assigning and Accepting Tasks
          5. Viewing and Managing Tasks
          6. Managing Tasks
          7. Setting Tasks Options
      4. 25. Working with Contacts and Planning Meetings
        1. Navigating the Contacts List
        2. Creating a New Contact
          1. Entering Contact Details
          2. Adding Fields for a Contact
        3. Editing Contact Information
          1. Editing a Business Card
          2. Tagging Contacts with Flags and Categories
          3. Mapping a Contact’s Address
        4. Searching the Contacts Folder
        5. Organizing Contacts with Groups
        6. Forwarding and Sharing Contacts
          1. Forwarding Contacts
          2. Sharing Contacts
        7. Accessing Contacts on Social Networks
        8. Communicating with Contacts
        9. Contact Actions
        10. Printing Contact Information
        11. Setting Contact Options
        12. Scheduling Meetings
          1. Selecting the Meeting Location
          2. Using the Scheduling Assistant
          3. Viewing and Editing Meeting Information
        13. Responding to Meeting Requests
      5. 26. Using the Journal and Notes
        1. Using the Outlook Journal
          1. Creating a New Journal Entry
          2. Using the Journal Timer
          3. Adding Tags and Names to a Journal Entry
          4. Adding Outlook Items and Inserting Files
          5. Journal Actions
        2. Viewing the Journal
          1. Manipulating the Journal View
          2. Using Search to Filter Journal Entries
        3. Working with Notes
          1. Viewing and Managing Notes
          2. Creating Appointments and Tasks from Notes
      6. 27. Securing and Maintaining Outlook
        1. Security Overview
          1. Malware and Antivirus Software
          2. Strong Password Protection
        2. Configuring Outlook Security Settings
        3. Encrypting Email and Using Digital Signatures
          1. Options for Encrypting Email
          2. Digitally Signing Emails
        4. The Perils of HTML Email
        5. Dealing with Message Attachments
        6. Coping with Junk Email
          1. Working with the Junk Email Commands
          2. Setting Junk Email Options
        7. Creating Email Rules
          1. Creating a Quick Rule for a Specific Sender
          2. Creating Complex Rules
          3. The Rule Wizard
        8. Managing Rules
        9. Archiving Outlook Items
          1. Configuring AutoArchive Settings
          2. Setting AutoArchive Options for a Folder
          3. Archiving Manually
        10. Configuring an Autoreply Message
    17. VI: Publisher
      1. 28. Requisite Publisher: Essential Features
        1. Introducing Publisher 2016
        2. Planning Your Publication
        3. Working with Publication Templates
        4. Creating a New Publication
          1. Using a Template
          2. Using Blank Sizes
          3. Creating a New Template
          4. Navigating the Publisher Workspace
          5. Using the Rulers and Guides
          6. Options for Viewing the Publication
        5. Creating a Business Information Set
          1. Creating a New Business Information Set
          2. Creating Additional Business Information Sets
        6. Working with Text
          1. Editing Text in a Text Box
          2. Creating Your Own Text Boxes
          3. Formatting Text Boxes
          4. Linking Text Boxes
          5. Inserting a Text File
        7. Inserting Illustrations
          1. Options for Inserting Pictures
          2. Formatting a Picture
          3. Inserting Clip Art
          4. Inserting Shapes
        8. Using Building Blocks
        9. Printing Publications
      2. 29. Advanced Publisher Features
        1. Adding Pages to a Publication
        2. Configuring Page Settings
        3. Changing the Current Template
        4. Working with Master Pages
          1. Placing Objects on the Master Page
          2. Inserting Headers and Footers
          3. Creating Master Pages
        5. Using Tables in Publications
          1. Table Design Commands
          2. Table Layout Commands
        6. Manipulating Publication Objects
          1. Grouping Objects
          2. Layering Objects
          3. Swapping Images
        7. Merging Data into a Publication
          1. Performing a Mail Merge
          2. Performing a Catalog Merge
        8. Fine-tuning Your Publications
          1. The Spelling Feature
          2. Hyphenation
          3. Design Checker
    18. VII: OneNote
      1. 30. Requisite OneNote: Essential Features
        1. Introducing OneNote
          1. How OneNote Notebooks Are Organized
        2. Navigating the OneNote Workspace
          1. The OneNote Ribbon
          2. The Notebook Pane
        3. Creating a Notebook
        4. Modifying Notebook Properties
          1. Sharing a Notebook
          2. Viewing the Sync Status
        5. Working with Sections
          1. Creating or Deleting a Section
          2. Modifying Sections
          3. Merging a Section
          4. Creating a Section Group
        6. Working with Pages
          1. Creating Pages Using Templates
          2. Creating Subpages
        7. Restoring Sections and Pages from the Notebook Recycle Bin
        8. Inserting and Formatting Notes
        9. Using Tags
        10. Finding Tagged Notes
        11. Using Tables to Store Information
      2. 31. Working with Notebook Pages
        1. Managing Pages
          1. Using the Move or Copy Pages Dialog Box
          2. Making More Space Available on a Page
        2. Modifying the Page Setup and View
        3. Viewing Page Versions
        4. Viewing Recent Edits
        5. Viewing Changes by Author
        6. Adding Objects to Notebook Pages
          1. Adding Pictures
          2. Recording Audio
          3. Recording Video
          4. Adding Drawings to OneNote Pages
        7. Printing Notebook Pages
      3. 32. Integrating OneNote with Other Office Applications
        1. Taking Linked Notes
        2. Using File Printout
        3. Adding Links
        4. Attaching Files
        5. Inserting Screen Clips
        6. Integrating OneNote and Outlook
          1. Adding Outlook Tasks
          2. Emailing a Notebook Page
          3. Inserting Meeting Details
    19. VIII: Appendix
      1. A. Office Application Integration
        1. Sharing Application Data
        2. Understanding Object Linking and Embedding
          1. Choosing Between Linking and Embedding
        3. Linking Objects
          1. Linking with Paste Special
          2. Linking with the Paste Options Gallery
          3. Linking Using the Object Command
        4. Updating and Breaking Links
          1. Editing Linked Objects
          2. Embedding Objects
          3. Embedding with Paste Special
          4. Embedding Using the Object Command
          5. Embedding New Objects
        5. Editing Embedded Objects
        6. Sharing Data with Outlook Using Actions
      2. B. Office Macros
        1. Macros and Office 2016
          1. Adding the Developer Tab to the Ribbon
          2. Enabling Macros in the Trust Center
          3. Creating Macro-Enabled Office Files
        2. Understanding Macros
        3. Creating a Macro
          1. Recording a Macro
          2. Assigning a Macro Button to the Quick Access Toolbar
        4. Running Macros
        5. Editing Recorded Macros
          1. Exploring the VBA Editor
          2. Stepping Through a Macro
        6. Digitally Signing Macros
    20. Index
    21. Code Snippets

    Product information

    • Title: Office 2016 In Depth
    • Author(s):
    • Release date: October 2015
    • Publisher(s): Que
    • ISBN: 9780134273761