Excel 2010 Workbook For Dummies [NOOK Book]

Overview

Get hands-on practice and learn to use all the features of Excel 2010!

Using Excel as nothing more than an electronic version of an accountant's spreadsheet would be like using a super-modified race car just to drive the kids to school. Excel lets you design forms, interact with corporate databases, interpret and present sales figures, and perform dozens of other tasks. The exercises in this workbook let you practice the techniques and learn by doing. Then you can reinforce your...

See more details below
Excel 2010 Workbook For Dummies

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • 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)
$16.49
BN.com price
(Save 45%)$29.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Get hands-on practice and learn to use all the features of Excel 2010!

Using Excel as nothing more than an electronic version of an accountant's spreadsheet would be like using a super-modified race car just to drive the kids to school. Excel lets you design forms, interact with corporate databases, interpret and present sales figures, and perform dozens of other tasks. The exercises in this workbook let you practice the techniques and learn by doing. Then you can reinforce your knowledge by viewing the feature demos of various Excel tasks on the CD.

See how to

  • Create, format, modify, and print spreadsheets

  • Build and use formulas

  • Work with charts and graphics

  • Manage and analyze data

  • Customize Excel with macros and VBA

On the CD, you'll find:

  • Demo files showing you various features of Excel 2010

  • Sample workbook files and completed worksheets for practice exercises

See the CD Appendix for complete system requirements.

  • Practice creating spreadsheets and working with formulas and functions

  • Learn to depict your data with graphics

  • Plan common or complex Excel tasks

  • View feature demos on the CD

Read More Show Less

Product Details

  • ISBN-13: 9780470904763
  • Publisher: Wiley
  • Publication date: 8/13/2010
  • Series: For Dummies Series
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 408
  • Sales rank: 458,431
  • File size: 5 MB

Meet the Author

Greg Harvey, PhD, is an experienced educator and the bestselling author of numerous Excel books.
Read More Show Less

Table of Contents

Introduction.

Part I: Creating Spreadsheets.

Chapter 1: Getting Familiar with the Excel 2010 Interface.

Chapter 2: Entering the Spreadsheet Data.

Chapter 3: Formatting the Spreadsheet.

Chapter 4: Printing Spreadsheet Reports.

Chapter 5: Modifying the Spreadsheet.

Part II: Using Formulas and Functions.

Chapter 6: Building Formulas.

Chapter 7: Copying and Correcting Formulas.

Chapter 8: Creating Date and Time Formulas.

Chapter 9: Financial Formulas and Functions.

Chapter 10: Using Math Functions.

Chapter 11: Using Common Statistical Functions.

Chapter 12: Using Lookup Functions.

Chapter 13: Using Logical Functions.

Chapter 14: Text Formulas and Functions.

Part III: Working with Graphics.

Chapter 15: Charting Spreadsheet Data.

Chapter 16: Adding Graphics to Spreadsheets.

Part IV: Managing and Securing Data.

Chapter 17: Building and Maintaining Data Lists.

Chapter 18: Protecting the Spreadsheet.

Part V: Doing Data Analysis.

Chapter 19: Performing What-If Analysis.

Chapter 20: Generating Pivot Tables.

Part VI: Macros and Visual Basic for Applications.

Chapter 21: Using Macros.

Chapter 22: Using the Visual Basic Editor.

Part VII: The Part of Tens.

Chapter 23: Top Ten Features in Excel 2010.

Chapter 24: Top Ten Tips for Using Excel Like a Pro.

Appendix A: Comparing Worksheets Side by Side.

Appendix B: About the CD.

Appendix C: Table of Exercises.

Index.

Read More Show Less

Customer Reviews

Average Rating 2.5
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(1)

2 Star

(1)

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
Sort by: Showing all of 2 Customer Reviews
  • Posted June 21, 2011

    Read full disclosure before buying, i wouldn't have bought it had i read disclosure first!

    the book is fine but it sucks that i canot get the CD with my NookColor because now i just wasted my money on a book that i, in my opinion, did not get fully. You need the CD to do practice worksheets and now i can't do those!!!!!!!!!!!!!!

    3 out of 3 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 29, 2013

    The ebook doesn't include the CD containing the workbook files n

    The ebook doesn't include the CD containing the workbook files needed to complete the exercises. Unless you already have Exel 2010 you cannot reproduce the information to see how it functions. Argh!

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

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