Office 2016 For Dummies

Book description

Office 2016 For Dummies (9781119293477) was previously published as Office 2016 For Dummies (9781119077374). While this version features a new Dummies cover and design, the content is the same as the prior release and should not be considered a new or updated product.


The bestselling Microsoft Office book of all time

Packed with straightforward, friendly instruction, this updated edition of the bestselling Microsoft Office book gets you thoroughly up to speed on the latest version of the industry standard for office productivity suites. In no time, Office 2016 For Dummies will help you become a whiz at Word, take your Excel skills to new heights, add pizzazz to your PowerPoint presentations, and make every part of your work day more organized and productive.

Following alongside approachable, plain-English explanations, you'll quickly discover how to type, format text, and design documents in Word; navigate and edit spreadsheets, create formulas, and analyze data in Excel; configure email, store contacts, organize tasks, and schedule your time with Outlook; create and edit well-designed and crowd-pleasing PowerPoint presentations; and design, edit, and modify an Access database. Even if the mere thought of working with Microsoft Office makes you nervous, this fun and friendly guide makes it easy.

  • Helps you make sense of word processing, email, presentations, data management and analysis, and much more
  • Covers the five main Office applications: Word, Excel, PowerPoint, Outlook, and Access
  • Walks you through the new features of Microsoft Office 2016
  • Written by a veteran author who has written more than 20 For Dummies books, which account for more than three million books in print

If you're an uninitiated user looking to make the most of this powerful suite of applications, this hands-on, friendly guide is the key to your brand new Office!

