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 Chap.