The most detailed Excel function encyclopedia
 |
Description
Book Introduction
A must-read for practitioners, covering everything about Excel functions!
Excel Function Dictionary: Find the functions you need at a glance
When trying to use Excel functions at work, the names are complicated, the input formats are confusing, and you often feel lost because you don't know which function to use in which situation.
This book is an 'Excel Function Encyclopedia' for those practitioners.
It contains over 400 functions provided by Excel, ranging from frequently used functions to advanced functions, and the function, input format, usage, and examples of each function are neatly organized in dictionary format for easy understanding at a glance.
The explanations are concise and clear, focusing on practical examples, making them easy for even Excel beginners to understand and immediately apply in real-world situations.
Additionally, it provides three indices - by function, by purpose, and by alphabetical order - so you can quickly find the function you want. It also organizes everything from the basic concepts required for using functions to practical application tips and advanced techniques, making it useful for improving your practical skills.
If you've always been confused about using functions, have only used Excel by copying and pasting, or have been searching for function manuals, you'll be able to learn everything about Excel functions with this one book.
Excel Function Dictionary: Find the functions you need at a glance
When trying to use Excel functions at work, the names are complicated, the input formats are confusing, and you often feel lost because you don't know which function to use in which situation.
This book is an 'Excel Function Encyclopedia' for those practitioners.
It contains over 400 functions provided by Excel, ranging from frequently used functions to advanced functions, and the function, input format, usage, and examples of each function are neatly organized in dictionary format for easy understanding at a glance.
The explanations are concise and clear, focusing on practical examples, making them easy for even Excel beginners to understand and immediately apply in real-world situations.
Additionally, it provides three indices - by function, by purpose, and by alphabetical order - so you can quickly find the function you want. It also organizes everything from the basic concepts required for using functions to practical application tips and advanced techniques, making it useful for improving your practical skills.
If you've always been confused about using functions, have only used Excel by copying and pasting, or have been searching for function manuals, you'll be able to learn everything about Excel functions with this one book.
- You can preview some of the book's contents.
Preview
index
01 Math/Trigonometric Functions
[Four basic operations] SUM / SUMIF / SUMIFS / PRODUCT / SUMPRODUCT / SUBTOTAL / AGGREGATE / SUMSQ / SUMX2MY2 / SUMX2PY2 / SUMXMY2
[Integer operations] ROUND / ROUNDDOWN / ROUNDUP / MROUND / ODD / EVEN / ISO.CEILING / CEILING.PRECISE / CEILING.MATH / FLOOR.PRECISE / FLOOR.MATH / TRUNC / INT / QUOTIENT / MOD / GCD / LCM
[Permutation/Combination] COMBIN / COMBINA
[Polynomial] MULTINOMIAL
[Power Series] SERIESSUM
[Power] POWER / EXP
[Succession] FACT / FACTDOUBLE
[Absolute value/sign] ABS / SIGN
[Log] LN / LOG / LOG10
[Base Conversion] BASE / DECIMAL
[Square root] SQRT / SQRTPI
[Trigonometric functions] PI / RADIANS / DEGREES / SIN / COS / TAN / CSC / SEC / COT / ASIN / ACOS / ATAN / ATAN2 / ACOT
[Hyperbolic function] SINH / COSH / TANH / CSCH / SECH / COTH / ASINH / ACOSH / ATANH / ACOTH
[Array/Matrix] MDETERM / MINVERSE / MMULT / MUNIT / SEQUENCE
[Random Number] RAND / RANDBETWEEN / RANDARRAY
[Roman Numeral Conversion] ROMAN / ARABIC
02 Date/Time Function
[Current Date] TODAY / NOW
[Date] YEAR / MONTH / DAY / DATE / HOUR / MINUTE / SECOND / TIME
[Period] EDATE / EOMONTH / WORKDAY / WORKDAY.INTL / NETWORKDAYS / NETWORKDAYS.INTL / DATEDIF / YEARFRAC / DAYS / DAYS360 / WEEKDAY / WEEKNUM / ISOWEEKNUM
[Date/Time Conversion] TIMEVALUE / DATEVALUE
03 Statistical functions
[Data count] COUNT / COUNTBLANK / COUNTA / COUNTIF / COUNTIFS / FREQUENCY
[Median] MEDIAN
[Mode] MODE.SNGL / MODE.MULT
[Maximum/Minimum] MIN / MINA / MINIFS / MAX / MAXA / MAXIFS
[Average value] AVERAGE / AVERAGEA / AVERAGEIF / AVERAGEIFS / GEOMEAN / HARMEAN / TRIMMEAN
[Ranking] RANK.EQ / RANK.AVG / SMALL / LARGE
[Quantile] PERCENTRANK.INC / PERCENTRANK.EXC / PERCENTILE.INC / PERCENTILE.EXC / QUARTILE.INC / QUARTILE.EXC
[Distributed] VAR.P / VARPA / VAR.S / VARA
[Standard Deviation] STDEV.P / STDEVPA / STDEV.S / STDEVA
[Deviation] AVEDEV / DEVSQ
[Skew/Kurtosis] SKEW / SKEW.P / KURT
[Correlation] CORREL / PEARSON / RSQ / COVARIANCE.P / COVARIANCE.S
[Normal distribution] NORM.DIST / NORM.INV / NORM.S.DIST / NORM.S.INV / PHI / STANDARDIZE / GAUSS
[Log distribution] LOGNORM.DIST / LOGNORM.INV
[Probability of upper and lower limits] PROB
[Exponential Distribution] EXPON.DIST
[Binomial distribution] BINOM.DIST / BINOM.DIST.RANGE / BINOM.INV / NEGBINOM.DIST
[Hypergeometric distribution] HYPGEOM.DIST
[Poisson Distribution] POISSON.DIST
[Chi-square distribution] CHISQ.DIST / CHISQ.DIST.RT / CHISQ.INV / CHISQ.INV.RT / CHISQ.TEST
[Confidence interval] CONFIDENCE.NORM / CONFIDENCE.T
[t distribution/test] T.DIST / T.DIST.RT / T.DIST.2T / T.INV / T.INV.2T / T.TEST
[Z distribution/test] Z.TEST
[F distribution/test] F.DIST / F.DIST.RT / F.INV / F.INV.RT / F.TEST
[Regression analysis] FORECAST.LINEAR / SLOPE / INTERCEPT / STEYX / TREND / LINEST / GROWTH / LOGEST / FORECAST.ETS / FORECAST.ETS.CONFINT / FORECAST.ETS.SEASONALITY / FORECAST.ETS.STAT
[Extended Distribution] BETA.DIST / BETA.INV
[Gamma Distribution] GAMMA / GAMMALN / GAMMALN.PRECISE / GAMMA.DIST / GAMMA.INV
[Weibull Distribution] WEIBULL.DIST
[Fisher Transformation] FISHER / FISHERINV
[Permutation] PERMUT / PERMUTATIONA
04 String manipulation functions
[string length] LEN / LENB
[String Extraction] LEFT / LEFTB / RIGHT / RIGHTB / MID / MIDB / CONCAT / TEXTBEFORE / TEXTAFTER
[String Join] TEXTJOIN
[String Split] TEXTSPLIT
[String Substitution] REPLACE / REPLACEB / SUBSTITUTE
[String Search] FIND / FINDB / SEARCH / SEARCHB
[String Display] REPT
[String conversion] FIXED / TEXT / ARRAYTOTEXT / VALUETOTEXT / ASC / JIS / WON / DOLLAR / YEN / LOWER / UPPER / PROPER / NUMBERSTRING / NUMBERVALUE / VALUE
[String Comparison] EXACT
[Remove spaces] TRIM
[Control Character Delete] CLEAN
[Character Code] CODE / UNICODE / CHAR / UNICHAR
[Extract string] T
05 Logical Functions
[Conditions] IF / AND / OR / NOT / XOR / IFS / SWITCH
[Error] IFERROR / IFNA
[Logical value] TRUE / FALSE
[Formula definition] LET / LAMBDA / BYROW / BYCOL / MAKEARRAY / MAP / SCAN / REDUCE
06 Search, Matrix, and Web Functions
[Data Search] VLOOKUP / HLOOKUP / LOOKUP / XLOOKUP / CHOOSE / INDEX
[Cell Reference] ROW / COLUMN / ROWS / COLUMNS / ADDRESS / AREAS / INDIRECT
[Transpose] TRANSPOSE
[Relative Position] OFFSET / MATCH / XMATCH
[Sort] SORT / SORTBY
[Data Extraction] FILTER / UNIQUE / FIELDVALUE / RTD / FORMULATEXT
[Array manipulation] EXPAND / TAKE / DROP / CHOOSEROWS / CHOOSECOLS / TOROW / TOCOL / VSTACK / HSTACK / STOCKHISTORY / WRAPROWS / WRAPCOLS
[URL Encode] ENCODEURL
[Web] WEBSERVICE / FILTERXML
[Link] HYPERLINK
[Pivot Table] GETPIVOTDATA
07 Cube Function
[CUBE] CUBEMEMBER / CUBEVALUE / CUBESET / CUBERANKEDMEMBER / CUBESETCOUNT / CUBEMEMBERPROPERTY / CUBEKPIMEMBER
08 Information Function
[IS function] ISNUMBER / ISEVEN / ISODD / ISTEXT / ISNONTEXT / ISBLANK / ISLOGICAL / ISFORMULA / ISREF / ISERR / ISERROR / ISNA / ISOMITTED
[Error] NA
[Information Extraction] SHEET / SHEETS / CELL / INFO / TYPE / ERROR.TYPE
[Number conversion] N
09 Database Functions
[Average] DAVERAGE
[Total] DSUM
[Maximum/Minimum] DMAX / DMIN
[Count] DCOUNT / DCOUNTA
[Multiply] DPRODUCT /
[Standard Deviation] DSTDEVP / DSTDEV
[Dispersion] DVARP / DVAR
[Value Extraction] DGET
10 Financial Functions
[Savings/Loan Repayment] PMT / PPMT / IPMT / CUMPRINC / CUMIPMT / NPER / ISPMT / RATE
[Present Value/Future Value] PV / FV / FVSCHEDULE / RRI / PDURATION
[Net Present Value] NPV / XNPV
[Internal Rate of Return] IRR / XIRR / MIRR
[Interest rate] EFFECT / NOMINAL
[dollar] DOLLARDE / DOLLARFR
[Depreciation] DB / DDB / VDB / SLN / SYD / AMORDEGRC / AMORLINC
[Bonds] DURATION / MDURATION / ODDFYIELD / ODDLYIELD / ODDFPRICE / ODDLPRICE / ACCRINT / ACCRINTM / YIELD / PRICE / DISC / PRICEDISC / INTRATE / RECEIVED / PRICEMAT / YIELDMAT / YIELDDISC
[Interest Payment Period] COUPPCD / COUPNCD / COUPNUM / COUPDAYBS / COUPDAYSNC / COUPDAYS
[US Treasury Short-Term Bonds] TBILLEQ / TBILLPRICE / TBILLYIELD
11 Engineering Functions
[Unit Conversion] CONVERT
[Number Comparison] DELTA / GESTEP
[Base conversion] DEC2BIN / DEC2OCT / DEC2HEX / BIN2OCT / BIN2DEC / BIN2HEX / OCT2BIN / OCT2DEC / OCT2HEX / HEX2BIN / HEX2DEC / HEX2OCT
[Bit operation] BITAND / BITOR / BITXOR / BITLSHIFT / BITRSHIFT
[Complex number] COMPLEX / IMREAL / IMAGINARY / IMCONJUGATE / IMABS / IMARGUMENT / IMSUM / IMSUB / IMPRODUCT / IMDIV / IMPOWER / IMSQRT / IMSIN / IMCOS / IMTAN / IMSEC / IMCSC / IMCOT / IMSINH / IMCOSH / IMSECH / IMCSCH / IMEXP / IMLN / IMLOG10 / IMLOG2
[Error function] ERF / ERF.PRECISE / ERFC / ERFC.PRECISE
[Bessel function] BESSELJ / BESSELY / BESSELI / BESSELK
grounding
What is a function?
factor
operator
Function input
Modify function
Cell reference method
Name definition
Copy function (auto-fill feature)
Relative references, absolute references, and compound references
Logical formula
wildcard characters
Array constants
Array formulas
Dynamic array formulas and spills
Date and time calculation
Set display format
3D aggregation
Error handling
Useful techniques
Conditional formatting settings
Data Validity
database table
structural reference
outline
partial sum
Integration
Quick Fill
Virtual Analysis
circular reference
Tracking referenced and referencing cells
Formula calculation
Formula display
Automatic/manual switching of recalculation
Frequently used shortcuts
Compatibility functions
[Four basic operations] SUM / SUMIF / SUMIFS / PRODUCT / SUMPRODUCT / SUBTOTAL / AGGREGATE / SUMSQ / SUMX2MY2 / SUMX2PY2 / SUMXMY2
[Integer operations] ROUND / ROUNDDOWN / ROUNDUP / MROUND / ODD / EVEN / ISO.CEILING / CEILING.PRECISE / CEILING.MATH / FLOOR.PRECISE / FLOOR.MATH / TRUNC / INT / QUOTIENT / MOD / GCD / LCM
[Permutation/Combination] COMBIN / COMBINA
[Polynomial] MULTINOMIAL
[Power Series] SERIESSUM
[Power] POWER / EXP
[Succession] FACT / FACTDOUBLE
[Absolute value/sign] ABS / SIGN
[Log] LN / LOG / LOG10
[Base Conversion] BASE / DECIMAL
[Square root] SQRT / SQRTPI
[Trigonometric functions] PI / RADIANS / DEGREES / SIN / COS / TAN / CSC / SEC / COT / ASIN / ACOS / ATAN / ATAN2 / ACOT
[Hyperbolic function] SINH / COSH / TANH / CSCH / SECH / COTH / ASINH / ACOSH / ATANH / ACOTH
[Array/Matrix] MDETERM / MINVERSE / MMULT / MUNIT / SEQUENCE
[Random Number] RAND / RANDBETWEEN / RANDARRAY
[Roman Numeral Conversion] ROMAN / ARABIC
02 Date/Time Function
[Current Date] TODAY / NOW
[Date] YEAR / MONTH / DAY / DATE / HOUR / MINUTE / SECOND / TIME
[Period] EDATE / EOMONTH / WORKDAY / WORKDAY.INTL / NETWORKDAYS / NETWORKDAYS.INTL / DATEDIF / YEARFRAC / DAYS / DAYS360 / WEEKDAY / WEEKNUM / ISOWEEKNUM
[Date/Time Conversion] TIMEVALUE / DATEVALUE
03 Statistical functions
[Data count] COUNT / COUNTBLANK / COUNTA / COUNTIF / COUNTIFS / FREQUENCY
[Median] MEDIAN
[Mode] MODE.SNGL / MODE.MULT
[Maximum/Minimum] MIN / MINA / MINIFS / MAX / MAXA / MAXIFS
[Average value] AVERAGE / AVERAGEA / AVERAGEIF / AVERAGEIFS / GEOMEAN / HARMEAN / TRIMMEAN
[Ranking] RANK.EQ / RANK.AVG / SMALL / LARGE
[Quantile] PERCENTRANK.INC / PERCENTRANK.EXC / PERCENTILE.INC / PERCENTILE.EXC / QUARTILE.INC / QUARTILE.EXC
[Distributed] VAR.P / VARPA / VAR.S / VARA
[Standard Deviation] STDEV.P / STDEVPA / STDEV.S / STDEVA
[Deviation] AVEDEV / DEVSQ
[Skew/Kurtosis] SKEW / SKEW.P / KURT
[Correlation] CORREL / PEARSON / RSQ / COVARIANCE.P / COVARIANCE.S
[Normal distribution] NORM.DIST / NORM.INV / NORM.S.DIST / NORM.S.INV / PHI / STANDARDIZE / GAUSS
[Log distribution] LOGNORM.DIST / LOGNORM.INV
[Probability of upper and lower limits] PROB
[Exponential Distribution] EXPON.DIST
[Binomial distribution] BINOM.DIST / BINOM.DIST.RANGE / BINOM.INV / NEGBINOM.DIST
[Hypergeometric distribution] HYPGEOM.DIST
[Poisson Distribution] POISSON.DIST
[Chi-square distribution] CHISQ.DIST / CHISQ.DIST.RT / CHISQ.INV / CHISQ.INV.RT / CHISQ.TEST
[Confidence interval] CONFIDENCE.NORM / CONFIDENCE.T
[t distribution/test] T.DIST / T.DIST.RT / T.DIST.2T / T.INV / T.INV.2T / T.TEST
[Z distribution/test] Z.TEST
[F distribution/test] F.DIST / F.DIST.RT / F.INV / F.INV.RT / F.TEST
[Regression analysis] FORECAST.LINEAR / SLOPE / INTERCEPT / STEYX / TREND / LINEST / GROWTH / LOGEST / FORECAST.ETS / FORECAST.ETS.CONFINT / FORECAST.ETS.SEASONALITY / FORECAST.ETS.STAT
[Extended Distribution] BETA.DIST / BETA.INV
[Gamma Distribution] GAMMA / GAMMALN / GAMMALN.PRECISE / GAMMA.DIST / GAMMA.INV
[Weibull Distribution] WEIBULL.DIST
[Fisher Transformation] FISHER / FISHERINV
[Permutation] PERMUT / PERMUTATIONA
04 String manipulation functions
[string length] LEN / LENB
[String Extraction] LEFT / LEFTB / RIGHT / RIGHTB / MID / MIDB / CONCAT / TEXTBEFORE / TEXTAFTER
[String Join] TEXTJOIN
[String Split] TEXTSPLIT
[String Substitution] REPLACE / REPLACEB / SUBSTITUTE
[String Search] FIND / FINDB / SEARCH / SEARCHB
[String Display] REPT
[String conversion] FIXED / TEXT / ARRAYTOTEXT / VALUETOTEXT / ASC / JIS / WON / DOLLAR / YEN / LOWER / UPPER / PROPER / NUMBERSTRING / NUMBERVALUE / VALUE
[String Comparison] EXACT
[Remove spaces] TRIM
[Control Character Delete] CLEAN
[Character Code] CODE / UNICODE / CHAR / UNICHAR
[Extract string] T
05 Logical Functions
[Conditions] IF / AND / OR / NOT / XOR / IFS / SWITCH
[Error] IFERROR / IFNA
[Logical value] TRUE / FALSE
[Formula definition] LET / LAMBDA / BYROW / BYCOL / MAKEARRAY / MAP / SCAN / REDUCE
06 Search, Matrix, and Web Functions
[Data Search] VLOOKUP / HLOOKUP / LOOKUP / XLOOKUP / CHOOSE / INDEX
[Cell Reference] ROW / COLUMN / ROWS / COLUMNS / ADDRESS / AREAS / INDIRECT
[Transpose] TRANSPOSE
[Relative Position] OFFSET / MATCH / XMATCH
[Sort] SORT / SORTBY
[Data Extraction] FILTER / UNIQUE / FIELDVALUE / RTD / FORMULATEXT
[Array manipulation] EXPAND / TAKE / DROP / CHOOSEROWS / CHOOSECOLS / TOROW / TOCOL / VSTACK / HSTACK / STOCKHISTORY / WRAPROWS / WRAPCOLS
[URL Encode] ENCODEURL
[Web] WEBSERVICE / FILTERXML
[Link] HYPERLINK
[Pivot Table] GETPIVOTDATA
07 Cube Function
[CUBE] CUBEMEMBER / CUBEVALUE / CUBESET / CUBERANKEDMEMBER / CUBESETCOUNT / CUBEMEMBERPROPERTY / CUBEKPIMEMBER
08 Information Function
[IS function] ISNUMBER / ISEVEN / ISODD / ISTEXT / ISNONTEXT / ISBLANK / ISLOGICAL / ISFORMULA / ISREF / ISERR / ISERROR / ISNA / ISOMITTED
[Error] NA
[Information Extraction] SHEET / SHEETS / CELL / INFO / TYPE / ERROR.TYPE
[Number conversion] N
09 Database Functions
[Average] DAVERAGE
[Total] DSUM
[Maximum/Minimum] DMAX / DMIN
[Count] DCOUNT / DCOUNTA
[Multiply] DPRODUCT /
[Standard Deviation] DSTDEVP / DSTDEV
[Dispersion] DVARP / DVAR
[Value Extraction] DGET
10 Financial Functions
[Savings/Loan Repayment] PMT / PPMT / IPMT / CUMPRINC / CUMIPMT / NPER / ISPMT / RATE
[Present Value/Future Value] PV / FV / FVSCHEDULE / RRI / PDURATION
[Net Present Value] NPV / XNPV
[Internal Rate of Return] IRR / XIRR / MIRR
[Interest rate] EFFECT / NOMINAL
[dollar] DOLLARDE / DOLLARFR
[Depreciation] DB / DDB / VDB / SLN / SYD / AMORDEGRC / AMORLINC
[Bonds] DURATION / MDURATION / ODDFYIELD / ODDLYIELD / ODDFPRICE / ODDLPRICE / ACCRINT / ACCRINTM / YIELD / PRICE / DISC / PRICEDISC / INTRATE / RECEIVED / PRICEMAT / YIELDMAT / YIELDDISC
[Interest Payment Period] COUPPCD / COUPNCD / COUPNUM / COUPDAYBS / COUPDAYSNC / COUPDAYS
[US Treasury Short-Term Bonds] TBILLEQ / TBILLPRICE / TBILLYIELD
11 Engineering Functions
[Unit Conversion] CONVERT
[Number Comparison] DELTA / GESTEP
[Base conversion] DEC2BIN / DEC2OCT / DEC2HEX / BIN2OCT / BIN2DEC / BIN2HEX / OCT2BIN / OCT2DEC / OCT2HEX / HEX2BIN / HEX2DEC / HEX2OCT
[Bit operation] BITAND / BITOR / BITXOR / BITLSHIFT / BITRSHIFT
[Complex number] COMPLEX / IMREAL / IMAGINARY / IMCONJUGATE / IMABS / IMARGUMENT / IMSUM / IMSUB / IMPRODUCT / IMDIV / IMPOWER / IMSQRT / IMSIN / IMCOS / IMTAN / IMSEC / IMCSC / IMCOT / IMSINH / IMCOSH / IMSECH / IMCSCH / IMEXP / IMLN / IMLOG10 / IMLOG2
[Error function] ERF / ERF.PRECISE / ERFC / ERFC.PRECISE
[Bessel function] BESSELJ / BESSELY / BESSELI / BESSELK
grounding
What is a function?
factor
operator
Function input
Modify function
Cell reference method
Name definition
Copy function (auto-fill feature)
Relative references, absolute references, and compound references
Logical formula
wildcard characters
Array constants
Array formulas
Dynamic array formulas and spills
Date and time calculation
Set display format
3D aggregation
Error handling
Useful techniques
Conditional formatting settings
Data Validity
database table
structural reference
outline
partial sum
Integration
Quick Fill
Virtual Analysis
circular reference
Tracking referenced and referencing cells
Formula calculation
Formula display
Automatic/manual switching of recalculation
Frequently used shortcuts
Compatibility functions
Detailed image
GOODS SPECIFICS
- Date of issue: October 20, 2025
- Page count, weight, size: 448 pages | 826g | 152*225*24mm
- ISBN13: 9788931480870
You may also like
카테고리
korean
korean
![GQ KOREA Mark (Monthly): December [2025]](http://librairie.coreenne.fr/cdn/shop/files/8ef265dbbfbf186523ed75ba7319009d.jpg?v=1765340328&width=3840)
