Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | September 15, 2014

    Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



    There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »

    spacer

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

by

Excel 2000 in a Nutshell: A Power User's Quick Reference (In a Nutshell) Cover

 

Out of Print

Synopses & Reviews

Publisher Comments:

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, andExcel 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.

Synopsis:

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.

Synopsis:

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 easyaccess, providing readers with everything they need to know about the premier spreadsheet application.

About 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.

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;

Product Details

ISBN:
9781565927148
Author:
Simon, Jinjer L.
Publisher:
O'Reilly Media
Author:
Simon, Jinjer L.
Location:
Sebastopol, CA
Subject:
Business
Subject:
Computers
Subject:
Spreadsheets - General
Subject:
Spreadsheets - IBM Compatible
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Spreadsheets.
Subject:
Microsoft Excel
Subject:
Computer Bks - Spreadsheets
Subject:
Computer Books: Spreadsheets
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel 2000;spreadsheets
Copyright:
Edition Number:
1st ed.
Edition Description:
Print PDF
Series:
In a Nutshell (O'Reilly)
Series Volume:
106-796
Publication Date:
20000931
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
608
Dimensions:
9 x 6 x 1.3 in 1.77 lb

Other books you might like

  1. Sams Teach Yourself Microsoft Excel... Used Trade Paper $1.75
  2. Sams Teach Yourself Microsoft... Used Trade Paper $5.95
  3. O'Leary Series: Microsoft Excel 2000... Used Trade Paper $1.75
  4. Spss for Windows Step By Step : a... Used Trade Paper $36.00

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2000 in a Nutshell: A Power User's Quick Reference (In a Nutshell) Used Trade Paper
0 stars - 0 reviews
$2.98 In Stock
Product details 608 pages O'Reilly Media - English 9781565927148 Reviews:
"Synopsis" by ,
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.
"Synopsis" by , 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 easyaccess, providing readers with everything they need to know about the premier spreadsheet application.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.