Table of contents

    1. Cover
    2. Introduction
      1. Who Should Buy This Book
      2. Icons Used in This Book
      3. Beyond the Book
      4. Getting Started
    3. Part 1: Getting Started with Office 2016
      1. Chapter 1: Introducing Microsoft Office 2016
        1. Starting an Office 2016 Program
        2. Introducing the Microsoft Office Ribbon
        3. Using the Ribbon
        4. Using the Quick Access Toolbar
        5. Customizing an Office 2016 Program
        6. Exiting Office 2016
      2. Chapter 2: Selecting and Editing Data
        1. Adding Data by Pointing
        2. Selecting Data
        3. Editing Text with the Pop-up Toolbar
        4. Deleting Data
        5. Cutting and Pasting (Moving) Data
        6. Copying and Pasting Data
        7. Using Paste Options
        8. Dragging with the Mouse to Cut, Copy, and Paste
        9. Undo and Redo
        10. Sharing Data with Other Office 2016 Programs
      3. Chapter 3: Modifying Pictures
        1. Adding (and Deleting) Pictures
        2. Manipulating Pictures
        3. Enhancing Pictures
      4. Chapter 4: Getting Help from Office 2016
        1. Searching in the Help Window
        2. Making the Help Window Easier to Read
        3. Finding the Right Commands to Use
    4. Part 2: Working with Word
      1. Chapter 5: Typing Text in Word
        1. Moving the Cursor with the Mouse
        2. Moving the Cursor with the Keyboard
        3. Navigating through a Document
        4. Finding and Replacing Text
        5. Checking Your Spelling
        6. Checking Your Grammar
        7. Viewing a Document
      2. Chapter 6: Formatting Text
        1. Changing the Font
        2. Changing the Font Size
        3. Changing the Text Style
        4. Changing Colors
        5. Justifying Text Alignment
        6. Adjusting Line Spacing
        7. Making Lists
        8. Using the Ruler
        9. Using Format Painter
        10. Using Styles
        11. Using Templates
        12. Removing Formatting from Text
      3. Chapter 7: Designing Your Pages
        1. Inserting New Pages
        2. Adding (and Deleting) a Cover Page
        3. Inserting Page Breaks
        4. Inserting Headers and Footers
        5. Organizing Text in Tables
        6. Formatting and Coloring a Table
        7. Sorting a Table
        8. Deleting Tables
        9. Making Text Look Artistic
        10. Dividing Text into Columns
        11. Previewing a Document before Printing
    5. Part 3: Playing the Numbers with Excel
      1. Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas
        1. Understanding Spreadsheets
        2. Storing Stuff in a Spreadsheet
        3. Formatting Numbers and Labels
        4. Navigating a Spreadsheet
        5. Searching a Spreadsheet
        6. Editing a Spreadsheet
        7. Clearing Data
        8. Printing Workbooks
      2. Chapter 9: Playing with Formulas
        1. Creating a Formula
        2. Using Functions
        3. Editing a Formula
        4. Conditional Formatting
        5. Data Validation
        6. Goal Seeking
        7. Creating Multiple Scenarios
        8. Auditing Your Formulas
        9. Checking for Errors
      3. Chapter 10: Charting and Analyzing Data
        1. Understanding the Parts of a Chart
        2. Creating a Chart
        3. Editing a Chart
        4. Using the Chart Tools
        5. Using Sparklines
        6. Organizing Lists in Pivot Tables
    6. Part 4: Making Presentations with PowerPoint
      1. Chapter 11: Creating a PowerPoint Presentation
        1. Defining the Purpose of Your Presentation
        2. Creating a PowerPoint Presentation
        3. Working with Text
      2. Chapter 12: Adding Color and Pictures to a Presentation
        1. Applying a Theme
        2. Changing the Background
        3. Adding Graphics to a Slide
        4. Adding Movies to a Slide
        5. Adding Sound to a Slide
      3. Chapter 13: Showing Off a Presentation
        1. Spell-Checking Your Presentation
        2. Organizing Slides in Sections
        3. Adding Visual Transitions
        4. Adding Hyperlinks
        5. Viewing a Presentation
        6. Creating Handouts
    7. Part 5: Getting Organized with Outlook
      1. Chapter 14: Managing Email with Outlook
        1. Configuring Email Settings
        2. Creating Email
        3. Attaching Files to Messages
        4. Reading and Organizing Email
        5. Deleting Email Messages
        6. Creating Quick Steps
      2. Chapter 15: Calendars, Contacts, and Tasks
        1. Setting Appointments
        2. Storing Names and Addresses
        3. Managing Tasks
    8. Part 6: Storing Stuff in Access
      1. Chapter 16: Using a Database
        1. Understanding the Basics of a Database
        2. Designing a Database
        3. Editing and Modifying a Database
        4. Typing Data into a Database
        5. Closing and Saving a Database
      2. Chapter 17: Searching, Sorting, and Querying a Database
        1. Searching a Database
        2. Sorting a Database
        3. Querying a Database
      3. Chapter 18: Creating a Database Report
        1. Using the Report Wizard
        2. Manipulating the Data in a Report
        3. Editing a Report
        4. Making Reports Look Pretty
        5. Deleting a Report
    9. Part 7: The Part of Tens
      1. Chapter 19: Ten Tips for Using Office 2016
        1. Saving Office 2016 Files
        2. Password-Protecting Your Files
        3. Guarding Against Macro Viruses
        4. Customize the Ribbon
        5. Send Feedback to Microsoft
        6. When in Doubt, Right-Click the Mouse
        7. Freezing Row and Column Headings in Excel
        8. Displaying Slides Out of Order in PowerPoint
        9. Reduce Spam in Outlook
        10. Using Office 365 and Office on Android and iOS
      2. Chapter 20: Almost Ten Ways to Make Office 2016 Easier to Use
        1. Build (and Use) Your Own Office Add-Ins
        2. Collaborating with the Review Tab
        3. Using Word’s References Tab
        4. Using Excel’s Data Tab
        5. Saving and Sending Files
        6. Encrypting a File
        7. Saving to the Cloud
        8. Ignoring the Silly Office Ribbon
    10. About the Author
    11. Advertisement Page
    12. Connect with Dummies
    13. End User License Agreement

Product information

  • Title: Office 2016 For Dummies
  • Author(s): Wallace Wang
  • Release date: June 2016
  • Publisher(s): Wiley
  • ISBN: 9781119293477