Teach Yourself VISUALLY: Microsoft Office 2010

Master the new version of Microsoft Office with this easy, visual guide The popular Microsoft Office suite has been revamped to provide new features, including Web applications that can be accessed from anywhere and a new, streamlined Ribbon. If you learn better with visual instructions, this full-color guide is just what you need. Covering Word, Excel, PowerPoint, Outlook, Access, and Publisher, this book is filled with step-by-step instructions and full-color screen shots that show you exactly what you'll see at each step. You'll also get instruction on the new Office Internet and graphics tools, as well as how to tackle dozens of common tasks in each application. Ideal for visual learners, this guide covers the entire Office suite: Word, Excel, PowerPoint, Outlook, Access, and Publisher Introduces the new Microsoft Office features, including Office Internet and graphics tools Provides step-by-step instructions for common tasks in each application Full-color screen shots illustrate what you see on the screen every step of the way Teach Yourself VISUALLY Office 2010 gets you up and running with Office 2010 quickly and easily, so you can take advantage of all the enhanced features. Teach Yourself VisuallyTM Microsoft® Office 2010......Page 1 Credits......Page 5 Author’s Acknowledgments......Page 6 How to Use This Book......Page 7 Table of Contents......Page 8 Part I: Office Features......Page 20 Start and Exit Office Applications......Page 22 Navigate the Program Windows......Page 24 Work with the Ribbon......Page 26 Customize the Quick Access Toolbar......Page 28 Find Help with Office......Page 30 Create a New File......Page 32 Save a File......Page 34 Open a File......Page 36 Print a File......Page 38 Check Your File for Hidden or Personal Data......Page 40 E-mail a File......Page 42 Select Data......Page 44 Cut, Copy, and Paste Data......Page 46 View Multiple Files......Page 48 Insert Clip Art......Page 50 View Clip Art with the Clip Organizer......Page 52 Insert a Picture......Page 54 Resize and Move Objects......Page 56 Rotate and Flip Objects......Page 58 Crop a Picture......Page 60 Add a Picture Border......Page 62 Add a Picture Effect......Page 64 Make Image Corrections......Page 65 Make Color Adjustments......Page 66 Apply Artistic Effects......Page 67 Create a WordArt Object......Page 68 Add SmartArt......Page 70 Create a New Workspace......Page 72 Upload a File to Office Live Workspace......Page 74 Create a New File in Office Live Workspace......Page 76 Edit a File in Office Live Workspace......Page 78 Share a Workspace......Page 80 View Shared Workspaces......Page 82 Delete a File from Office Live Workspace......Page 83 Part II: Word......Page 84 Change Word’s Views......Page 86 Type and Edit Text......Page 88 Insert Quick Parts......Page 90 Insert Symbols......Page 92 Create a Blog Post......Page 94 Change the Font, Size, and Color......Page 96 Align Text......Page 100 Set Line Spacing......Page 101 Indent Text......Page 102 Set Tabs......Page 104 Set Margins......Page 106 Create Lists......Page 108 Copy Formatting......Page 110 Clear Formatting......Page 111 Format with Styles......Page 112 Apply a Template......Page 114 Assign a Theme......Page 116 Add Borders......Page 118 Create Columns......Page 120 Insert a Table......Page 122 Apply Table Styles......Page 124 Insert an Excel Spreadsheet......Page 125 Add Headers and Footers......Page 126 Insert Footnotes and Endnotes......Page 128 Insert Page Numbers and Page Breaks......Page 130 Mark Index Entries......Page 132 Generate an Index......Page 134 Generate a Table of Contents......Page 136 Create a Bibliography......Page 138 Find and Replace Text......Page 140 Scan Document Content......Page 142 Check Spelling and Grammar......Page 144 Work with AutoCorrect......Page 146 Use Word’s Thesaurus and Dictionary......Page 148 Translate Text......Page 150 Track and Review Document Changes......Page 152 Compare Documents......Page 154 Insert Comments......Page 156 Part III: Excel......Page 158 Enter Cell Data......Page 160 Select Cells......Page 162 Faster Data Entry with AutoFill......Page 164 Turn On Text Wrapping......Page 166 Center Data Across Columns......Page 167 Adjust Cell Alignment......Page 168 Change the Font and Size......Page 170 Change Number Formats......Page 172 Increase or Decrease Decimals......Page 173 Add Borders......Page 174 Format Data with Styles......Page 176 Apply Conditional Formatting......Page 178 Add Columns and Rows......Page 180 Resize Columns and Rows......Page 182 Freeze a Column or Row......Page 183 Name a Range......Page 184 Delete Data or Cells......Page 186 Add a Worksheet......Page 188 Name a Worksheet......Page 189 Change Page Setup Options......Page 190 Move and Copy Worksheets......Page 192 Delete a Worksheet......Page 193 Find and Replace Data......Page 194 Sort Data......Page 196 Filter Data......Page 198 Track and Review Worksheet Changes......Page 200 Insert a Comment......Page 204 Understanding Formulas......Page 206 Create a Formula......Page 208 Apply Absolute and Relative Cell References......Page 210 Understanding Functions......Page 212 Apply a Function......Page 214 Total Cells with AutoSum......Page 216 Audit a Worksheet for Errors......Page 218 Add a Watch Window......Page 220 Create a Chart......Page 222 Move and Resize Charts......Page 224 Change the Chart Type......Page 226 Change the Chart Style......Page 227 Change the Chart Layout......Page 228 Add Axis Titles......Page 229 Format Chart Objects......Page 230 Add Gridlines......Page 232 Change the Chart Data......Page 233 Use Sparklines to View Data Trends......Page 234 Part IV: PowerPoint......Page 236 Create a Photo Album Presentation......Page 238 Create a Presentation with a Template......Page 240 Build a Blank Presentation......Page 242 Change PowerPoint Views......Page 244 Insert Slides......Page 246 Change the Slide Layout......Page 247 Create a Custom Layout......Page 248 Add and Edit Slide Text......Page 250 Change the Font, Size, and Color......Page 252 Apply a Theme......Page 256 Set Line Spacing......Page 257 Align Text......Page 258 Add a Text Box to a Slide......Page 259 Add a Table to a Slide......Page 260 Add a Chart to a Slide......Page 262 Add a Picture to a Slide......Page 264 Add a Video Clip to a Slide......Page 266 Move a Slide Object......Page 268 Resize a Slide Object......Page 269 Reorganize Slides......Page 270 Reuse a Slide......Page 272 Organize Slides into Sections......Page 274 Define Slide Transitions......Page 276 Add Animation Effects......Page 278 Create a Custom Animation......Page 280 Record Narration......Page 282 Set Up a Slide Show......Page 283 Create Speaker Notes......Page 284 Rehearse a Slide Show......Page 286 Run a Slide Show......Page 288 Package Your Presentation on a CD......Page 290 Part V: Access......Page 292 Understanding Database Basics......Page 294 Create a Database Based on a Template......Page 296 Create a Blank Database......Page 298 Create a New Table......Page 300 Change Table Views......Page 302 Add a Field to a Table......Page 304 Delete a Field from a Table......Page 305 Hide a Field in a Table......Page 306 Move a Field in a Table......Page 307 Create a Form......Page 308 Change Form Views......Page 310 Move a Field in a Form......Page 311 Delete a Field in a Form......Page 312 Apply a Database Theme......Page 313 Format Form Fields......Page 314 Add a Background Image......Page 315 Add a Record to a Table......Page 316 Add a Record to a Form......Page 318 Navigate Records in a Form......Page 320 Search for a Record in a Form......Page 321 Delete a Record from a Table......Page 322 Delete a Record from a Form......Page 323 Sort Records......Page 324 Filter Records......Page 326 Apply Conditional Formatting......Page 328 Perform a Simple Query......Page 330 Create a Report......Page 334 Part VI: Outlook......Page 338 View Outlook Components......Page 340 Schedule an Appointment......Page 342 Schedule a Recurring Appointment......Page 344 Schedule an Event......Page 346 Create a New Contact......Page 348 Create a New Task......Page 350 Add a Note......Page 352 Organize Outlook Items......Page 354 Perform an Instant Search......Page 356 Customize the To-Do Bar......Page 357 Compose and Send a Message......Page 358 Send a File Attachment......Page 360 Read an Incoming Message......Page 361 Reply To or Forward a Message......Page 362 Add a Sender to Your Outlook Contacts......Page 364 Delete a Message......Page 365 View Conversations......Page 366 Clean Up a Conversation......Page 368 Ignore a Conversation......Page 369 Screen Junk E-mail......Page 370 Create a Message Rule......Page 372 Part VII: Publisher......Page 374 Create a Publication......Page 376 Create a Blank Publication......Page 378 Zoom In and Out......Page 380 Add Text......Page 382 Add a New Text Box......Page 383 Add a Picture to a Publication......Page 384 Change the Font, Size, and Color......Page 386 Apply a Text Effect......Page 390 Change Text Alignment......Page 391 Add a Border......Page 392 Control Text Wrap......Page 393 Link Text Boxes......Page 394 Move and Resize Publication Objects......Page 396 Edit the Background......Page 398 Add a Building Block Object......Page 400 Create a Building Block Object......Page 402 Part VIII: OneNote......Page 404 Navigate OneNote......Page 406 Type and Draw Notes......Page 408 Paste a Picture into OneNote......Page 410 Attach Files to Notes......Page 411 Insert a Screen Clipping......Page 412 Record an Audio Note......Page 414 Create a New Notebook......Page 416 Create a New Section......Page 417 Create a New Page......Page 418 Rename Sections and Pages......Page 420 Group Sections......Page 422 Search Notes......Page 424 E-mail a Notes Page......Page 426 Convert Notes to PDF or XPS Format......Page 427 Index......Page 428 "Are you a visual learner? Do you prefer instructions that show you how to do something--and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 220 Office 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Office 2010 in no time"--Page 4 of cover