O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Office 2019 For Dummies

Book Description

Now updated and revised to cover the latest features of Microsoft Office 2019

The world’s leading suite of business productivity software, Microsoft Office helps users complete common business tasks, including word processing, email, presentations, data management and analysis, and much more. Whether you need accessible instruction on Word, Excel, PowerPoint, Outlook, or Access—or all of the above—this handy reference makes it easier. 

In Office X For Dummies, you’ll get help with typing and formatting text in Word, creating and navigating an Excel spreadsheet, creating a powerful PowerPoint presentation, adding color, pictures, and sound to a presentation, configuring email with Outlook, designing an Access database, and more. Information is presented in the straightforward but fun language that has defined the Dummies series for more than twenty years.

  • Get insight into common tasks and advanced tools
  • Find full coverage of each application in the suite
  • Benefit from updated information based on the newest software release
  • Make your work life easier and more efficiently

If you need to make sense of Office X and don’t have time to waste, this is the trusted reference you’ll want to keep close at hand!

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 2019
    1. Chapter 1: Introducing Microsoft Office 2019
      1. Starting an Office 2019 Program
      2. Introducing the Microsoft Office Ribbon
      3. Using the File Tab
      4. Using the Ribbon
      5. Using the Quick Access Toolbar
      6. Customizing an Office 2019 Program
      7. Exiting Office 2019
    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 2019 Programs
    3. Chapter 3: Modifying Pictures and Drawing on Documents
      1. Adding and Deleting Pictures
      2. Manipulating Pictures
      3. Enhancing Pictures
      4. Drawing with the Draw Tab
      5. Drawing Shapes
      6. Creating Math Equations
    4. Chapter 4: Getting Help from Office 2019
      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. Finding Formatting Tools on the Home Tab
      2. Changing the Font
      3. Changing the Font Size
      4. Changing the Text Style
      5. Changing Colors
      6. Justifying Text Alignment
      7. Adjusting Line Spacing
      8. Making Lists
      9. Using the Ruler
      10. Using Format Painter
      11. Using Styles
      12. Using Templates
      13. 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 2019
      1. Saving Office 2019 Files
      2. Password-Protecting Your Files
      3. Guarding Against Macro Viruses
      4. Customizing the Ribbon
      5. Changing the Size of the Office Window
      6. Right-Clicking the Mouse
      7. Freezing Row and Column Headings in Excel
      8. Displaying Slides Out of Order in PowerPoint
      9. Reducing Spam in Outlook
      10. Using Office 365 and Office on Android and iOS
    2. Chapter 20: Ten Ways to Make Office 2019 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
      9. Find More Office Templates
      10. Use Microsoft Office Everywhere
  10. Index
  11. About the Author
  12. Advertisement Page
  13. Connect with Dummies
  14. End User License Agreement