Office 2019 All-in-One For Dummies

Office 2019 All-in-One For Dummies

by Peter Weverka
Released October 2018
Publisher(s): For Dummies
ISBN: 9781119513278

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

One book that does the work of nine

Knowing your way around Microsoft Office requires you to be part mathematician, part storyteller, and part graphic designer—with some scheduling wizard and database architect sprinkled in. So what do you do if these talents don't come naturally to you? 

Fear not! Office 2019 All-in-One For Dummies fills in the gaps and helps you create easy-to-read Word documents, smash numbers in Excel, tell your tale with PowerPoint, and keep it all organized with Outlook. With additional books covering Access, OneNote, and common Office tasks, this is the only Office book you need on your shelf.

  • Get insight into tools common to all Office applications
  • Find full coverage of Word, Excel, PowerPoint, Outlook, and Access
  • Benefit from updated information based on the newest software release
  • Discover the tricks Office pros use to enhance efficiency

If you need to make sense of Office 2019and don’t have time to waste, this is the all-in-one reference you’ll want to keep close by!

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. A Survey of Office Applications
      2. All about Office 365
      3. Finding Your Way Around the Office Interface
      4. Saving Your Files
      5. Navigating the Save As and Open Windows
      6. Opening and Closing Files
      7. Reading and Recording File Properties
      8. Locking a File with a Password
      9. 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 2019
    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 2019
    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. Comments for Documenting Your Worksheet
      5. Selecting Cells in a Worksheet
      6. Deleting, Copying, and Moving Data
      7. Handling the Worksheets in a Workbook
      8. 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 2019
    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 2019
    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. 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
    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 2019
    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 2019
    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 2019: 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 2019 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
  13. Index
  14. About the Author
  15. Connect with Dummies
  16. End User License Agreement

Product information

  • Title: Office 2019 All-in-One For Dummies
  • Author(s): Peter Weverka
  • Release date: October 2018
  • Publisher(s): For Dummies
  • ISBN: 9781119513278