Office 2010 Simplified


A clear, visual way to learn Office 2010 quickly and easily

If you're looking for a way to get up to speed quickly on the newest version of Microsoft Office, these 400 pages of step-by-step instructions and full-color screen shots make it easy. Office 2010 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified ...

See more details below
$21.93 price
(Save 26%)$29.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (26) from $3.26   
  • New (12) from $9.99   
  • Used (14) from $3.26   


A clear, visual way to learn Office 2010 quickly and easily

If you're looking for a way to get up to speed quickly on the newest version of Microsoft Office, these 400 pages of step-by-step instructions and full-color screen shots make it easy. Office 2010 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach.

This easy-to-follow guide covers Word, Excel, PowerPoint, Outlook, and Publisher. Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites.

  • More than 90 percent of Windows users use Microsoft Office
  • This guide covers all the Office applications: Word, Excel, PowerPoint, Outlook, and Publisher
  • Designed for people who learn best visually, with step-by-step instructions illustrated with full-color screen shots throughout
  • Revamped interior design makes it even easier to find and understand information
  • Teaches dozens of common Office tasks

Office 2010 Simplified makes this technology easy to understand, even for those who are completely new to computers.

Read More Show Less

Product Details

  • ISBN-13: 9780470571941
  • Publisher: Wiley
  • Publication date: 5/24/2010
  • Series: Simplified Series, #15
  • Edition number: 1
  • Pages: 416
  • Sales rank: 361,417
  • Product dimensions: 8.40 (w) x 9.90 (h) x 1.00 (d)

Meet the Author

Freelance writer/editor Kate Shoup has authored 20 books and edited scores more. Recent titles include Windows 7 Digital Classroom, Teach Yourself VISUALLY Outlook 2007, Office 2007: Top 100 Simplified Tips & Tricks, and Internet Visual Quick Tips. When not working, Kate loves to ski (she was once nationally ranked), read, and ride her motorcycle — and she plays a mean game of 9-ball. Kate lives in Indianapolis with her daughter and their dog.

Read More Show Less

Table of Contents

Part I Office Features

1 Office Basics

Start and Exit Office Applications 4

Navigate the Program Windows 6

Work with the Ribbon 8

Customize the Quick Access Toolbar 10

Find Help with Office 12

2 Working with Files

Create a New File 14

Save a File 16

Open a File 18

Print a File 20

Select Data 22

Cut, Copy, and Paste Data 24

View Multiple Files 26

3 Office Graphics Tools

Insert Clip Art 28

Insert a Picture 30

Resize and Move Objects 32

Rotate and Flip Objects 34

Crop a Picture 36

Add a Picture Effect 38

Make Image Corrections 39

Make Color Adjustments 40

Apply Artistic Effects 41

Create a WordArt Object 42

Add SmartArt 44

4 Working with Office Files Online

Create a New Workspace 46

Upload a File to Office Live Workspace 48

Create a New File in Office Live Workspace 50

Edit a File in Office Live Workspace 52

Share a Workspace 54

View Shared Workspaces 56

Delete a File from Office Live Workspace 57

Part II Word

5 Adding Text

Change Word's Views 60

Type and Edit Text 62

Insert Quick Parts 64

Insert Symbols 66

Create a Blog Post 68

6 Formatting Text

Change the Font, Size, and Color 70

Align Text 74

Set Line Spacing 75

Indent Text 76

Set Tabs 78

Set Margins 80

Create Lists 82

Copy Formatting 84

Clear Formatting 85

Format with Styles 86

Apply a Template 88

7 Adding Extra Touches

Assign a Theme 90

Add Borders 92

Create Columns 94

Insert a Table 96

Apply Table Styles 98

Insert an Excel Spreadsheet 99

Add Headers and Footers 100

Insert Footnotes and Endnotes 102

Insert Page Numbers and Page Breaks 104

Mark Index Entries 106

Generate an Index 108

Generate a Table of Contents 110

Create a Bibliography 112

8 Reviewing Documents

Find and Replace Text 114

Scan Document Content 116

Check Spelling and Grammar 118

Work with AutoCorrect 120

Use Word's Thesaurus and Dictionary 122

Translate Text 124

Track and Review Document Changes 126

Compare Documents 128

Insert Comments 130

Part III Excel

9 Building Spreadsheets

Enter Cell Data 134

Select Cells 136

Faster Data Entry with AutoFill 138

Turn On Text Wrapping 140

Center Data Across Columns 141

Adjust Cell Alignment 142

Change the Font and Size 144

Change Number Formats 146

Increase or Decrease Decimals 147

Add Borders 148

Format Data with Styles 150

Apply Conditional Formatting 152

