Book description
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.
Table of contents
-
Excel 2000 in a Nutshell
- Preface
- I. Excel 2000 Overview
-
II. Menu Reference
- 3. File
- 4. Edit
- 5. View
- 6. Insert
- 7. Format
-
8. Tools
- Tools → Spelling
- Tools → AutoCorrect
- Tools → AutoSave
- Tools → Share Workbook
- Tools → Track Changes
- Tools → Merge Workbooks
- Tools → Protection
- Tools → Online Collaboration
- Tools → Goal Seek
- Tools → Scenarios
- Tools → Auditing
- Tools → Solver
- Tools → Macro
- Tools → Add-Ins
- Tools → Customize
- Tools → Options
- Tools → Wizard
- Tools → Data Analysis
- Tools → Update Add-In Links
- 9. Data
- 10. Chart
-
III. Function Reference
- 11. Working with Functions
-
12. Financial Functions
- Understanding the Financial Jargon
-
The Financial Functions
-
Recurring Arguments
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
Recurring Arguments
- 13. Date and Time Functions
-
14. Mathematics and Trigonometry Functions
-
Understanding Math Lingo
-
The Math and Trigonometric Functions
- ABS
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CEILING
- COMBIN
- COS
- COSH
- DEGREES
- EVEN
- EXP
- FACT
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- Roman
- ROUND
- ROUNDDOWN
- ROUNDUP
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
-
The Math and Trigonometric Functions
-
Understanding Math Lingo
-
15. Statistical Functions
- Common Statistical Terminology
-
The Statistical Functions
-
Recurring Arguments
- AVEDEV
- AVERAGE
- AVERAGEA
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FISHER
- FINSHERINV
- FORECAST
- FREQUENCY
- FTEST
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- RSQ
- SKEW
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
-
Recurring Arguments
- 16. Lookup and Reference Functions
- 17. Database Functions
- 18. Text Functions
- 19. Logical Functions
- 20. Information Functions
- IV. Appendices
- Index
- Colophon
Product information
- Title: Excel 2000 in a Nutshell
- Author(s):
- Release date: August 2000
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565927148
You might also like
book
Excel 2003: The Missing Manual
Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an …
book
Excel 2013: The Missing Manual
The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more …
book
Excel Annoyances
It's the solution to almost all of your electronic organization needs. Need to present a detailed …
book
Formulas and Functions with Microsoft® Excel 2003
The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating …