Picture yourself learning Microsoft Office 2010: step-by-step

✍ Scribed by Koers, Diane

• Publisher: Course Technology; Delmar
• Year: 2010
• Tongue: English
• Leaves: 513
• Series: @Picture yourself learning
• Category: Library

✦ Synopsis

Featured in the four-color, visual Picture Yourself series, PICTURE YOURSELF LEARNING MICROSOFT OFFICE 2010 is a valuable resource for all readers, beginner to intermediate. Clear, step-by-step instructions walk you through the basics of each application from beginning to end. Helpful tips provide additional information and advice to enhance your Office 2010 experience and help meet your needs. PICTURE YOURSELF LEARNING MICROSOFT OFFICE 2010 is packed with information useful to those who have purchased their first computer and are learning Office 2010 for the first time. Those who have experience with older versions of Office will find this book an excellent way to help them get up to speed on their computing experience, by way of the over 1,000 screenshots to guide your way. You have the option of reading the book from cover to cover, or simply reading the individual programs you are interested in.

✦ Table of Contents

Table of Contents......Page 7
Introduction......Page 13
Part I: Getting Started......Page 16
Chapter 1 Discovering Office Common Features......Page 18
Opening Office Programs......Page 19
Exploring the Backstage View......Page 23
Working with Files......Page 24
Previewing with Live Preview......Page 30
Customizing Applications......Page 31
Part II: Word......Page 34
Chapter 2 Getting Started with Word......Page 36
Exploring the Word Window......Page 37
Moving Around the Screen......Page 38
Editing Text......Page 40
Moving and Copying Text......Page 45
Using Undo and Repeat......Page 49
Displaying Non-Printing Symbols......Page 50
Chapter 3 Making a Word Document Look Good......Page 52
Selecting Text Attributes......Page 53
Formatting Paragraphs......Page 60
Copying Formatting......Page 68
Working with Lists......Page 69
Working with Themes......Page 70
Using Quick Styles......Page 71
Chapter 4 Managing Word Pages......Page 74
Creating Page Breaks......Page 75
Using Section Breaks......Page 76
Managing Page Layouts......Page 77
Viewing a Document......Page 80
Adding Headers and Footers......Page 86
Chapter 5 Working with Columns and Tables......Page 90
Using Columns......Page 91
Working with Tables......Page 93
Adding an Excel Table to a Word Document......Page 105
Chapter 6 Using Word for Mail Merge......Page 108
Generating a Single Envelope......Page 109
Creating Labels......Page 112
Using Mail Merge......Page 114
Chapter 7 Discovering Word Tools......Page 122
Employing Tools for Quality......Page 123
Applying Tools for Speed......Page 132
Creating Footnotes and Endnotes......Page 140
Working with Outlines......Page 143
Keeping Documents Secure......Page 146
Printing and Publishing......Page 151
Part III: Excel......Page 154
Chapter 8 Creating a Basic Worksheet......Page 156
Exploring the Excel Window......Page 157
Entering Excel Data......Page 160
Learning Selection Techniques......Page 164
Editing a Worksheet......Page 166
Working with Range Names......Page 171
Using Data Validation......Page 174
Chapter 9 Working with Formulas and Functions......Page 178
Working with Formulas......Page 179
Using Excel Functions......Page 183
Troubleshooting Errors......Page 194
Chapter 10 Making Your Worksheet Look Good......Page 198
Changing Cell Formats......Page 199
Working with Alignment and Spacing......Page 204
Adding Borders and Shading......Page 211
Discovering Formatting Shortcuts......Page 213
Conditional Formatting......Page 216
Chapter 11 Managing Large Amounts of Data......Page 220
Working with Multiple Worksheets......Page 221
Managing Worksheet Views......Page 229
Sorting Data......Page 233
Filtering Data......Page 238
Chapter 12 Setting Security and Printing Options......Page 248
Keeping Workbooks Secure......Page 249
Checking for Errors......Page 254
Using Find and Replace......Page 256
Adjusting Page Layout......Page 258
Working with Headers and Footers......Page 263
Printing Your Worksheet......Page 266
Chapter 13 Generating Excel Charts......Page 270
Creating a Basic Chart......Page 271
Inserting a Chart......Page 273
Changing the Chart Options......Page 275
Working with Sparklines......Page 287
Part IV: PowerPoint......Page 292
Chapter 14 Creating a PowerPoint Presentation......Page 294
Starting with the PowerPoint Basics......Page 295
Adding New Slides......Page 298
Adding Slide Objects......Page 302
Working with Outlines......Page 313
Chapter 15 Editing Your Presentation......Page 316
Changing Views......Page 317
Modifying Slide Layouts......Page 320
Adding Multimedia and WordArt to Your Presentation......Page 321
Managing Objects......Page 327
Chapter 16 Formatting Your Presentation......Page 336
Changing Views......Page 337
Changing Theme Options......Page 338
Working with Slide Masters......Page 341
Creating Speaker Notes......Page 346
Finishing Your Presentation......Page 347
Chapter 17 Presenting Your Presentation......Page 352
Adding Transitions and Animations......Page 353
Running Your Presentation......Page 359
Part V: Access......Page 364
Chapter 18 Creating an Access Database......Page 366
Understanding Database Terms......Page 367
Exploring Access......Page 368
Creating a New Database......Page 371
Working with Records......Page 376
Chapter 19 Modifying an Access Database......Page 386
Designing Table Appearance......Page 387
Modifying Table Structure......Page 391
Modifying a Form......Page 398
Part VI: Outlook......Page 404
Chapter 20 Communicating with Outllook E-Mail......Page 406
Looking at the Outlook Window......Page 407
Working with E-Mail......Page 408
Working with E-Mail Attachments......Page 416
Chapter 21 Working with Outlook Contacts......Page 422
Exploring Your Contacts Folder......Page 423
Printing Contact Information......Page 433
Chapter 22 Using the Outlook Calendar......Page 436
Exploring the Calendar......Page 437
Working in the Calendar Folder......Page 440
Chapter 23 Tracking Tasks with Outlook......Page 448
Working with Tasks......Page 449
Exploring To-Do’s......Page 455
Creating Notes......Page 457
Using the To-Do Bar......Page 458
Part VII: Publisher......Page 460
Chapter 24 Creating a Predesigned Publisher Publication......Page 462
Selecting a Publication Template......Page 463
Viewing the Publisher Window......Page 464
Customizing Your Publication......Page 467
Presenting View Options......Page 469
Working with Text......Page 472
Working with Graphics......Page 478
Chapter 25 Designing Your Own Publication......Page 480
Starting Your Publication......Page 481
Working with Frames......Page 483
Working with Text......Page 490
Working with Pages......Page 494
Preparing for Printing......Page 497
C......Page 502
D......Page 503
E......Page 504
F......Page 505
I......Page 506
O......Page 507
P......Page 508
R......Page 509
T......Page 510
W–Z......Page 512