Introduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 4 Book I: 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 10 The File tab and Backstage 10 The Quick Access toolbar 12 The Ribbon and its tabs 12 Context-sensitive tabs 13 The anatomy of a tab 13 Mini-toolbars and shortcut menus 14 Office 2016 for keyboard lovers 15 Saving Your Files 16 Saving a file 17 Saving a file for the first time 17 Saving AutoRecovery information 18 Navigating the Save As and Open Windows 19 Opening and Closing Files 20 Opening a file 20 Closing a file 21 Reading and Recording File Properties 21 Locking a File with a Password 22 Password-protecting a file 23 Removing a password from a file 24 Chapter 2: Wrestling with the Text 25 Manipulating the Text 25 Selecting text 25 Moving and copying text 27 Taking advantage of the Clipboard task pane 27 Deleting text 27 Changing the Look of Text 28 Choosing fonts for text 29 Changing the font size of text 30 Applying font styles to text 32 Applying text effects to text 32 Underlining text 34 Changing the color of text 34 Quick Ways to Handle Case, or Capitalization 35 Entering Symbols and Foreign Characters 36 Creating Hyperlinks 38 Linking a hyperlink to a web page 38 Creating a hyperlink to another place in your file 40 Creating an email hyperlink 41 Repairing and removing hyperlinks 41 Chapter 3: Speed Techniques Worth Knowing About 43 Undoing and Repeating Commands 43 Undoing a mistake 43 Repeating an action -- and quicker this time 44 Zooming In, Zooming Out 45 Viewing a File Through More Than One Window 46 Correcting Typos on the Fly 47 Entering Text Quickly with the AutoCorrect Command 48 Book II: Word 2016 51 Chapter 1: Speed Techniques for Using Word 53 Introducing the Word Screen 53 Creating a New Document 55 Getting a Better Look at Your Documents 57 Viewing documents in different ways 57 Splitting the screen 60 Selecting Text in Speedy Ways 61 Moving Around Quickly in Documents 63 Keys for getting around quickly 63 Navigating from page to page or heading to heading 63 Going there fast with the Go To command 65 Bookmarks for hopping around 65 Inserting a Whole File into a Document 66 Entering Information Quickly in a Computerized Form 67 Creating a computerized form 68 Entering data in the form 70 Chapter 2: Laying Out Text and Pages 71 Paragraphs and Formatting 71 Inserting a Section Break for Formatting Purposes 72 Breaking a Line 74 Starting a New Page 74 Setting Up and Changing the Margins 75 Indenting Paragraphs and First Lines 77 Clicking an Indent button (for left-indents) 77 "Eye-balling it" with the ruler 77 Indenting in the Paragraph dialog box 79 Numbering the Pages 79 Numbering with page numbers only 79 Including a page number in a header or footer 80 Changing page number formats 81 Putting Headers and Footers on Pages 82 Creating, editing, and removing headers and footers 83 Fine-tuning a header or footer 85 Adjusting the Space between Lines 86 Adjusting the Space Between Paragraphs 87 Creating Numbered and Bulleted Lists 88 Simple numbered and bulleted lists 88 Constructing lists of your own 89 Managing a multilevel list 90 Working with Tabs 91 Hyphenating Text 92 Automatically and manually hyphenating a document 93 Unhyphenating and other hyphenation tasks 94 Chapter 3: Word Styles 95 All About Styles 95 Styles and templates 95 Types of styles 96 Applying Styles to Text and Paragraphs 97 Applying a style 97 Experimenting with style sets 98 Choosing which style names appear on the Style menus 99 Creating a New Style 101 Creating a style from a paragraph 101 Creating a style from the ground up 102 Modifying a Style 103 Creating and Managing Templates 105 Creating a new template 105 Opening a template so that you can modify it 109 Modifying, deleting, and renaming styles in templates 110 Chapter 4: Constructing the Perfect Table 111 Talking Table Jargon 111 Creating a Table 112 Entering the Text and Numbers 114 Selecting Different Parts of a Table 115 Laying Out Your Table 116 Changing the size of a table, columns, and rows 116 Adjusting column and row size 116 Inserting columns and rows 117 Deleting columns and rows 118 Moving columns and rows 119 Aligning Text in Columns and Rows 120 Merging and Splitting Cells 121 Repeating Header Rows on Subsequent Pages 122 Formatting Your Table 123 Designing a table with a table style 123 Calling attention to different rows and columns 124 Decorating your table with borders and colors 124 Using Math Formulas in Tables 127 Neat Table Tricks 128 Changing the direction of header row text 128 Wrapping text around a table 129 Using a picture as the table background 130 Drawing diagonal lines on tables 131 Drawing on a table 132 Chapter 5: Taking Advantage of the Proofing Tools 133 Correcting Your Spelling Errors 133 Correcting misspellings one at a time 134 Running a spell-check 135 Preventing text from being spell checked 136 Checking for Grammatical Errors in Word 137 Getting a Word Definition 138 Finding and Replacing Text 138 The basics: Finding stray words and phrases 138 Narrowing your search 139 Conducting a find-and-replace operation 145 Researching a Topic Inside Word 146 Finding the Right Word with the Thesaurus 148 Proofing Text Written in a Foreign Language 149 Telling Office which languages you will use 150 Marking text as foreign language text 150 Translating Foreign Language Text 151 Chapter 6: Desktop Publishing with Word 153 Experimenting with Themes 153 Sprucing Up Your Pages 155 Decorating a page with a border 155 Putting a background color on pages 156 Getting Word''s help with cover letters 157 Making Use of Charts, Diagrams, Shapes, and Photos 157 Working with the Drawing Canvas 158 Positioning and Wrapping Objects Relative to the Page and Text 159 Wrapping text around an object 159 Positioning an object on a page 161 Working with Text Boxes 163 Inserting a text box 163 Making text flow from text box to text box 164 Dropping In a Drop Cap 164 Watermarking for the Elegant Effect 165 Putting Newspaper-Style Columns in a Document 166 Doing the preliminary work 167 Running text into columns 167 Landscape Documents 168 Printing on Different Size Paper 169 Showing Online Video in a Document 169 Chapter 7: Getting Word''s Help with Office Chores 171 Highlighting Parts of a Document 171 Commenting on a Document 172 Entering a comment 172 Viewing and displaying comments 174 Caring for and feeding comments 174 Tracking Changes to Documents 175 Telling Word to start marking changes 176 Reading and reviewing a document with change marks 176 Marking changes when you forgot to turn on change marks 178 Accepting and rejecting changes to a document 179 Printing an Address on an Envelope 180 Printing a Single Address Label (Or a Page of the Same Label) 182 Churning Out Letters, Envelopes, and Labels for Mass Mailings 183 Preparing the source file 184 Merging the document with the source file 185 Printing form letters, envelopes, and labels 189 Chapter 8: Tools for Reports and Scholarly Papers 191 Alphabetizing a List 191 Outlines for Organizing Your Work 192 Viewing the outline in different ways 193 Rearranging document sections in Outline view 193 Collapsing and Expanding Parts of a Document 194 Generating a Table of Contents 195 Creating a TOC 195 Updating and removing a TOC 196 Customizing a TOC 196 Changing the structure of a TOC 197 Indexing a Document 199 Marking index items in the document 199 Generating the index 201 Editing an index 203 Putting Cross?References in a Document 203 Putting Footnotes and Endnotes in Documents 205 Entering a footnote or endnote 206 Choosing the numbering scheme and position of notes 207 Deleting, moving, and editing notes 208 Compiling a Bibliography 208 Inserting a citation for your bibliography 208 Editing a citation 210 Changing how citations appear in text 210 Generating the bibliography 211 Book III: Excel 2016 213 Chapter 1: Up and Running with Excel 215 Creating a New Excel Workbook 215 Getting Acquainted with Excel 217 Rows, columns, and cell addresses 219 Workbooks and worksheets 219 Entering Data in a Worksheet 219 The bas.