Say hello to Office productivity with this one-stop referenceWithOffice 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 TeamsMake amazing charts and graphs that you can plug into your documents, spreadsheets, and presentationsGet better at working collaboratively with file sharing options and other neat featuresDo 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.
Introduction1
Book 1: Common Microsoft Office Tasks 5
Chapter 1: Office Nuts and Bolts 7
Chapter 2: Wrestling with the Text 27
Chapter 3: Speed Techniques Worth Knowing About 47
Book 2: Word 2021 55
Chapter 1: Speed Techniques for Using Word 57
Chapter 2: Laying Out Text and Pages 77
Chapter 3: Word Styles 103
Chapter 4: Constructing the Perfect Table 121
Chapter 5: Taking Advantage of the Proofing Tools 145
Chapter 6: Desktop Publishing with Word 165
Chapter 7: Getting Word's Help with Office Chores 183
Chapter 8: Tools for Reports and Scholarly Papers 203
Book 3: Excel 2021 227
Chapter 1: Up and Running with Excel 229
Chapter 2: Refining Your Worksheet 247
Chapter 3: Formulas and Functions for Crunching Numbers 261
Chapter 4: Making a Worksheet Easier to Read and Understand 293
Chapter 5: Advanced Techniques for Analyzing Data 311
Book 4: PowerPoint 2021 329
Chapter 1: Getting Started in PowerPoint 331
Chapter 2: Fashioning a Look for Your Presentation 353
Chapter 3: Entering the Text 367
Chapter 4: Making Your Presentations Livelier 385
Chapter 5: Delivering a Presentation 401
Book 5: Outlook 2021 421
Chapter 1: Outlook Basics 423
Chapter 2: Maintaining the People App 435
Chapter 3: Handling Your Email 445
Chapter 4: Managing Your Time and Schedule 467
Book 6: Access 2021 479
Chapter 1: Introducing Access 481
Chapter 2: Building Your Database Tables 497
Chapter 3: Entering the Data 525
Chapter 4: Sorting, Querying, and Filtering for Data 535
Chapter 5: Presenting Data in a Report 557
Book 7: Publisher 2021 563
Chapter 1: Introducing Publisher 565
Chapter 2: Refining a Publication 577
Chapter 3: Putting on the Finishing Touches 589
Book 8: Working with Charts and Graphics 601
Chapter 1: Creating a Chart 603
Chapter 2: Making a SmartArt Diagram 623
Chapter 3: Handling Graphics and Photos 643
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 659
Book 9: Office 2021: One Step Beyond 693
Chapter 1: Customizing an Office Program 695
Chapter 2: Ways of Distributing Your Work 709
Book 10: File Sharing and Collaborating 717
Chapter 1: Up and Running on OneDrive 719
Chapter 2: File Sharing and Collaborating 731
Index 739
