Microsoft Office Professional 2010 Step by Step


Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to:...

See more details below
$33.44 price
(Save 25%)$44.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (20) from $6.90   
  • New (12) from $26.81   
  • Used (8) from $6.90   
Microsoft Office Professional 2010 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99 price
(Save 44%)$35.99 List Price


Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to:

  • Create attractive documents, publications, and spreadsheets
  • Manage your e-mail, calendar, meetings, and communications
  • Put your business data to work
  • Develop and deliver great presentations
  • Organize your ideas and notes in one place
  • Connect, share, and accomplish more when working together"
Read More Show Less

Product Details

  • ISBN-13: 9780735626966
  • Publisher: Microsoft Press
  • Publication date: 9/12/2010
  • Pages: 1072
  • Sales rank: 379,090
  • Product dimensions: 7.40 (w) x 8.90 (h) x 1.60 (d)

Meet the Author

Curtis D. Frye is the author of several books on Access and Excel, including MICROSOFT OFFICE EXCEL 2007 STEP BY STEP, along with numerous online training courses.

Read More Show Less

Table of Contents

Introducing Microsoft Office Professional 2010

Modifying the Display of the Ribbon

Features and Conventions of this Book

Using the Practice Files

Getting Help

Part 1 Microsoft Office Professional 2010

1 Explore Office 2010 3

Working in the Program Environment 4

Changing Program Settings 17

Customizing the Ribbon 26

Customizing the Quick Access Toolbar 31

Key Points 35

2 Work with Files 37

Creating and Saving Files 38

Sidebar: File Compatibility with Earlier Versions of Office Programs 44

Opening, Moving Around in, and Closing Files 46

Viewing Files in Different Ways 52

Key Points 60

Part 2 Microsoft Word 2010

3 Edit and Proofread Text 63

Making Text Changes 64

Sidebar: About the Clipboard 72

Finding and Replacing Text 73

Fine-Tuning Text 79

Correcting Spelling and Grammatical Errors 87

Sidebar: Viewing Document Statistics 93

Inserting Saved Text 93

Sidebar: Inserting One Document into Another 97

Key Points 97

4 Change the Look of Text 99

Quickly Formatting Text 100

Changing a Document's Theme 106

Manually Changing the Look of Characters 111

Sidebar: Character Formatting and Case Considerations 119

Manually Changing the Look of Paragraphs 119

Sidebar: Finding and Replacing Formatting 130

Creating and Modifying Lists 130

Sidebar: Formatting Text as You Type 136

Key Points 137

5 Organize Information in Columns and Tables 139

Presenting Information in Columns 140

Creating Tabbed Lists 147

Presenting Information in Tables 149

Sidebar: Performing Calculations in Tables 158

Sidebar: Other Layout Options 159

Formatting Tables 160

Sidebar: Quick Tables 164

Key Points 165

6 Add Simple Graphic Elements 167

Inserting and Modifying Pictures 168

Sidebar: About Clip Art 174

Changing a Document's Background 176

Inserting Building Blocks 183

Sidebar: Drawing Text Boxes 196

Adding WordArt Text 197

Sidebar: Formatting the First Letter of a Paragraph 202

Key Points 203

7 Preview, Print, and Distribute Documents 205

Previewing and Adjusting Page Layout 206

Controlling What Appears on Each Page 212

Printing Documents 217

Preparing Documents for Electronic Distribution 219

Key Points 224

Part 3 Microsoft Excel 2010

8 Set Up a Workbook 227

Creating Workbooks 228

Modifying Workbooks 233

Modifying Worksheets 237

Customizing the Excel 2010 Program Window 241

Zooming in on a Worksheet 242

Arranging Multiple Workbook Windows 243

Adding Buttons to the Quick Access Toolbar 244

Customizing the Ribbon 246

Maximizing Usable Space in the Program Window 249

Key Points 253

9 Work with Data and Excel Tables 255

Entering and Revising Data 256

Moving Data Within a Workbook 260

Finding and Replacing Data 264

Correcting and Expanding Upon Worksheet Data 269

Defining Excel Tables 274

Key Points 279

10 Perform Calculations on Data 281

Naming Groups of Data 282

Creating Formulas to Calculate Values 286

Summarizing Data That Meets Specific Conditions 296

