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 5 Book 1: Common Office Tasks 7 Chapter 1: Office Nuts and Bolts 9 Introducing Office 365 9 Finding Your Way around the Office Interface 13 Saving Your Files 20 Navigating the Save As and Open Windows 21 Opening and Closing Files 23 Reading and Recording File Properties 24 Locking a File with a Password 25 Trusting (or not Trusting) Microsoft with Your "Content" 26 Chapter 2: Wrestling with the Text 29 Manipulating the Text 29 Speaking, not Typing, the Words 32 Changing the Look of Text 34 Quick Ways to Handle Case, or Capitalization 41 Entering Symbols and Foreign Characters 42 Creating Hyperlinks 44 Chapter 3: Speed Techniques Worth Knowing About 49 Undoing and Repeating Commands 49 Zooming In, Zooming Out 51 Viewing a File through More than One Window 52 Correcting Typos on the Fly 53 Entering Text Quickly with the AutoCorrect Command 55 Book 2: Word 365 57 Chapter 1: Speed Techniques for Using Word 59 Introducing the Word Screen 59 Creating a New Document 61 Getting a Better Look at Your Documents 63 Selecting Text in Speedy Ways 68 Moving around Quickly in Documents 69 Inserting a Whole File into a Document 73 Getting Word to Read It 74 Entering Information Quickly in a Computerized Form 74 Chapter 2: Laying Out Text and Pages 79 Paragraphs and Formatting 79 Inserting a Section Break for Formatting Purposes 80 Breaking a Line 83 Starting a New Page 83 Setting Up and Changing the Margins 84 Indenting Paragraphs and First Lines 86 Numbering the Pages 88 Putting Headers and Footers on Pages 91 Adjusting the Space between Lines 95 Adjusting the Space between Paragraphs 96 Creating Numbered and Bulleted Lists 97 Working with Tabs 100 Hyphenating Text 102 Chapter 3: Word Styles 105 All about Styles 105 Applying Styles to Text and Paragraphs 107 Creating a New Style 112 Modifying a Style 115 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 179 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) 198 Churning Out Letters, Envelopes, and Labels for Mass Mailings 200 Chapter 8: Tools for Reports and Scholarly Papers 207 Alphabetizing a List 207 Outlines for Organizing Your Work 208 Collapsing and Expanding Parts of a Document 210 Generating a Table of Contents 211 Indexing a Document 215 Putting Cross-References in a Document 220 Putting Footnotes and Endnotes in Documents 222 Compiling a Bibliography 225 Book 3: Excel 365 229 Chapter 1: Up and Running with Excel 231 Creating a New Excel Workbook 231 Getting Acquainted with Excel 233 Entering Data in a Worksheet 235 Quickly Entering Lists and Serial Data with the AutoFill Command 241 Formatting Numbers, Dates, and Time Values 244 Establishing Data-Validation Rules 245 Chapter 2: Refining Your Worksheet 249 Editing Worksheet Data 249 Moving around in a Worksheet 250 Getting a Better Look at the Worksheet 251 Notes for Documenting Your Worksheet 254 Comments for Collaborating with Others on a Workbook 256 Selecting Cells in a Worksheet 257 Deleting, Copying, and Moving Data 258 Handling the Worksheets in a Workbook 259 Keeping Others from Tampering with Worksheets 261 Chapter 3: Formulas and Functions for Crunching Numbers 263 How Formulas Work 263 The Basics of Entering a Formula 269 Speed Techniques for Entering Formulas 269 Copying Formulas from Cell to Cell 275 Detecting and Correcting Errors in Formulas 276 Working with Functions 280 A Look at Some Very Useful Functions 284 Chapter 4: Making a Worksheet Easier to Read and Understand 295 Laying Out a Worksheet 295 Decorating a Worksheet with Borders and Colors 301 Getting Ready to Print a Worksheet 306 Chapter 5: Advanced Techniques for Analyzing Data 313 Seeing What the Sparklines Say 313 Conditional Formats for Calling Attention to Data 314 Managing Information in Lists 316 Forecasting with the Goal Seek Command 319 Performing What-If Analyses with Data Tables 321 Analyzing Data with PivotTables 325 Book 4: Powerpoint 365 329 Chapter 1: Getting Started in PowerPoint 331 Getting Acquainted with PowerPoint 332 A Brief Geography Lesson 333 A Whirlwind Tour of PowerPoint 334 Creating a New Presentation 335 Advice for Building Persuasive Presentations 338 Creating New Slides for Your Presentation 340 Getting a Better View of Your Work 343 Hiding and Displaying the Slides Pane and Notes Pane 345 Selecting, Moving, and Deleting Slides 346 Putting Together a Photo Album 347 Hidden Slides for All Contingencies 350 Chapter 2: Fashioning a Look for Your Presentation 353 Looking at Themes and Slide Backgrounds 353 Choosing a Theme for Your Presentation 355 Creating Slide Backgrounds on Your Own 356 Changing the Background of a Single or Handful of Slides 362 Choosing the Slide Size 363 Using Master Slides and Master Styles for a Consistent Design 363 Chapter 3: Entering the Text 367 Entering Text 367 Fun with Text Boxes and Text Box Shapes 371 Controlling How Text Fits in Text Frames and Text Boxes 372 Positioning Text in Frames and Text Boxes 375 Handling Bulleted and Numbered Lists 376 Putting Footers (and Headers) on Slides 379 Chapter 4: Making Your Presentations Livelier 383 Suggestions for Enlivening Your Presentation 383 Presenting Information in a Table 384 Exploring Transitions and Animations 387 Making Audio Part of Your Presentation 390 Playing Video on Slides 393 Recording a Voice Narration for Slides 396 Chapter 5: Delivering a Presentation 399 All about Notes 399 Rehearsing and Timing Your Presentation 400 Showing Your Presentation 402 Tricks for Making Presentations a Little Livelier 405 Delivering a Presentation When You Can''t Be There in Person 408 Book 5: Outlook 365 419 Chapter 1: Outlook Basics 421 What is Outlook, Anyway? 421 Navigating the Outlook Folders 422 Categorizing Items 423 Searching for Stray Folder Items 425 Deleting Email Messages, Contacts, Tasks, and Other Items 428 Cleaning Out Your Folders 429 Chapter 2: Maintaining the Contacts Folder 433 Maintaining a Happy and Healthy Contacts Folder 434 Contact Groups for Sending Messages to Groups 437 Finding a Contact in the Contacts Folder 440 Linking Duplicate Contacts 440 Sharing Contacts with Coworkers 441 Printing the Contacts Folder 443 Chapter 3: Handling Your Email 447 Setting Up an Email Account 447 Addressing and Sending Email Messages 448 Sending Files and Photos 454 Receiving Email Messages 456 Reading Your Email in the Inbox Window 457 Handling Files That Were Sent to You 459 Techniques for Organizing Email Messages 460 All about Email Folders 464 Yes, You Can Prevent Junk Mail (Sort of) 466 Chapter 4: Managing Your Time and Schedule 469 Introducing the Calendar 469 The Di.