Excel 2010 Simplified

Overview

Get going with Excel 2010 quickly and easily with this Simplified guide

Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away.

With an easy-to-read design, numbered steps illustrated ...

See more details below
Paperback
$16.54
BN.com price
(Save 33%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (16) from $7.74   
  • New (9) from $13.38   
  • Used (7) from $7.74   

Overview

Get going with Excel 2010 quickly and easily with this Simplified guide

Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away.

With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier than ever before.

  • Excel is the world's leading spreadsheet and data analysis tool; Excel 2010 includes numerous new features, a redesigned interface, a new focus on collaboration and application servers, and much more
  • Its complexity makes Excel a perfect subject for the step-by-step visual instruction in this guide
  • Numbered steps illustrated with full-color screen shots teach dozens of Excel 2010 tasks
  • Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more
  • A quick and easy way to get up to speed on Excel 2010 for both novice users and those upgrading from an earlier version

Excel 2010 Simplified tames this complicated application and gives you the skills to start using Excel with confidence.

Read More Show Less

Product Details

  • ISBN-13: 9780470577639
  • Publisher: Wiley
  • Publication date: 4/26/2010
  • Series: Simplified Series , #16
  • Edition number: 1
  • Pages: 256
  • Sales rank: 386,341
  • Product dimensions: 8.40 (w) x 9.90 (h) x 0.60 (d)

Meet the Author

Paul McFedries is a technical writer who has been authoring computer books since 1991. He has more than 60 books to his credit, which together have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010, Teach Yourself VISUALLY Microsoft Office 2008 for Mac, Excel 2010 Visual Quick Tips, and Excel 2010 PivotTable and PivotCharts Visual Blueprint. Paul also runs Word Spy, a Web site dedicated to tracking new words and phrases (see www.wordspy.com). Please visit Paul's personal Web site at www.mcfedries.com.

Read More Show Less

Table of Contents

1 Working with Excel

Getting to Know Excel 4

Start Excel 6

Tour the Excel Window 8

Work with Excel’s Ribbon 9

Work with Excel’s Galleries 10

Customize the Quick Access Toolbar 12

Customize the Ribbon 14

Work with Smart Tags 16

Change the View 18

Configure Excel Options 20

2 Entering and Editing Excel Data

Learning the Layout of a Worksheet 24

Understanding the Types of Data You Can Use 25

Enter Text into a Cell 26

Enter a Number into a Cell 28

Enter a Date or Time into a Cell 30

Insert a Symbol 32

Edit Cell Data 34

Delete Data from a Cell 36

3 Working with Excel Ranges

Select a Range 40

Fill a Range with the Same Data 42

Fill a Range with a Series of Values 44

Move or Copy a Range 46

Insert a Row or Column 48

Insert a Cell or Range 50

Delete Data from a Range 52

Delete a Range 54

Hide a Row or Column 56

Freeze Rows or Columns 58

Merge Two or More Cells 60

Transpose Rows and Columns 62

4 Working with Range Names

Define a Range Name 66

Use Worksheet Text to Define a Range Name 68

Navigate a Workbook Using Range Names 70

Change a Range Name 72

Delete a Range Name 74

5 Formatting Excel Ranges

Change the Font and Font Size 78

Apply Font Effects 80

Change the Font Color 82

Align Text Within a Cell 84

Center Text Across Multiple Columns 86

Rotate Text Within a Cell 88

Add a Background Color to a Range 90

Apply a Number Format 92

Change the Number of Decimal Places Displayed 94

Apply an AutoFormat to a Range 96

Apply a Conditional Format to a Range 98

Apply a Style to a Range .100

Change the Column Width 102

Change the Row Height 104

Wrap Text Within a Cell 106

Add Borders to a Range 108

6 Building Formulas and Functions

Understanding Excel Formulas 112

Build a Formula 114

Understanding Excel Functions 116

Add a Function to a Formula 118

Add a Row or Column of Numbers 120

Build an AutoSum Formula 122

Add a Range Name to a Formula 124

Reference Another Worksheet Range in a Formula 126

Move or Copy a Formula 128

7 Manipulating Excel Worksheets

Navigate a Worksheet 132

Rename a Worksheet 133

Create a New Worksheet 134

Move a Worksheet 136

Copy a Worksheet 138

Delete a Worksheet 140

Change the Gridline Color 142

Toggle Worksheet Gridlines On and Off 144

Toggle Worksheet Headings On and Off 145

8 Dealing with Excel Workbooks

Create a New Blank Workbook 148

Create a New Workbook from a Template 150

Save a Workbook 152

Open a Workbook 153

Arrange Workbook Windows 154

Find Text in a Workbook 156

Replace Text in a Workbook 158

9 Formatting Excel Workbooks

Modify the Workbook Colors 162

Set the Workbook Fonts 164

Choose Workbook Effects 166

Apply a Workbook Theme 168

10 Analyzing Excel Data

Sort a Range 172

Filter a Range 174

Set Data Validation Rules 176

Convert a Range to a Table 178

Create a Data Table 180

Summarize Data with Subtotals 182

11 Visualizing Data with Excel Charts

Examining Chart Elements 186

Understanding Chart Types 187

Create a Chart 188

Add Chart Titles 190

Add Data Labels 191

Position the Chart Legend 192

Display Chart Gridlines 193

Display a Data Table 194

Change the Chart Layout and Style 195

Select a Different Chart Type 196

12 Formatting Excel Charts

Format Chart Elements 200

Customize a Chart Element Background 202

Set a Chart Element’s Outline 204

Add Effects to a Chart Element 206

Apply a Style to a Chart Element 208

13 Collaborating with Other People

Add a Comment to a Cell 212

Protect a Worksheet’s Data 214

Protect a Workbook’s Structure and Windows 216

Share a Workbook with Other Users 218

Track Workbook Changes 220

Accept or Reject Workbook Changes 222

Send a Workbook as an E-Mail Attachment 224

Save Excel Data as a Web Page 226

Make a Workbook Compatible with Earlier Versions of Excel 228

Collaborate on a Workbook Online 230

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

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

Reminder:

  • - 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)