Finding and Correcting Errors in Calculations 300

Key Points 307

11 Change Workbook Appearance 309

Formatting Cells 310

Defining Styles 316

Applying Workbook Themes and Excel Table Styles 320

Making Numbers Easier to Read 327

Changing the Appearance of Data Based on its Value 332

Adding Images to Worksheets 339

Key Points 345

12 Focus on Specific Data by Using Filters 347

Limiting Data That Appears on Your Screen 348

Manipulating Worksheet Data 354

Selecting List Rows at Random 354

Summarizing Worksheets with Hidden and Filtered Rows 355

Finding Unique Values Within a Data Set 358

Defining Valid Sets of Values for Ranges of Cells 361

Key Points 367

Part 4 Microsoft PowerPoint 2010

13 Work with Slides 371

Adding and Deleting Slides 371

Adding Slides with Ready-Made Content 374

Sidebar: Working with Slide Libraries 379

Sidebar: Exporting Presentations as Outlines 380

Dividing Presentations into Sections 380

Rearranging Slides and Sections 384

Key Points 387

14 Work with Slide Text 389

Entering Text in Placeholders 390

Adding Text Boxes 393

Sidebar: Changing the Default Font for Text Boxes 400

Editing Text 400

Sidebar: About the Clipboard 405

Correcting and Sizing Text While Typing 406

Checking Spelling and Choosing the Best Words 412

Sidebar: Researching Information and Translating Text 417

Finding and Replacing Text and Fonts 418

Key Points 421

15 Format Slides 423

Applying Themes 423

Using Different Color and Font Schemes 426

Changing the Slide Background 429

Changing the Look of Placeholders 433

Changing the Alignment, Spacing, Size, and Look of Text 437

Sidebar: Non-Color Scheme Colors 444

Key Points 445

16 Add Simple Visual Enhancements 447

Inserting Pictures and Clip Art Images 448

Inserting Diagrams 454

Sidebar: Graphic Formats 455

Sidebar: Converting Existing Bullet Points into Diagrams 462

Inserting Charts 462

Drawing Shapes 470

Sidebar: Connecting Shapes 478

Adding Transitions 479

Key Points 483

17 Review and Deliver Presentations 485

Setting Up Presentations for Delivery 486

Previewing and Printing Presentations 491

Preparing Speaker Notes and Handouts 495

Sidebar: Enhanced Handouts 501

Finalizing Presentations 502

Sidebar: Setting Up Presenter View 508

Delivering Presentations 509

Key Points 512

Part 5 Microsoft OneNote 2010

18 Explore OneNote 2010 515

Navigating in the OneNote Program Window 516

Sidebar: Working with Multiple Notebooks 518

Working in the OneNote Program Window 519

Working from the Ribbon and Quick Access Toolbar 519

Working in the Backstage View 522

Exploring OneNote in the Default Notebook 526

Customizing OneNote 535

Key Points 537

19 Create and Configure Notebooks 539

Creating a Notebook for Use by One Person 540

Creating a Notebook for Use by Multiple People 543

Sharing a New or Existing Notebook 544

Managing a Shared Notebook 548

Creating Sections and Pages 550

Creating Pages and Subpages 551

Naming Sections and Pages 554

Creating Sections and Section Groups 555

Key Points 561

20 Create and Organize Notes 563

Working with Note Containers 564

Entering Content Directly onto a Page 565

Referencing External Files 565

Creating Handwritten Notes 567

Inserting Images 568

Formatting Notes, Pages, and Sections 569

Sidebar: Tagging Content 578

Sending Content to OneNote 579

Collecting Screen Clippings 581

Collecting Web Notes 583

Sidebar: Inserting the Date and Time 584

Capturing Audio and Video Notes 585

Sidebar: Missing the OneNote Icon? 590

Taking Notes on the Side 591

Sidebar: Collecting Information Outside of OneNote 593

Key Points 594

Part 6 Microsoft Outlook 2010

21 Send and Receive E-Mail Messages 597

Creating and Sending Messages 598

Addressing Messages 599

Troubleshooting Message Addressing 601

Entering Content 603

Saving and Sending Messages 604

Sidebar: Managing Multiple Accounts 614

Attaching Files to Messages 615

Sidebar: Troubleshooting File Types and Extensions 617

