Contents Part1 Excel... 7 Trick 01 Excel... 8 Trick 02 Excel Trick Trick 04 Excel.. 15 Trick 05 Excel Part Trick 01 CHAR...

Size: px

Start display at page:

Download "Contents Part1 Excel... 7 Trick 01 Excel... 8 Trick 02 Excel Trick Trick 04 Excel.. 15 Trick 05 Excel Part Trick 01 CHAR..."

栖窦
5 years ago
Views:

1 2AE239-Excel函數密技字典封面底完稿-ol Cyan Magenta Yellow Black

2 Contents Part1 Excel... 7 Trick 01 Excel... 8 Trick 02 Excel Trick Trick 04 Excel.. 15 Trick 05 Excel Part Trick 01 CHAR Trick 02 CODE Trick 03 LEFT Trick 04 LOWER Trick 05 MID Trick 06 PROPER Trick 07 REPLACE Trick 08 RIGHT Trick 09 SEARCH Trick 10 SUBSTITUTE Trick 11 TRIM Trick 12 UPPER Trick 13 VALUE Part Trick 01 AND Trick 02 IF

3 Trick 03 NOT Trick 04 OR Part Trick 01 NOW Trick 02 TODAY Trick 03 WEEKDAY Trick 04 DATE Trick 05 MONTH Trick 06 YEAR Trick 07 TIME Trick 08 HOUR Part Trick 01 AREAS Trick 02 CELL Trick 03 CHOOSE Trick 04 DGET Trick 05 HLOOKUP Trick 06 HYPERLINK Trick 07 INDEX Trick 08 INDIRECT Trick 09 INFO Trick 10 SNUMBER Trick 11 ISTEXT

4 Contents Trick 12 LOOKUP Trick 13 LOOKUP Trick 14 MATCH Trick 15 OFFSET Trick 16 PHONETIC Trick 17 ROW COLUMN Trick 18 ROWS COLUMNS Trick 19 VLOOKUP Part Trick 01 ABS Trick 02 AVERAGE Trick 03 CEILING Trick 04 COMBIN Trick 05 COUNT Trick 06 COUNTA Trick 07 COUNTBLANK Trick 08 COUNTIF Trick 09 FACT Trick 10 FLOOR Trick 11 MEDIAN Trick 12 MIN MAX Trick 13 MOD Trick 14 POWER Trick 15 PRODUCT Trick 16 RAND

5 Trick 17 ROMAN Trick 18 ROUND Trick 19 ROUNDDOWN Trick 20 ROUNDUP Trick 21 SIN Trick 22 SQRT Trick 23 SUBTOTAL Trick 24 SUM Trick 25 SUMIF Trick 26 SUMPRODUCT Trick 27 TRIMMEAN Trick 01 FV Trick 02 IPMT Trick 03 IRR Trick 04 MIRR Trick 05 NPER Trick 06 NPV Trick 07 PMT Trick 08 PPMT Trick 09 PV Trick 10 RATE

6 Contents Trick 01 Bessel Trick Trick Trick Excel Trick Trick Trick Trick Trick Trick Trick Trick Trick Trick Trick 11 CUBE

7 Trick 01 Excel Excel Excel Excel 360 Excel Excel Excel 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 DATE DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY YEAR YEARFRAC

8 9 Part1 Excel ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH 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 SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC 60 AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS 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 83 ADDRESS AREAS CHOOSE COLUMN COLUMNS HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS RTD TRANSPOSE VLOOKUP 17 DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP 12

9 ASC BAHTTEXT CHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIND FINDB FIXED JIS LEFT LEFTB LEN LENB LOWER MID MIDB PHONETIC PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TRIM UPPER VALUE AND FALSE IF IFERROR NOT OR TRUE 7 Cube CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT 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 CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE

10 2AE239-Excel函數密技字典封面底完稿-ol Cyan Magenta Yellow Black

excel在统计分析中的应用

excel在统计分析中的应用 Excel... 3 Excel... 3 Excel... 5 Excel... 6 Excel... 8 Excel... 8... 9... 9... 11... 12... 12 Excel... 12... 13... 14 Excel... 15... 17... 18 Excel... 19... 19... 21... 24... 25... 27... 29 X 2... 32...