Office 2016 Simplified

Office 2016 Simplified

by Elaine Marmel
Released November 2015
Publisher(s): Visual
ISBN: 9781119074748

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

Start learning the latest in Office

Office Simplified is the quick, easy, full-color guide to the new features and tools of the latest version of Office. With a clear, highly visual, introductory style of instruction, this book gives you step-by-step directions alongside illustrative screen shots to help you learn Microsoft's bestselling productivity software. You'll take a tour through all Office applications, and learn how the new tools can make your workday easier. The simplified approach eliminates unnecessary information, focusing instead on the essentials you need to know to get things done. Organized for easy navigation, this helpful guide is designed to be used both as a start-to-finish tutorial and as a handy desk reference when you run into unfamiliar territory.

Whether you're upgrading from a previous version or using the Office suite of applications for the first time, this book has you covered every step of the way. You'll find the answers you need, new tools you can use, and the step-by-step guidance that helps you get it right on the first try.

  • Get acquainted with the Office workflow
  • Walk through Word, Excel, PowerPoint, Outlook, and Publisher
  • Follow along with practical examples to tackle dozens of tasks
  • Compose documents, create spreadsheets, organize your email, and more

This book provides the ideal rundown of Microsoft Office's full feature set and capabilities. Even experienced users may learn something they never realized they were missing. If you need to get things done with minimal interruption to your workflow, Office Simplified will get you up to speed quickly and easily.

