BN.com Gift Guide

Excel 2002 Bible

( 1 )

Overview

Microsoft Excel 2002 Bible delivers comprehensive, authoritative coverage of what you need to know about Excel. Learn to go beyond entering data and applying simple formulas. Microsoft Excel 2002 Bible empowers you to tap the enormous potential of Excel. This volume shows how to use Excel effectively on the Internet or intranet. It's an excellent all-in-one reference for anyone who uses Excel, from novices to experts.

Read More Show Less
...
See more details below
Paperback (New Edition)
$31.16
BN.com price
(Save 22%)$39.99 List Price
Other sellers (Paperback)
  • All (24) from $1.99   
  • New (7) from $16.12   
  • Used (17) from $1.99   
Sending request ...

Overview

Microsoft Excel 2002 Bible delivers comprehensive, authoritative coverage of what you need to know about Excel. Learn to go beyond entering data and applying simple formulas. Microsoft Excel 2002 Bible empowers you to tap the enormous potential of Excel. This volume shows how to use Excel effectively on the Internet or intranet. It's an excellent all-in-one reference for anyone who uses Excel, from novices to experts.

Read More Show Less

Product Details

  • ISBN-13: 9780764535833
  • Publisher: Wiley
  • Publication date: 1/28/2001
  • Series: Bible Series , #135
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 984
  • Product dimensions: 7.30 (w) x 9.20 (h) x 2.07 (d)

Meet the Author

About the Author John Walkenbach is the author of more than two dozen spreadsheet books. Visit his Web site at http://www.j-walk.com. Brian Underdahl is the well-known, best-selling author of nearly 60 computer books including several current titles from Hungry Minds: Pocket PCs For Dummies, Internet Bible, 2nd Edition, Teach Yourself Windows 2000 Professional, and Teach Yourself Office XP. Brian spends most of his time at the keyboard writing about personal computing. When he finds the time, he enjoys taking in the view from the home he and his wife Darlene built in the mountains 2,000 feet above Reno, Nevada. He tries to find the time to attend Mensa meetings whenever possible, and has become a fairly decent gourmet cook in recent years, too.

Read More Show Less

Table of Contents

Preface.

Quick Start: Getting Acquainted with Excel.

PART I: Getting Started with Excel.

Chapter 1: Entering and Editing Worksheet Data.

Chapter 2: Essential Spreadsheet Operations.

Chapter 3: Printing Your Work.

Chapter 4: Working with Cell Ranges.

Chapter 5: Worksheet Formatting.

Chapter 6: Using and Creating Templates.

PART II: Working with Formulas and Functions.

Chapter 7: Creating and Using Formulas.

Chapter 8: Using Worksheet Functions.

Chapter 9: Using Functions and Formulas to Manipulate Text.

Chapter 10: Working with Dates, Times, and Related Functions.

Chapter 11: Creating Formulas That Count and Sum.

Chapter 12: Creating Formulas That Look Up Values.

PART III: Enhancing Your Excel Workbooks.

Chapter 13: Getting Started Making Charts.

Chapter 14: Learning Some Advanced Charting.

Chapter 15: Enhancing Your Work with Pictures and Drawings.

Chapter 16: Introducing Arrays.

Chapter 17: Performing Magic with Array Formulas.

PART IV: Analyzing Data with Excel.

Chapter 18: Importing Data From Other Sources.

Chapter 19: Working with Lists.

Chapter 20: Using External Database Files.

Chapter 21: Analyzing Data with Pivot Tables.

Chapter 22: Performing Spreadsheet What-If Analysis.

Chapter 23: Analyzing Data Using Goal Seeking and Solver.

Chapter 24: Analyzing Data with Analysis ToolPak.

PART V: Using Advanced Excel Features.

Chapter 25: Creating and Using Worksheet Outlines.

Chapter 26: Linking and Consolidating Worksheets.

Chapter 27: Customizing Toolbars and Menus.

Chapter 28: Excel and the Internet.

Chapter 29: Using Excel in a Workgroup.

Chapter 30: Sharing Data with Other Applications.

Chapter 31: Making Your Worksheets Error-Free.

PART VI: Programming Excel with VBA.

Chapter 32: Introducing Visual Basic for Applications.

Chapter 33: VBA Programming Fundamentals.

Chapter 34: Working with VBA Sub Procedures.

Chapter 35: Creating Custom Worksheet Functions.

Chapter 36: Introducing UserForms.

Chapter 37: UserForm Techniques.

Chapter 38: Working with Excel's Events.

Chapter 39: Creating Custom Excel Add-Ins.

Chapter 40: Creating Custom Toolbars.

Chapter 41: Creating Custom Menus.

Appendix: Worksheet Function Reference.

Index.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

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

    Posted March 28, 2003

    Great book

    Excellent and comprehensive

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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