Excel函数应用500例教学内容阅读_Excel函数应用500例学哪些内容

6.6

基本信息：

课件分类：计算机

课件类型：参考资料

文件大小：621.67KB

差评(0)

中评(10)

好评(8)

下载积分：10

可预览文件：

课件目录与文件树：

Excel函数应用500例
- 信息函数
  - CELL.xls(13824)
  - COUNTBLANK.xls(13824)
  - ERROR.TYPE.xls(13824)
  - INFO.xls(13824)
  - ISBLANK.xls(13824)
  - ISERR.xls(13824)
  - ISERROR.xls(13824)
  - ISEVEN.xls(13824)
  - ISLOGICAL.xls(13824)
  - ISNA.xls(13824)
  - ISNONTEXT.xls(13824)
  - ISNUMBER.xls(13824)
  - ISODD.xls(13824)
  - ISREF.xls(53760)
  - ISTEXT.xls(13824)
  - NA函数.xls(13824)
  - N函数.xls(13824)
  - TYPE函数.xls(13824)
- 工程函数
  - BESSELI.xls(13824)
  - BESSELJ.xls(13824)
  - BESSELK.xls(13824)
  - BESSELY.xls(13824)
  - BIN2DEC.xls(13824)
  - BIN2HEX.xls(13824)
  - BIN2OCT.xls(13824)
  - COMPLEX.xls(14336)
  - CONVERT.xls(13824)
  - DEC2BIN.xls(13824)
  - DEC2HEX.xls(13824)
  - DEC2OCT.xls(13824)
  - DELTA.xls(13824)
  - ERF.xls(13824)
  - ERFC.xls(13824)
  - GESTEP.xls(13824)
  - HEX2BIN.xls(13824)
  - HEX2DEC.xls(13824)
  - HEX2OCT.xls(13824)
  - IMABS.xls(13824)
  - IMAGINARY.xls(13824)
  - IMARGUMENT.xls(13824)
  - IMCONJUGATE.xls(13824)
  - IMCOS.xls(13824)
  - IMDIV.xls(13824)
  - IMEXP.xls(13824)
  - IMLN.xls(13824)
  - IMLOG10.xls(13824)
  - IMLOG2.xls(13824)
  - IMPOWER.xls(13824)
  - IMPRODUCT.xls(13824)
  - IMREAL.xls(13824)
  - IMSIN.xls(13824)
  - IMSQRT.xls(13824)
  - IMSUB.xls(13824)
  - IMSUM.xls(13824)
  - OCT2BIN.xls(13824)
  - OCT2DEC.xls(13824)
  - OCT2HEX.xls(13824)
- 数学与三角函数
  - ABS.xls(13824)
  - ACOS.xls(13824)
  - ACOSH.xls(13824)
  - ASIN.xls(13824)
  - ASINH.xls(13824)
  - ATAN.xls(13824)
  - ATANH.xls(13824)
  - CEILING.xls(13824)
  - COMBIN.xls(13824)
  - COS.xls(13824)
  - COSH.xls(13824)
  - DEGREES.xls(13824)
  - EVEN.xls(13824)
  - EXP.xls(13824)
  - FACT.xls(13824)
  - FACTDOUBLE.xls(13824)
  - FLOOR.xls(13824)
  - GCD.xls(13824)
  - INT.xls(13824)
  - LCM.xls(13824)
  - LN.xls(13824)
  - LOG.xls(13824)
  - LOG10.xls(13824)
  - MDETERM.xls(13824)
  - MINVERSE.xls(13824)
  - MMULT.xls(13824)
  - MOD.xls(13824)
  - MROUND.xls(13824)
  - MULTINOMIAL.xls(13824)
  - ODD.xls(13824)
  - PI.xls(13824)
  - POWER.xls(13824)
  - PRODUCT.xls(13824)
  - QUOTIENT.xls(13824)
  - RADIANS.xls(13824)
  - RAND.xls(13824)
  - RANDBETWEEN.xls(13824)
  - ROMAN.xls(13824)
  - ROUND.xls(13824)
  - ROUNDDOWN.xls(13824)
  - ROUNDUP.xls(13824)
  - SERIESSUM.xls(13824)
  - SIGN.xls(13824)
  - SIN.xls(13824)
  - SINH.xls(13824)
  - SQRT.xls(13824)
  - SQRTPI.xls(13824)
  - SUBTOTAL.xls(13824)
  - SUM.xls(13824)
  - SUMIF.xls(13824)
  - SUMPRODUCT.xls(13824)
  - SUMSQ.xls(13824)
  - SUMX2MY2.xls(13824)
  - SUMX2PY2.xls(13824)
  - SUMXMY2.xls(13824)
  - TAN.xls(13824)
  - TANH.xls(13824)
  - TRUNC.xls(13824)
