Easy Microsoft Excel 2010


This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Excel 2010's new features - and, with Easy Microsoft Excel 2010, you'll find exactly what you're looking for. This full-color, utterly simple, step-by-step book has been carefully crafted to provide instant access to the 100+ tasks you'll find most useful and valuable. As with all books in the Easy series, it's designed to teach visually: you never have to work your way through lengthy text ...

See more details below
Other sellers (Paperback)
  • All (10) from $11.66   
  • New (7) from $12.03   
  • Used (3) from $11.65   
Easy Microsoft Excel 2010

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

Want a NOOK? Explore Now

NOOK Book (eBook)
BN.com price
(Save 41%)$17.99 List Price


This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Excel 2010's new features - and, with Easy Microsoft Excel 2010, you'll find exactly what you're looking for. This full-color, utterly simple, step-by-step book has been carefully crafted to provide instant access to the 100+ tasks you'll find most useful and valuable. As with all books in the Easy series, it's designed to teach visually: you never have to work your way through lengthy text explanations. Its large typeface makes it even more accessible to all readers - especially senior readers whose needs are disregarded by most computer books. Written by an experienced Microsoft Excel trainer and author, Easy Microsoft Excel 2010 walks you through the easiest, fastest, most direct procedures for getting the results they're looking for.Coverage includes: getting started fast; managing, viewing, and editing workbooks; formatting data; using formulas, functions, charts, and graphics; analyzing data; printing; and even advanced techniques. Along the way, you will learn how to make the most of many of Excel 2010's most powerful innovations, such as Sparklines and the Excel Web App.

  • 100+ hands-on, step-by-step tasks show novices and inexperienced upgraders the easiest, fastest, most direct way to accomplish common tasks
  • Written by an experienced Microsoft Excel trainer and author
  • Fully revamped for Excel 2010's most powerful new tools and features
  • Large typeface improves readability and appeals to senior readers ignored by most computer books
Read More Show Less

Product Details

  • ISBN-13: 9780789742872
  • Publisher: Que
  • Publication date: 6/29/2010
  • Series: Easy Series
  • Pages: 190
  • Sales rank: 848,299
  • Product dimensions: 7.90 (w) x 9.90 (h) x 0.50 (d)

Meet the Author

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips to the Office community.

Read More Show Less

Table of Contents

Introduction x


The Ribbon User Interface 2

The Anatomy of the Ribbon Interface 3

Familiarizing Yourself with the Ribbon Tabs 4

Understanding Contextual Tabs 6

Understanding Workbooks and Worksheets 7

Customizing the Quick Access Toolbar 8

Adding Commands to the Quick Access Toolbar 9

Adding Hidden Commands to the Quick Access Toolbar 10


Opening an Excel Workbook 14

Closing an Excel Workbook 15

Saving a Workbook 16

Switching Between Open Workbooks 17

Switching Between Worksheets 18

Viewing Multiple Workbooks 19

Inserting and Deleting Worksheets 20

Renaming Worksheets 21

Coloring Worksheet Tabs 22

Moving Worksheets Within a Workbook 23

Copying Worksheets Between Workbooks 24

Password Protect a Workbook 25

Protecting a Worksheet 26


Entering Data 30

Editing and Deleting Existing Data 31

Zooming Into Your Data 32

Undoing and Redoing Changes 33

Copying and Pasting Data 34

Freezing Rows and Columns 36

Splitting a Worksheet 37

Inserting Cells 38

Deleting Cells 39

Inserting and Deleting Rows 40

Inserting and Deleting Columns 41

Moving Data 42

Finding Data 43

Replacing Data 44

Applying a Data Filter 45

Sorting Data 46

Adding and Managing Cell Comments 48


Changing the Font and Font Size 52

Changing Column Width 53

Changing the Color of the Cell Background and Cell Text 54

Formatting the Display of Numeric Data 55

Using a General Format 56

Using a Number Format 57

Using a Currency Format 58

Using a Date Format 59

Using a Text Format 60

Applying Bold, Italic, and Underline 61

Using Merge and Center on Cells 62

Changing Horizontal Data Alignment 63

Changing Row Height 64

Changing Vertical Data Alignment 65

Changing Cell Orientation 66

Wrapping Data in a Cell 67

Changing Borders 68

Indenting Entries in a Cell 69

Clearing Formatting 70

Hiding and Unhiding Rows 71

Hiding and Unhiding Columns 72

Hiding and Unhiding a Worksheet 73

Using Format As Table 74

Copying Formatting 75

Creating and Applying a Formatting Style 76

Using Conditional Formatting 78


Using AutoSum (SUM) 82

Finding a Cell Average (AVERAGE) 83

Finding the Largest Cell Amount (MAX) 84

Finding the Smallest Cell Amount (MIN) 85

Counting the Number of Cells (COUNT) 86

Entering a Formula 87

Editing a Formula or Function 88

Copying a Formula 89

Assigning Names to a Cell or Range 90

Referencing Names in a Function 91

Using Functions Across Worksheets 92

Using Auto-Calculate 94

Finding Functions 95

Calculating a Loan Payment (PMT) 96

Performing a Logical Test Function (IF) 98

Conditionally Summing a Range (SUMIF) 100

Finding the Future Value of an Investment (FV) 102

Fixing the #### Error 104

Fixing the #DIV/0! Error 105

Fixing the #NAME? Error 106

Fixing the #VALUE! Error 107

Recognizing the #REF! Error 108

Recognizing Circular References 109

Checking for Formula References (Precedents) 110

Checking for Cell References (Dependents) 111


The Chart Tools Contextual Tab 113

Creating a Chart 114

Changing the Chart Type 116

Altering the Source Data Range 117

Altering Chart Options 118

Formatting the Plot Area 120

Formatting the Chart Area 121

Formatting the Axis Scale 122

Altering the Original Data 123

Adding Data to Charts 124

Adding a Legend 125


Using Drawing Tools 128

Inserting Clip Art 130

Inserting a Picture from File 131

Using AutoShapes 132

Inserting WordArt 133

Using Smart Art in Excel 134

Inserting a Diagram 135

Inserting an Object 136

Selecting an Object 137

Formatting an Object 138

Moving an Object 139

Resizing an Object 140

Deleting an Object 141


Using Print Preview 144

Setting the Print Area 146

Adjusting Page Margins 148

Inserting Page Breaks 150

Working in Page Break Preview Mode 152

Printing a Worksheet on One Page 154

Printing in Portrait or Landscape Orientation 155

Centering a Worksheet on a Page 156

Printing Gridlines and Row/Column Headers 157

Printing Cell Comments 158

Printing Cell Error Indicators 159

Printing Repeating Row and Column Titles 160

Adding Headers and Footers 161

Printing Worksheets 162


Creating a Pivot Table 166

Rearranging a Pivot Table 168

Refreshing Pivot Table Data 169

Adding a Report Filter 170

Adding Pivot Table Data 172

Changing the Pivot Table Layout 173

Customizing Field Names 174

Applying Numeric Formats to Data Fields 175

Changing Summary Calculations 176

Showing and Hiding Data Items 177

Sorting Your Pivot Table 178



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 & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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 & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)