Learn Excel - Simplify Life with Excel Concepts

Excel Functions List

Function By Category

Play Smart with Excel - Get2Excel a Single online place to learn all excel functions easly & symple!

All Microsoft Excel Functions Listed By Category - With detailed Function Syntax, Parameters or Arguments, Examples, where to use these function & how to use these functions, Start learning step by step each functions ...

Lookup / Reference Functions

LOOKUP(Excel)
VLOOKUP(Excel)
HLOOKUP(Excel)
MATCH(Excel)
INDEX(Excel)
CHOOSE(Excel, VBA)
OFFSET(Excel)
INDIRECT(Excel)
COLUMN(Excel)
COLUMNS(Excel)
ROW(Excel)
ROWS(Excel)
TRANSPOSE(Excel)
ADDRESS(Excel)
AREAS(Excel)
HYPERLINK(Excel)

String / Text Functions

ASC(VBA)
BAHTTEXT(Excel)
CHAR(Excel)
CHR(VBA)
CLEAN(Excel)

Database Functions

DAVERAGE(Excel)
DCOUNT(Excel)
DCOUNTA(Excel)
DGET(Excel)
DMAX(Excel)
DMIN(Excel)
DPRODUCT(Excel)
DSTDEV(Excel)
DSTDEVP(Excel)
DSUM(Excel)
DVAR(Excel)
DVARP(Excel)

Engineering Functions

BIN2DEC(Excel)
BIN2HEX(Excel)
BIN2OCT(Excel)
COMPLEX(Excel)
CONVERT(Excel)

File/Directory Functions

CHDIR(VBA)
CHDRIVE(VBA)
CURDIR(VBA)
DIR(VBA)
FILEDATETIME(VBA)
FILELEN(VBA)
GETATTR(VBA)
MKDIR(VBA)
SETATTR(VBA)

Data Type Convert Functions

CBOOL(VBA)
CBYTE(VBA)
CCUR(VBA)
CDATE(VBA)
CDBL(VBA)
CDEC(VBA)
CINT(VBA)
CLNG(VBA)
CSNG(VBA)
CSTR(VBA)
CVAR(VBA)