Only $4.
Learning 205 Excel Functions Ebook with excel files
that contains example for each functions
Fill out this form before payment
that 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