Table of contents

    1. Cover
    2. Part I: Office Features
      1. Chapter 1: Office Basics
        1. Start and Exit Office Applications
        2. Navigate the Program Windows
        3. Work with Backstage View
        4. Change the Color Scheme
        5. Find a Ribbon Command
        6. Work with the Ribbon
        7. Customize the Quick Access Toolbar
        8. Using an Office Program on a Tablet PC
      2. Chapter 2: Working with Files
        1. Create a New File
        2. Save a File
        3. Open a File
        4. Print a File
        5. Email a File
        6. Select Data
        7. Cut, Copy, and Paste Data
        8. Arrange Windows
      3. Chapter 3: Office Graphics Tools
        1. Insert a Picture
        2. Insert an Online Picture
        3. Resize and Move Objects
        4. Understanding Graphics Modification Techniques
      4. Chapter 4: Working with Office Files Online
        1. Office and the Cloud
        2. Sign In to Office 365
        3. Share a Document from Office
        4. Download Apps from the Office Store
        5. Sign In to OneDrive
        6. Using an Online App in OneDrive
        7. Using an Office Program from OneDrive
        8. Upload a Document to OneDrive
        9. Share a Document Using OneDrive
    3. Part II: Word
      1. Chapter 5: Adding Text
        1. Change Word’s Views
        2. Type and Edit Text
        3. Insert Quick Parts
        4. Insert Symbols
        5. Create a Blog Post
      2. Chapter 6: Formatting Text
        1. Change the Font, Size, and Color
        2. Align Text
        3. Set Line Spacing
        4. Indent Text
        5. Set Tabs
        6. Set Margins
        7. Create Lists
        8. Copy Formatting
        9. Clear Formatting
        10. Format with Styles
        11. Using a Template
      3. Chapter 7: Adding Extra Touches
        1. Insert an Online Video
        2. Assign a Theme
        3. Add Borders
        4. Create Columns
        5. Insert a Table
        6. Apply Table Styles
        7. Insert Table Rows or Columns
        8. Add Headers and Footers
        9. Insert Footnotes and Endnotes
        10. Insert Page Numbers and Page Breaks
        11. Generate a Table of Contents
        12. Create a Bibliography
      4. Chapter 8: Reviewing Documents
        1. Work in Read Mode View
        2. Find and Replace Text
        3. Scan Document Content
        4. Check Spelling and Grammar
        5. Work with AutoCorrect
        6. Using Word’s Thesaurus and Dictionary
        7. Translate Text
        8. Track and Review Document Changes
        9. Lock and Unlock Tracking
        10. Work with Comments
    4. Part III: Excel
      1. Chapter 9: Building Spreadsheets
        1. Enter Cell Data
        2. Select Cells
        3. Faster Data Entry with AutoFill
        4. Turn On Text Wrapping
        5. Center Data Across Columns
        6. Adjust Cell Alignment
        7. Change the Font and Size
        8. Change Number Formats
        9. Increase or Decrease Decimals
        10. Add Cell Borders and Shading
        11. Format Data with Styles
        12. Apply Conditional Formatting
        13. Add Columns and Rows
        14. Resize Columns and Rows
        15. Freeze Column and Row Titles On-Screen
        16. Name a Range
        17. Clear or Delete Cells
        18. Split and Format a Column of Data
      2. Chapter 10: Worksheet Basics
        1. Add a Worksheet
        2. Name a Worksheet
        3. Change Page Setup Options
        4. Move and Copy Worksheets
        5. Delete a Worksheet
        6. Find and Replace Data
        7. Create a Table
        8. Filter or Sort Table Information
        9. Analyze Data Quickly
        10. Understanding Data Analysis Choices
        11. Track and Review Worksheet Changes
        12. Insert a Comment
      3. Chapter 11: Working with Formulas and Functions
        1. Understanding Formulas
        2. Create a Formula
        3. Apply Absolute and Relative Cell References
        4. Understanding Functions
        5. Apply a Function
        6. Total Cells with AutoSum
        7. Audit a Worksheet for Errors
      4. Chapter 12: Working with Charts
        1. Create a Chart
        2. Move and Resize Charts
        3. Change the Chart Type
        4. Change the Chart Style
        5. Change the Chart Layout
        6. Add Chart Elements
        7. Format Chart Objects
        8. Change the Chart Data
        9. Using Sparklines to View Data Trends
    5. Part IV: PowerPoint
      1. Chapter 13: Creating a Presentation
        1. Create a New Presentation
        2. Create a Photo Album Presentation
        3. Change PowerPoint Views
        4. Insert Slides
        5. Change the Slide Layout
        6. Change the Slide Size
      2. Chapter 14: Populating Presentation Slides
        1. Add and Edit Slide Text
        2. Change the Font, Size, and Color
        3. Apply a Theme
        4. Set Line Spacing
        5. Align Text
        6. Add a Text Box to a Slide
        7. Add a Table to a Slide
        8. Add a Chart to a Slide
        9. Add a Video Clip to a Slide
        10. Move a Slide Object
        11. Resize a Slide Object
      3. Chapter 15: Assembling and Presenting a Slide Show
        1. Reorganize Slides
        2. Reuse a Slide
        3. Define Slide Transitions
        4. Add Animation Effects
        5. Record Narration
        6. Insert a Background Song
        7. Create Speaker Notes
        8. Rehearse a Slide Show
        9. Run a Slide Show
        10. Review a Presentation
        11. Package Your Presentation on a CD
        12. Present Online
    6. Part V: Access
      1. Chapter 16: Database Basics
        1. Understanding Database Basics
        2. Create a Database Based on a Template
        3. Create a Blank Database
        4. Create a New Table
        5. Change Table Views
        6. Add a Field to a Table
        7. Delete a Field from a Table
        8. Hide a Field in a Table
        9. Move a Field in a Table
        10. Create a Form
        11. Change Form Views
        12. Move a Field in a Form
        13. Delete a Field in a Form
        14. Apply a Database Theme
      2. Chapter 17: Adding, Finding, and Querying Data
        1. Add a Record to a Table
        2. Add a Record to a Form
        3. Navigate Records in a Form
        4. Search for a Record Using a Form
        5. Delete a Record from a Table
        6. Delete a Record Using a Form
        7. Sort Records
        8. Filter Records
        9. Apply Conditional Formatting
        10. Perform a Simple Query
        11. Create a Report
    7. Part VI: Outlook
      1. Chapter 18: Organizing with Outlook
        1. Navigate in Outlook
        2. Schedule an Appointment
        3. Create a New Contact
        4. Create a New Task
        5. Add a Note
        6. Customize the Navigation Bar
        7. Peek at Appointments and Tasks
        8. Search for Outlook Items
        9. Work with the To-Do Bar
        10. Link Contacts
      2. Chapter 19: Emailing with Outlook
        1. Compose and Send a Message
        2. Send a File Attachment
        3. Read an Incoming Message
        4. Reply To or Forward a Message
        5. Add a Sender to Your Outlook Contacts
        6. Delete a Message
        7. Work with Conversations
        8. Screen Junk Email
    8. Part VII: Publisher
      1. Chapter 20: Publisher Basics
        1. Create a Publication
        2. Zoom In and Out
        3. Add Text
        4. Add a New Text Box
        5. Swap Pictures
        6. Save a Publication for Photo Center Printing
      2. Chapter 21: Fine-Tuning a Publication
        1. Change the Font, Size, and Color
        2. Apply a Text Effect
        3. Change Text Alignment
        4. Add a Border
        5. Control Text Wrap
        6. Link Text Boxes
        7. Edit the Background
    9. Part VIII: OneNote
      1. Chapter 22: Taking Notes with OneNote
        1. Navigate OneNote
        2. Type and Draw Notes
        3. Insert and Format a Table
        4. Attach Files to Notes
        5. Create a Quick Note
        6. Insert a Screen Clipping
        7. Record an Audio Note
      2. Chapter 23: Organizing and Sharing Notes
        1. Create a New Notebook
        2. Create a New Section
        3. Create a New Page
        4. Rename a Section or Page
        5. Group Sections
        6. Search Notes
        7. Search for Recent Edits
        8. Set Synchronization Options
        9. Share Notes with People Who Do Not Have OneNote
    10. End User License Agreement

Product information

  • Title: Office 2016 Simplified
  • Author(s): Elaine Marmel
  • Release date: November 2015
  • Publisher(s): Visual
  • ISBN: 9781119074748