ExcelRoadMap.com

Function Tutorial Collection

Text Functions:

REGEXEXTRACT Tutorial
REGEXREPLACE Tutorial
REGEXTEST Tutorial
TEXTSPLIT Tutorial
TEXTJOIN Tutorial
VALUETOTEXT Tutorial

Lookup and Reference Functions:

CHOOSECOLS Tutorial
CHOOSEROWS Tutorial
WRAPCOLS Tutorial
WRAPROWS Tutorial
DROP Tutorial

Logical Functions:

BYCOL Tutorial
BYROW Tutorial

Statistical Functions:

SCAN Tutorial
SMALL Tutorial

Uncategorised Functions:

LET Tutorial
PERCENTOF Tutorial