大数据分析的好帮手 Excel函数应用的顶级实战 Excel数据分析应用+VBA实战 24G课程
2021-07-22 09:05:38
175B
1
《办公宝典:Excel 2003/2002/2000函数大全》是一本翔实的介绍Excel函数的图书。全书深入地探讨了Excel公式与函数的作用，收录了Excel 2003/2002/2000所有函数，通过实务案例对函数的定义和使用方法做了详细说明。《办公宝典:Excel 2003/2002/2000函数大全》语言简练，通俗易懂，即使刚刚接触函数的读者，也可轻松学习，快速上手。全书从读者“想做什么”的要求出发，将函数分门别类地整理，更附以丰富的使用技巧提示，通过常用的实务案例带领读者深入学习Excel函数，高效完成复杂琐碎的工作。
2021-06-20 22:31:21
193.19MB
1
EXCEL 函数速查手册
一、数学和三角函数（60条）
·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 ·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
二、统计函数（80条）
·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
·NORMSINV ·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
三、文本和数据函数（28条）
·ASC ·CHAR ·CLEAN ·CODE ·CONCATENATE ·DOLLAR 或 RMB
·EXACT ·FIND ·FINDB ·FIXED ·JIS ·LEFT 或 LEFTB
·LEN 或 LENB ·LOWER ·MID 或 MIDB ·PHONETIC ·PROPER ·REPLACE 或 REPL
·REPT ·RIGHT 或 RIGHTB ·SEARCH 或 SEARC ·SUBSTITUTE ·T ·TEXT
·TRIM ·UPPER ·value ·WIDECHAR
四、逻辑运算符（6条）
·AND ·FALSE ·IF ·NOT ·OR ·TRUE
五、查找和引用函数（17条）
·ADDRESS ·AREAS ·CHOOSE ·COLUMN ·COLUMNS ·HLOOKUP
·HYPERLINK ·INDEX ·INDIRECT ·LOOKUP ·MATCH ·OFFSET
·ROW ·ROWS ·RTD ·TRANSPOSE ·VLOOKUP
六、数据库函数（13条）
·DAVERAGE ·DCOUNT ·DCOUNTA ·DGET ·DMAX ·DMIN
·DPRODUCT ·DSTDEV ·DSTDEVP ·DSUM
2021-05-22 19:37:55
47KB
1