Office 365 All-in-One For Dummies

Book description

The deepest reference on Microsoft’s productivity service

Office 365 offers the same productivity power as past versions of Microsoft Office along with tools designed to boost collaboration in the workplace and instant access to the latest Office updates without buying a whole new software package. It’s an ideal solution for both the office and home use.

The author of the bestselling Office All-in-One For Dummies shares his advice on how to navigate the nuts and bolts of getting things done with Office 365. Look inside for step-by-step instructions on Excel, Outlook, Word, PowerPoint, Access, and OneNote along with a dive into the cloud services that come with Office 365.

  • Access Office 365
  • Make sense of common Office tasks
  • Use Excel, Word, outlook, PowerPoint and more
  • Take advantage of 365 online services

If you’re a home or business user interested in having a complete reference on the suite, this book has you covered.

Table of contents

  1. Cover
  2. Introduction
    1. What Makes This Book Different
    2. Foolish Assumptions
    3. Conventions Used in This Book
    4. Icons Used in This Book
    5. Beyond the Book
  3. Book 1: Common Office Tasks
    1. Chapter 1: Office Nuts and Bolts
      1. Introducing Office 365
      2. Finding Your Way around the Office Interface
      3. Saving Your Files
      4. Navigating the Save As and Open Windows
      5. Opening and Closing Files
      6. Reading and Recording File Properties
      7. Locking a File with a Password
      8. Trusting (or not Trusting) Microsoft with Your “Content”
    2. Chapter 2: Wrestling with the Text
      1. Manipulating the Text
      2. Speaking, not Typing, the Words
      3. Changing the Look of Text
      4. Quick Ways to Handle Case, or Capitalization
      5. Entering Symbols and Foreign Characters
      6. 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 2: Word 365
    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. Getting Word to Read It
      8. 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. Correcting Grammatical Errors
      3. Finding and Replacing Text
      4. Finding the Right Word with the Thesaurus
      5. Proofing Text Written in a Foreign Language
      6. 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 3: Excel 365
    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. Notes for Documenting Your Worksheet
      5. Comments for Collaborating with Others on a Workbook
      6. Selecting Cells in a Worksheet
      7. Deleting, Copying, and Moving Data
      8. Handling the Worksheets in a Workbook
      9. 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 4: PowerPoint 365
    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 Slides Pane 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 Single or 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 5: Outlook 365
    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. 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. Linking Duplicate Contacts
      5. Sharing Contacts with Coworkers
      6. 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
      6. Managing Meetings with the Calendar
    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
  8. Book 6: Access 365
    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 among 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
  9. Book 7: Publisher 365
    1. Chapter 1: Introducing 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. Understanding and Using the Layout Guides
    2. Chapter 2: Refining a Publication
      1. Entering Text on the Pages
      2. Making Text Fit in Text Frames
      3. Formatting Text
      4. Making Text Wrap around a Frame or Graphic
      5. Replacing the Placeholder Pictures
      6. Inserting Frames on the Pages
      7. Making Frames Overlap
      8. Inserting, Removing, and Moving Pages
    3. Chapter 3: Putting on the Finishing Touches
      1. Decorating the Text
      2. Techniques for Decorating Pages
      3. Master Pages for Handling Page Backgrounds
      4. Running the Design Checker
      5. Commercially Printing a Publication
  10. Book 8: 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: Making Lines, Arrows, and Shapes
      2. Handling Lines, Arrows, and Connectors
      3. Handling Rectangles, Ovals, Stars, and Other Shapes
      4. Drawing by Freehand
      5. Decorating Your Work with Icons
      6. Inserting a 3-D Model
      7. WordArt for Embellishing Letters and Words
      8. Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
      9. Changing an Object’s Size and Shape
      10. Changing an Object’s Color, Outline Color, and Transparency
      11. Moving and Positioning Objects
  11. Book 9: Office 365: 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 Background and 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
  12. Book 10: 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 365 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 Managing How Files and Folders Are Shared
    3. Chapter 3: Collaborating in SharePoint
      1. Introducing Team Sites
      2. Working with Document Libraries
      3. Delving Deeper into Office 365
    4. Chapter 4: Working Together in Teams
      1. Introducing Microsoft Teams and Channels
      2. Setting Your Status
      3. All about Conversations
      4. Chatting Privately with a Colleague
      5. Filtering and Searching
      6. Choosing Notification Settings
      7. Sharing and Editing Files with Coworkers
      8. Holding Meetings with Coworkers
  13. Index
  14. About the Author
  15. Advertisement Page
  16. Connect with Dummies
  17. End User License Agreement

Product information

  • Title: Office 365 All-in-One For Dummies
  • Author(s): Peter Weverka, Timothy L. Warner
  • Release date: June 2019
  • Publisher(s): For Dummies
  • ISBN: 9781119576242