Office 2021 All-in-One For Dummies

Office 2021 All-in-One For Dummies

by Peter Weverka
Released February 2022
Publisher(s): For Dummies
ISBN: 9781119831419

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

Say hello to Office productivity with this one-stop reference

With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk.

How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office.

  • Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams
  • Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations
  • Get better at working collaboratively with file sharing options and other neat features
  • Do more, faster with expert tips and guidance on the full suite of Office software for 2021

Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. 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
  5. Book 1: Common Microsoft Office Tasks
    1. Chapter 1: Office Nuts and Bolts
      1. Introducing Office 2021
      2. Finding Your Way Around the Office Interface
      3. Saving Your Files
      4. Navigating the Save As and Open Windows
      5. Opening and Closing Files
      6. Reading and Recording File Properties
      7. Locking a File with a Password
      8. 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
  6. Book 2: Word 2021
    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
  7. Book 3: Excel 2021
    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
  8. Book 4: PowerPoint 2021
    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
  9. Book 5: Outlook 2021
    1. Chapter 1: Outlook Basics
      1. What Is Outlook, Anyway?
      2. Navigating the Outlook Apps
      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 People App
      1. Entering and Editing Contact Information
      2. Contact Groups for Sending Messages to Groups
      3. Finding a Contact
      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 Meetings
      5. Canceling, Rescheduling, and Altering Activities
      6. Managing Meetings with the Calendar
  10. Book 6: Access 2021
    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
  11. Book 7: Publisher 2021
    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
  12. 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
  13. Book 9: Office 2021: 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
  14. 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 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 Which Files and Folders Are Shared
      4. Investigating and Managing How Files and Folders Are Shared
  15. Index
  16. About the Author
  17. Connect with Dummies
  18. End User License Agreement

Product information

  • Title: Office 2021 All-in-One For Dummies
  • Author(s): Peter Weverka
  • Release date: February 2022
  • Publisher(s): For Dummies
  • ISBN: 9781119831419