Office 2021 All-in-One For Dummies
- Length: 800 pages
- Edition: 1
- Language: English
- Publisher: For Dummies
- Publication Date: 2022-03-02
- ISBN-10: 1119831415
- ISBN-13: 9781119831419
- Sales Rank: #234085 (See Top 100 Books)
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.
Cover Title Page Copyright Table of Contents Introduction What Makes This Book Different Foolish Assumptions Conventions Used in This Book Icons Used in This Book Beyond the Book Book 1: Common Microsoft Office Tasks Chapter 1: Office Nuts and Bolts Introducing Office 2021 Finding Your Way Around the Office Interface Saving Your Files Navigating the Save As and Open Windows Opening and Closing Files Reading and Recording File Properties Locking a File with a Password Trusting (or not Trusting) Microsoft with Your “Content” Chapter 2: Wrestling with the Text Manipulating the Text Speaking, not Typing, the Words Changing the Look of Text Quick Ways to Handle Case, or Capitalization Entering Symbols and Foreign Characters Creating Hyperlinks Chapter 3: Speed Techniques Worth Knowing About Undoing and Repeating Commands Zooming In, Zooming Out Viewing a File Through More Than One Window Correcting Typos on the Fly Entering Text Quickly with the AutoCorrect Command Book 2: Word 2021 Chapter 1: Speed Techniques for Using Word Introducing the Word Screen Creating a New Document Getting a Better Look at Your Documents Selecting Text in Speedy Ways Moving Around Quickly in Documents Inserting a Whole File into a Document Getting Word to Read It Entering Information Quickly in a Computerized Form Chapter 2: Laying Out Text and Pages Paragraphs and Formatting Inserting a Section Break for Formatting Purposes Breaking a Line Starting a New Page Setting Up and Changing the Margins Indenting Paragraphs and First Lines Numbering the Pages Putting Headers and Footers on Pages Adjusting the Space Between Lines Adjusting the Space Between Paragraphs Creating Numbered and Bulleted Lists Working with Tabs Hyphenating Text Chapter 3: Word Styles All About Styles Applying Styles to Text and Paragraphs Creating a New Style Modifying a Style Creating and Managing Templates Chapter 4: Constructing the Perfect Table Talking Table Jargon Creating a Table Entering the Text and Numbers Selecting Different Parts of a Table Laying Out Your Table Aligning Text in Columns and Rows Merging and Splitting Cells Repeating Header Rows on Subsequent Pages Formatting Your Table Using Math Formulas in Tables Neat Table Tricks Chapter 5: Taking Advantage of the Proofing Tools Correcting Your Spelling Errors Correcting Grammatical Errors Finding and Replacing Text Finding the Right Word with the Thesaurus Proofing Text Written in a Foreign Language Translating Foreign Language Text Chapter 6: Desktop Publishing with Word Experimenting with Themes Sprucing Up Your Pages Making Use of Charts, Diagrams, Shapes, and Photos Working with the Drawing Canvas Positioning and Wrapping Objects Relative to the Page and Text Working with Text Boxes Dropping In a Drop Cap Watermarking for the Elegant Effect Putting Newspaper-Style Columns in a Document Landscape Documents Printing on Different Size Paper Showing Online Video in a Document Chapter 7: Getting Word’s Help with Office Chores Highlighting Parts of a Document Commenting on a Document Tracking Changes to Documents Printing an Address on an Envelope Printing a Single Address Label (Or a Page of the Same Label) Churning Out Letters, Envelopes, and Labels for Mass Mailings Chapter 8: Tools for Reports and Scholarly Papers Alphabetizing a List Outlines for Organizing Your Work Collapsing and Expanding Parts of a Document Generating a Table of Contents Indexing a Document Putting Cross-References in a Document Putting Footnotes and Endnotes in Documents Compiling a Bibliography Book 3: Excel 2021 Chapter 1: Up and Running with Excel Creating a New Excel Workbook Getting Acquainted with Excel Entering Data in a Worksheet Quickly Entering Lists and Serial Data with the AutoFill Command Formatting Numbers, Dates, and Time Values Establishing Data-Validation Rules Chapter 2: Refining Your Worksheet Editing Worksheet Data Moving Around in a Worksheet Getting a Better Look at the Worksheet Comments for Documenting Your Worksheet Selecting Cells in a Worksheet Deleting, Copying, and Moving Data Handling the Worksheets in a Workbook Keeping Others from Tampering with Worksheets Chapter 3: Formulas and Functions for Crunching Numbers How Formulas Work The Basics of Entering a Formula Speed Techniques for Entering Formulas Copying Formulas from Cell to Cell Detecting and Correcting Errors in Formulas Working with Functions A Look at Some Very Useful Functions Chapter 4: Making a Worksheet Easier to Read and Understand Laying Out a Worksheet Decorating a Worksheet with Borders and Colors Getting Ready to Print a Worksheet Chapter 5: Advanced Techniques for Analyzing Data Seeing What the Sparklines Say Conditional Formats for Calling Attention to Data Managing Information in Lists Forecasting with the Goal Seek Command Performing What-If Analyses with Data Tables Analyzing Data with PivotTables Book 4: PowerPoint 2021 Chapter 1: Getting Started in PowerPoint Getting Acquainted with PowerPoint A Brief Geography Lesson A Whirlwind Tour of PowerPoint Creating a New Presentation Advice for Building Persuasive Presentations Creating New Slides for Your Presentation Getting a Better View of Your Work Hiding and Displaying the Slides Pane and Notes Pane Selecting, Moving, and Deleting Slides Putting Together a Photo Album Hidden Slides for All Contingencies Chapter 2: Fashioning a Look for Your Presentation Looking at Themes and Slide Backgrounds Choosing a Theme for Your Presentation Creating Slide Backgrounds on Your Own Changing the Background of a Single or Handful of Slides Choosing the Slide Size Using Master Slides and Master Styles for a Consistent Design Chapter 3: Entering the Text Entering Text Fun with Text Boxes and Text Box Shapes Controlling How Text Fits in Text Frames and Text Boxes Positioning Text in Frames and Text Boxes Handling Bulleted and Numbered Lists Putting Footers (and Headers) on Slides Chapter 4: Making Your Presentations Livelier Suggestions for Enlivening Your Presentation Presenting Information in a Table Exploring Transitions and Animations Making Audio Part of Your Presentation Playing Video on Slides Recording a Voice Narration for Slides Chapter 5: Delivering a Presentation All about Notes Rehearsing and Timing Your Presentation Showing Your Presentation Tricks for Making Presentations a Little Livelier Delivering a Presentation When You Can’t Be There in Person Book 5: Outlook 2021 Chapter 1: Outlook Basics What Is Outlook, Anyway? Navigating the Outlook Apps Categorizing Items Searching for Stray Folder Items Deleting Email Messages, Contacts, Tasks, and Other Items Cleaning Out Your Folders Chapter 2: Maintaining the People App Entering and Editing Contact Information Contact Groups for Sending Messages to Groups Finding a Contact Printing the Contacts Folder Chapter 3: Handling Your Email Setting Up an Email Account Addressing and Sending Email Messages Sending Files and Photos Receiving Email Messages Reading Your Email in the Inbox Window Handling Files That Were Sent to You Techniques for Organizing Email Messages All about Email Folders Yes, You Can Prevent Junk Mail (Sort of) Chapter 4: Managing Your Time and Schedule Introducing the Calendar The Different Kinds of Activities Seeing Your Schedule Scheduling Appointments and Meetings Canceling, Rescheduling, and Altering Activities Managing Meetings with the Calendar Book 6: Access 2021 Chapter 1: Introducing Access What Is a Database, Anyway? Tables, Queries, Forms, and Other Objects Creating a Database File Finding Your Way Around the Navigation Pane Designing a Database Chapter 2: Building Your Database Tables Creating a Database Table Opening and Viewing Tables Entering and Altering Table Fields Field Properties for Making Sure That Data Entries Are Accurate Indexing for Faster Sorts, Searches, and Queries Establishing Relationships among Database Tables Chapter 3: Entering the Data The Two Ways to Enter Data Entering the Data in Datasheet View Entering the Data in a Form Finding a Missing Record Finding and Replacing Data Chapter 4: Sorting, Querying, and Filtering for Data Sorting Records in a Database Table Filtering to Find Information Querying: The Basics Six Kinds of Queries Chapter 5: Presenting Data in a Report Creating a Report Opening and Viewing Reports Tweaking a Report Book 7: Publisher 2021 Chapter 1: Introducing Publisher “A Print Shop in a Can” Introducing Frames Creating a Publication Redesigning a Publication Getting a Better View of Your Work Understanding and Using the Layout Guides Chapter 2: Refining a Publication Entering Text on the Pages Making Text Fit in Text Frames Formatting Text Making Text Wrap around a Frame or Graphic Replacing the Placeholder Pictures Inserting Frames on the Pages Making Frames Overlap Inserting, Removing, and Moving Pages Chapter 3: Putting on the Finishing Touches Decorating the Text Techniques for Decorating Pages Master Pages for Handling Page Backgrounds Running the Design Checker Commercially Printing a Publication Book 8: Working with Charts and Graphics Chapter 1: Creating a Chart The Basics: Creating a Chart Choosing the Right Chart Providing the Raw Data for Your Chart Positioning Your Chart in a Workbook, Page, or Slide Changing a Chart’s Appearance Saving a Chart as a Template So That You Can Use It Again Chart Tricks for the Daring and Heroic Troubleshooting a Chart Chapter 2: Making a SmartArt Diagram The Basics: Creating SmartArt Diagrams Creating the Initial Diagram Changing the Size and Position of a Diagram Laying Out the Diagram Shapes Handling the Text on Diagram Shapes Changing a Diagram’s Direction Choosing a Look for Your Diagram Changing the Appearance of Diagram Shapes Creating a Diagram from Scratch Chapter 3: Handling Graphics and Photos All about Picture File Formats Inserting a Picture in an Office File Touching Up a Picture Compressing Pictures to Save Disk Space Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects The Basics: Making Lines, Arrows, and Shapes Handling Lines, Arrows, and Connectors Handling Rectangles, Ovals, Stars, and Other Shapes Drawing by Freehand Decorating Your Work with Icons Inserting a 3-D Model WordArt for Embellishing Letters and Words Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects Changing an Object’s Size and Shape Changing an Object’s Color, Outline Color, and Transparency Moving and Positioning Objects Book 9: Office 2021: One Step Beyond Chapter 1: Customizing an Office Program Customizing the Ribbon Customizing the Quick Access Toolbar Customizing the Status Bar Changing the Screen Background and Office Theme Customizing Keyboard Shortcuts in Word Chapter 2: Ways of Distributing Your Work Printing — the Old Standby Distributing a File in PDF Format Sending Your File in an Email Message Saving an Office File as a Web Page Book 10: File Sharing and Collaborating Chapter 1: Up and Running on OneDrive Signing In to OneDrive Exploring the OneDrive Window Managing Your OneDrive Folders Uploading Files to a Folder on OneDrive Saving a File from Office to OneDrive Opening a File from OneDrive Downloading Files from OneDrive to Your Computer Chapter 2: File Sharing and Collaborating Sharing Files: The Big Picture Sharing Your Files and Folders with Others Seeing Which Files and Folders Are Shared Investigating and Managing How Files and Folders Are Shared Index About the Author Connect with Dummies End User License Agreement
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.