- 数据库函数
  - DAVERAGE.xls(14848)
  - DCOUNT.xls(14848)
  - DCOUNTA.xls(14336)
  - DGET.xls(14848)
  - DMAX.xls(14848)
  - DMIN.xls(14848)
  - DPRODUCT.xls(13824)
  - DSTDEV.xls(14336)
  - DSTDEVP.xls(14336)
  - DSUM.xls(14336)
  - DVAR.xls(14336)
  - DVARP.xls(14336)
  - GETPIVOTDATA.xls(15872)
- 文本函数
  - asc函数.xls(13824)
  - BAHTTEXT函数.xls(13824)
  - char函数.xls(13824)
  - clean函数.xls(13824)
  - code函数.xls(13824)
  - CONCATENATE函数.xls(13824)
  - DOLLAR函数.xls(13824)
  - exact函数.xls(13824)
  - findb函数.xls(13824)
  - find函数.xls(13824)
  - FIXED函数.xls(13824)
  - leftb函数.xls(14336)
  - left函数.xls(13824)
  - lenb函数.xls(13824)
  - len函数.xls(13824)
  - lower函数.xls(16384)
  - midb函数.xls(13824)
  - mid函数.xls(13824)
  - PROPER函数.xls(13824)
  - replaceb函数.xls(13824)
  - replace函数.xls(13824)
  - rept函数.xls(13824)
  - rightb函数.xls(13824)
  - right函数.xls(13824)
  - rmb函数.xls(13824)
  - SEARCHB函数.xls(13824)
  - search函数.xls(13824)
  - substitute函数.xls(13824)
  - text函数.xls(13824)
  - trim函数.xls(13824)
  - t函数.xls(13824)
  - upper函数.xls(13824)
  - value函数.xls(13824)
  - widechar函数.xls(13824)
- 日期与时间函数
  - DATE.xls(13824)
  - DATEIF.xls(13824)
  - DATEVALUE.xls(13824)
  - DAY.xls(13824)
  - DAYS360.xls(13824)
  - EDATE.xls(13824)
  - EOMONTH.xls(13824)
  - HOUR.xls(13824)
  - MINUTE.xls(13824)
  - MONTH.xls(13824)
  - NETWORKDAYS.xls(13824)
  - NOW.xls(13824)
  - SECOND.xls(13824)
  - TIME.xls(13824)
  - TIMEVALUE.xls(13824)
  - TODAY.xls(13824)
  - WEEKDAY.xls(13824)
  - WEEKNUM.xls(13824)
  - WORKDAY.xls(13824)
  - YEAR.xls(13824)
  - YEARFRAC.xls(13824)
- 查找与引用函数
  - ADDRESS.xls(13824)
  - AREAS.xls(13824)
  - CHOOSE.xls(14336)
  - COLUMN.xls(13824)
  - COLUMNS.xls(13824)
  - HLOOKUP.xls(14848)
  - HYPERLINK.xls(14336)
  - INDEX.xls(14336)
  - INDEX2.xls(14336)
  - INDIRECT.xls(14336)
  - LOOKUP.xls(13824)
  - LOOKUP2.xls(14336)
  - MATCH.xls(14336)
  - OFFSET.xls(14336)
  - ROW.xls(13824)
  - ROWS.xls(13824)
  - RTD.xls(13824)
  - TRANSPOSE.xls(14336)
  - VLOOKUP.xls(14336)
