Excel 2007 Workbook for Dummies

( 7 )

Overview

From formulas to functions to the latest features - practice and plan Excel tasks with ease

Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 ...

See more details below
Paperback (REV)
$18.85
BN.com price
(Save 24%)$24.99 List Price
Other sellers (Paperback)
  • All (28) from $1.99   
  • New (14) from $5.48   
  • Used (14) from $1.99   
Sending request ...

Overview

From formulas to functions to the latest features - practice and plan Excel tasks with ease

Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 walk-throughs of Excel features on the CD-ROM. Plus, you get full coverage of all the new and enhanced features of Excel 2007!

See how to

* Set up, format, and edit basic spreadsheets
*

Manage and secure your Excel data
*

Create formulas and functions for finance, date and time, math, text, and more
*

Master data analysis with pivot tables
*

Save and share your spreadsheet data

Quick refresher explanations

Step-by-step procedures

Hands-on practice exercises

Tear-out Cheat Sheet

A dash of humor and fun

All this on the bonus CD-ROM

* Dynamic video walk-throughs demonstrate Excel features and tasks
*

Practice files let you work through the exercises in the book

For details and complete system requirements, see the CD-ROM appendix.

Read More Show Less

Product Details

  • ISBN-13: 9780470169377
  • Publisher: Wiley
  • Publication date: 9/4/2007
  • Series: For Dummies Series
  • Edition description: REV
  • Edition number: 2
  • Pages: 408
  • Sales rank: 483,742
  • Product dimensions: 9.98 (w) x 7.96 (h) x 0.86 (d)

Meet the Author

Greg Harvey, PhD, is president of Mind Over Media, Inc. and an experienced trainer and teacher who has written numerous books on Excel.

Read More Show Less

Table of Contents

Introduction.

Part I: Creating Spreadsheets.

Chapter 1: Getting Familiar with the Excel 2007 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 2007.

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

Appendix: About the CD.

Index.

Read More Show Less

Customer Reviews

Average Rating 4.5
( 7 )
Rating Distribution

5 Star

(5)

4 Star

(0)

3 Star

(2)

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
Sort by: Showing all of 7 Customer Reviews
  • Anonymous

    Posted October 27, 2008

    Microsoft Excel 2007 For Dummies

    Microsoft Excel 2007 for Dummies is a great program for people who want to learn more about Microsoft Excel. IT has projects for you to do and it has a CD in the back for the answers. It a great book.

    2 out of 2 people found this review helpful.

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

    Posted June 30, 2009

    No text was provided for this review.

  • Anonymous

    Posted June 17, 2010

    No text was provided for this review.

  • Anonymous

    Posted April 8, 2010

    No text was provided for this review.

  • Anonymous

    Posted January 2, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 5, 2009

    No text was provided for this review.

  • Anonymous

    Posted June 14, 2010

    No text was provided for this review.

Sort by: Showing all of 7 Customer Reviews

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