Home > Store

Microsoft Excel 2000 Functions in Practice

Register your product to gain access to bonus material or receive a coupon.

Microsoft Excel 2000 Functions in Practice

Book

  • This product currently is not for sale.
Not for Sale

Description

  • Copyright 1999
  • Dimensions: 7.375 X 9.125
  • Pages: 350
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-2045-0
  • ISBN-13: 978-0-7897-2045-0

The Microsoft Excel 2000 Functions in Practice provides in-depth information on the functions that will maximize your use of the analytical tools within Excel 2000. Packed with examples and detailed insight into both the functions and their uses, this reference includes more than just discussions of the functions—it offers practical, real-world usage of them with chapters on crucial topics such as using Excel's functions in your job, database and list-management functions, date and time functions, engineering functions, financial functions, information and logical functions, lookup and reference functions, math and trigonometry functions, and statistical and text functions.

Sample Content

Online Sample Chapters

Database and List Management Functions

Excel 2000 Database Functions Overview

Table of Contents

1. Functions Overview.
Function Fundamentals. Database- and List-Management Functions. Date and Time Functions. DDE and External Functions. Engineering Functions. Financial Functions. Information Functions. Logical Functions. Lookup and Reference Functions. Math and Trigonometry Functions. Statistical Functions. Text Functions.

2. Managing Your Business with Functions.
An Overview. Using Functions for Lookup and Reference, Math, and Trigonometry. Working with Date and Time. Computing Statistics. Generating Financial Results. Producing Logical and Informational Data. Working with Text. Important Tools for Any Business.

3. Database- and List-Management Functions.
Database Functions Overview. General DFUNCTION Syntax. DAVERAGE. DCOUNT. DCOUNTA. DGET. DMAX. DMIN. DPRODUCT. DSTDEV. DSTDEVP. DSUM. DVAR. DVARP. GETPIVOTDATA.

4. Date and Time Functions.
Date and Time Functions Overview. DATE. DATEVALUE. DAY. DAYS360. EDATE. EOMONTH. HOUR. MINUTE. MONTH. NETWORKDAYS. NOW. SECOND. TIME. TIMEVALUE. TODAY. WEEKDAY. WEEKNUM. WORKDAY. YEAR. YEARFRAC.

5. Engineering Functions.
Engineering Functions Overview. BESSELI. BESSELJ. BESSELK. BESSELY. BIN2DEC. BIN2HEX. BIN2OCT. COMPLEX. CONVERT. DEC2BIN. DEC2HEX. DELTA. ERF. ERFC. GESTEP. HEX2BIN. HEX2DEC. HEX2OCT. IMABS. IMAGINARY. IMARGUMENT. IMCONJUGATE. IMCOS. IMDIV. IMEXP. IMLN. IMLOG10. IMLOG2. IMPOWER. IMPRODUCT. IMREAL. IMSIN. IMSQRT. IMSUB. IMSUM. OCT2BIN. OCT2DEC. OCT2HEX.

6. Financial Functions.
Financial Functions Overview. 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. RECEIVED. SLN. SYD. TBILLEQ. TBILLPRICE. TBILLYIELD. VDB. XIRR. XNPV. YIELD. YIELDDISC. YIELDMAT.

7. Information Functions.
Information Functions Overview. CELL. COUNTBLANK. ERROR.TYPE. INFO. IS Functions. Using the ISBLANK Function. ISNUMBER. N. NA. TYPE.

8. Logical Functions.
Logical Functions Overview. AND. FALSE. IF. NOT. OR. TRUE.

9. Lookup and Reference Functions.
Lookup and Reference Functions Overview. ADDRESS. AREAS. CHOOSE. COLUMN. COLUMNS. HLOOKUP. HYPERLINK. INDEX Array Form). INDEX (Reference Form). INDIRECT. LOOKUP (Array Form). LOOKUP (Vector Form). MATCH. OFFSET. ROW. ROWS. TRANSPOSE. VLOOKUP.

10. Math and Trigonometry Functions.
Math and Trigonometry Functions Overview. ABS. ACOS. ACOSH. ASIN. ASINH. ATAN. ATAN2. ATANH. CEILING. COMBIN. COS. COSH. COUNTIF. DEGREES. EVEN. EXP. FACT. FACTDOUBLE. FLOOR. GCD. INT. LCM. LN. LOG. LOG10. MDETERM. MINVERSE. MMULT. MOD. MROUND. MULTINOMIAL. ODD. PERMUT. 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.

11. Statistical Functions.
Statistical Functions Overview. AVEDEV. AVERAGE. AVERAGEA. BETADIST. BETAINV. BINOMDIST. CHIDIST. CHIINV. CHITEST. CONFIDENCE. CORREL. COUNT. COUNTA. COUNTBLANK. COUNTIF. COVAR. CRITBINOM. DEVSQ. EXPONDIST. FDIST. FINV. FISHER. FISHERINV. 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.

12. Text Functions.
Text Functions Overview. ASC. CHAR. CLEAN. CODE. CONCATENATE. DOLLAR. EXACT. FIND. FIXED. JIS. LEFT. LEN. LOWER. MID. PHONETIC. PROPER. REPLACE. REPT. RIGHT. SEARCH. SUBSTITUTE. T. TEXT. TRIM. UPPER. VALUE. YEN.

Index.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership