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

Microsoft Office 2019 Inside Out, First Edition

Book Description

Conquer Microsoft Office 2019–from the inside out!

Dive into Microsoft Office 2019–and really put its productivity toolsand services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Office's most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Office 2019 and Office 365, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, online Office apps, and more. Discover how experts tackle today's key tasks–and challenge yourself to new levels of mastery.

 

  • Create amazing content faster with Office's new features, tools, and shortcuts
  • Share, collaborate with, and secure Office files in the cloud
  • Organize, edit, and format complex documents with Microsoft Word
  • Build tables of contents, captions, indexes, and footnotes that automatically update
  • Efficiently enter and manage data in Excel workbooks, and format it for easy understanding
  • Build flexible, reliable Excel workbooks with formulas and functions
  • Integrate data from external sources, including web tables, text files, and more
  • Transform data into insight with Excel charts, Sparklines, and PivotTables
  • Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries
  • Build more impactful slides with advanced formatting, SmartArt, animation, transitions, and multimedia
  • Use PowerPoint 2019 tools to present more effectively, both in person and online
  • Systematically improve email productivity and security with Outlook 2019
  • Manage appointments and tasks, and quickly plan meetings

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. Contents at a Glance
  6. Table of Contents
  7. Acknowledgments
  8. About the Author
  9. Introduction
    1. How this book is organized
    2. Support and feedback
  10. Part I Getting started with the Office applications
    1. Chapter 1 Getting oriented to the Office applications
      1. Introducing Office
      2. New features and tools in Office
      3. The Office suite applications
      4. The different versions of the Office suite
      5. Hardware and software requirements for Office
      6. Installing Office
      7. Getting Help in the Office applications
    2. Chapter 2 Navigating and customizing the Office interface
      1. Getting familiar with the Office interface
      2. Navigating the Office applications
      3. Customizing an application interface
      4. Configuring application options
      5. Using Office add-ins
      6. Using the Trust Center
    3. Chapter 3 Managing and sharing Office files
      1. Understanding Office file formats
      2. Configuring save file options
      3. Creating and managing files
      4. Searching for Office files
      5. Sharing files using Homegroup
      6. Protecting an Office file
      7. Preparing a file for sharing
    4. Chapter 4 Using and creating graphics
      1. The Office options for graphics and pictures
      2. Working with your digital pictures
      3. Inserting online pictures
      4. Using shapes and the Office drawing tools
      5. Using the screenshot feature
      6. Using WordArt
    5. Chapter 5 Using the Office Online apps
      1. What the Online apps can do
      2. Where the Online apps live
      3. Saving Office application files to the cloud
      4. Using the Word Online app
      5. Using Excel Online
      6. Using PowerPoint Online
  11. Part II Word
    1. Chapter 6 Essential Word features
      1. Introducing Word
      2. Options for creating a new Word document
      3. Using templates
      4. Navigating a Word document
      5. Moving around a document with the keyboard
      6. Understanding document formatting
      7. Working with fonts and text formatting
      8. Working with paragraph formatting
      9. Page layout: margins and page options
      10. Printing documents
    2. Chapter 7 Enhancing Word documents
      1. Creating better documents
      2. Creating bulleted and numbered lists
      3. Working with borders and shading
      4. Formatting with themes
      5. Creating headers and footers
      6. Inserting pictures, clip art, and charts
      7. Changing the document display
      8. Using the review tools
      9. Working with Quick Parts
      10. Configuring AutoCorrect
      11. Understanding styles
    3. Chapter 8 Working with tables, columns, and sections
      1. Options for adding a table
      2. Formatting tables
      3. Sorting table data
      4. Using formulas in tables
      5. Adding columns to a document
      6. Understanding sections
    4. Chapter 9 Managing mailings and forms
      1. Options for mail-related documents
      2. Creating an envelope
      3. Creating a label or labels
      4. Understanding mass mailings
      5. Performing a mail merge
      6. Understanding Word fields
      7. Building a form with form controls
    5. Chapter 10 Creating special documents
      1. Options for large documents
      2. Creating a table of contents
      3. Working with captions and tables of figures
      4. Generating an index
      5. Working with citations and bibliographies
      6. Tracking document changes
      7. Building a better “big” document
      8. Creating a master document
  12. Part III Excel
    1. Chapter 11 Essential Excel features
      1. Introducing the new Excel
      2. Navigating the Excel workspace
      3. Creating workbooks and worksheets
      4. Managing Excel workbooks
      5. Entering data in a worksheet
      6. Copying, moving, and deleting cell contents
      7. Editing cell content
      8. Viewing worksheets
      9. Printing worksheets
    2. Chapter 12 Worksheet formatting and management
      1. Formatting text entries
      2. Formatting values
      3. Adding comments to cells
      4. Using themes
      5. Formatting cells using borders and color
      6. Using cell styles and the Format Painter
      7. Using conditional formatting
      8. Manipulating cells and cell content
      9. Working with columns and rows
      10. Working with worksheets
      11. Naming ranges
      12. Adding images and graphics to worksheets
    3. Chapter 13 Getting the most from formulas and functions
      1. Performing calculations in Excel worksheets
      2. Relative versus absolute referencing
      3. Creating and editing formulas
      4. Working with Excel functions
      5. Entering a function in a cell
      6. Using range names in formulas and functions
      7. Referencing cells or ranges on other worksheets
      8. Copying and moving formulas and functions
      9. Choosing the right function
      10. Proofing your formulas and functions
    4. Chapter 14 Enhancing worksheets with charts
      1. Understanding Excel charts
      2. Creating charts
      3. Modifying a chart
      4. Working with chart elements
      5. Creating a combination chart
    5. Chapter 15 Using Excel tables and pivot tables
      1. Excel and databases
      2. Defining a table range
      3. Creating a table using styles
      4. Using the table tools
      5. Sorting table data
      6. Filtering table data
      7. Using the data form
      8. Creating outlines and subtotals
      9. Working with external data
      10. Connecting to other data sources
      11. Working with pivot tables
    6. Chapter 16 Validating and analyzing worksheet data
      1. Taking advantage of data validation
      2. Performing a what-if analysis
      3. Using Goal Seek, Solver, and Forecast Sheet
  13. Part IV PowerPoint
    1. Chapter 17 Essential PowerPoint features
      1. PowerPoint
      2. Options for creating a new presentation
      3. Creating a template
      4. Inserting new slides
      5. Modifying a slide’s layout
      6. Working with slides in different views
      7. Opening a new presentation window
      8. Rearranging and deleting slides
      9. Modifying bulleted lists
      10. Using numbered lists
      11. Viewing a presentation during editing
    2. Chapter 18 Advanced presentation formatting, themes, and masters
      1. Working with text boxes and formatting
      2. Arranging text in tables
      3. Working with themes
      4. Using headers and footers
      5. Understanding masters
      6. Altering and creating master slides
      7. Creating layout masters
      8. Using slide sections
    3. Chapter 19 Better slides with clip art, pictures, and SmartArt
      1. Using graphics to enhance slides
      2. Inserting a picture
      3. Adding online images to slides
      4. Creating a photo album
      5. Working with shapes
      6. Inserting icons
      7. Using SmartArt graphics
      8. Adding charts to slides
      9. Working with slide objects
      10. Adding hyperlinks to slides
      11. Using PowerPoint Designer
    4. Chapter 20 Enhancing slides with animation, transitions, and multimedia
      1. Animations versus transitions
      2. Assigning animation to a slide object
      3. Advanced animation techniques
      4. Managing slide animations
      5. Adding transitions to slides
      6. Adding sound to a slide
      7. Editing sound options
      8. Adding video to a slide
    5. Chapter 21 Delivering a presentation and creating support materials
      1. Planning your presentation
      2. Checking the presentation for spelling and grammar errors
      3. Running through a completed presentation
      4. Using the presenter view
      5. Using hidden slides
      6. Creating a custom slide show
      7. Creating a self-running presentation
      8. Creating an interactive presentation
      9. Presenting a slideshow online
      10. Working with the notes and handout masters
      11. Printing presentations, notes, and handouts
      12. Exporting a presentation
      13. Sharing your presentation
  14. Part V Outlook
    1. Chapter 22 Outlook configuration and essential features
      1. Introducing Outlook
      2. Outlook and email accounts
      3. Configuring Outlook at first start
      4. Understanding Outlook profiles
      5. Understanding Outlook data files
      6. Importing and exporting data
      7. Navigating the Outlook workspace
      8. Working with views in Outlook
      9. Categorizing Outlook items
      10. Searching for Outlook items
      11. Printing Outlook items
    2. Chapter 23 Managing email in Outlook
      1. Working in the Mail folder
      2. Creating an email message
      3. Using the Outlook Address Book
      4. Setting message options
      5. Attaching files and items to a message
      6. Using themes and email stationery
      7. Adding a signature
      8. Sending mail
      9. Recalling a message
      10. Working with received email
      11. Managing email
      12. Managing email accounts
      13. Setting Outlook mail options
    3. Chapter 24 Using the calendar for appointments and tasks
      1. Navigating the calendar
      2. Scheduling an appointment
      3. Searching the calendar
      4. Sharing calendars
      5. Setting calendar options
      6. Working with tasks
    4. Chapter 25 Working with contacts and planning meetings
      1. Navigating the Contacts list
      2. Creating a new contact
      3. Editing contact information
      4. Searching the Contacts folder
      5. Organizing contacts with groups
      6. Forwarding and sharing contacts
      7. Communicating with contacts
      8. Contact actions
      9. Printing contact information
      10. Setting contact options
      11. Scheduling meetings
      12. Responding to meeting requests
    5. Chapter 26 Using the Journal and notes
      1. Using the Outlook Journal
      2. Viewing the Journal
      3. Working with notes
    6. Chapter 27 Securing and maintaining Outlook
      1. Security overview
      2. Configuring Outlook security settings
      3. Encrypting email and using digital signatures
      4. The perils of HTML email
      5. Dealing with message attachments
      6. Coping with junk email
      7. Creating email rules
      8. Managing rules
      9. Archiving Outlook items
      10. Configuring an autoreply message
  15. Part VI Publisher
    1. Chapter 28 Essential Publisher features
      1. Introducing Publisher
      2. Planning your publication
      3. Working with publication templates
      4. Creating a new publication
      5. Creating a business information set
      6. Working with text
      7. Inserting illustrations
      8. Using building blocks
      9. Printing publications
    2. Chapter 29 Advanced Publisher features
      1. Adding pages to a publication
      2. Configuring page settings
      3. Changing the current template
      4. Working with master pages
      5. Using tables in publications
      6. Manipulating publication objects
      7. Merging data into a publication
      8. Fine-tuning your publications
  16. Part VII Appendixes
    1. Appendix A Office application integration
      1. Sharing application data
      2. Understanding object linking and embedding
      3. Linking objects
      4. Updating and breaking links
      5. Editing embedded objects
      6. Sharing data with Outlook using actions
    2. Appendix B Office macros
      1. Macros and Office
      2. Understanding macros
      3. Creating a macro
      4. Running macros
      5. Editing recorded macros
      6. Digitally signing macros
  17. Index
  18. Code Snippets