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
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
File/Directory Functions
- CHDIR(VBA)
- CHDRIVE(VBA)
- CURDIR(VBA)
- DIR(VBA)
- FILEDATETIME(VBA)
- FILELEN(VBA)
- GETATTR(VBA)
- MKDIR(VBA)
- SETATTR(VBA)