2AE239-Excel函數密技字典封面底完稿-ol Cyan Magenta Yellow Black
Contents Part1 Excel... 7 Trick 01 Excel... 8 Trick 02 Excel... 11 Trick 03... 13 Trick 04 Excel.. 15 Trick 05 Excel... 18 Part2...19 Trick 01 CHAR... 20 Trick 02 CODE... 21 Trick 03 LEFT... 22 Trick 04 LOWER... 24 Trick 05 MID... 26 Trick 06 PROPER... 28 Trick 07 REPLACE... 30 Trick 08 RIGHT... 32 Trick 09 SEARCH... 34 Trick 10 SUBSTITUTE... 36 Trick 11 TRIM... 39 Trick 12 UPPER... 41 Trick 13 VALUE... 45 Part3...47 Trick 01 AND... 48 Trick 02 IF... 50 2
Trick 03 NOT... 54 Trick 04 OR... 57 Part4...59 Trick 01 NOW... 60 Trick 02 TODAY... 61 Trick 03 WEEKDAY... 62 Trick 04 DATE... 66 Trick 05 MONTH... 68 Trick 06 YEAR... 70 Trick 07 TIME... 71 Trick 08 HOUR... 73 Part5...75 Trick 01 AREAS... 76 Trick 02 CELL... 78 Trick 03 CHOOSE... 84 Trick 04 DGET... 87 Trick 05 HLOOKUP... 90 Trick 06 HYPERLINK... 92 Trick 07 INDEX... 94 Trick 08 INDIRECT... 96 Trick 09 INFO... 99 Trick 10 SNUMBER...103 Trick 11 ISTEXT...104 3
Contents Trick 12 LOOKUP...105 Trick 13 LOOKUP...108 Trick 14 MATCH...110 Trick 15 OFFSET...112 Trick 16 PHONETIC...114 Trick 17 ROW COLUMN...116 Trick 18 ROWS COLUMNS...117 Trick 19 VLOOKUP...118 Part6... 121 Trick 01 ABS...122 Trick 02 AVERAGE...124 Trick 03 CEILING...126 Trick 04 COMBIN...129 Trick 05 COUNT...131 Trick 06 COUNTA...133 Trick 07 COUNTBLANK...135 Trick 08 COUNTIF...137 Trick 09 FACT...139 Trick 10 FLOOR...140 Trick 11 MEDIAN...142 Trick 12 MIN MAX...144 Trick 13 MOD...146 Trick 14 POWER...148 Trick 15 PRODUCT...150 Trick 16 RAND...152 4
Trick 17 ROMAN...154 Trick 18 ROUND...156 Trick 19 ROUNDDOWN...158 Trick 20 ROUNDUP...160 Trick 21 SIN...162 Trick 22 SQRT...164 Trick 23 SUBTOTAL...166 Trick 24 SUM...168 Trick 25 SUMIF...171 Trick 26 SUMPRODUCT...173 Trick 27 TRIMMEAN...175 7... 177 Trick 01 FV...178 Trick 02 IPMT...180 Trick 03 IRR...182 Trick 04 MIRR...184 Trick 05 NPER...186 Trick 06 NPV...188 Trick 07 PMT...190 Trick 08 PPMT...192 Trick 09 PV...194 Trick 10 RATE...197 5
Contents 8... 199 Trick 01 Bessel...200 Trick 02 2 8 10 16...203 Trick 03...207 Trick 04...208 9 Excel... 209 Trick 01...210 Trick 02...221 Trick 03...223 Trick 04...228 Trick 05...238 Trick 06...241 Trick 07...243 Trick 08...247 Trick 09...248 Trick 10...250 Trick 11 CUBE...254 6
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 53 20 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
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 27 17 39 7 10
2AE239-Excel函數密技字典封面底完稿-ol Cyan Magenta Yellow Black