Excel School - All Function

MS Excel: ALL Functions - Category

String Functions

ASC (VBA)
CHAR (WS)
CHR (VBA)
CLEAN (WS)
CODE (WS)
CONCATENATE (WS)
Concatenate with & (WS, VBA)
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)
VALUE (WS)

Numeric / Mathematical Functions

ABS (WS, VBA)
ACOS (WS)
ACOSH (WS)
AGGREGATE (WS)
ASIN (WS)
ASINH (WS)
ATAN (WS)
ATAN2 (WS)
ATANH (WS)
ATN (VBA)
AVERAGE (WS)
AVERAGEA (WS)
AVERAGEIF (WS)
AVERAGEIFS (WS)
BIN2DEC (WS)
BIN2HEX (WS)
BIN2OCT (WS)
CEILING (WS)
CEILING.PRECISE (WS)
COMBIN (WS)
COMBINA (WS)
COMPLEX (WS)
CONVERT (WS)
COS (WS, VBA)
COSH (WS)
COUNT (WS)
COUNTA (WS)
COUNTBLANK (WS)
COUNTIF (WS)
DEGREES (WS)

EVEN (WS)
EXP (WS, VBA)
FACT (WS)
FIX (VBA)
FLOOR (WS)
FORMAT Numbers (VBA)
FREQUENCY (WS)
INT (WS, VBA)
LARGE (WS)
LN (WS)
LOG (WS, VBA)
LOG10 (WS)
MAX (WS)
MAXA (WS)
MDETERM (WS)
MEDIAN (WS)
MIN (WS)
MINA (WS)
MINVERSE (WS)
MMULT (WS)
MOD (WS)
N (WS)
ODD (WS)
PI (WS)
POWER (WS)
PRODUCT (WS)
RADIANS (WS)
RAND (WS)
RANDBETWEEN (WS)
RND (VBA)

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)
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)
BETADIST (WS)
BETA.INV (WS)
BETAINV (WS)
BINOM.DIST (WS)
BINOMDIST (WS)
BINOM.INV (WS)
CHIDIST (WS)

CHIINV (WS)
CHITEST (WS)
COVAR (WS)
FORECAST (WS)
GROWTH (WS)
INTERCEPT (WS)
LARGE (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)
CASE (VBA)
FALSE (WS)
IF (WS)

OR (WS)
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 (WS)
DATE (VBA)
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)

Lookup / Reference Functions

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

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)

Miscellaneous Functions

YouTube

YouTube

DWorld Group

On Line Admission

Result in MSExcel

Admission Form in PDF

Map Location

Max Maya Free Autocadd course ke sath

Offers

Created with page4, copyright © 2021 by page4 Corp., USA. All rights reserved.
Report this site as abusive Login

This is a free homepage created with page4. Get your own on www.page4.com