Microsoft Office 2019 Step by Step, First Edition

Table of contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Contents at a Glance
5. About the authors
6. Introduction
   1. Who this book is for
   2. The Step by Step approach
   3. Download the practice files
   4. E-book edition
   5. Get support and give feedback
7. Part 1: Microsoft Office 2019
   1. 1 Explore Office 2019
      1. Work in the Office user interface
      2. Change Office and app options
      3. Customize the Quick Access Toolbar
      4. Customize the ribbon
      5. Get help and provide feedback
      6. Key points
      7. Practice tasks
   2. 2 Create and manage files
      1. Create files
      2. Open and move around in files
      3. Display different views of files
      4. Display and edit file properties
      5. Save and close files
      6. Key points
      7. Practice tasks
8. Part 2: Microsoft Word 2019
   1. 3 Modify the structure and appearance of text
      1. Apply paragraph formatting
      2. Structure content manually
      3. Apply character formatting
      4. Create and modify lists
      5. Apply built-in styles to text
      6. Change the document theme
      7. Key points
      8. Practice tasks
   2. 4 Collaborate on documents
      1. Mark up documents
      2. Display and review document markup
      3. Compare and merge documents
      4. Control content changes
      5. Coauthor documents
      6. Key points
      7. Practice tasks
   3. 5 Merge data with documents and labels
      1. Understand the mail merge process
      2. Start the mail merge process
      3. Choose and refine the data source
      4. Insert merge fields
      5. Preview and complete the merge
      6. Create individual envelopes and labels
      7. Key points
      8. Practice tasks
9. Part 3: Microsoft Excel 2019
   1. 6 Perform calculations on data
      1. Name groups of data
      2. Create formulas to calculate values
      3. Summarize data that meets specific conditions
      4. Set iterative calculation options and enable or disable automatic calculation
      5. Use array formulas
      6. Find and correct errors in calculations
      7. Key points
      8. Practice tasks
   2. 7 Manage worksheet data
      1. Limit data that appears on your screen
      2. Manipulate worksheet data
      3. Define valid sets of values for ranges of cells
      4. Key points
      5. Practice tasks
   3. 8 Reorder and summarize data
      1. Sort worksheet data
      2. Sort data by using custom lists
      3. Organize data into levels
      4. Look up information in a worksheet
      5. Key points
      6. Practice tasks
   4. 9 Analyze alternative data sets
      1. Examine data by using the Quick Analysis Lens
      2. Define an alternative data set
      3. Define multiple alternative data sets
      4. Analyze data by using data tables
      5. Vary your data to get a specific result by using Goal Seek
      6. Find optimal solutions by using Solver
      7. Analyze data by using descriptive statistics
      8. Key points
      9. Practice tasks
10. Part 4: Microsoft PowerPoint 2019
    1. 10 Create and manage slides
       1. Add and remove slides
       2. Insert new slides
       3. Copy and import slides and content
       4. Hide and delete slides
       5. Apply themes
       6. Change slide backgrounds
       7. Sidebar: Non-theme colors
       8. Divide presentations into sections
       9. Rearrange slides and sections
       10. Key points
       11. Practice tasks
    2. 11 Insert and manage simple graphics
       1. Insert, move, and resize pictures
       2. Sidebar: Graphic formats
       3. Edit and format pictures
       4. Provide additional information about pictures
       5. Create a photo album
       6. Capture and insert screen clippings
       7. Insert and format icons
       8. Sidebar: Work with scalable vector graphics
       9. Draw and modify shapes
       10. Draw and add text to shapes
       11. Sidebar: Locate additional formatting commands
       12. Move and modify shapes
       13. Format shapes
       14. Sidebar: Connect shapes
       15. Key points
       16. Practice tasks
    3. 12 Add sound and movement to slides
       1. Animate text and pictures on slides
       2. Sidebar: Animate this
       3. Sidebar: Morphing slide content into new forms
       4. Customize animation effects
       5. Sidebar: Bookmark points of interest in media clips
       6. Add audio content to slides
       7. Add video content to slides
       8. Compress media to decrease file size
       9. Sidebar: Hyperlink to additional resources
       10. Key points
       11. Practice tasks
11. Part 5: Microsoft Outlook 2019
    1. 13 Send and receive email messages
       1. Create and send messages
       2. Create messages
       3. Troubleshoot message addressing
       4. Save and send messages
       5. Sidebar: Send from a specific account
       6. Attach files and Outlook items to messages
       7. Sidebar: New mail notifications
       8. Display messages and message attachments
       9. Display message content
       10. Display attachment content
       11. Display message participant information
       12. Respond to messages
       13. Sidebar: Resending and recalling messages
       14. Key points
       15. Practice tasks
    2. 14 Organize your Inbox
       1. Display and manage messages
       2. Select the primary Inbox content
       3. Display and manage conversations
       4. Arrange messages by specific attributes
       5. Categorize items
       6. Sidebar: Store information in Outlook notes
       7. Organize messages in folders
       8. Sidebar: Print messages
       9. Key points
       10. Practice tasks
    3. 15 Manage scheduling
       1. Display different views of a calendar
       2. Sidebar: Use the Date Navigator
       3. Schedule appointments and events
       4. Convert calendar items
       5. Sidebar: Add holidays to your calendar
       6. Configure calendar item options
       7. Schedule and change meetings
       8. Respond to meeting requests
       9. Key points
       10. Practice tasks
12. Appendix: Define Excel tables
13. Index