Only $4.
Learning 205 Excel Functions Ebook with excel filesthat contains example for each functions
Fill out this form before payment
EXCEL FUNCTIONS BY CATEGORY
Logical Funtions
- IF
- IF
- IFERROR
- OR
- AND
- NOT
Lookup and Reference
- ADRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- OFFSET
- ROW
- ROWS
- TRANSPOSE
- VLOOKUP
Information
- CELL
- ERROR.TYPE
- INFO
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISTEXT
- N
- TYPE
Date and Time
- DATE
- DATEVALUE
- DAY
- DAYS360
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
Financial
- ACCRINT
- ACCRINTM
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DURATION
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- ISPMT
- IRR
- MDURATION
- MIRR
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
Database
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- STDEVP
- DSUM
- DVAR
- DVARP
Math and Trig
- ABS
- COMBIN
- EVEN
- FACT
- INT
- LN
- LOG
- LOG10
- MOD
- MULTINOMIAL
- ODD
- POWER
- PRODUCT
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SQRT
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
Statistical
- AVENDEV and AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BINOMDIST
- CHIDTST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT and COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- FINV
- FORECAST
- FREQUENCY
- FTEST
- GROWTH
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- MAX and MAXA
- MEDIAN
- MIN and mina
- MODE
- NORSMDIST
- PEARSON
- RANK
- SLOPE
- SMALL
- STDEV and STDEVA
- TREND
- TRIMMEAN
- TTEST
- VAR and vara
- ZTEST