HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
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.
Database and List Management Functions
Excel 2000 Database Functions Overview
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.