Microsoft Office Step by Step (Office 2021 and Microsoft 365)

Table of contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Pearson’s Commitment to Diversity, Equity, and Inclusion
5. Contents at a glance
6. Contents
7. Acknowledgments
8. About the authors
9. Introduction
   1. Who this book is for
   2. The Step by Step approach
   3. Features and conventions
   4. Download the practice files
   5. E-book edition
   6. Get support and give feedback
10. Part 1: Microsoft Office (Microsoft 365 Apps)
    1. 1. Explore Office
       1. Work in the Office user interface
       2. Discover new features
       3. Change Office and app options
       4. Display and customize the Quick Access Toolbar
       5. Customize the ribbon
       6. Get help and provide feedback
       7. Key points
       8. 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
11. Part 2: Microsoft Word
    1. 3. Modify the structure and appearance of text
       1. Apply paragraph formatting
       2. Apply character formatting
       3. Structure content manually
       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 combine 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
12. Part 3: Excel
    1. 6. Perform calculations on data
       1. Name data ranges
       2. Create formulas to calculate values
       3. Summarize data that meets specific conditions
       4. Copy and move formulas
       5. Create array formulas
       6. Find and correct errors in calculations
       7. Configure automatic and iterative calculation options
       8. Key points
       9. Practice tasks
    2. 7. Manage worksheet data
       1. Filter data ranges and tables
       2. Summarize filtered data
       3. Enforce data entry criteria
       4. Key points
       5. Practice tasks
    3. 8. Reorder and summarize data
       1. Sort worksheet data
       2. Sort data by using custom lists
       3. Outline and subtotal data
       4. Key points
       5. Practice tasks
    4. 9. Analyze alternative data sets
       1. Define and display alternative data sets
       2. Forecast data by using data tables
       3. Identify the input necessary to achieve a specific result
       4. Key points
       5. Practice tasks
13. Part 4: PowerPoint
    1. 10. Create and manage slides
       1. Add and remove slides
       2. Apply themes
       3. Change slide backgrounds
       4. Divide presentations into sections
       5. Rearrange slides and sections
       6. Key points
       7. Practice tasks
    2. 11. Insert and manage simple graphics
       1. Insert, move, and resize pictures
       2. Edit and format pictures
       3. Provide additional information about pictures
       4. Create a photo album
       5. Insert and format icons
       6. Draw and modify shapes
       7. Key points
       8. Practice tasks
    3. 12. Add sound and movement to slides
       1. Animate text and pictures on slides
       2. Customize animation effects
       3. Add audio content to slides
       4. Add video content to slides
       5. Compress media to decrease file size
       6. Key points
       7. Practice tasks
14. Part 5: Microsoft Outlook
    1. 13. Send and receive email messages
       1. Create and send messages
       2. Attach files and Outlook items to messages
       3. Display messages and message attachments
       4. Display message participant information
       5. Respond to messages
       6. Key points
       7. Practice tasks
    2. 14. Organize your Inbox
       1. Display and manage messages
       2. Arrange messages by specific attributes
       3. Categorize items
       4. Organize messages in folders
       5. Print messages
       6. Key points
       7. Practice tasks
    3. 15. Manage scheduling
       1. Display different views of a calendar
       2. Schedule appointments and events
       3. Convert calendar items
       4. Configure calendar item options
       5. Schedule and change meetings
       6. Respond to meeting requests
       7. Key points
       8. Practice tasks
15. Appendix: Keyboard shortcuts
16. Index