Excel 2000 in a Nutshell: A Power User's Quick Reference

Overview

By virtue of the estimated 20-million-strong installed base of Microsoft Office users, Excel has become the de facto standard for spreadsheet applications. A powerful application needs powerful documentation, and
Excel 2000 in a Nutshell, a detailed reference to every one of Excel's menu options and functions, is the key to unlocking Excel's many capabilities. The book's feature-based format means users can find what they're looking for quickly...

See more details below
Paperback
$22.83
BN.com price
(Save 23%)$29.95 List Price
Other sellers (Paperback)
  • All (21) from $1.99   
  • New (5) from $11.19   
  • Used (16) from $1.99   
Sending request ...

Overview

By virtue of the estimated 20-million-strong installed base of Microsoft Office users, Excel has become the de facto standard for spreadsheet applications. A powerful application needs powerful documentation, and
Excel 2000 in a Nutshell, a detailed reference to every one of Excel's menu options and functions, is the key to unlocking Excel's many capabilities. The book's feature-based format means users can find what they're looking for quickly without having to spend extra time searching the index.

Written for intermediate and advanced users, this book is divided into three main sections. The first section introduces Excel basics, such as creating and formatting worksheets and formulas, and surveys the new features of Excel 2000. It also includes a chapter on the anatomy of Excel that dissects everything from cells to toolbars.

The second section details each Excel Menu option, from the Chart Menu to the File Menu to the Tools Menu. This section is the place to find handy tips for accessing the full power of Excel 2000's many options.

The third section deals with Excel Functions, organized in an easy and accessible grouping by categories such as Financial, Date and Time, Statistical, and Database Functions. Topics in this section include:

  • How to use the NetWorkedDays function, which calculates workdays, to determine accrued vacation time
  • Performing financial calculations to determine depreciation of an asset
  • The many functions included in the Analysis ToolPak that comes with Excel 2000

Excel 2000 in a Nutshell is a one-stop reference to Excel for both professional and home users. In typical Nutshell fashion, information is organized for quick and easy access, providing readers with everything they need to know about the premier spreadsheet application.

This one-stop reference combines the in-a-nutshell approach with detailed comprehensive information, providing readers with everything they need to know about the premier spreadsheet application. Throughout the book, readers will find handy tips to help make better power use of the many new features available in Excel 2000.

Read More Show Less

Product Details

  • ISBN-13: 9781565927148
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 9/28/2000
  • Series: In a Nutshell (O'Reilly) Series
  • Pages: 608
  • Product dimensions: 6.01 (w) x 8.95 (h) x 1.30 (d)

Meet the Author

Jinjer Simon has been actively involved in the computer industry as a web site developer, end user trainer, and developer of online documentation for the past 15 years. She has written numerous books, including Visual Basic Scripting SuperBible from Waite Group Press, and Windows CE for Dummies from IDG Press. Jinjer lives in a suburb of Dallas, Texas, with her husband and two children. In her spare time she likes to play golf and scuba dive.

Read More Show Less

Table of Contents

Preface;
Organization of This Book;
Conventions Used in This Book;
How to Contact Us;
Microsoft Office 2000 Service Releases;
Acknowledgments;
Excel 2000 Overview;
Chapter 1: Excel Basics;
1.1 Installing Excel 2000;
1.2 Opening Excel;
1.3 Excel Menus and Shortcuts;
Chapter 2: Excel Anatomy;
2.1 The Excel Window;
2.2 The External Side of Excel;
2.3 Using Styles;
2.4 Customizing in Excel;
Menu Reference;
Chapter 3: File;
3.1 Microsoft Excel Files;
Chapter 4: Edit;
4.1 Windows Clipboard Versus Office Clipboard;
Chapter 5: View;
Chapter 6: Insert;
6.1 Insert → Cells;
6.2 Insert → Rows;
6.3 Insert → Columns;
6.4 Insert → Worksheet;
6.5 Insert → Chart;
6.6 Insert → Page Break;
6.7 Insert → Function;
6.8 Insert → Name;
6.9 Insert → Comment;
6.10 Insert → Picture;
6.11 Insert → Object;
6.12 Insert → Hyperlink;
6.13 Some Hyperlink Tips;
Chapter 7: Format;
Chapter 8: Tools;
Chapter 9: Data;
Chapter 10: Chart;
10.1 Column Charts;
Function Reference;
Chapter 11: Working with Functions;
11.1 Function or Formula?;
11.2 Function Categories;
11.3 Function Arguments;
11.4 Inserting a Function;
Chapter 12: Financial Functions;
12.1 Understanding the Financial Jargon;
12.2 The Financial Functions;
Chapter 13: Date and Time Functions;
13.1 How Excel Stores Dates and Times;
Chapter 14: Mathematics and Trigonometry Functions;
14.1 Understanding Math Lingo;
Chapter 15: Statistical Functions;
15.1 Common Statistical Terminology;
15.2 The Statistical Functions;
Chapter 16: Lookup and Reference Functions;
16.1 The Lookup and Reference Functions;
Chapter 17: Database Functions;
17.1 The Database Functions;
Chapter 18: Text Functions;
18.1 The Text Functions;
Chapter 19: Logical Functions;
19.1 The Logical Functions;
Chapter 20: Information Functions;
20.1 The Information Functions;
Appendices;
Keyboard Shortcuts;
Tip Reference;
Colophon;

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)