You are previewing Office 2016 All-In-One For Dummies.
O'Reilly logo
Office 2016 All-In-One For Dummies

Book Description

The fast and easy way to get things done with Office

Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word—and every application in between—this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more—and make your work and home life easier, more productive, and more streamlined.

Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it—let alone master it. Luckily, Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office's advanced features.

  • Create customized documents and add graphic elements, proofing, and citations in Word
  • Build a worksheet, create formulas, and perform basic data analysis in Excel
  • Create a notebook and organize your thoughts in Notes
  • Manage messages, tasks, contacts, and calendars in Outlook

Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you'll turn to again and again.

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. Book I: Common Office Tasks
      1. Chapter 1: Office Nuts and Bolts
        1. A Survey of Office Applications
        2. All about Office 365
        3. Finding Your Way Around the Office Interface
        4. Saving Your Files
        5. Navigating the Save As and Open Windows
        6. Opening and Closing Files
        7. Reading and Recording File Properties
        8. Locking a File with a Password
      2. Chapter 2: Wrestling with the Text
        1. Manipulating the Text
        2. Changing the Look of Text
        3. Quick Ways to Handle Case, or Capitalization
        4. Entering Symbols and Foreign Characters
        5. Creating Hyperlinks
      3. Chapter 3: Speed Techniques Worth Knowing About
        1. Undoing and Repeating Commands
        2. Zooming In, Zooming Out
        3. Viewing a File Through More Than One Window
        4. Correcting Typos on the Fly
        5. Entering Text Quickly with the AutoCorrect Command
    4. Book II: Word 2016
      1. Chapter 1: Speed Techniques for Using Word
        1. Introducing the Word Screen
        2. Creating a New Document
        3. Getting a Better Look at Your Documents
        4. Selecting Text in Speedy Ways
        5. Moving Around Quickly in Documents
        6. Inserting a Whole File into a Document
        7. Entering Information Quickly in a Computerized Form
      2. Chapter 2: Laying Out Text and Pages
        1. Paragraphs and Formatting
        2. Inserting a Section Break for Formatting Purposes
        3. Breaking a Line
        4. Starting a New Page
        5. Setting Up and Changing the Margins
        6. Indenting Paragraphs and First Lines
        7. Numbering the Pages
        8. Putting Headers and Footers on Pages
        9. Adjusting the Space between Lines
        10. Adjusting the Space Between Paragraphs
        11. Creating Numbered and Bulleted Lists
        12. Working with Tabs
        13. Hyphenating Text
      3. Chapter 3: Word Styles
        1. All About Styles
        2. Applying Styles to Text and Paragraphs
        3. Creating a New Style
        4. Modifying a Style
        5. Creating and Managing Templates
      4. Chapter 4: Constructing the Perfect Table
        1. Talking Table Jargon
        2. Creating a Table
        3. Entering the Text and Numbers
        4. Selecting Different Parts of a Table
        5. Laying Out Your Table
        6. Aligning Text in Columns and Rows
        7. Merging and Splitting Cells
        8. Repeating Header Rows on Subsequent Pages
        9. Formatting Your Table
        10. Using Math Formulas in Tables
        11. Neat Table Tricks
      5. Chapter 5: Taking Advantage of the Proofing Tools
        1. Correcting Your Spelling Errors
        2. Checking for Grammatical Errors in Word
        3. Getting a Word Definition
        4. Finding and Replacing Text
        5. Researching a Topic Inside Word
        6. Finding the Right Word with the Thesaurus
        7. Proofing Text Written in a Foreign Language
        8. Translating Foreign Language Text
      6. Chapter 6: Desktop Publishing with Word
        1. Experimenting with Themes
        2. Sprucing Up Your Pages
        3. Making Use of Charts, Diagrams, Shapes, and Photos
        4. Working with the Drawing Canvas
        5. Positioning and Wrapping Objects Relative to the Page and Text
        6. Working with Text Boxes
        7. Dropping In a Drop Cap
        8. Watermarking for the Elegant Effect
        9. Putting Newspaper-Style Columns in a Document
        10. Landscape Documents
        11. Printing on Different Size Paper
        12. Showing Online Video in a Document
      7. Chapter 7: Getting Word’s Help with Office Chores
        1. Highlighting Parts of a Document
        2. Commenting on a Document
        3. Tracking Changes to Documents
        4. Printing an Address on an Envelope
        5. Printing a Single Address Label (Or a Page of the Same Label)
        6. Churning Out Letters, Envelopes, and Labels for Mass Mailings
      8. Chapter 8: Tools for Reports and Scholarly Papers
        1. Alphabetizing a List
        2. Outlines for Organizing Your Work
        3. Collapsing and Expanding Parts of a Document
        4. Generating a Table of Contents
        5. Indexing a Document
        6. Putting Cross-References in a Document
        7. Putting Footnotes and Endnotes in Documents
        8. Compiling a Bibliography
    5. Book III: Excel 2016
      1. Chapter 1: Up and Running with Excel
        1. Creating a New Excel Workbook
        2. Getting Acquainted with Excel
        3. Entering Data in a Worksheet
        4. Quickly Entering Lists and Serial Data with the AutoFill Command
        5. Formatting Numbers, Dates, and Time Values
        6. Establishing Data-Validation Rules
      2. Chapter 2: Refining Your Worksheet
        1. Editing Worksheet Data
        2. Moving Around in a Worksheet
        3. Getting a Better Look at the Worksheet
        4. Comments for Documenting Your Worksheet
        5. Selecting Cells in a Worksheet
        6. Deleting, Copying, and Moving Data
        7. Handling the Worksheets in a Workbook
        8. Keeping Others from Tampering with Worksheets
      3. Chapter 3: Formulas and Functions for Crunching Numbers
        1. How Formulas Work
        2. The Basics of Entering a Formula
        3. Speed Techniques for Entering Formulas
        4. Copying Formulas from Cell to Cell
        5. Detecting and Correcting Errors in Formulas
        6. Working with Functions
        7. A Look at Some Very Useful Functions
      4. Chapter 4: Making a Worksheet Easier to Read and Understand
        1. Laying Out a Worksheet
        2. Decorating a Worksheet with Borders and Colors
        3. Getting Ready to Print a Worksheet
      5. Chapter 5: Advanced Techniques for Analyzing Data
        1. Seeing What the Sparklines Say
        2. Conditional Formats for Calling Attention to Data
        3. Managing Information in Lists
        4. Forecasting with the Goal Seek Command
        5. Performing What-If Analyses with Data Tables
        6. Analyzing Data with PivotTables
    6. Book IV: PowerPoint 2016
      1. Chapter 1: Getting Started in PowerPoint
        1. Getting Acquainted with PowerPoint
        2. A Brief Geography Lesson
        3. A Whirlwind Tour of PowerPoint
        4. Creating a New Presentation
        5. Advice for Building Persuasive Presentations
        6. Creating New Slides for Your Presentation
        7. Getting a Better View of Your Work
        8. Hiding and Displaying the SlidesPane and Notes Pane
        9. Selecting, Moving, and Deleting Slides
        10. Putting Together a Photo Album
        11. Hidden Slides for All Contingencies
      2. Chapter 2: Fashioning a Look for Your Presentation
        1. Looking at Themes and Slide Backgrounds
        2. Choosing a Theme for Your Presentation
        3. Creating Slide Backgrounds on Your Own
        4. Changing the Background of a Singleor Handful of Slides
        5. Choosing the Slide Size
        6. Using Master Slides and Master Styles for a Consistent Design
      3. Chapter 3: Entering the Text
        1. Entering Text
        2. Fun with Text Boxes and Text Box Shapes
        3. Controlling How Text Fits in Text Frames and Text Boxes
        4. Positioning Text in Frames and Text Boxes
        5. Handling Bulleted and Numbered Lists
        6. Putting Footers (and Headers) on Slides
      4. Chapter 4: Making Your Presentations Livelier
        1. Suggestions for Enlivening Your Presentation
        2. Presenting Information in a Table
        3. Exploring Transitions and Animations
        4. Making Audio Part of Your Presentation
        5. Playing Video on Slides
        6. Recording a Voice Narration for Slides
      5. Chapter 5: Delivering a Presentation
        1. All about Notes
        2. Rehearsing and Timing Your Presentation
        3. Showing Your Presentation
        4. Tricks for Making Presentations a Little Livelier
        5. Delivering a Presentation When You Can’t Be There in Person
    7. Book V: OneNote 2016
      1. Chapter 1: Up and Running with OneNote
        1. Introducing OneNote
        2. Finding Your Way Around the OneNote Screen
        3. Units for Organizing Notes
        4. Creating a Notebook
        5. Creating Sections and Section Groups
        6. Creating Pages and Subpages
        7. Renaming and Deleting Groups and Pages
        8. Getting from Place to Place in OneNote
        9. Changing Your View of OneNote
      2. Chapter 2: Taking Notes
        1. Entering a Typewritten Note
        2. Notes: The Basics
        3. Drawing on the Page
        4. Converting a Handwritten Note to Text
        5. Writing a Math Expression in a Note
        6. Taking a Screen-Clipping Note
        7. Recording and Playing Audio Notes
        8. Attaching, Copying, and Linking Files to Notes
      3. Chapter 3: Finding and Organizing Your Notes
        1. Finding a Stray Note
        2. Tagging Notes for Follow Up
        3. Color-Coding Notebooks, Sections, and Pages
        4. Merging and Moving Sections, Pages, and Notes
    8. Book VI: Outlook 2016
      1. Chapter 1: Outlook Basics
        1. What Is Outlook, Anyway?
        2. Navigating the Outlook Folders
        3. Categorizing Items
        4. Searching for Stray Folder Items
        5. Deleting Email Messages, Contacts, Tasks, and Other Items
        6. Finding and Backing Up Your Outlook File
        7. Cleaning Out Your Folders
      2. Chapter 2: Maintaining the Contacts Folder
        1. Maintaining a Happy and Healthy Contacts Folder
        2. Contact Groups for Sending Messages to Groups
        3. Finding a Contact in the Contacts Folder
        4. Printing the Contacts Folder
      3. Chapter 3: Handling Your Email
        1. Setting Up an Email Account
        2. Addressing and Sending Email Messages
        3. Sending Files and Photos
        4. Receiving Email Messages
        5. Reading Your Email in the Inbox Window
        6. Handling Files That Were Sent to You
        7. Techniques for Organizing Email Messages
        8. All about Email Folders
        9. Yes, You Can Prevent Junk Mail (Sort of)
      4. Chapter 4: Managing Your Time and Schedule
        1. Introducing the Calendar
        2. The Different Kinds of Activities
        3. Seeing Your Schedule
        4. Scheduling Appointments and Events
        5. Canceling, Rescheduling, and Altering Activities
      5. Chapter 5: Tasks, Reminders, and Notes
        1. Tasks: Seeing What Needs to Get Done
        2. Reminders for Being Alerted to Activities and Tasks
        3. Making Notes to Yourself
    9. Book VII: Access 2016
      1. Chapter 1: Introducing Access
        1. What Is a Database, Anyway?
        2. Tables, Queries, Forms, and Other Objects
        3. Creating a Database File
        4. Finding Your Way Around the Navigation Pane
        5. Designing a Database
      2. Chapter 2: Building Your Database Tables
        1. Creating a Database Table
        2. Opening and Viewing Tables
        3. Entering and Altering Table Fields
        4. Field Properties for Making Sure That Data Entries Are Accurate
        5. Indexing for Faster Sorts, Searches, and Queries
        6. Establishing Relationships Between Database Tables
      3. Chapter 3: Entering the Data
        1. The Two Ways to Enter Data
        2. Entering the Data in Datasheet View
        3. Entering the Data in a Form
        4. Finding a Missing Record
        5. Finding and Replacing Data
      4. Chapter 4: Sorting, Querying, and Filtering for Data
        1. Sorting Records in a Database Table
        2. Filtering to Find Information
        3. Querying: The Basics
        4. Six Kinds of Queries
      5. Chapter 5: Presenting Data in a Report
        1. Creating a Report
        2. Opening and Viewing Reports
        3. Tweaking a Report
    10. Book VIII: Working with Charts and Graphics
      1. Chapter 1: Creating a Chart
        1. The Basics: Creating a Chart
        2. Choosing the Right Chart
        3. Providing the Raw Data for Your Chart
        4. Positioning Your Chart in a Workbook, Page, or Slide
        5. Changing a Chart’s Appearance
        6. Saving a Chart as a Template So That You Can Use It Again
        7. Chart Tricks for the Daring and Heroic
        8. Troubleshooting a Chart
      2. Chapter 2: Making a SmartArt Diagram
        1. The Basics: Creating SmartArt Diagrams
        2. Creating the Initial Diagram
        3. Changing the Size and Position of a Diagram
        4. Laying Out the Diagram Shapes
        5. Handling the Text on Diagram Shapes
        6. Changing a Diagram’s Direction
        7. Choosing a Look for Your Diagram
        8. Changing the Appearance of Diagram Shapes
        9. Creating a Diagram from Scratch
      3. Chapter 3: Handling Graphics and Photos
        1. All about Picture File Formats
        2. Inserting a Picture in an Office File
        3. Touching Up a Picture
        4. Compressing Pictures to Save Disk Space
      4. Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects
        1. The Basics: Drawing Lines, Arrows, and Shapes
        2. Handling Lines, Arrows, and Connectors
        3. Handling Rectangles, Ovals, Stars, and Other Shapes
        4. WordArt for Embellishing Letters and Words
        5. Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
        6. Changing an Object’s Size and Shape
        7. Changing an Object’s Color, Outline Color, and Transparency
        8. Moving and Positioning Objects
    11. Book IX: Office 2016 — One Step Beyond
      1. Chapter 1: Customizing an Office Program
        1. Customizing the Ribbon
        2. Customizing the Quick Access Toolbar
        3. Customizing the Status Bar
        4. Changing the Screen Backgroundand Office Theme
        5. Customizing Keyboard Shortcuts in Word
      2. Chapter 2: Ways of Distributing Your Work
        1. Printing — the Old Standby
        2. Distributing a File in PDF Format
        3. Sending Your File in an Email Message
        4. Saving an Office File as a Web Page
        5. Blogging from inside Word
      3. Chapter 3: Working with Publisher
        1. “A Print Shop in a Can”
        2. Introducing Frames
        3. Creating a Publication
        4. Redesigning a Publication
        5. Getting a Better View of Your Work
        6. Entering Text on the Pages
        7. Making Text Fit in Text Frames
        8. Making Text Wrap around a Frame or Graphic
        9. Replacing the Placeholder Pictures
        10. Inserting, Removing, and Moving Pages
        11. Master Pages for Handling Page Backgrounds
        12. Running the Design Checker
        13. Commercially Printing a Publication
    12. Book X: File Sharing and Collaborating
      1. Chapter 1: Up and Running on OneDrive
        1. Signing In to OneDrive
        2. Exploring the OneDrive Window
        3. Managing Your OneDrive Folders
        4. Uploading Files to a Folder on OneDrive
        5. Saving a File from Office 2016 to OneDrive
        6. Opening a File from OneDrive
        7. Downloading Files from OneDrive to Your Computer
      2. Chapter 2: File Sharing and Collaborating
        1. Sharing Files: The Big Picture
        2. Sharing Your Files and Folders with Others
        3. Seeing Files and Folders Others Shared with You
        4. Investigating and Changing How Files and Folders Are Shared
    13. About the Author
    14. Cheat Sheet
    15. Connect with Dummies
    16. End User License Agreement