Add Columns and Rows 154

Resize Columns and Rows 156

Freeze a Column or Row 157

Name a Range 158

Delete Data or Cells 160

10 Worksheet Basics

Add a Worksheet 162

Name a Worksheet 163

Change Page Setup Options 164

Move and Copy Worksheets 166

Delete a Worksheet 167

Find and Replace Data 168

Sort Data 170

Filter Data 172

Track and Review Worksheet Changes 174

Insert a Comment 178

11 Working with Formulas and Functions

Understanding Formulas 180

Create a Formula 182

Apply Absolute and Relative Cell References 184

Understanding Functions 186

Apply a Function 188

Total Cells with AutoSum 190

Audit a Worksheet for Errors 192

Add a Watch Window 194

12 Working with Charts

Create a Chart 196

Move and Resize Charts 198

Change the Chart Type 200

Change the Chart Style 201

Change the Chart Layout 202

Add Axis Titles 203

Format Chart Objects 204

Add Gridlines 206

Change the Chart Data 207

Use Sparklines to View Data Trends 208

Part IV PowerPoint

13 Creating a Presentation

Create a Photo Album Presentation 212

Create a Presentation with a Template 214

Build a Blank Presentation 216

Change PowerPoint Views 218

Insert Slides 220

Change the Slide Layout 221

Create a Custom Layout 222

14 Populating Presentation Slides

Add and Edit Slide Text 224

Change the Font, Size, and Color 226

Apply a Theme 230

Set Line Spacing 231

Align Text 232

Add a Text Box to a Slide 233

Add a Table to a Slide 234

Add a Chart to a Slide 236

Add a Picture to a Slide 238

Add a Video Clip to a Slide 240

Move a Slide Object 242

Resize a Slide Object 243

15 Assembling and Presenting a Slide Show

Reorganize Slides 244

Reuse a Slide 246

Define Slide Transitions 248

Add Animation Effects 250

Create a Custom Animation 252

Record Narration 254

Set Up a Slide Show 255

Create Speaker Notes 256

Rehearse a Slide Show 258

Run a Slide Show 260

Package Your Presentation on a CD 262

Part V Access

16 Database Basics

Understanding Database Basics 266

Create a Database Based on a Template 268

Create a Blank Database 270

Create a New Table 272

Change Table Views 274

Add a Field to a Table 276

Delete a Field from a Table 277

Hide a Field in a Table 278

Move a Field in a Table 279

Create a Form 280

Change Form Views 282

Move a Field in a Form 283

Delete a Field in a Form 284

Apply a Database Theme 285

17 Adding, Finding, and Querying Data

Add a Record to a Table 286

Add a Record to a Form 288

Navigate Records in a Form 290

Search for a Record in a Form 291

Delete a Record from a Table 292

Delete a Record from a Form 293

Sort Records 294

Filter Records 296

Apply Conditional Formatting 298

Perform a Simple Query 300

Create a Report 304

Part VI Outlook

18 Organizing with Outlook

View Outlook Components 310

Schedule an Appointment 312

Schedule a Recurring Appointment 314

Schedule an Event 316

Create a New Contact 318

Create a New Task 320

Add a Note 322

Organize Outlook Items 324

Perform an Instant Search 326

Customize the To-Do Bar 327

19 E-mailing with Outlook

Compose and Send a Message 328

Send a File Attachment 330

Read an Incoming Message 331

Reply To or Forward a Message 332

Add a Sender to Your Outlook Contacts 334

Delete a Message 335

View Conversations 336

Clean Up a Conversation 338

Ignore a Conversation 339

Screen Junk E-mail 340

Create a Message Rule 342

Part VII Publisher

20 Publisher Basics

Create a Publication 346

Create a Blank Publication 348

Zoom In and Out 350

Add Text 352

Add a New Text Box 353

Add a Picture to a Publication 354

21 Fine-Tuning a Publication

Change the Font, Size, and Color 356

Apply a Text Effect 360

Change Text Alignment 361

Add a Border 362

Control Text Wrap 363

Link TextBoxes 364

Move and Resize Publication Objects 366

Edit the Background 368

Add a Building Block Object 370

Create a Building Block Object 372

Part VIII OneNote

22 Taking Notes with OneNote

Navigate OneNote 376

Type and Draw Notes 378

Paste a Picture into OneNote 380

Attach Files to Notes 381

Insert a Screen Clipping 382

Record an Audio Note 384

23 Organizing and Sharing Notes

Create a New Notebook 386

Create a New Section 387

Create a New Page 388

Rename Sections and Pages 390

Group Sections 392

Search Notes 394

E-mail a Note Page 396

Convert Notes to PDF or XPS Format 397

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)