Friday, January 20, 2012

How Excel deals with dates?

In Excel, all dates are stored as integers (Integer 1 represents January 1, 1900, integer 2 represents January 2, 1900, and so on).
As the dates are stored as integers, you can perform operations such as addition, subtraction of dates. This helps us to know the difference between two dates, and so on.
To perform operations with date, Excel provides us many built-in functions like DATE, DATEVALUE, DAY, MONTH, YEAR, and more.

Thursday, January 19, 2012

Excel 2007 functions


Excel 2007 - 347 functions
Add-in and Automation functions (5)
  • CALL
  • EUROCONVERT
  • GETPIVOTDATA
  • REGISTER.ID
  • SQL.REQUEST


Cube functions (7)
  • CUBEKPIMEMBER
  • CUBEMEMBER
  • CUBEMEMBERPROPERTY
  • CUBERANKEDMEMBER
  • CUBESET
  • CUBESETCOUNT
  • CUBEVALUE

Database functions (12)
  • DAVERAGE
  • DCOUNT
  • DCOUNTA
  • DGET
  • DMAX
  • DMIN
  • DPRODUCT
  • DSTDEV
  • DSTDEVP
  • DSUM
  • DVAR
  • DVARP

Date and time functions (20)
  • DATE
  • DATEVALUE
  • DAY
  • DAYS360
  • EDATE
  • EOMONTH
  • HOUR
  • MINUTE
  • MONTH
  • NETWORKDAYS
  • NOW
  • SECOND
  • TIME
  • TIMEVALUE
  • TODAY
  • WEEKDAY
  • WEEKNUM
  • YEAR
  • YEARFRAC

Engineering functions (39)
  • 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

Financial functions (53)
  • 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

Information functions (17)
  • CELL
  • ERROR.TYPE
  • INFO
  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISLOGICAL
  • ISNA
  • ISNONTEXT
  • ISNUMBER
  • ISODD
  • ISREF
  • ISTEXT
  • N
  • NA
  • TYPE

Logical functions (7)
  • AND
  • FALSE
  • IF
  • IFERROR
  • NOT
  • OR
  • TRUE

Lookup and reference functions (17)
  • ADDRESS
  • AREAS
  • CHOOSE
  • COLUMN
  • COLUMNS
  • HLOOKUP
  • HYPERLINK
  • INDEX
  • INDIRECT
  • LOOKUP
  • MATCH
  • OFFSET
  • ROW
  • ROWS
  • RTD
  • TRANSPOSE
  • VLOOKUP

Math and trigonometry functions (60)
  • 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

Statistical functions (83)
  • AVEDEV
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • BETADIST
  • BETAINV
  • BINOMDIST
  • CHIDIST
  • CHIINV
  • CHITEST
  • CONFIDENCE
  • CORREL
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • COVAR
  • CRITBINOM
  • DEVAQ
  • 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

Text functions (27)
  • 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