- 统计函数
  - avedev函数.xls(13824)
  - averagea函数.xls(13824)
  - average函数.xls(13824)
  - betadist函数.xls(13824)
  - betainv函数.xls(13824)
  - binomdist函数.xls(13824)
  - chidist函数.xls(8192)
  - chiinv函数.xls(8704)
  - chitest函数.xls(14336)
  - confidence函数.xls(9216)
  - CORREL.xls(13824)
  - counta.xls(13824)
  - countblank.xls(13824)
  - countif函数.xls(13824)
  - count函数.xls(13824)
  - covar函数.xls(13824)
  - critbinom函数.xls(13824)
  - devsq函数.xls(13824)
  - expondist.xls(13824)
  - fdist函数.xls(13824)
  - finv函数.xls(13824)
  - fisherinv函数.xls(13824)
  - fisher函数.xls(13824)
  - forecase函数.xls(13824)
  - forecast函数.xls(13824)
  - frequency.xls(13824)
  - ftest函数.xls(13824)
  - gammadist函数.xls(13824)
  - gammainv.xls(13824)
  - gammaln函数.xls(13824)
  - geomean函数.xls(13824)
  - growth函数.xls(13824)
  - harmean函数.xls(13824)
  - hypgeomdist函数.xls(13824)
  - intercept函数.xls(13824)
  - kurt函数.xls(13824)
  - large函数.xls(13824)
  - linest函数.xls(13824)
  - logest函数.xls(13824)
  - loginv函数.xls(13824)
  - lognormdist函数.xls(13824)
  - maxa函数.xls(13824)
  - max函数.xls(13824)
  - median函数.xls(13824)
  - mina函数.xls(13824)
  - min函数.xls(13824)
  - mode函数.xls(13824)
  - normdist.xls(13824)
  - norminv函数.xls(13824)
  - normsdist函数.xls(13824)
  - normsinv函数.xls(13824)
  - pearson函数.xls(13824)
  - percentile函数.xls(13824)
  - percentrank函数.xls(13824)
  - permut函数.xls(13824)
  - poisson函数.xls(13824)
  - PROB.xls(13824)
  - QUARTILE.xls(14336)
  - RANK.xls(14336)
  - RSQ.xls(13824)
  - SKEW.xls(13824)
  - SLOPE.xls(13824)
  - SMALL.xls(13824)
  - STANDARDIZE.xls(13824)
  - STDEV.xls(13824)
  - STDEVA.xls(13824)
  - STDEVP.xls(13824)
  - STDEVPA.xls(13824)
  - STEYX.xls(14848)
  - TDIST.xls(13824)
  - TINV.xls(13824)
  - TREND.xls(13824)
  - TRIMMEAN.xls(13824)
  - TTEST.xls(13824)
  - VAR.xls(13824)
  - VARA.xls(13824)
  - VARP.xls(13824)
  - VARPA.xls(13824)
  - WEIBULL.xls(14848)
  - ZTEST.xls(13824)
- 财务函数
  - ACCRINT.xls(15360)
  - ACCRINTM.xls(13824)
  - AMORDEGRC.xls(14336)
  - AMORLINC.xls(13824)
  - COUPDAYBS.xls(13824)
  - COUPDAYS.xls(13824)
  - COUPDAYSNC.xls(13824)
  - COUPNCD.xls(13824)
  - COUPNUM.xls(13824)
  - COUPOCD.xls(13824)
  - CUMIPMT.xls(13824)
  - CUMPRINC.xls(13824)
  - DB.xls(14848)
  - DDB.xls(15360)
  - DISC.xls(13824)
  - DOLLARDE.xls(13824)
  - DOLLARFR.xls(13824)
  - DURATION.xls(13824)
  - EFFECT.xls(13824)
  - FV.xls(13824)
  - FVSCHEDULE.xls(13824)
  - INTRATE.xls(14336)
  - IPMT.xls(14848)
  - IRR.xls(14336)
  - ISPMT.xls(13824)
  - MDURATION.xls(13824)
  - MIRR.xls(14336)
  - NOMINAL.xls(13824)
  - NPER.xls(13824)
  - NPV.xls(13824)
  - ODDFPRICE.xls(14336)
  - ODDFYIELD.xls(14336)
  - ODDLPRICE.xls(14336)
  - ODDLYIELD.xls(14336)
  - PMT.xls(14848)
  - PPMT.xls(13824)
  - PRICE.xls(13824)
  - PRICEDISC.xls(13824)
  - PRICEMAT.xls(13824)
  - PV.xls(13824)
  - RATE.xls(13824)
  - RECEIVED.xls(13824)
  - SLN.xls(13824)
  - SYD.xls(13824)
  - TBILLEQ.xls(13824)
  - TBILLPRICE.xls(13824)
  - TBILLYIELD.xls(13824)
  - VDB.xls(14336)
  - XIRR.xls(13824)
  - XNPV.xls(13824)
  - YIELD.xls(13824)
  - YIELDDISC.xls(13824)
  - YIELDMAT.xls(14848)
- 逻辑函数
  - AND.xls(13824)
  - FALSE.xls(13824)
  - IF.xls(13824)
  - NOT.xls(13824)
  - OR.xls(13824)
  - TRUE.xls(13824)

说明.txt(348)