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