エクセル一覧(エクセル2010)

エクセルの関数はなんと396種類!

全部を覚える必要は全くありません。

実務で使うのは多くて30~50個くらいでしょうか。

10個使えれば上等ですよ!

スポンサーリンク

財務

=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()

論理

=AND()

=FALSE()

=IF()

=IFERROR()

=NOT()

=OR()

=TRUE()

文字列操作

=ASC()

=BAHTTEXT()

=CHAR()

=CLEAN()

=CODE()

=CONCATENATE()

=DOLLAR()

=EXACT()

=FIND()

=FINDB()

=FIXED()

=JIS()

=LEFT()

=LEFTB()

=LEN()

=LENB()

=LOWER()

=MID()

=MIDB()

=PROPER()

=REPLACE()

=REPLACEB()

=REPT()

=RIGHT()

=RIGHTB()

=SEARCH()

=SEARCHB()

=SUBSTITUTE()

=T()

=TEXT()

=TRIM()

=UPPER()

=VALUE()

=YEN()

日付/時刻

=DATE()

=DATEVALUE()

=DAY()

=DAYS360()

=EDATE()

=EOMONTH()

=HOUR()

=MINUTE()

=MONTH()

=NETWORKDAYS()

=NETWORKDAYS.INTL()

=NOW()

=SECOND()

=TIME()

=TIMEVALUE()

=TODAY()

=WEEKDAY()

=WEEKNUM()

=WORKDAY()

=WORKDAY.INTL()

=YEAR()

=YEARFRAC()

検索/行列

=ADDRESS()

=AREAS()

=CHOOSE()

=COLUMN()

=COLUMNS()

=GETPIVOTDATA()

=HLOOKUP()

=HYPERLINK()

=INDEX()+INDIRECT()

=LOOKUP()+MATCH()

=OFFSET()

=ROW()

=ROWS()

=RTD()

=TRANSPOSE()

=VLOOKUP()

数学/三角

=ABS()

=ACOS()

=ACOSH()

=AGGREGATE()+ASIN()

=ASINH()

=ATAN()

=ATAN2()

=ATANH()

=CEILING()

=CEILING.PRECISE()

=COMBIN()

=COS()

=COSH()

=DEGREES()

=EVEN()

=EXP()

=FACT()

=FACTDOUBLE()

=FLOOR()

=FLOOR.PRECISE()

=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()

統計

=AVEDEV()

=AVERAGE()

=AVERAGEA()

=AVERAGEIF()

=AVERAGEIFS()

=BETA.DIST()

=BETA.INV()

=BINOM.DIST()

=BINOM.INV()

=CHISQ.DIST()

=CHISQ.DIST.RT()

=CHISQ.INV()

=CHISQ.INV.RT()

=CHISQ.TEST()

=CONFIDENCE.NORM()

=CONFIDENCE.T()

=CORREL()

=COUNT()

=COUNTA()

=COUNTBLANK()

=COUNTIF()

=COUNTIFS()

=COVARIANCE.P()

=COVARIANCE.S()

=DEVSQ()

=EXPON.DIST()

=F.DIST()

=F.DIST.RT()

=F.INV()

=F.INV.RT()

=F.TEST()

=FISHER()

=FISHERINV()

=FORECAST()

=FREQUENCY()

=GAMMA.DIST()

=GAMMA.INV()

=GAMMALN()

=GAMMALN.PRECISE()

=GEOMEAN()

=GROWTH()

=HARMEAN()

=HYPGEOM.DIST()

=INTERCEPT()

=KURT()

=LARGE()

=LINEST()

=LOGEST()

=LOGNORM.DIST()

=LOGNORM.INV()

=MAX()

=MAXA()

=MEDIAN()

=MIN()

=MINA()

=MODE.MULT()

=MODE.SNGL()

=NEGBINOM.DIST()

=NORM.DIST()

=NORM.INV()

=NORM.S.DIST()

=NORM.S.INV()

=PEARSON()

=PERCENTILE.EXC()

=PERCENTILE.INC()

=PERCENTRANK.EXC()

=PERCENTRANK.INC()

=PERMUT()

=POISSON.DIST()

=PROB()

=QUARTILE.EXC()

=QUARTILE.INC()

=RANK.AVG()

=RANK.EQ()

=RSQ()

=SKEW()

=SLOPE()

=SMALL()

=STANDARDIZE()

=STDEV.P()

=STDEV.S()

=STDEVA()

=STDEVPA()

=STEYX()

=T.DIST()

=T.DIST.2T()

=T.DIST.RT()

=T.INV()

=T.INV.2T()

=T.TEST()

=TREND()

=TRIMMEAN()

=VAR.P()

=VAR.S()

=VARA()

=VARPA()

=WEIBULL.DIST()

=Z.TEST()

エンジニアリング

=BESSELI()

=BESSELJ()

=BESSELK()

=BESSELY()

=BIN2DEC()

=BIN2HEX()

=BIN2OCT()

=COMPLEX()

=CONVERT()

=DEC2BIN()

=DEC2HEX()

=DEC2OCT()

=DELTA()

=ERF()

=ERF.PRECISE()

=ERFC()

=ERFC.PRECISE()

=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()

情報

=CELL()

=ERROR.TYPE()

=INFO()

=ISBLANK()

=ISERR()

=ISERROR()

=ISEVEN()

=ISLOGICAL()

=ISNA()

=ISNONTEXT()

=ISNUMBER()

=ISODD()

=ISREF()

=ISTEXT()

=N()

=NA()

=PHONETIC()

=TYPE()

互換性

=BETADIST()

=BETAINV()

=BINOMDIST()

=CHIDIST()

=CHIINV()

=CHITEST()

=CONFIDENCE()

=COVAR()

=CRITBINOM()

=EXPONDIST()

=FDIST()

=FINV()

=FTEST()

=GAMMADIST()

=GAMMAINV()

=HYPGEOMDIST()

=LOGINV()

=LOGNORMDIST()

=MODE()

=NEGBINOMDIST()

=NORMDIST()

=NORMINV()

=NORMSDIST()

=NORMSINV()

=PERCENTILE()

=PERCENTRANK()

=POISSON()

=QUARTILE()

=RANK()

=STDEV()

=STDEVP()

=TDIST()

=TINV()

=TTEST()

=VAR()

=VARP()

=WEIBULL()

=ZTEST()

スポンサーリンク
地方公務員.com