You are previewing Teach Yourself VISUALLY Office 2016.
O'Reilly logo
Teach Yourself VISUALLY Office 2016

Book Description

Quickly and efficiently learn the latest version of Office

Are you a visual learner who wants to spend more time working in Microsoft Office than trying to figure out how the programs actually work? Teach Yourself Visually Office offers you a straightforward, visual approach to making your work life more efficient and productive using the latest version of the Microsoft Office suite. Featuring visually rich tutorials and step-by-step instructions that will help you make the most of this power-packed suite of office productivity tools, it covers everything you need to compute, document, graph, chart, present, and organize your way to success in the workplace—from the most basic to the most advanced.

The Microsoft Office suite can be intimidating to the uninitiated, but it doesn't have to be. Through a series of easy-to-follow, full-color two-page tutorials, you'll quickly get up and running on working in Word, excelling at Excel, powering through PowerPoint, keeping in touch on Outlook, managing data in Access, and propelling your way through Publisher like a pro!

  • Highly visual tutorials and step-by-step screenshots make lessons easy to follow and understand

  • Helps you grasp the basic functions of Microsoft Office—and beyond

  • Walks you through Microsoft Office's new features

  • Demonstrates how to use the Microsoft Office suite to make your work life more streamlined and effective

  • Whether you're looking to discover what's new in the latest release of Microsoft Office or don't know Access from Word, this visual guide makes learning easy!

    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. Check Your File for Hidden or Personal Data
          6. Email a File
          7. Select Data
          8. Cut, Copy, and Paste Data
          9. 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. Mark Index Entries
          12. Generate an Index
          13. Generate a Table of Contents
          14. 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. Combine Reviewers’ Comments
          11. 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
          10. Understanding PivotTables
          11. Create a PivotTable
          12. Create a PivotChart
          13. Insert a PivotTable Slicer
      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. Organize Slides into Sections
          4. Define Slide Transitions
          5. Add Animation Effects
          6. Create a Custom Animation
          7. Record Narration
          8. Insert a Background Song
          9. Create Speaker Notes
          10. Rehearse a Slide Show
          11. Run a Slide Show
          12. Review a Presentation
          13. Package Your Presentation on a CD
          14. 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
          15. Format Form Fields
          16. Add a Background Image
        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
          9. Create a Message Rule
      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
          8. Add a Building Block Object
          9. Create a Building Block Object
      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