புதன், 26 பிப்ரவரி, 2014

MS Excel: ALL Functions

MS Excel Function Navigation

Note: (WS) = Worksheet function, (VBA) = Visual Basic for Applications function

MS Excel: ALL Functions - Category

Below is a list of the most commonly used functions in Excel, sorted by Category. These functions can generally be used as either Worksheet or VBA functions:

String Functions

ASC (VBA)
CHAR (WS)
CHR (VBA)
CLEAN (WS)
CODE (WS)
Concat with & (WS, VBA)
CONCATENATE (WS)
CURDIR (VBA)
DOLLAR (WS)
EXACT (WS)
FIND (WS)
FIXED (WS)
FORMAT Strings (VBA)

INSTR (VBA)
INSTRREV (VBA)
LCASE (VBA)
LEFT (WS, VBA)
LEN (WS, VBA)
LOWER (WS)
LTRIM (VBA)
MID (WS, VBA)
PROPER (WS)
REPLACE (WS)
REPLACE (VBA)
REPT (WS)
RIGHT (WS, VBA)

RTRIM (VBA)
SEARCH (WS)
SPACE (VBA)
STR (VBA)
STRCONV (VBA)
SUBSTITUTE (WS)
T (WS)
TEXT (WS)
TRIM (WS, VBA)
UCASE (VBA)
UPPER (WS)
VAL (VBA)
VALUE (WS)

Numeric / Mathematical Functions

ROMAN (WS)
ROUND (WS)
ROUND (VBA)
ROUNDDOWN (WS)
ROUNDUP (WS)
SGN (VBA)
SIGN (WS)
SIN (WS, VBA)
SINH (WS)
SMALL (WS)
SQRT (WS)
SUBTOTAL (WS)
SUM (WS)
SUMIF (WS)
SUMIFS (WS)
SUMPRODUCT (WS)
SUMSQ (WS)
SUMX2MY2 (WS)
SUMX2PY2 (WS)
SUMXMY2 (WS)
TAN (WS, VBA)
TANH (WS)
TRUNC (WS)
VAL (VBA)
VALUE (WS)
VAR (WS)
VARA (WS)
VARP (WS)
VARPA (WS)

Statistical Functions

AGGREGATE (WS)
AVEDEV (WS)
AVERAGE (WS)
AVERAGEA (WS)
AVERAGEIF (WS)
AVERAGEIFS (WS)
BETA.DIST (WS)
BETA.INV (WS)
BETADIST (WS)
BETAINV (WS)
BINOM.DIST (WS)
BINOM.INV (WS)
BINOMDIST (WS)
CHIDIST (WS)

CHIINV (WS)
CHITEST (WS)
COVAR (WS)
FORECAST (WS)
GROWTH (WS)
INTERCEPT (WS)
LARGE (WS)
LINEST (WS)
MAX (WS)
MAXA (WS)
MEDIAN (WS)
MIN (WS)
MINA (WS)
PERCENTILE (WS)

PERCENTRANK (WS)
PERMUT (WS)
PI (WS)
QUARTILE (WS)
RANK (WS)
SMALL (WS)
STDEV (WS)
STDEVA (WS)
STDEVP (WS)
STDEVPA (WS)
VAR (WS)
VARA (WS)
VARP (WS)
VARPA (WS)

Logical Functions

AND (WS)
AND (VBA)
CASE (VBA)
FALSE (WS)

NOT (WS)
OR (WS)
OR (VBA)
TRUE (WS)

Information Functions

CELL (WS)
ERROR.TYPE (WS)
INFO (WS)
ISBLANK (WS)
ISDATE (VBA)
ISERR (WS)

ISERROR (WS, VBA)
ISLOGICAL (WS)
ISNA (WS)
ISNONTEXT (WS)
ISNULL (VBA)
ISNUMBER (WS)

ISNUMERIC (VBA)
ISREF (WS)
ISTEXT (WS)
N (WS)
NA (WS)
TYPE (WS)

Date / Time Functions

DATE (VBA)
DATE (WS)
DATEADD (VBA)
DATEDIF (WS)
DATEDIFF (VBA)
DATEPART (VBA)
DATESERIAL (VBA)
DATEVALUE (WS, VBA)
DAY (WS, VBA)

DAYS360 (WS)
FORMAT Dates (VBA)
HOUR (WS, VBA)
MINUTE (WS, VBA)
MONTH (WS, VBA)
MONTHNAME (VBA)
NETWORKDAYS (WS)
NETWORKDAYS.INTL (WS)
NOW (WS, VBA)

SECOND (WS)
TIME (WS)
TIMESERIAL (VBA)
TIMEVALUE (WS, VBA)
TODAY (WS)
WEEKDAY (WS, VBA)
WEEKDAYNAME (VBA)
YEAR (WS, VBA)

Database Functions

DAVERAGE (WS)
DCOUNT (WS)
DCOUNTA (WS)
DGET (WS)

DMAX (WS)
DMIN (WS)
DPRODUCT (WS)
DSTDEV (WS)

DSTDEVP (WS)
DSUM (WS)
DVAR (WS)
DVARP (WS)

Data Type Conversion Functions

CBOOL (VBA)
CBYTE (VBA)
CCUR (VBA)
CDATE (VBA)

CDBL (VBA)
CDEC (VBA)
CINT (VBA)
CLNG (VBA)

CSNG (VBA)
CSTR (VBA)
CVAR (VBA)

Financial Functions

ACCRINT (WS)
ACCRINTM (WS)
AMORDEGRC (WS)
AMORLINC (WS)
DB (WS)
DDB (WS, VBA)
FV (WS, VBA)

IPMT (WS, VBA)
IRR (WS, VBA)
ISPMT (WS)
MIRR (WS, VBA)
NPER (WS, VBA)
NPV (WS, VBA)
PMT (WS, VBA)

PPMT (WS, VBA)
PV (WS, VBA)
RATE (WS, VBA)
SLN (WS, VBA)
SYD (WS, VBA)
VDB (WS)

File / Directory Functions

CHDIR (VBA)
CHDRIVE (VBA)
CURDIR (VBA)

DIR (VBA)
FILEDATETIME (VBA)
FILELEN (VBA)

GETATTR (VBA)
MKDIR (VBA)
SETATTR (VBA)

Lookup / Reference Functions

ADDRESS (WS)
AREAS (WS)
CHOOSE (WS, VBA)
COLUMN (WS)
COLUMNS (WS)
HLOOKUP (WS)

HYPERLINK (WS)
INDEX (WS)
INDIRECT (WS)
LOOKUP (WS)
MATCH (WS)
OFFSET (WS)

ROW (WS)
ROWS (WS)
SWITCH (VBA)
TRANSPOSE (WS)
VLOOKUP (WS)

More Lookup Functions

Miscellaneous Functions

கருத்துகள் இல்லை:

கருத்துரையிடுக

இதற்கு குழுசேர்: கருத்துரைகளை இடு (Atom)