Office 2019 All-in-One For Dummies

Introduction 1What Makes This Book Different 2Foolish Assumptions 3Conventions Used in This Book 3Icons Used in This Book 4Beyond the Book 4Book 1: Common Office Tasks 5Chapter 1: Office Nuts and Bolts 7A Survey of Office Applications 7All about Office 365 9Finding Your Way Around the Office Interface 11Saving Your Files 18Navigating the Save As and Open Windows 19Opening and Closing Files 21Reading and Recording File Properties 22Locking a File with a Password 23Trusting (or not Trusting) Microsoft with Your "Content" 24Chapter 2: Wrestling with the Text 27Manipulating the Text 27Speaking, not Typing, the Words 30Changing the Look of Text 32Quick Ways to Handle Case, or Capitalization 39Entering Symbols and Foreign Characters 41Creating Hyperlinks 42Chapter 3: Speed Techniques Worth Knowing About 47Undoing and Repeating Commands 47Zooming In, Zooming Out 49Viewing a File Through More Than One Window 50Correcting Typos on the Fly 51Entering Text Quickly with the AutoCorrect Command 52Book 2: Word 2019 55Chapter 1: Speed Techniques for Using Word 57Introducing the Word Screen 57Creating a New Document 59Getting a Better Look at Your Documents 61Selecting Text in Speedy Ways 66Moving Around Quickly in Documents 67Inserting a Whole File into a Document 71Getting Word to Read It 72Entering Information Quickly in a Computerized Form 72Chapter 2: Laying Out Text and Pages 77Paragraphs and Formatting 77Inserting a Section Break for Formatting Purposes 78Breaking a Line 81Starting a New Page 81Setting Up and Changing the Margins 82Indenting Paragraphs and First Lines 84Numbering the Pages 86Putting Headers and Footers on Pages 89Adjusting the Space Between Lines 93Adjusting the Space Between Paragraphs 95Creating Numbered and Bulleted Lists 96Working with Tabs 99Hyphenating Text 101Chapter 3: Word Styles 105All About Styles 105Applying Styles to Text and Paragraphs 107Creating a New Style 112Modifying a Style 114Creating and Managing Templates 116Chapter 4: Constructing the Perfect Table 123Talking Table Jargon 124Creating a Table 124Entering the Text and Numbers 127Selecting Different Parts of a Table 128Laying Out Your Table 128Aligning Text in Columns and Rows 133Merging and Splitting Cells 134Repeating Header Rows on Subsequent Pages 135Formatting Your Table 137Using Math Formulas in Tables 140Neat Table Tricks 141Chapter 5: Taking Advantage of the Proofing Tools 147Correcting Your Spelling Errors 148Correcting Grammatical Errors 151Finding and Replacing Text 153Finding the Right Word with the Thesaurus 161Proofing Text Written in a Foreign Language 162Translating Foreign Language Text 164Chapter 6: Desktop Publishing with Word 167Experimenting with Themes 167Sprucing Up Your Pages 168Making Use of Charts, Diagrams, Shapes, and Photos 171Working with the Drawing Canvas 172Positioning and Wrapping Objects Relative to the Page and Text 173Working with Text Boxes 177Dropping In a Drop Cap 179Watermarking for the Elegant Effect 180Putting Newspaper-Style Columns in a Document 181Landscape Documents 183Printing on Different Size Paper 184Showing Online Video in a Document 184Chapter 7: Getting Word's Help with Office Chores 187Highlighting Parts of a Document 187Commenting on a Document 188Tracking Changes to Documents 192Printing an Address on an Envelope 197Printing a Single Address Label (Or a Page of the Same Label) 199Churning Out Letters, Envelopes, and Labels for Mass Mailings 200Chapter 8: Tools for Reports and Scholarly Papers 209Alphabetizing a List 209Outlines for Organizing Your Work 210Collapsing and Expanding Parts of a Document 212Generating a Table of Contents 213Indexing a Document 218Putting Cross-References in a Document 222Putting Footnotes and Endnotes in Documents 225Compiling a Bibliography 227Book 3: Excel 2019 233Chapter 1: Up and Running with Excel 235Creating a New Excel Workbook 235Getting Acquainted with Excel 237Entering Data in a Worksheet 239Quickly Entering Lists and Serial Data with theAutoFill Command 245Formatting Numbers, Dates, and Time Values 248Establishing Data-Validation Rules 249Chapter 2: Refining Your Worksheet 253Editing Worksheet Data 253Moving Around in a Worksheet 254Getting a Better Look at the Worksheet 255Comments for Documenting Your Worksheet 258Selecting Cells in a Worksheet 260Deleting, Copying, and Moving Data 261Handling the Worksheets in a Workbook 261Keeping Others from Tampering with Worksheets 264Chapter 3: Formulas and Functions for Crunching Numbers 267How Formulas Work 267The Basics of Entering a Formula 273Speed Techniques for Entering Formulas 273Copying Formulas from Cell to Cell 279Detecting and Correcting Errors in Formulas 281Working with Functions 284A Look at Some Very Useful Functions 289Chapter 4: Making a Worksheet Easier to Read and Understand 299Laying Out a Worksheet 299Decorating a Worksheet with Borders and Colors 305Getting Ready to Print a Worksheet 310Chapter 5: Advanced Techniques for Analyzing Data 317Seeing What the Sparklines Say 317Conditional Formats for Calling Attention to Data 319Managing Information in Lists 320Forecasting with the Goal Seek Command 323Performing What-If Analyses with Data Tables 325Analyzing Data with PivotTables 329Book 4: Powerpoint 2019 335Chapter 1: Getting Started in PowerPoint 337Getting Acquainted with PowerPoint 338A Brief Geography Lesson 339A Whirlwind Tour of PowerPoint 340Creating a New Presentation 341Advice for Building Persuasive Presentations 344Creating New Slides for Your Presentation 346Getting a Better View of Your Work 350Hiding and Displaying the Slides Pane and Notes Pane 352Selecting, Moving, and Deleting Slides 352Putting Together a Photo Album 354Hidden Slides for All Contingencies 357Chapter 2: Fashioning a Look for Your Presentation 359Looking at Themes and Slide Backgrounds 360Choosing a Theme for Your Presentation 361Creating Slide Backgrounds on Your Own 362Changing the Background of a Single or Handful of Slides 368Choosing the Slide Size 369Using Master Slides and Master Styles for a Consistent Design 370Chapter 3: Entering the Text 373Entering Text 373Fun with Text Boxes and Text Box Shapes 377Controlling How Text Fits in Text Frames and Text Boxes 379Positioning Text in Frames and Text Boxes 382Handling Bulleted and Numbered Lists 382Putting Footers (and Headers) on Slides 385Some background on footers and headers 386Putting a standard footer on all your slides 386Creating a nonstandard footer 387Removing a footer from a single slide 388Chapter 4: Making Your Presentations Livelier 389Suggestions for Enlivening Your Presentation 389Presenting Information in a Table 390Exploring Transitions and Animations 393Making Audio Part of Your Presentation 396Playing Video on Slides 399Recording a Voice Narration for Slides 403Chapter 5: Delivering a Presentation 405All about Notes 405Rehearsing and Timing Your Presentation 406Showing Your Presentation 408Tricks for Making Presentations a Little Livelier 411Delivering a Presentation When You Can't Be There in Person 414Book 5: Outlook 2019 425Chapter 1: Outlook Basics 427What Is Outlook, Anyway? 427Navigating the Outlook Folders 429Categorizing Items 430Searching for Stray Folder Items 432Deleting Email Messages, Contacts, Tasks, and Other Items 435Cleaning Out Your Folders 436Chapter 2: Maintaining the Contacts Folder 441Maintaining a Happy and Healthy Contacts Folder 442Contact Groups for Sending Messages to Groups 445Finding a Contact in the Contacts Folder 447Printing the Contacts Folder 448Chapter 3: Handling Your Email 451Setting Up an Email Account 451Addressing and Sending Email Messages 452Sending Files and Photos 458Receiving Email Messages 460Reading Your Email in the Inbox Window 461Handling Files That Were Sent to You 463Techniques for Organizing Email Messages 464All about Email Folders 468Yes, You Can Prevent Junk Mail (Sort of) 470Chapter 4: Managing Your Time and Schedule 473Introducing the Calendar 473The Different Kinds of Activities 474Seeing Your Schedule 475Scheduling Appointments and Events 477Scheduling an activity: The basics 477Scheduling a recurring appointment or event 478Scheduling an event 479Canceling, Rescheduling, and Altering Activities 480Chapter 5: Tasks, Reminders, and Notes 481Tasks: Seeing What Needs to Get Done 481Reminders for Being Alerted to Activities and Tasks 484Making Notes to Yourself 487Book 6: Access 2019 489Chapter 1: Introducing Access 491What Is a Database, Anyway? 492Tables, Queries, Forms, and Other Objects 492Creating a Database File 497Finding Your Way Around the Navigation Pane 499Designing a Database 501Chapter 2: Building Your Database Tables 507Creating a Database Table 507Opening and Viewing Tables 511Entering and Altering Table Fields 512Field Properties for Making Sure That Data Entries Are Accurate 518Indexing for Faster Sorts, Searches, and Queries 526Establishing Relationships Among Database Tables 528Chapter 3: Entering the Data 535The Two Ways to Enter Data 535Entering the Data in Datasheet View 536Entering the Data in a Form 540Finding a Missing Record 542Finding and Replacing Data 543Chapter 4: Sorting, Querying, and Filtering for Data 545Sorting Records in a Database Table 545Filtering to Find Information 546Querying: The Basics 552Six Kinds of Queries 560Chapter 5: Presenting Data in a Report 567Creating a Report 567Opening and Viewing Reports 569Tweaking a Report 569Book 7: Publisher 2019 573Chapter 1: Introducing Publisher 575"A Print Shop in a Can" 575Introducing Frames 576Creating a Publication 577Redesigning a Publication 578Getting a Better View of Your Work 580Understanding and Using the Layout Guides 582Chapter 2: Refining a Publication 587Entering Text on the Pages 587Making Text Fit in Text Frames 588Formatting Text 592Making Text Wrap around a Frame or Graphic 592Replacing the Placeholder Pictures 593Inserting Frames on the Pages 594Making Frames Overlap 596Inserting, Removing, and Moving Pages 596Chapter 3: Putting on the Finishing Touches 599Decorating the Text 600Techniques for Decorating Pages 602Master Pages for Handling Page Backgrounds 606Running the Design Checker 608Commercially Printing a Publication 609Book 8: Working with Charts and Graphics 611Chapter 1: Creating a Chart 613The Basics: Creating a Chart 613Choosing the Right Chart 615Providing the Raw Data for Your Chart 617Positioning Your Chart in a Workbook, Page, or Slide 619Handling the gridlines 624Changing a chart element's color, font, or other particular 624Saving a Chart as a Template So That You Can Use It Again 626Chart Tricks for the Daring and Heroic 627Troubleshooting a Chart 630Chapter 2: Making a SmartArt Diagram 633The Basics: Creating SmartArt Diagrams 633Creating the Initial Diagram 636Changing the Size and Position of a Diagram 638Laying Out the Diagram Shapes 638Handling the Text on Diagram Shapes 644Changing a Diagram's Direction 647Choosing a Look for Your Diagram 647Changing the Appearance of Diagram Shapes 648Creating a Diagram from Scratch 651Chapter 3: Handling Graphics and Photos 653All about Picture File Formats 653Inserting a Picture in an Office File 657Touching Up a Picture 660Compressing Pictures to Save Disk Space 668Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 671The Basics: Making Lines, Arrows, and Shapes 672Handling Lines, Arrows, and Connectors 674Handling Rectangles, Ovals, Stars, and Other Shapes 678Drawing by Freehand 682Decorating Your Work with Icons 685Inserting a 3-D Model 686WordArt for Embellishing Letters and Words 686Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 688Changing an Object's Size and Shape 691Changing an Object's Color, Outline Color, and Transparency 692Moving and Positioning Objects 697Book 9: Office 2019: One Step Beyond 705Chapter 1: Customizing an Office Program 707Customizing the Ribbon 707Customizing the Quick Access Toolbar 713Customizing the Status Bar 716Changing the Screen Background and Office Theme 717Customizing Keyboard Shortcuts in Word 718Chapter 2: Ways of Distributing Your Work 721Printing - the Old Standby 721Distributing a File in PDF Format 723Sending Your File in an Email Message 725Saving an Office File as a Web Page 726Book 10: File Sharing and Collaborating 729Chapter 1: Up and Running on OneDrive 731Signing In to OneDrive 731Exploring the OneDrive Window 733Managing Your OneDrive Folders 733Uploading Files to a Folder on OneDrive 738Saving a File from Office 2019 to OneDrive 739Opening a File from OneDrive 740Downloading Files from OneDrive to Your Computer 741Chapter 2: File Sharing and Collaborating 743Sharing Files: The Big Picture 743Sharing Your Files and Folders with Others 745Inviting people by email 745Seeing Files and Folders Others Shared with You 748Investigating and Managing How Files and Folders Are Shared 749Index 751