Office 2013 Simplified

Microsoft Office 2013 Simplified......Page 1
 Dedication......Page 6
 How to Use This Book......Page 7
 Table of Contents......Page 8
 Part I: Office Features......Page 16
   Start and Exit Office Applications......Page 18
   Navigate the Program Windows......Page 20
   Work with Backstage View......Page 21
   Work with the Ribbon......Page 22
   Customize the Quick Access Toolbar......Page 24
   Using an Office Program on a Tablet PC......Page 26
   Create a New File......Page 28
   Working with Files......Page 29
   Save a File......Page 30
   Open a File......Page 32
   Print a File......Page 34
   E-Mail a File......Page 36
   Select Data......Page 38
   Cut, Copy, and Paste Data......Page 40
   Arrange Windows......Page 42
   Insert a Picture......Page 44
   Insert an Online Picture......Page 46
   Resize and Move Graphic Objects......Page 48
   Understanding Graphic Object Modification Techniques......Page 50
   Office and the Cloud......Page 52
   Sign In to Office Online......Page 54
   Share a Document from Office......Page 56
   Download Apps from the Office Store......Page 58
   Download Apps from the Office Store (continued)......Page 60
   Sign In to SkyDrive......Page 62
   Using a Web App in SkyDrive......Page 64
   Using an Office Program from SkyDrive......Page 66
   Upload a Document to SkyDrive......Page 68
   Share a Document Using SkyDrive......Page 70
 Part II: Word......Page 72
   Change Word’s Views......Page 74
   Type and Edit Text......Page 76
   Insert Quick Parts......Page 78
   Insert Symbols......Page 80
   Create a Blog Post......Page 82
   Change the Font, Size, and Color......Page 84
   Change the Font, Size, and Color (continued)......Page 86
   Align Text......Page 88
   Set Line Spacing......Page 89
   Indent Text......Page 90
   Set Tabs......Page 92
   Set Margins......Page 94
   Create Lists......Page 96
   Copy Formatting......Page 98
   Clear Formatting......Page 99
   Format with Styles......Page 100
   Apply a Template......Page 102
   Insert an Online Video......Page 104
   Assign a Theme......Page 106
   Add Borders......Page 108
   Create Columns......Page 110
   Insert a Table......Page 112
   Apply Table Styles......Page 114
   Insert an Excel Spreadsheet......Page 115
   Add Headers and Footers......Page 116
   Insert Footnotes and Endnotes......Page 118
   Insert Page Numbers and Page Breaks......Page 120
   Generate a Table of Contents......Page 122
   Create a Bibliography......Page 124
   Work in Read Mode View......Page 126
   Find and Replace Text......Page 128
   Scan Document Content......Page 130
   Check Spelling and Grammar......Page 132
   Work with AutoCorrect......Page 134
   Using Word’s Thesaurus and Dictionary......Page 136
   Translate Text......Page 138
   Track and Review Document Changes......Page 140
   Lock and Unlock Tracking......Page 142
   Work with Comments......Page 144
 Part III: Excel......Page 146
   Enter Cell Data......Page 148
   Select Cells......Page 149
   Faster Data Entry with AutoFill......Page 150
   Building Spreadsheets......Page 151
   Turn On Text Wrapping......Page 152
   Center Data across Columns......Page 153
   Adjust Cell Alignment......Page 154
   Change the Font and Size......Page 156
   Change Number Formats......Page 158
   Increase or Decrease Decimals......Page 159
   Add Cell Borders and Shading......Page 160
   Format Data with Styles......Page 162
   Apply Conditional Formatting......Page 164
   Add Columns and Rows......Page 166
   Resize Columns and Rows......Page 168
   Freeze Column and Row Titles On-Screen......Page 169
   Name a Range......Page 170
   Clear or Delete Cells......Page 172
   Split and Format a Column of Data......Page 174
   Add a Worksheet......Page 176
   Name a Worksheet......Page 177
   Change Page Setup Options......Page 178
   Worksheet Basics......Page 179
   Move and Copy Worksheets......Page 180
   Delete a Worksheet......Page 181
   Find and Replace Data......Page 182
   Create a Table......Page 184
   Filter or Sort Table Information......Page 186
   Analyze Data Quickly......Page 188
   Understanding Data Analysis Choices......Page 189
   Track and Review Worksheet Changes......Page 190
   Track and Review Worksheet Changes (continued)......Page 192
   Insert a Comment......Page 194
   Understanding Formulas......Page 196
   Create a Formula......Page 198
   Apply Absolute and Relative Cell References......Page 200
   Understanding Functions......Page 202
   Apply a Function......Page 204
   Total Cells with AutoSum......Page 206
   Audit a Worksheet for Errors......Page 208
   Create a Chart......Page 210
   Move and Resize Charts......Page 212
   Change the Chart Type......Page 214
   Change the Chart Style......Page 215
   Change the Chart Layout......Page 216
   Add Chart Elements......Page 217
   Format Chart Objects......Page 218
   Change the Chart Data......Page 219
   Using Sparklines to View Data Trends......Page 220
 Part IV: PowerPoint......Page 222
   Create a New Presentation......Page 224
   Create a Photo Album Presentation......Page 226
   Change PowerPoint Views......Page 228
   Insert Slides......Page 230
   Change the Slide Layout......Page 231
   Change the Slide Size......Page 232
   Add and Edit Slide Text......Page 234
   Change the Font, Size, and Color......Page 236
   Change the Font, Size, and Color (continued)......Page 238
   Apply a Theme......Page 240
   Set Line Spacing......Page 241
   Align Text......Page 242
   Add a Text Box to a Slide......Page 243
   Add a Table to a Slide......Page 244
   Add a Chart to a Slide......Page 246
   Add a Video Clip to a Slide......Page 248
   Move a Slide Object......Page 250
   Resize a Slide Object......Page 251
   Reorganize......Page 252
   Reuse a Slide......Page 254
   Define Slide Transitions......Page 256
   Add Animation Effects......Page 258
   Record Narration......Page 260
   Insert a Background Song......Page 261
   Create Speaker Notes......Page 262
   Rehearse a Slide Show......Page 264
   Run a Slide Show......Page 266
   Run a Slide Show (continued)......Page 268
   Review a Presentation......Page 270
   Package Your Presentation on a CD......Page 272
   Present Online......Page 274
 Part V: Access......Page 276
   Understanding Database Basics......Page 278
   Create a Database Based on a Template......Page 280
   Create a Blank Database......Page 282
   Create a New Table......Page 284
   Change Table Views......Page 286
   Add a Field to a Table......Page 288
   Delete a Field from a Table......Page 289
   Hide a Field in a Table......Page 290
   Move a Field in a Table......Page 291
   Create a Form......Page 292
   Change Form Views......Page 294
   Move a Field in a Form......Page 295
   Delete a Field in a Form......Page 296
   Apply a Database Theme......Page 297
   Add a Record......Page 298
   Add a Record to a Form......Page 300
   Navigate Records in a Form......Page 302
   Search for a Record in a Form......Page 303
   Delete a Record from a Table......Page 304
   Delete a Record from a Form......Page 305
   Sort Records......Page 306
   Filter Records......Page 308
   Apply Conditional Formatting......Page 310
   Perform a Simple Query......Page 312
   Perform a Simple Query (continued)......Page 314
   Create a Report......Page 316
 Part VI: Outlook......Page 318
   Navigate in Outlook......Page 320
   Schedule an Appointment......Page 322
   Create a New Contact......Page 324
   Create a New Task......Page 326
   Add a Note......Page 328
   Customize the Navigation Bar......Page 330
   Peek at Appointments and Tasks......Page 332
   Perform a Basic Search......Page 334
   Link Contacts......Page 335
   Compose and Send a Message......Page 336
   Send a File Attachment......Page 338
   Read an Incoming Message......Page 339
   Reply To or Forward a Message......Page 340
   Add a Sender to Your Outlook Contacts......Page 342
   Delete a Message......Page 343
   Work with Conversations......Page 344
   Screen Junk E-Mail......Page 346
 Part VII: Publisher......Page 348
   Create a Publication......Page 350
   Zoom In and Out......Page 352
   Add Text......Page 354
   Add a New Text Box......Page 355
   Swap Pictures......Page 356
   Save a Publication for Photo Center Printing......Page 358
   Change the Font, Size, and Color......Page 360
   Change the Font, Size, and Color (continued)......Page 362
   Apply a Text Effect......Page 364
   Change Text Alignment......Page 365
   Add a Border......Page 366
   Control Text Wrap......Page 367
   Link Text Boxes......Page 368
   Edit the Background......Page 370
 Part VIII: OneNote......Page 372
   Navigate OneNote......Page 374
   Type and Draw Notes......Page 376
   Insert and Format a Table......Page 378
   Attach Files to Notes......Page 380
   Send Information to OneNote......Page 381
   Insert a Screen Clipping......Page 382
   Create a Quick Note......Page 383
   Record an Audio Note......Page 384
   Create a New Notebook......Page 386
   Create a New Section......Page 387
   Create a New Page......Page 388
   Rename a Section or Page......Page 389
   Group Sections......Page 390
   Search Notes......Page 392
   Search for Recent Edits......Page 394
   Set Synchronization Options......Page 395
   Share Notes with People Who Do Not Have OneNote......Page 396
 Index......Page 398