Viewing Messages and Message Attachments 618

Sidebar: Viewing Conversations 627

Configuring Reading Pane Behavior 627

Viewing Reading Pane Content 627

Marking Messages as Read 628

Single Key Reading 629

Viewing Message Participant information 630

Presence Icons 630

Contact Cards 630

The People Pane 632

Sidebar: Troubleshooting the People Pane 633

Responding to Messages 634

Key Points 640

Sidebar: Resending and Recalling Messages 641

22 Store and Access Contact Information 643

Saving and Updating Contact Information 644

Creating Contact Records 645

Address Books 646

Sidebar: Dialing Rules 648

Sidebar: Conformaing to Address Standards 656

Communicating with Contacts 656

Initiating Communication from Contact Records 657

Selecting Message Recipients from Address Books 658

Displaying Different Views of Contact Records 659

Sidebar: User-Defined Fields 666

Printing Contact Records 667

Key Points 676

23 Manage Scheduling 679

Scheduling and Changing Appointments 680

Sidebar: Adding National Holidays to Your Calendar 686

Sidebar: Creating an Appointment from a Message 688

Scheduling and Changing Events 689

Scheduling Meetings 691

Sidebar: Updating and Canceling Meetings 697

Responding to Meeting Requests 698

Displaying Different Views of a Calendar 701

Views 701

Arrangements 701

Using the Date Navigator 703

Key Points 712

24 Track Tasks 715

Creating Tasks 716

Creating Tasks from Scratch 716

Task Options 717

Creating Tasks from Outlook Items 718

Updating Tasks 726

Removing Tasks and Items from Task Lists 729

Managing Task Assignments 730

Tasks You Assign to Others 730

Tasks Other People Assign to You 732

Displaying Different Views of Tasks 735

Sidebar: Finding and Organizing Tasks 742

Key Points 743

Part 7 Microsoft Access 2010

25 Explore an Access 2010 Database 747

Working in Access 2010 748

Sidebar: Enabling Macros and Other Database Content 758

Understanding Database Concepts 760

Exploring Tables 761

Sidebar: Tabbed Pages vs. Overlapping Windows 766

Exploring Forms 768

Exploring Queries 773

Exploring Reports 777

Previewing and printing Access Objects 782

Key Points 787

26 Create Databases and Simple Tables 789

Creating Databases from Templates 790

Sidebar: Web Databases 795

Creating Databases and Tables Manually 796

Sidebar: Database Design 804

Manipulating Table Columns and Rows 805

Refining Table Structure 808

Creating Relationships Between Tables 813

Key Points 819

27 Create Simple Forms 821

Creating Forms by Using the Form Tool 822

Changing the Look of Forms 829

Changing the Arrangement of Forms 837

Key Points 843

28 Display Data 845

Sorting Information in Tables 846

Sidebar: How Access Sorts 850

Filtering Information in Tables 851

Filtering Information by Using Forms 855

Sidebar: Wildcards 859

Locating Information That Matches Multiple Criteria 859

Sidebar: Generating Reports 863

Key Points 864

Part 8 Microsoft Publisher 2010

29 Get Started with Publisher 2010 867

Starting New Publications 868

Using Templates 869

Sidebar: Custom Templates 870

Importing Word Documents 871

Storing Personal and Company Information 879

Previewing and Printing Publications 887

Checking Publications 888

Working with Advanced Printer Settings 888

Key Points 897

30 Create Visual Interest 899

Working with Text Boxes 900

Manipulating Text Boxes 900

Formatting Text for Visual Impact 901

Working with WordArt 908

Working with Graphics 919

Working with Shapes 931

Manipulating Shapes 931

Connecting and Grouping Shapes 932

Working with Ready-Made Visual Elements 940

Key Points 947

31 Create Colorful Cards and Calendars 949

Creating Folded Cards 950

Choosing a Design or Layout 950

Changing the Color Scheme 951

Using Non-Color-Scheme Colors 952

Choosing Text 952

Creating Postcards 963

Using Mail Merge 963

Using Catalog Merge 964

Creating Calendars 974

Adding Captions, Credits, and Copyrights 974

Changing Page Backgrounds 975

Working with Master Pages 975

Key Points 984

Index 985

About the Authors 1032

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)