Introduction 1 Part I Introduction to the Office 2013 Application Suite Chapter 1 Getting Oriented to the Office 2013 Applications 7 Introducing Office 2013 7 New Features and Tools in Office 2013 9 Saving and Sharing Files in the Cloud 10 New Start Screen 12 Editing Adobe Acrobat Files 13 Other Office 2013 Improvements and Updates 13 The Office 2013 Suite Applications 14 The Different Versions of the Office 2013 Suite 15 Hardware and Software Requirements for Office 2013 16 Installing Office 2013 17 Getting Help in the Office Applications 20 Chapter 2 Navigating and Customizing the Office Interface 23 Getting Familiar with the Office Interface 23 Galleries 25 Contextual Tabs 26 Overview of the Office Application Window 27 Navigating the Office Applications 30 Working with the Ribbon 30 Working in the Backstage 33 Customizing an Application Interface 35 Customizing the Ribbon 36 Customizing the Quick Access Toolbar 38 Customizing the Status Bar 41 Configuring Application Options 42 Advanced Option Settings 44 Add-Ins 45 Adding Apps to the Office Applications 46 Using the Trust Center 48 Trusted Publishers 49 Trusted Locations 50 Chapter 3 Managing and Sharing Office Files 53 Understanding Office File Formats 53 Saving Files to Different File Types 56 Converting Files to Different File Types 57 Configuring Save File Options 58 Creating and Managing Files 60 Managing Files 62 Viewing File Versions in an Application 65 Searching for Office Files 66 Sharing Files Using Homegroup 67 Protecting an Office File 69 Prepare a File for Sharing 72 Chapter 4 Using and Creating Graphics 73 The Office 2013 Options for Graphics and Pictures 73 Working with SmartArt Graphics 76 Inserting SmartArt Graphics 79 Modifying SmartArt Graphics 81 Working with Your Digital Pictures 83 Inserting Pictures 83 Adjusting Pictures 84 Cropping an Image 87 Using the Background Removal Tool 87 Inserting Online Pictures 89 Inserting Clip Art 90 Inserting Bing Image Search Results 90 Inserting Flickr.com Images 91 Inserting Images from your SkyDrive 92 Using Shapes and the Office Drawing Tools 93 Adding and Combining Multiple Shapes 94 Formatting a Shape with the Drawing Tools 96 Using the Screenshot Feature 97 Using WordArt 99 Chapter 5 Using the Office Web Apps 103 What the Web Apps Can Do 104 Where the Web Apps Live 105 Saving Office Application Files to the Cloud 108 Saving a File to SkyDrive or SkyDrive Pro 110 Sharing a File Saved to the Cloud 111 Sharing OneNote Notebooks 113 Using the Word Web App 114 The File Tab 115 The Word Web App Home Tab 115 The Word Web App Insert Tab 117 The Word Web App View Tab 118 Using the Excel Web App 119 The Excel Web App File Tab 120 Working in the Excel Web App 120 Inserting Functions and Charts in the Excel Web App 120 Using the PowerPoint Web App 123 Working with Slides 125 Adding Pictures and SmartArt 126 Using the OneNote Web App 127 Adding Sections and Pages 127 Adding Notes and Note Tags to Pages 128 Inserting Tables and Other Objects onto Pages 129 Part II Word Chapter 6 Requisite Word: Essential Features 131 Introducing Word 2013 131 The Word 2013 Interface 131 New Features and Improvements 133 Options for Creating a New Word Document 134 Using Templates 137 Creating a Template 140 Attaching a Template 142 Navigating a Word Document 143 Moving Around a Document with the Mouse 143 Moving Around a Document with the Keyboard 144 Selecting Text 145 Understanding Document Formatting 146 Character Formatting Versus Paragraph Formatting 146 Manual Formatting Versus Styles and Themes 147 Working with Fonts and Text Formatting 147 Formatting Text 148 Working with Paragraph Formatting 151 Setting Paragraph Alignment 152 Changing Line Spacing 153 Setting Line and Page Breaks 154 Setting Indents 155 Working with Tabs 156 Revealing Format Settings 158 Page Layout: Margins and Page Options 159 Changing Margins 160 Changing Page Orientation and Paper Size 161 Inserting Page Breaks 161 Printing Documents 161 Chapter 7 Enhancing Word Documents 165 Creating Better Documents 165 Creating Bulleted and Numbered Lists 166 Bulleted Lists 166 Numbered Lists 168 Multilevel Lists 169 Working with Borders and Shading 170 Formatting with Themes 172 Creating Headers and Footers 176 Inserting Headers and Footers 177 The Header and Footer Tools 178 Working with Page Numbering 180 Inserting Pictures, Clip Art, and Charts 181 Inserting Pictures 182 Adding Clip Art 184 Inserting a Chart 185 Integrating Text and Images 187 Changing the Document Display 188 Using the Navigation Pane 190 Using the Outline View 191 Splitting the Document Window 192 Using the Review Tools 193 Running Spelling and Grammar 193 Using the Thesaurus 194 Using the Define Command 194 Working with Quick Parts 196 Creating and Inserting an AutoText Entry 196 Creating and Inserting Building Blocks 197 Configuring AutoCorrect 198 Understanding Styles 199 Using the Styles Gallery 200 Creating Styles 201 Editing Styles 202 Managing Styles 203 Chapter 8 Working with Tables, Columns, and Sections 207 Options for Adding a Table 207 Inserting a Table 209 Drawing a Table 211 Converting Text to a Table 211 Entering Text and Navigating a Table 212 Selecting and Positioning a Table 213 Formatting Tables 213 Adjusting Columns and Rows 215 Formatting Cells 217 Using Table Styles 218 Sorting Table Data 221 Using Formulas in Tables 222 Adding Columns to a Document 223 Understanding Sections 225 Adding and Removing Section Breaks 225 Formatting Page Attributes in a Section 226 Chapter 9 Managing Mailings and Forms 229 Options for Mail-Related Documents 229 Creating an Envelope 230 Creating a Label or Labels 231 Understanding Word''s Options for Mass Mailings 233 Performing a Mail Merge 233 Using the Mail Merge Commands 235 Understanding Recipient Lists 236 Creating a Recipient List 237 Editing and Manipulating a Recipient List 239 Using Merge Fields 241 Using Merge Rules 243 Previewing Merge Results 245 Completing the Merge 246 Creating Merged Envelopes and Labels 247 Understanding Word Fields 248 Building a Form with Form Controls 249 Chapter 10 Creating Special Documents 253 Options for Large Documents 253 Creating a Table of Contents 254 Creating a Table of Contents with Built-in Styles 255 Creating a Table of Contents with Your Own Styles 256 Adding Entries and Updating the TOC 258 Building a TOC with Field Codes 259 Working with Captions and Tables of Figures 261 Inserting a Caption 262 Inserting a Table of Figures 263 Using Cross-References 264 Generating an Index 265 Marking Index Entries 266 Inserting the Index 267 Working with Citations and Bibliographies 268 Creating Citations 269 Managing Citations 270 Inserting the Bibliography 271 Inserting Footnotes and Endnotes 272 Tracking Document Changes 274 Options for Viewing Changes 277 Reviewing Changes 277 Comparing Documents 279 Building a Better "Big" Document 281 Creating Bookmarks 281 Inserting Comments 282 Creating a Master Document 283 Working in Outline View 284 Creating Subdocuments from Scratch 285 Inserting Existing Document Files into a Master Document Outline 286 Manipulating the Master Document 287 Part III Excel Chapter 11 Requisite Excel: Essential Features 289 Introducing Excel 2013 289 Quick Analysis 291 Recommended Chart 292 Flash Fill 293 Navigating the Excel Workspace 294 The Excel Ribbon 294 Moving Around a Worksheet 296 Creating Workbooks and Worksheets 297 Using Office.com Templates 298 Inserting and Rearranging Worksheets 299 Managing Excel Workbooks 301 Protecting Workbooks and Worksheets 303 Locking Cells 304 Specifying Edit Ranges 306 Preparing a Workbook for Sharing 308 Managing Versions 309 Entering Data in a Worksheet 309 Entering Labels 310 Entering Values 310 Using AutoComplete 311 Filling and Entering Series 312 Using the Fill Handle 312 Creating Custom Fill Lists 314 Creating Custom Series 316 Copying, Moving, and Deleting Cell Contents 317 Using the Paste Special Dialog Box 319 Moving Cells and Ranges 321 Clearing and Deleting Cells 321 Editing Cell Content 323 Viewing Worksheets 323 Printing Worksheets 326 Using the Page Layout Commands 326 Setting a Print Area 3.